docs: residential (Redfin) sourcing section — writeback path + cost + baseline

40ef73d589a5c294b2e9a0316462cd4fd6703cb0 · 2026-07-31 08:08:16 -0700 · steve

Files touched

M docs/SOURCING.md

Diff

commit 40ef73d589a5c294b2e9a0316462cd4fd6703cb0
Author: steve <steve@designerwallcoverings.com>
Date:   Fri Jul 31 08:08:16 2026 -0700

    docs: residential (Redfin) sourcing section — writeback path + cost + baseline
---
 docs/SOURCING.md | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/docs/SOURCING.md b/docs/SOURCING.md
index d2a9ec8..9623d89 100644
--- a/docs/SOURCING.md
+++ b/docs/SOURCING.md
@@ -49,6 +49,18 @@ Resolve the broker-of-record for the **1,747 aggregator-only** deals not yet in
 pushing broker-of-record coverage from 43% toward ~90%. Metered (~$0.04–0.10 batched) — Steve-gated.
 Optionally deep-link each deal to the broker's own site for canonical verification.
 
+## Residential (SFR + condo) — the Redfin frontier
+Residential is 100% Redfin-sourced (aggregator). The gis-csv feed carries NO listing agent
+(`fetch-sfr-redfin.js` — broker_name/firm_name stay NULL); the listing broker is captured separately
+per-listing via Redfin's `mainHouseInfoPanelInfo` detail endpoint by `fetch-sfr-agents.js` (SFR) and
+`fetch-redfin-agents.js` (condos). Writeback path is intact end-to-end: those scripts
+`UPDATE sfr SET broker_name, firm_name` → `/api/residential` serves them → `mapSfr` → the viewer's
+doctrine classifier → the Brokerage facet. Newly-resolved brokers surface with no extra wiring.
+- **Baseline:** ~839/17,700 SFR (4.7%) + ~640/2,190 condos (29%) have a broker; the rest unresolved.
+- **Cost:** ~40 listings per Browserbase session (~$0.04); full SFR resolution ≈ $18. Metered,
+  Steve-gated; the script self-caps at CC_MAX_COST (default $1.50) per run. Some agents are Redfin-
+  suppressed → honest NULL, never fabricated.
+
 ## Hard lines
 - Never present an aggregator record as canonical when a broker-of-record is known.
 - Business-contact fields only (CCPA); record `source_url` per enriched field.

← 3f752e8 viewer: Brokerage left-rail facet — filter deals by listing · back to Commercialrealestate · doctrine HARD RULE: an aggregator is never a data source — k ccaba2e →