Real Estate

Find, enrich, and rank real estate markets

A 4-phase pipeline that pulls live market statistics from 100 US cities via Redfin, uses Claude to rank and select the top 10 investment markets, then surfaces active Zillow listings and deep market reports from Perplexity for each selected city. The entire research workflow an analyst would spend days on, done in minutes.

Quick Start

Inputs

  • City List The US cities to collect market data for — 100 cities are included by default and can be edited in the config file before running.

Outputs

  • Ranked city scorecard with investment scores across 5 dimensions
  • Top investment markets selected and ranked
  • Per-city investment thesis and key risk
  • Active Zillow listings across tracked markets, with photos and full specs
  • In-depth city report per tracked market
  • Interactive US map with cities sized by transaction volume and colored by investment score

Sample dataset. 100 cities scored, top 10 selected by Claude, 1,199 active listings, and 10 full city reports — collected May 2026. No API key needed to explore the dashboard.

View example on GitHub

How it works

A 4-phase pipeline. Read the blog here for a deeper explanation.

  1. ‍Collect The Redfin agent pulls live market stats for 100 US cities — median price, days on market, sale-to-list ratio, YoY appreciation, homes sold, and price per sqft.
  2. ‍Rank Claude scores all 100 cities on 5 investment factors and selects the top 10, with a written thesis and key risk per city.
  3. Listings The Zillow agent pulls active listings across 3 zip codes per selected city — 30 agent calls, 1,199 total listings with photos and full specs.
  4. Research The Perplexity agent generates a deep market report for each of the 10 cities, covering appreciation trends, affordability, rental demand, and risk factors.

Stack

Nimble primitives plus the full runtime stack.
Nimble APIs
What it does
  1. redfin_market_housing_data_community_2026_05_02 Pulls live market stats per city from Redfin — median price, days on market, sale-to-list ratio, YoY change, and market description.
  2. zillow_plp Fetches active property listings from Zillow by zip code — price, beds, baths, sqft, home type, photos, and days on Zillow.
  3. perplexity Generates a deep real estate investment report for any city — appreciation trends, affordability, rental demand, and risk factors.
3rd Party Tools
Role
  1. claude-sonnet-4-6 Anthropic Claude API — scores 30 candidate markets, selects the top 10, and writes an investment thesis and key risk per city.
  2. streamlit 4-tab dashboard combining market data, Claude analysis, active listings, and city deep dives.
  3. plotly Scatter geo map, radar chart, horizontal bar charts, price histograms, and scatter plots.
  4. pydeck Interactive property maps using CARTO dark tiles — no Mapbox token required.
  5. python 3.9+ Pipeline orchestration across 4 phases.
Reach out if you have any questions.
Talk to an Expert