feat: broker-history pilot — transaction history + listing-agent enrichment on property cards

192e889054f2e762a36495c7ce0226d54d6361d7 · 2026-06-30 19:54:18 -0700 · Steve Abrams

- data/broker-history-pilot.json: pilot dataset covering top 13 of the 30 sampled ranked
  properties. Each entry has: LA County Assessor AIN + recording_date (last deed, Tier A),
  sale-price history where findable from public MLS search results (Tier B), and the
  current listing agent name/DRE/firm/phone from Redfin/Zillow/Compass/LoopNet results.
  12/13 properties have a named broker or firm (92% coverage in pilot).

- scripts/serve.js: adds GET /api/broker-history endpoint serving the pilot JSON. Indexed
  by listing id and lowercase address for fast O(1) card-level lookup. Graceful 503 if
  file absent; full set returned when no query params (for bulk UI hydration).

- public/index.html:
  - CSS: .brokerflag (amber "Prior broker on file" badge), .txhist (deed + sale date
    rows with Tier A/B color coding), .brokerline (agent name/DRE/phone chip).
  - JS: loads /api/broker-history at boot into window.BROKER_HIST (by id) +
    window.BROKER_HIST_ADDR (by address); re-renders when DATA is ready.
  - card(): injects brokerFlagBadge, txHistHTML(), brokerLineHTML() per property using
    the pilot index — degrades gracefully (empty string) when property not in pilot set.

Coverage findings (pilot sample of 30):
  - Assessor parcel hit: 27/30 (90%). Three misses: Granada Hills (long address), Reseda
    (dual-number parcel 7302-7304), Tujunga (Foothill address variant).
  - closed_sale DB: 0/30 matches. The 17k rows are residential SFR/condo (Redfin
    gis-csv); none are commercial multifamily — not a useful source for these properties.
  - Broker/agent found (current listing): 12/13 enriched (92%). 1 miss (553 Stanford Ave
    — broker not surfaced in public search results).
  - Historical sale price found: 5/13 (38%). Sources: Redfin search snippets, Zillow.
  - Historical BROKER on a PAST sale: 2/13 (15%) — 9350 Tampa 2022 listing (Stephanie
    Vitacco/Equity Union) and 8022 Felix 2025 sale (Brandon Hauer). Past-sale brokers are
    NOT in any free public record (deed carries no agent name; confirmed against RR/CC FAQ).

Equity Union finding: appears on 4 of the top 10 ranked properties (ranks 2, 4, 6, 10).
Marcus & Millichap on rank 23 (383 W 14th St San Pedro).
Lyon Stahl/Cameron Samimi on rank 8 (10370 Ashton).

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Files touched

Diff

commit 192e889054f2e762a36495c7ce0226d54d6361d7
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 30 19:54:18 2026 -0700

    feat: broker-history pilot — transaction history + listing-agent enrichment on property cards
    
    - data/broker-history-pilot.json: pilot dataset covering top 13 of the 30 sampled ranked
      properties. Each entry has: LA County Assessor AIN + recording_date (last deed, Tier A),
      sale-price history where findable from public MLS search results (Tier B), and the
      current listing agent name/DRE/firm/phone from Redfin/Zillow/Compass/LoopNet results.
      12/13 properties have a named broker or firm (92% coverage in pilot).
    
    - scripts/serve.js: adds GET /api/broker-history endpoint serving the pilot JSON. Indexed
      by listing id and lowercase address for fast O(1) card-level lookup. Graceful 503 if
      file absent; full set returned when no query params (for bulk UI hydration).
    
    - public/index.html:
      - CSS: .brokerflag (amber "Prior broker on file" badge), .txhist (deed + sale date
        rows with Tier A/B color coding), .brokerline (agent name/DRE/phone chip).
      - JS: loads /api/broker-history at boot into window.BROKER_HIST (by id) +
        window.BROKER_HIST_ADDR (by address); re-renders when DATA is ready.
      - card(): injects brokerFlagBadge, txHistHTML(), brokerLineHTML() per property using
        the pilot index — degrades gracefully (empty string) when property not in pilot set.
    
    Coverage findings (pilot sample of 30):
      - Assessor parcel hit: 27/30 (90%). Three misses: Granada Hills (long address), Reseda
        (dual-number parcel 7302-7304), Tujunga (Foothill address variant).
      - closed_sale DB: 0/30 matches. The 17k rows are residential SFR/condo (Redfin
        gis-csv); none are commercial multifamily — not a useful source for these properties.
      - Broker/agent found (current listing): 12/13 enriched (92%). 1 miss (553 Stanford Ave
        — broker not surfaced in public search results).
      - Historical sale price found: 5/13 (38%). Sources: Redfin search snippets, Zillow.
      - Historical BROKER on a PAST sale: 2/13 (15%) — 9350 Tampa 2022 listing (Stephanie
        Vitacco/Equity Union) and 8022 Felix 2025 sale (Brandon Hauer). Past-sale brokers are
        NOT in any free public record (deed carries no agent name; confirmed against RR/CC FAQ).
    
    Equity Union finding: appears on 4 of the top 10 ranked properties (ranks 2, 4, 6, 10).
    Marcus & Millichap on rank 23 (383 W 14th St San Pedro).
    Lyon Stahl/Cameron Samimi on rank 8 (10370 Ashton).
    
    Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

← 584c409 auto-save: 2026-06-30T19:42:55 (3 files) — public/index.html · back to Commercialrealestate · chore: v0.2.0 (session close — broker contacts/MLS+broker gr 6ee845c →