Scott Monaco

Data Visualization2 min read

Real Estate Heatmap Dashboard

Live appCode

Real Estate Heatmap Dashboard

Problem Statement

Neighborhood-level housing data is publicly available from Redfin, but it’s released as massive flat files with no geographic context or cross-market comparison. Buyers, sellers, and investors need a way to quickly compare pricing, inventory, and market speed across metros and drill into specific neighborhoods - without writing SQL or building their own pipelines.

This project transforms raw Redfin data into an interactive Streamlit dashboard covering 7 U.S. metro areas and 1,262 neighborhoods, with heatmaps, rankings, and market velocity analysis.

Methodology

Data Pipeline

The Redfin Market Tracker dataset is ingested as neighborhood-level quarterly data (August 2023, 90-day trailing window). A Python pipeline filters to seven target metros (Austin, Boston, Chicago, Denver, Miami, New York, San Francisco), coerces types, geocodes neighborhoods, and outputs cleaned CSVs. The dashboard is built with Streamlit, Plotly for interactive charts, and Folium for geospatial heatmaps.

Results

Price Distribution by City

Median sale price distribution across major U.S. metro areas
San Francisco leads at $1.4M median with the widest intra-market spread. Chicago and Austin offer the most affordable entry points, while New York’s median sits lower than expected due to outer-borough inclusion.

City Metrics Heatmap

Heatmap of real estate metrics across cities
Normalized comparison of pricing, inventory, and velocity metrics across all seven metros.

Most Expensive Neighborhoods

Top most expensive neighborhoods across metro areas
The top 15 neighborhoods are concentrated in San Francisco and New York, with Pacific Heights and Presidio Heights exceeding $3M median.

Price Variance Analysis

Price variance by city showing intra-market inequality
IQR analysis reveals San Francisco has the widest price spread, while Denver shows a compressed, uniformly competitive market.

Market Velocity

Market velocity scatter showing relationship between DOM and off-market speed
Neighborhoods where >40% of listings go off-market within two weeks tend to have median prices 20–30% above their city’s overall median. Austin and Denver show the highest absorption rates.

Next Steps

  • Automate quarterly data refresh via the pipeline scripts
  • Supplement Redfin data with Zillow pricing data for a more holistic view
  • Build a predictive model for future median sale prices by neighborhood for ROI-driven investment

Tools and technologies

  • Python
  • Pandas
  • Streamlit
  • Plotly
  • Folium

Data source: RedfinStatus: Active

  • Geospatial
  • Streamlit
  • Plotly
  • Real Estate