Projects CoreAI Market Flare

CoreAI Market Flare

End-to-end predictive ML system quantifying ZIP-level real estate market hotness using proprietary industry data, XGBoost, and SARIMA forecasting. Awarded 1st Place at 2025 UCI ICS Project Expo.

Capstone Project ML / Data Product

Tech Stack

  • Python
  • XGBoost
  • Random Forest
  • LightGBM
  • SARIMA
  • K-Means
  • SQL
  • Streamlit

Overview

CoreAI Market Flare forecasts real estate market "hotness" at the ZIP-code level across California. Built during my UCI Data Science capstone in partnership with a leading real estate data provider, the system won 1st Place at the 2025 UCI ICS Project Expo.

The Problem

Real estate hotness — where demand exceeds supply and homes sell over list price — is difficult to quantify directly. A single "hotness score" hides which underlying market forces are driving it and makes the score hard to trust or explain.

Our approach: instead of predicting hotness directly, we independently forecast the underlying market indicators (Days on Market, Absorption Rate, Offer-to-List Price Ratio) using ZIP-level historical data, then combine those predictions into a single, weighted, explainable Hotness Score.

What I Built

  • Engineered 50+ features from raw transaction data (101,462 rows) at the ZIP-code × month level, including momentum, volatility, Fourier/cyclic transforms, and lag features
  • Built a K-Means clustering approach (K=12, tuned via MAE) to group behaviorally similar ZIP codes, capturing subtle market patterns lost in broader city/county aggregations
  • Trained independent Random Forest and XGBoost models per cluster to forecast three key market indicators 1-6 months ahead: Days on Market, Absorption Rate, and Offer-to-List Price Ratio
  • Designed a weighted aggregation layer that combines the three forecasted indicators into a single composite Hotness Score, with user-adjustable weights (custom vs. equal) to let domain experts prioritize specific market dynamics
  • Handled erratic ZIP clusters (highly volatile behavior, sharp market shifts, sparse data) by modeling outliers separately and manually adjusting cluster assignments

Key Features

  • Modular forecasting architecture: independently predicts each market indicator rather than a black-box hotness score, tracing exactly how each factor contributes
  • Cluster-aware modeling: ZIP codes grouped by K-Means (K=12) into behaviorally similar segments, with lag-based temporal panels capturing time-based patterns
  • Ensemble forecasting: Random Forest + XGBoost per cluster per indicator, validated with MAE, RMSE, R², and SMAPE
  • Customizable weighted scoring: users can set custom or equal weights across indicators to tailor the composite Hotness Score to their needs
  • Interactive Streamlit dashboard: choropleth map visualization of ZIP-level hotness across California with city/county/postal code search
  • Team capstone: built with 3 teammates and industry/UCI mentors; 1st Place, 2025 UCI ICS Project Expo

Technical Architecture

High-level system diagram.

CoreAI Market Flare technical architecture diagram showing data sources, preprocessing and feature engineering, ZIP cluster modeling, feature forecast models, composite hotness scoring, and the interactive application