Summary
Built a daily SF real estate market scanner that polls Redfin’s CSV API across 7 neighborhoods and posts value-scored digests to Discord #housing.
What Was Built
- Housing Scout (
~/repos/deal-scout/housing-scout.js) — polls Redfin stingray CSV endpoint for active listings in Inner Richmond, West Portal, Cole Valley, Noe Valley, Portola, Pacific Heights, and North Beach - Value scoring — scores on $/sqft vs neighborhood median, days on market, lot size, price bracket, and thoroughfare proximity penalty
- Thoroughfare filter — penalizes properties on or near Geary, California, Fulton, 19th Ave, Van Ness, Divisadero, Lombard via street name matching + lat/lng corridor proximity
- Discord #housing channel — created channel + webhook, first report posted with 41 listings and 8 top picks
- PM2 cron — daily at 8am PT (0 15 * * * UTC)
Filters
- Budget: ≤$3M
- Property type: SFH, condo/TIC, multi-family (2-4 unit)
- Min: 2bd/2ba, 1000+ sqft
Initial Top Picks
- 263-265 8th Ave (Inner Richmond) — $1.30M, 4bd/2ba, $560/sqft, Score 100
- 375 Day St (Noe Valley) — $1.30M, 4bd/2ba, $418/sqft, 580 DOM
- 1623 Vallejo St (Pac Heights) — $2.80M, 5bd/4ba, $755/sqft, 241 DOM
- 421 Cornwall St (Inner Richmond) — $1.40M, 4bd/4ba, $402/sqft
- 1033 Girard St (Portola) — $888K, 3bd/2ba, $595/sqft
Data Source
Redfin stingray CSV API (gis-csv endpoint). No auth required. Region IDs mapped for all 7 neighborhoods. Rate-limited with 2s delays between requests.