Rental Market Analyzer
Crunches Zillow data across 389 metros and 7,789 zip codes, then generates bank-grade pro formas with comps, stress tests, and Google Sheets output.
Key Outcomes
389 metro areas and 7,789 zip codes analyzed and ranked
40+ investment metrics per ZIP code with color-coded comparisons
Features
Automated end-to-end property underwriting
Multi-scenario stress testing (bear/base/bull)
Google Sheets output with formulas and formatting
Interactive ZIP code dashboard with filtering and sorting
AI-generated investment recommendations per market
Architecture
1
Zillow Data Pipeline
ingests metrics across 389 metros and 7,789 zip codes
2
Pandas Analysis
ROI ranking, vacancy rates, appreciation forecasts
3
Claude Agent SDK
orchestrates per-property underwriting
4
Stress Testing
bear/base/bull scenario modeling with comparable rents
5
Google Sheets MCP
outputs formatted pro formas with formulas
Built With
PythonClaude Agent SDKPandasGoogle Sheets MCPZillow Data