condos table: add drillable DRE# column (License# → CA DRE record, +N co-agent indicator) — completes all-licenses visibility across card/modal/table (all 3 per-listing surfaces)

ea6498d5f57e0d6399b1f024def2c865397c72c7 · 2026-08-03 11:20:05 -0700 · Steve Abrams

Files touched

M public/condos.html

Diff

commit ea6498d5f57e0d6399b1f024def2c865397c72c7
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Aug 3 11:20:05 2026 -0700

    condos table: add drillable DRE# column (License# → CA DRE record, +N co-agent indicator) — completes all-licenses visibility across card/modal/table (all 3 per-listing surfaces)
---
 public/condos.html | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/public/condos.html b/public/condos.html
index 2111151..4a95ffd 100644
--- a/public/condos.html
+++ b/public/condos.html
@@ -186,6 +186,7 @@ const FIELDS=[
   {k:'zip',         l:'ZIP',                   col:1},
   {k:'broker_name', l:'Broker',                col:1},
   {k:'firm_name',   l:'Firm',                  col:1},
+  {k:'broker_dre',  l:'DRE#',                  col:1},
   {k:'warrant_source',l:'Warrant note',        col:0},
   {k:'created_at',  l:'Added',        date:1,  col:1},
 ];
@@ -239,6 +240,10 @@ function fcell(c,f){ const v=fval(c,f);
   if(f.money) return '$'+(+v).toLocaleString()+(f.suf||'');
   if(f.num) return (+v).toLocaleString();
   if(f.date){ return dateTimeSpan(v)||'—'; }
+  if(f.k==='broker_dre'){ const primary=v||(c.agents&&c.agents[0]&&c.agents[0].dre); if(!primary) return '—';
+    const u=c.dre_url||('https://www2.dre.ca.gov/PublicASP/pplinfo.asp?License_id='+primary);
+    const extra=(Array.isArray(c.agents)&&c.agents.length>1)?` <span style="color:var(--mut);font-size:10px" title="${c.agents.length-1} co-agent license(s) — see card/detail">+${c.agents.length-1}</span>`:'';
+    return `<a href="${esc(u)}" target="_blank" rel="noopener noreferrer" title="Full CA DRE license record">${esc(primary)} ↗</a>${extra}`; }
   if(f.k==='firm_name') return drillSpan('firm',v);
   if(f.k==='city') return drillSpan('city',v);
   return esc(v)+(f.suf||'');

← 8e1bfaa enrich-condo-brokers: cost circuit-breaker (Codex dissent) — · back to Commercialrealestate · condos table DRE# (Cody gate): resolve broker_dre BEFORE the a5ff4d2 →