CRE 2D — Retail Brokerage Mandate Lens
An anonymized mandate-pipeline export for sell-side and tenant-rep teams running on a finite calendar of lease events.
The lens, in brief
418 retail nodes tracked across 6 engines, 9 cross-intelligence layers.
This is an anonymized export from a Constellation deployment running for a national retail-brokerage shop covering grocery-anchored, single-tenant net-lease, and small-format urban retail. The same architecture, applied to your mandate footprint, would output the same shape — ranked occupiers ready to relocate, landlords approaching refinance pressure, and broker-of-record relationships drifting toward re-pitch.
The deployment tracks 418 nodes across six engines: occupier locations, landlord entities, lease-event timelines, broker-of-record relationships, capital-event signals, and competing brokerage footprints. Nine cross-intelligence layers compute renewal probability, relocation propensity, landlord refi pressure, broker-flight risk, co-tenancy uplift, deal sequencing, competing-mandate clusters, sub-market velocity, and warm-intro paths.
Mandate Phase 1 — top 10
Ten highest-conviction mandate targets ranked by composite score and event window.
| Row | Geo / Sub-market | Format · GLA Band | Lease-Event Risk | Composite | Window | Phase |
|---|---|---|---|---|---|---|
| 01 | TX · Dallas — Preston Center | Grocery-anchor · 45–60k sf | CRITICAL | 94 | 21 days | Phase 1 |
| 02 | AZ · Phoenix — Scottsdale corridor | Power center · 80–110k sf | CRITICAL | 91 | 30 days | Phase 1 |
| 03 | FL · Miami — Wynwood/Edgewater | Urban high-street · 6–10k sf | HIGH | 88 | 30 days | Phase 1 |
| 04 | CO · Denver — RiNo | Mixed-use · 12–18k sf | CRITICAL | 87 | 45 days | Phase 1 |
| 05 | TX · Austin — Domain submarket | Lifestyle · 22–30k sf | HIGH | 85 | 45 days | Phase 1 |
| 06 | GA · Atlanta — Buckhead | STNL · 4–6k sf | HIGH | 83 | 60 days | Phase 1 |
| 07 | NC · Charlotte — South End | Urban high-street · 5–8k sf | CRITICAL | 82 | 45 days | Phase 1 |
| 08 | WA · Seattle — Bellevue Sq area | Power center · 60–90k sf | HIGH | 81 | 60 days | Phase 1 |
| 09 | TN · Nashville — Gulch | Mixed-use · 10–14k sf | HIGH | 79 | 75 days | Phase 1 |
| 10 | CA · San Diego — UTC | Lifestyle · 18–24k sf | CRITICAL | 77 | 60 days | Phase 1 |
Phase 1 · 10 highest-conviction mandate targets
Phase 2 — follow-on roster
Eight of forty mid-tier mandates carrying renewal-window optionality inside 6–18 months.
| Row | Geo / Sub-market | Format · GLA Band | Lease-Event Risk | Composite | Window |
|---|---|---|---|---|---|
| 11 | OR · Portland — Pearl District | Urban · 7–10k sf | MEDIUM | 74 | 6 mo |
| 12 | MA · Boston — Seaport | Mixed-use · 14–20k sf | HIGH | 73 | 6 mo |
| 13 | IL · Chicago — Fulton Market | Urban high-street · 8–12k sf | MEDIUM | 71 | 9 mo |
| 14 | VA · Arlington — Ballston | Lifestyle · 16–22k sf | HIGH | 71 | 9 mo |
| 15 | MN · Minneapolis — Uptown | Mixed-use · 10–14k sf | MEDIUM | 70 | 9 mo |
| 16 | OH · Columbus — Short North | Urban · 6–9k sf | MEDIUM | 70 | 12 mo |
| 17 | UT · Salt Lake — Sugar House | STNL · 4–6k sf | MEDIUM | 70 | 12 mo |
| 18 | NV · Las Vegas — Summerlin | Power center · 70–95k sf | MEDIUM | 70 | 18 mo |
Phase 2 · 8 of 40 follow-on mandates
Cross-reference — occupier × landlord twofers
Mandates where the occupier-side opportunity and the landlord-side opportunity sit on the same asset.
| Pair | Occupier band (geo) | Landlord band (asset) | Overlap signals | Combined fee est. | Twofer |
|---|---|---|---|---|---|
| CR-01 | TX · Dallas · 45–60k sf | $28–34M asset | Co-term lease + maturing CMBS | $420K | YES |
| CR-02 | AZ · Phoenix · 80–110k sf | $52–60M asset | Anchor renewal + sponsor refi | $610K | YES |
| CR-03 | FL · Miami · 6–10k sf | $14–18M asset | Broker-of-record drift + maturity | $185K | YES |
| CR-04 | CO · Denver · 12–18k sf | $22–26M asset | Co-tenancy clause trigger | $240K | YES |
| CR-05 | NC · Charlotte · 5–8k sf | $11–14M asset | BoR turnover + ground-lease reset | $165K | YES |
Counter-party concentration
On the retail side, "carrier" becomes "national tenant" — concentration on a single anchor triggers the same flag at the same threshold.
| Tenant ref | Locations in book | GLA exposure | Concentration % | Risk |
|---|---|---|---|---|
| Tenant A | 44 | 1.8M sf | 17.2% | CRITICAL |
| Tenant B | 36 | 1.4M sf | 13.4% | HIGH |
| Tenant C | 27 | 0.9M sf | 8.6% | HIGH |
| Tenant D | 22 | 0.6M sf | 5.7% | MEDIUM |
| Tenant E | 16 | 0.4M sf | 3.8% | MEDIUM |
| Tenant F | 12 | 0.3M sf | 2.9% | MEDIUM |
Drill-down — Row 02
How the composite of 91 was assembled. (Anonymized: AZ · Phoenix — Scottsdale corridor, 80–110k sf power center.)
Tier 1 · Deterministic — +60 of 64 max. Anchor lease expires in 14 months with no renewal option exercised; CMBS maturity in 11 months on the underlying asset; co- tenancy clause already triggered by sister-anchor going dark; recorded ownership change within 18 months.
Tier 2 · Statistical — +19 of 22 max. Same-store sales drift across the center down 6%; sub-market asking rents up 11% YoY (relocation arbitrage open); peer-asset cap-rate drift +45 bps; tenant-rollover concentration above 35% inside the next 24 months.
Tier 3 · LLM-Inferred — +7 of 9 max. Anchor's investor-call language shifting toward "footprint optimization"; sponsor 10-Q references "selective dispositions"; two competing brokerages have circulated comparable BoVs in the submarket within 90 days.
Tier 4 · Network — stub. Not run for this sample; CRM integration required to traverse the relationship graph. Estimated +5 to +9 if active.
Proprietary Overlay — +5 of +14 max. Two of six layers firing: cycle- position velocity (mid-cycle, submarket rents accelerating) and multi-broker pursuit (one competing pitch already detected on the asset).
Composite — 60 + 19 + 7 + 0 + 5 = 91. Hot threshold. Recommended outreach window: 30 days.
Redacted vs kept
Redacted
- Tenant brand names
- Landlord / sponsor names
- Specific street addresses
- Exact GLA and rent figures
- Anchor identities
- Broker-of-record names
- Loan servicer identities
Kept
- State and sub-market
- Asset format
- GLA band
- Lease-event risk tier
- Composite score
- Recommended outreach window
- Phase tier
- Tier-by-tier signal contribution
The real deployment shows all of it — we strip the identifying layer for cold prospect review and put it back on for the live demo, where the brokerage team sees the actual ranked mandate roster on screen with every signal that fired and every confidence chip.
Why this shape ports to retail brokerage
The shape is the same. Replace "succession risk" with "lease-event risk" and the engine renders occupiers with imminent renewal decisions, landlords with refi pressure, and brokerage relationships drifting toward re-pitch. The nine cross-intelligence layers port directly: carrier concentration becomes anchor-tenant concentration, broker flight risk becomes BoR drift, deal sequencing becomes mandate cadence, revenue uplift becomes fee-per-closed-mandate.
Composite-score thresholds (Hot ≥85, Priority 70–84, Watch 55–69) survive verbatim. The outreach windows scale with vertical: insurance succession runs in days, retail mandate windows run in weeks to a few months. The engine adapts; the discipline does not.
The 4-Week Sprint — what you walk away with
A working mandate playbook for your brokerage footprint, fully identified, on a four-week clock.
Footprint calibrated
Geo + asset format + tenant-size band locked. 5–10 named mandate targets seeded — full Tier 1 + Tier 2 stack on those, plus the rest of the universe at composite ≥70.
Tier 3 + deep-intel briefs
Tier 3 LLM-inferred signals applied across the universe; deep-intel briefs on the top five mandate targets, including BoR drift and competing-pitch detection.
Movers & multi-broker flag
Movers report and Multi-Broker Pursuit Triangulation flagged — when another shop is already pitching the same mandate, you see it before you spend a week on the deck.
Final ranked roster
40–60 mandate targets ranked, recommended outreach windows on top 15, warm-intro hypotheses where Tier 4 graph integrated, partner-ready recap memo.
What the conversation covers
- How the 418-node scope was assembled from public filings, county recorder data, CMBS servicer records, and lease-event telemetry — and how the same input layers populate a brokerage deployment for your footprint.
- How the nine cross-intel layers compose a single composite score per mandate, where the proprietary overlay contributes (cycle position, multi-broker pursuit, BoR drift), and which signal weights flex per shop's vertical mix.
- What a 14-day pilot for your footprint would surface — mandate count by composite ≥70, tenant concentration view, recommended outreach windows, warm-intro hypotheses if your relationship graph is integrated.
Thirty-minute call
We run live engine output on the call against the existing Constellation corpus — full disclosure on every signal that fires, no homework on your end. If the math works, the next step is a 4-week Sprint built around 5–10 mandate targets of your own choosing.