Add CRE prospect-DB expansion-resources research (Muse + Codex synthesis)

ec301aa969f35c8031b04a5230766b1754397c17 · 2026-08-10 21:30:33 -0700 · steve
Files touched

A reports/expansion-resources-2026-08-10.md
Diff

commit ec301aa969f35c8031b04a5230766b1754397c17
Author: steve <steve@designerwallcoverings.com>
Date:   Mon Aug 10 21:30:33 2026 -0700

    Add CRE prospect-DB expansion-resources research (Muse + Codex synthesis)
---
 reports/expansion-resources-2026-08-10.md | 44 +++++++++++++++++++++++++++++++
 1 file changed, 44 insertions(+)

diff --git a/reports/expansion-resources-2026-08-10.md b/reports/expansion-resources-2026-08-10.md
new file mode 100644
index 0000000..80bc04d
--- /dev/null
+++ b/reports/expansion-resources-2026-08-10.md
@@ -0,0 +1,44 @@
+# LABJ / RENTV CRE prospect DB — expansion resources
+_Generated 2026-08-10 · sources: Muse (glimmer, local $0) + Codex (gpt-5.3-codex) · synthesized_
+
+Two DBs today: **102k licensed targets** (CSLB/AZ ROC/DFPI/DRE/state bar/DOI) + **182 curated LABJ firms**.
+Goal: more REACHABLE LA-area CRE advertiser prospects. Priority = **FREE + programmatically accessible** (API/CSV) so a scraper can ingest them the way the 102k set was built.
+
+## ⭐ Mine-next: FREE + scriptable (highest leverage)
+These behave like the registries we already ingest — structured, bulk, no login:
+
+1. **LA City Open Data (Socrata)** — `data.lacity.org` API/CSV. Two goldmines:
+   - **LADBS Building Permits** — owner + architect + engineer + contractor on every active commercial/TI permit.
+   - **LA Office of Finance Active Businesses** — NAICS-filter CRE/construction/finance/property-services.
+2. **Other municipal permit portals** (ArcGIS/Socrata) — Long Beach, Pasadena, Glendale, Burbank, Santa Monica, Beverly Hills, Culver City, WeHo. Same owner/developer/GC/architect extraction as LADBS.
+3. **HUD LIHTC + Multifamily portfolio** — bulk CSV / ArcGIS API of affordable + FHA-insured property owners/managers (`huduser.gov`, `catalog.data.gov`).
+4. **CA CTCAC / CDLAC / HCD award files** — Excel/PDF of affordable-housing developers, owners, lenders, project teams (`treasurer.ca.gov/ctcac`).
+5. **SEC EDGAR + IAPD/Form ADV (bulk)** — REITs, real-estate funds, private lenders, REIT managers filtered to LA; submissions/company-facts API + ADV bulk compilations.
+6. **FDIC BankFind / Call Reports + SBA 7(a)/504 loan data** — LA banks ranked by CRE/construction-loan exposure; CDCs + CRE-active lenders. API/CSV via data.gov (extends our DFPI set with the CRE-lending signal).
+7. **CA DIR Public Works Contractors + Caltrans CUCP DBE** — active public-works GCs/subs + engineering/environmental firms (portal query).
+8. **LA Metro vendor/award + Cal eProcure + SAM.gov/USAspending** — prime/sub contractors, consultants, certified vendors winning public CRE/construction/leasing work.
+9. **LA County Assessor secured roll** — commercial owners + mailing addresses (bulk = PAID license; portal lookup FREE for targeted enrichment).
+
+## Associations & member directories (mostly PAID/gated, some FREE web listings)
+- **FREE/limited web directories:** BOMA Greater LA, AIA-LA firm directory, USGBC California, SoCal NonProfit Housing, LA-area BID member lists (DTLA/Hollywood/Century City/Westwood/Culver/Santa Monica).
+- **PAID/member:** NAIOP SoCal, ULI-LA, AIR CRE, IREM-LA, CREW-LA, CCIM-LA, SIOR-LA, ICSC, BIA SoCal, AGC-CA, CMAA SoCal, CA Mortgage Bankers Assn.
+
+## Ranked lists / trade pubs (LABJ-style pointers)
+- **FREE/partial:** The Real Deal LA broker/developer rankings, Connect CRE California (awards), Bisnow SoCal (speakers/sponsors), GlobeSt influencers, LA Conservancy/AIA-LA/USGBC project awards.
+- **PAID:** LABJ Book of Lists (also pull its banks/PE-VC/law/SBA lists, not just RE), LA Business First (bizjournals) lists, ENR California Top Lists (contractors/design/CM), BD+C Giants, Commercial Property Executive / Multi-Housing News, Real Estate Alert, Commercial Mortgage Alert, PERE / Private Debt Investor, CoStar Power Broker.
+
+## Mid-market firm GAPS to add to the 182 (named, likely missing)
+- **Private CRE lenders / debt brokers:** Dekel Capital, Calmwater Capital, iBorrow, Hankey Capital, Sonnenblick-Eichner. _(Thorofare, Parkview already added.)_
+- **Investment / development (mid):** Redcar Properties, Urban Offerings, Bolour Associates, CGI+ Real Estate Strategies, Champion Real Estate, LaTerra Development, The Luzzatto Company, Olive Hill Group.
+- **Industrial / infill owners:** BLT Enterprises, Dedeaux Properties, Dunbar REIM.
+- **Affordable / workforce:** FlyawayHomes, EAH Housing, West Hollywood Community Housing, A Community of Friends. _(Meta Housing, Abode already added.)_
+- **Retail specialists:** Primestor Development, Paragon Commercial Group, illi Commercial Real Estate, Beta Agency, Progressive Real Estate Partners.
+- **Boutique brokerage:** Industry Partners, Stevenson Real Estate Services. _(Lee, DAUM, Beitler, Charles Dunn, NAI Capital already in.)_
+- **Property management:** The Abbey Company, E&S Ring, Beach Front Property Mgmt, Positive Investments, Winstar Properties, RCMI. _(Moss & Co already added.)_
+- **Architecture / design:** Togawa Smith Martin, Abramson Architects, SPF:a, House & Robertson, Retail Design Collaborative. _(KFA, Gruen, Steinberg Hart already in.)_
+- **Regional GCs:** Oltmans, KPRS, C.W. Driver, Sinanian Development. _(Bernards, Morley already in.)_
+- **Engineering / CM:** Psomas, KPFF LA, Miyamoto International, Nabih Youssef, Cordoba Corp, Simpson Gumpertz & Heger LA.
+- **Overlooked service categories** (CRE-adjacent advertisers): CRE law boutiques, land-use consultants, environmental/remediation, seismic retrofit, appraisal, cost-seg, tax-appeal, 1031 intermediaries, title/escrow, surveyors, signage, elevators, roofing, HVAC, security/access, restoration, TI contractors, EV/solar installers, proptech, workplace/furniture.
+
+## Recommended first move
+Wire a **Socrata ingester** for `data.lacity.org` (LADBS permits + Active Businesses) — it's the same shape as the existing registry scrapers, FREE, and yields fresh owner/developer/architect/GC records continuously. Second: **HUD LIHTC + CTCAC** for the affordable-housing owner/developer layer.
← 8cba392 chore: lint (URL-decode guard, tighten path containment, dro · back to Labj Cre Banks · Add 48 mid-market LA CRE firms (Codex/Muse gap list): 182->2 7d9951a →