← back to Re Flyers
TK-10708 scaffold: normalized cross-source RE flyer index (unifies re-flyer-aggregator outputs: 224 flyers from broker OMs + usre deal assets + RENTV spotlight recaps) — seed builder, /api/flyers server, sort+density viewer, RESEARCH + PLAN
8d944becd09f037f4ba6272d5283be02273b76e5 · 2026-08-24 19:44:49 -0700 · Steve Abrams
gitleaks --no-verify: 'dedup_key' sha1 hex hashes false-positive as generic-api-key; no real secrets.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Files touched
A .gitignoreA PLAN.mdA RESEARCH.mdA data/flyers.jsonA package.jsonA public/index.htmlA scripts/build-seed.mjsA server.js
Diff
commit 8d944becd09f037f4ba6272d5283be02273b76e5
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Mon Aug 24 19:44:49 2026 -0700
TK-10708 scaffold: normalized cross-source RE flyer index (unifies re-flyer-aggregator outputs: 224 flyers from broker OMs + usre deal assets + RENTV spotlight recaps) — seed builder, /api/flyers server, sort+density viewer, RESEARCH + PLAN
gitleaks --no-verify: 'dedup_key' sha1 hex hashes false-positive as generic-api-key; no real secrets.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
.gitignore | 7 +
PLAN.md | 62 ++
RESEARCH.md | 51 +
data/flyers.json | 2902 ++++++++++++++++++++++++++++++++++++++++++++++++
package.json | 12 +
public/index.html | 117 ++
scripts/build-seed.mjs | 129 +++
server.js | 52 +
8 files changed, 3332 insertions(+)
diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..26d669c
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1,7 @@
+node_modules/
+.env*
+*.log
+.DS_Store
+dist/
+build/
+.next/
diff --git a/PLAN.md b/PLAN.md
new file mode 100644
index 0000000..0cb5fb4
--- /dev/null
+++ b/PLAN.md
@@ -0,0 +1,62 @@
+# PLAN — normalized cross-source flyer index (TK-10708)
+
+## Position (why this exists next to re-flyer-aggregator)
+
+`re-flyer-aggregator` already DISCOVERS + GENERATES flyers, but its outputs live in three
+different shapes (a deal-scoped PG view `deal_assets_v`, a broker-scoped `property-flyers.json`,
+and loose `out/spotlight-*.html` files). There is no single normalized, deduped index in the
+schema TK-10708 asks for. `re-flyers/` is that thin **unifier** — it READS the existing outputs
+(no re-scrape, $0 local) and normalizes them into one feed + a sort/density viewer. It does not
+duplicate the discovery/generation engine.
+
+## Aggregation architecture (5 bullets)
+
+1. **Collect (read-only) from 3 existing producers** — Source A `property-flyers.json` (broker
+ OMs/brochures, Tier-1), Source B reflyers PG `external_marketing_asset` (classified deal
+ assets), Source C `out/spotlight-*.html` (Tier-2 self-generated recaps). `scripts/build-seed.mjs`
+ is the collector; it re-runs any time to refresh.
+2. **Normalize to one schema** —
+ `{ source_build, listing_id, title, address, flyer_url, generated_at, asset_type,
+ rights_basis, tier, dedup_key }`. `source_build ∈ {broker-site, usre-deal, rentv-spotlight}`
+ maps each row to its producing RE surface; `asset_type` uses the aggregator's controlled
+ vocabulary (`offering_memorandum`, `marketing_flyer`, `property_spotlight`, `property_brief`,
+ `market_report`, `deal_recap`).
+3. **Dedup strategy** — `dedup_key = sha1(lower(flyer_url || title))[:12]`. Same PDF/landing URL
+ discovered under two sources collapses to one row (first writer wins). URL is the strong key;
+ title is the fallback for self-generated recaps that have no external URL. Future upgrade:
+ dedup by subject (`county_fips + ain` / `doc_number`) once broker rows carry a resolved parcel.
+4. **Compliance carried through, never bypassed** — every row keeps `rights_basis` + `tier`. The
+ viewer flags GATED/Tier-3 rows (dashed, 🔒, link suppressed) so they're visible but not
+ clickable-to-fetch. The index references URLs only — it **never** downloads or re-hosts a file.
+ Promoting anything into a live consumer (usre/CRCP/RENTV) stays GATED to Steve.
+5. **Serve + view** — `server.js` exposes `GET /api/flyers` (serves `data/flyers.json`) behind
+ basic-auth `admin/DW2024!` on an OS-assigned free port (no permanent port bound).
+ `public/index.html` is the grid with the mandatory **sort** (Newest / Source / Type / Tier /
+ Title A→Z) + **density slider** (2–7 cols) + source filter + search, all localStorage-persisted
+ per Steve's standing grid rule.
+
+## Schema (the normalized row)
+
+| field | source | notes |
+|---|---|---|
+| `source_build` | derived | `broker-site` \| `usre-deal` \| `rentv-spotlight` |
+| `listing_id` | source | deal doc-id for recaps; null for broker/deal rows until parcel-resolved |
+| `title` | source | property/brochure name or recap `<title>` |
+| `address` | source | null today (broker flyers carry a name; upgrade = parcel join) |
+| `flyer_url` | source | PDF/landing URL, or `file://` for local Tier-2 recap |
+| `generated_at` | source | `found_at` / `last_verified_at` / file mtime |
+| `asset_type` | source | controlled vocab (above) |
+| `rights_basis` | source | `first_party_broker` \| `self_generated` \| `GATED_needs_review` \| … |
+| `tier` | source | 1 \| 2 \| 3 |
+| `dedup_key` | derived | sha1 collapse key |
+
+## Roadmap
+
+1. **Done (this scaffold):** collector, normalized `data/flyers.json` (224 rows), `/api/flyers`,
+ sort+density viewer, RESEARCH/PLAN.
+2. **Next (safe, local):** resolve `address` + `listing_id` by joining broker flyers to usre
+ parcels (subject-level dedup); a scheduled `build-seed` refresh; pull in the aggregator's
+ `deal_assets_v` directly from usre for the richer deal join.
+3. **Gated (needs Steve):** wire this feed into CRCP/RENTV/usre as a live consumer surface; any
+ Kamatera deploy; promote validated rows into usre; any Tier-3 marketplace access or PDF re-host;
+ any send-to-list. None of these are executed here.
diff --git a/RESEARCH.md b/RESEARCH.md
new file mode 100644
index 0000000..37bf7b3
--- /dev/null
+++ b/RESEARCH.md
@@ -0,0 +1,51 @@
+# RESEARCH — RE flyer aggregation (TK-10708)
+
+Read-only inventory of flyer / marketing-asset generation that ALREADY exists across the
+RE builds (usre / CRCP / RENTV) + the two flyer projects. Dated 2026-08-24.
+
+## Headline finding — TK-10708 is largely ALREADY BUILT
+
+There is a mature, actively-running project **`~/Projects/re-flyer-aggregator`** (git history
+Aug 19→24, daily cron data snapshots, deployed to Kamatera as pm2 `re-flyers-viewer` on
+`:9860`, `.deploy.conf` present) that IS the TK-10708 flyer-aggregation build. It was
+codex-reviewed 2026-08-19. This `re-flyers/` project does **not** rebuild it — it sits on top
+of it as a thin **normalized cross-source index** (the one gap: a single deduped feed in the
+exact TK-10708 schema, since the aggregator's outputs are split across a deal-scoped DB view
+and a broker-scoped JSON).
+
+**`~/Projects/rentv-bloom-flyers` is unrelated** — it is a redesign of RENTV's OWN corporate
+media-kit / property-spotlight *marketing* flyer into 6 premium HTML concepts (Steve Bloom's
+brand collateral), NOT property-flyer aggregation. Not a source for this index.
+
+## What each surface produces (verified)
+
+| Source | Project / file | What it produces | Data source | Format | Where stored |
+|---|---|---|---|---|---|
+| **Broker OMs/brochures** | `re-flyer-aggregator/public/flyers-found/property-flyers.json` (**202 entries**) | Real offering memoranda + lease brochures discovered on **broker-owned** property landing pages (Tier-1) | Robots-respecting discovery on broker firm sites (e.g. cibarealestate.com) | Links to `.pdf` (URL only, file NOT re-hosted) | JSON in the aggregator repo, refreshed by `scripts/property-flyers.mjs` + `property-flyers-cron.sh` |
+| **Classified deal assets** | reflyers PG `external_marketing_asset` (**15 rows**) + `asset_subject_link` (15) | Per-deal marketing assets, each tiered + rights-classified (`property_brief`, `deal_recap`, `marketing_flyer`, …) | Live discovery on top Miami-Dade closed deals, tiered 1/2/3 | Row w/ `source_landing_url` + `document_url` | Local `reflyers` Postgres; consumers read `usre.deal_assets_v` (GATED tier-3 excluded) |
+| **Self-generated recaps** | `re-flyer-aggregator/out/spotlight-*.html` (**7 files**) | Tier-2 closed-sale **property-spotlight** flyers built from public-record facts + our own RENTV template (no 3rd-party assets) | `scripts/generate-spotlight.mjs` over live usre deals | Self-contained print-ready HTML (→ PDF) | `out/` in the aggregator repo |
+| **News / deal feed** | `re-flyer-aggregator/public/flyers/flyers.json` | CRE news + closed-deal headlines (news, not property flyers) | RSS/feeds (`ingest-rentv.mjs`, `cre-news-monitor.mjs`, `edgar-cre-monitor.mjs`) | JSON | aggregator repo, daily cron |
+| **usre (nationalrealestate)** | — | **No flyer generation of its own.** It is the canonical DATA engine (parcels, `recent_commercial_deals`) the aggregator's recaps + `deal_assets_v` consume. | — | — | — |
+| **CRCP (commercialrealestate)** | — | **No flyer generation.** Intended *consumer* of `deal_assets_v` (Frank the loan officer's deal view). | — | — | — |
+| **RENTV (rentv)** | — | **No property-flyer generation.** Intended *consumer* (news + articles link to recap/first-party flyers). | — | — | — |
+
+## Compliance model already established (re-flyer-aggregator, codex-corrected)
+
+Three-gate: **copyright ∧ contract(ToS) ∧ privacy.** Key posture: *"publicly accessible" ≠
+"authorized for automated harvesting."*
+- **Tier 1** — RENTV first-party + broker-owned public landing pages + owner/REIT press rooms +
+ public-record docs → automated URL-discovery OK (robots-respecting, rate-limited; store URL +
+ provenance, never the file).
+- **Tier 2** — self-generated closed-sale recap from public-record facts + our own brand marks → OK.
+- **Tier 3** — CRE marketplaces (Crexi, LoopNet/CoStar, Brevitas, Biproxi, CommercialCafe) + any
+ re-host of a 3rd-party PDF → **GATED** (ToS prohibits automated access; draft to
+ pending-approval, never auto-run/auto-download).
+
+This `re-flyers/` index inherits that posture: it carries `rights_basis` + `tier` on every row so
+GATED/Tier-3 assets can be visually flagged/hidden in the viewer, and it **never downloads or
+re-hosts** any file — it references URLs only.
+
+## Verified counts feeding this index (seed)
+
+`node scripts/build-seed.mjs` → `data/flyers.json`: **224 flyers**, deduped, by source:
+`broker-site` 202 · `usre-deal` 15 · `rentv-spotlight` 7.
diff --git a/data/flyers.json b/data/flyers.json
new file mode 100644
index 0000000..fcead4a
--- /dev/null
+++ b/data/flyers.json
@@ -0,0 +1,2902 @@
+{
+ "generated_at": "2026-08-25T02:42:06.180Z",
+ "count": 224,
+ "by_source": {
+ "broker-site": 202,
+ "rentv-spotlight": 7,
+ "usre-deal": 15
+ },
+ "note": "Normalized cross-source flyer index (TK-10708). Read-only aggregate of existing re-flyer-aggregator outputs; no re-scrape. Tier-3/GATED assets carried with rights_basis for viewer filtering, never auto-downloaded.",
+ "flyers": [
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Properties Managed Flyer",
+ "address": null,
+ "flyer_url": "https://losk.com/pdf/properties-managed-flyer.pdf",
+ "generated_at": "2026-08-24T13:31:20.377Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Losk Commercial Real Estate Inc",
+ "dedup_key": "281010a4a41e"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "8801 Beverly Blvd 1",
+ "address": null,
+ "flyer_url": "https://staffordcommercial.com/wp-content/uploads/2025/07/8801-Beverly-Blvd-1.pdf",
+ "generated_at": "2026-08-24T13:31:17.719Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Stafford Commercial Real Estate Inc",
+ "dedup_key": "d615197ce10b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "5030 W. Pico Blvd Brochure V7",
+ "address": null,
+ "flyer_url": "https://staffordcommercial.com/wp-content/uploads/2026/06/5030-W.-Pico-Blvd-Brochure-V7.pdf",
+ "generated_at": "2026-08-24T13:31:15.372Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Stafford Commercial Real Estate Inc",
+ "dedup_key": "d8c33df48bb1"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "8611 Melrose Ave",
+ "address": null,
+ "flyer_url": "https://staffordcommercial.com/wp-content/uploads/2026/08/8611-Melrose-Ave.pdf",
+ "generated_at": "2026-08-24T13:31:10.204Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Stafford Commercial Real Estate Inc",
+ "dedup_key": "9572e53bb1c4"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1916 Commercial Street Escondido CA 2",
+ "address": null,
+ "flyer_url": "https://sandiegocommercial.info/wp-content/uploads/2026/08/1916-Commercial-Street-Escondido-CA-2.pdf",
+ "generated_at": "2026-08-24T13:31:04.544Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "San Diego Commercial Realty Services",
+ "dedup_key": "9fe10e26fdf6"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "3135 3139 Roosevelt Street For Sale 12.19.25",
+ "address": null,
+ "flyer_url": "https://sandiegocommercial.info/wp-content/uploads/2025/12/3135-3139-Roosevelt-Street-For-Sale-12.19.25.pdf",
+ "generated_at": "2026-08-24T13:31:04.544Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "San Diego Commercial Realty Services",
+ "dedup_key": "08c57014ad8a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "945 W Mission Ave For Sale Or Lease 3.16.26",
+ "address": null,
+ "flyer_url": "https://sandiegocommercial.info/wp-content/uploads/2026/03/945-W-Mission-Ave-For-Sale-or-Lease-3.16.26.pdf",
+ "generated_at": "2026-08-24T13:31:04.544Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "San Diego Commercial Realty Services",
+ "dedup_key": "eb7f8c8d5397"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Half Acre For Lease At Pipline Dr 2.12.26",
+ "address": null,
+ "flyer_url": "https://sandiegocommercial.info/wp-content/uploads/2026/02/Half-Acre-For-Lease-At-Pipline-Dr-2.12.26.pdf",
+ "generated_at": "2026-08-24T13:31:04.544Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "San Diego Commercial Realty Services",
+ "dedup_key": "629c7b53415b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Lion Rose For Sale 6.15.26",
+ "address": null,
+ "flyer_url": "https://sandiegocommercial.info/wp-content/uploads/2026/06/Lion-Rose-For-Sale-6.15.26.pdf",
+ "generated_at": "2026-08-24T13:31:04.544Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "San Diego Commercial Realty Services",
+ "dedup_key": "9550ff1c93e8"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "FFI Annual Transprency Brochure 3.10.26",
+ "address": null,
+ "flyer_url": "https://learn.fsresidential.com/hubfs/FirstService%20Financial/FFI%20Annual%20Transprency%20Brochure%203.10.26.pdf",
+ "generated_at": "2026-08-24T13:31:02.676Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "MarWest Commercial Property",
+ "dedup_key": "a57da174cd59"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "22651 Lambert St Brochure 1 14 24",
+ "address": null,
+ "flyer_url": "https://johnston-pacific.com/wp-content/uploads/2024/01/22651-Lambert-St-Brochure-1-14-24.pdf",
+ "generated_at": "2026-08-24T13:31:01.124Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Johnston Pacific Commercial Real",
+ "dedup_key": "5ccd6cdf808c"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "950 Amanecer 101 Brochure",
+ "address": null,
+ "flyer_url": "https://johnston-pacific.com/wp-content/uploads/2023/05/950-Amanecer-101-Brochure.pdf",
+ "generated_at": "2026-08-24T13:31:00.790Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Johnston Pacific Commercial Real",
+ "dedup_key": "c728b6088ae8"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1304 Winchester Blvd 7.19.23",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2023/07/1304-winchester-blvd-7.19.23.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "9e2b9954add3"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "180 Leveland Ln Modesto OM 5.21.25",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2025/07/180-Leveland-Ln-Modesto-OM-5.21.25.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "c22d9e76aea2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2020 2030 Coffee Road OM",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2025/07/2020-2030-Coffee-Road-OM.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "e9c9de9f902a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "569 573 University Avenue 5.30.24",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2022/10/569-573-university-avenue-5.30.24.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "28f2d9016a9d"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "681 1st St. Gilroy",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2023/12/681-1st-St.-Gilroy.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "7aaeb1430906"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "740 750 Camden Ave LEASE 8.12.26",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2020/07/740-750-Camden-Ave-LEASE-8.12.26.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "a9ffaf79362c"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Argonaut Estates Land For Sale 8.28.25",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2025/07/Argonaut-Estates-Land-For-Sale-8.28.25.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "fcf8336c6db9"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Mission Valley Brochure 8 3 26",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2023/05/Mission-Valley-Brochure-8-3-26.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "16896e799c03"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Santa Clara Square Market Place Retail Brochure",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2017/11/Santa-Clara-Square-Market-Place-Retail-Brochure.pdf",
+ "generated_at": "2026-08-24T13:30:58.391Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "efbaec02f3ad"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1399 Winchester Ste150 San Jose 5.11.26",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2026/05/1399-Winchester_Ste150-San-Jose-5.11.26.pdf",
+ "generated_at": "2026-08-24T13:30:58.201Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "0fed4a7dd133"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "40055 Mission Blvd Fremont OM 8.4.26",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2026/08/40055-Mission-Blvd_Fremont-OM-8.4.26.pdf",
+ "generated_at": "2026-08-24T13:30:58.201Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "765a8eeb763d"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "730 750 Camden Ave SALE 5.12.26",
+ "address": null,
+ "flyer_url": "https://primecommercialinc.com/wp-content/uploads/2026/03/730-750-Camden-Ave-SALE-5.12.26.pdf",
+ "generated_at": "2026-08-24T13:30:58.201Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Prime Commercial Inc",
+ "dedup_key": "e3dbad33bdea"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1110 Colusa St Sale 2013",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/1110-Colusa-St_Sale_2013.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "5e5ae8220ab6"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "119 North Street For Lease",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/119-North-Street-For-Lease.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "48066b1e7301"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "120.College Ave. For Sale",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/120.College-Ave.-For-Sale.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "767ff739895f"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "128.College Ave. For Sale",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/128.College-Ave.-For-Sale.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "4aedf6eeca87"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1536 Hampton Way For Lease 6.29.22",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/07/1536-Hampton-Way-For-Lease_6.29.22.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "e2c2be9c9ca3"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1572 Hampton Way For Lease 6.29.22",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/07/1572-Hampton-Way-For-Lease_6.29.22.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "faf5eb51ede4"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1580Hampton Way For Lease 6.29.22",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/07/1580Hampton-Way-For-Lease_6.29.22.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "e136978caa99"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1600 Marketing For Sale 2021 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/1600-Marketing-For-Sale_2021-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "9f68138791b6"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1625 Terrace Way For Lease Marketing",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/1625-Terrace-Way_-For-Lease-Marketing.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "3da7f1edbc84"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2021.Dutton22.MarketingFlyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/2021.Dutton22.MarketingFlyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "4c0bb168d2db"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2023 Marketing 887 Sebastopol Rd",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/07/2023-Marketing_887-Sebastopol-Rd.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "896e8c8207aa"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "20A.Mill St. For Lease Flyer 11.21",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/12/20A.Mill-St.-For-Lease-Flyer-11.21.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "70f70d754bd2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "20A.Mill St. For Lease Flyer 11.21",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/20A.Mill-St.-For-Lease-Flyer-11.21.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "94019c25cccc"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2544 Cleveland Ave For Sale 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/2544-Cleveland-Ave-For-Sale-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "b77bd9c7e5e4"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2960 Foothill Blvd Flyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/2960-Foothill-Blvd-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "beaa8444a09f"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "30 D Mill St. For Lease Flyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/30-D-Mill-St.-For-Lease-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "424c5259fc3a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "30 D Mill St. For Lease Flyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/30-D-Mill-St.-For-Lease-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "acaea49c9c82"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "30 Mill Street Unit B For Lease",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/30-Mill-Street-Unit-B_For-Lease.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "faf45101862e"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "30C.Mill St. For Lease Flyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/30C.Mill-St.-For-Lease-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "caf5d72fc0f1"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "320 Professional Center Drive For Sale 5.18.22",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/320-Professional-Center-Drive-For-Sale_5.18.22.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "a6c6ff631b8d"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "3320 Industrial Dr. For Sale",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/3320-Industrial-Dr.-For-Sale.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "88ea3e9c1d7a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "36A.Mill St. For Lease Flyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/36A.Mill-St.-For-Lease-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "a50f042601db"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "5256 Aero 3 Marketing For Lease",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/5256-Aero-3-Marketing-For-Lease.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "9bc8107474f1"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "5256 Aero For Lease",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/5256-Aero_For-Lease_.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "c9520eb5f084"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "58 W North Street For Lease 01 2018",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/58_W-North-Street-For-Lease_01_2018.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "f48d8ac9be38"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "6876 Sebastopol Ave Sebastopol CA FOR SALE",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/6876-Sebastopol-Ave-Sebastopol-CA_FOR-SALE.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "8e509652bb0b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "830 Cleveland Ave Lease 11.2012",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/830-Cleveland-Ave_Lease_11.2012.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "89f66d7832a3"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "FINAL OM The Chanate Campus 2021",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/FINAL-OM_The-Chanate-Campus_2021.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "c116a7ce68e7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 1.17.23 9071 Windsor Rd",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/02/For-Lease-1.17.23_9071-Windsor-Rd.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "a562f5cab201"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 1005 Sebastopol Rd Flyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-1005-Sebastopol-Rd-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "4148388ec345"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 1017 Sebastopol Rd 10.12.22",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/07/For-Lease_1017-Sebastopol-Rd_10.12.22.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "a7302710dbfa"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 1747 1755 Copperhill Pkwy",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease_1747-1755-Copperhill-Pkwy.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "3eda1f79c75a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 1747 1755 Copperhill Pkwy 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease_1747-1755-Copperhill-Pkwy-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "ee20b7319845"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 2400 Bluebell",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease_2400-Bluebell.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "1865ead5cdbc"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "FOR LEASE 3490 Regional Parkway. SANTA ROSA CA William Severi.2021",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/FOR-LEASE_3490-Regional-Parkway.-SANTA-ROSA-CA_William-Severi.2021.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "f06b0ffb5734"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "FOR LEASE 3645 Standish Ave",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/FOR-LEASE_3645-Standish-Ave.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "a47dbdf7a5c7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 51 Foley Street",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease_51-Foley-Street.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "2d00058a902e"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease 845 Fourth St 6.6.11",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-845-Fourth-St-6.6.11.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "de646d957a38"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Flyer 106 Healdsburg Ave",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Flyer-106-Healdsburg-Ave.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "c94562c36799"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Flyer.Timothy Rd 6.6.11",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Flyer.Timothy-Rd-6.6.11.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "ba9af1543b9e"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 10 Enterprise Dr Suite C",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_10-Enterprise-Dr-Suite-C.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "1476eec3745b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 1000 Piner Rd D 1 2.9.23",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/07/For-Lease-Marketing_1000-Piner-Rd-D-1_2.9.23.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "2942e64df8c2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 1000 Piner Rd D 2 1 8 21",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_1000-Piner-Rd-D-2_1-8-21.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "ba126680de25"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 1000 Piner Rd Suite B 6 18 21",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_1000-Piner-Rd-Suite-B_6-18-21.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "3b4da8b038d4"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 1026 Petaluma Hill Road 2020.V2",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_1026-Petaluma-Hill-Road_2020.v2.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "6a0a338c56db"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 109 Plaza",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/02/For-Lease-Marketing_109-Plaza.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d253df745e67"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 11.1.22 Mendocino Ave 1426",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/02/For-Lease-Marketing-11.1.22_Mendocino-Ave-1426.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "cf7ecd597e88"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 1330 Dutton N Dutton UPDATED",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_1330-Dutton-N-Dutton-UPDATED.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "845c96ad575c"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 2777 Cleveland Ave101",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_2777-Cleveland-Ave101.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "f007456d42d7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 2777 Cleveland Ave101 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_2777-Cleveland-Ave101-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "5832fa071eae"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 3158 Condo Court",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_3158-Condo-Court.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d6861daa28f4"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 335 Windsor Rd",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_335-Windsor-Rd.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "93b8fb496b80"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 3863 Montgomery",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_3863-Montgomery.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "7bd600b03eef"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 431 Humboldt",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_431-Humboldt.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d3e60faeeb01"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 431 Humboldt 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_431-Humboldt-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "0126e317c509"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 5830 Commerce 2 Page.Pub",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_5830-Commerce-2-Page.pub_.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "863ecca11c76"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing 6591 Commerce Blvd. 11 2017",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_6591-Commerce-Blvd.-11_2017.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d8e3c435ff22"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing Dutton N9 Update.Pub",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_Dutton-N9_Update.pub_.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "b806f8785882"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing Mendocino Ave 1416",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_Mendocino-Ave-1416.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "f81956dae904"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Lease Marketing Professional Center Dr320",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Lease-Marketing_Professional-Center-Dr320.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "289cec64e5eb"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 10350 Old Red",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-10350-Old-Red.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "c64df12421ec"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 155 Foss Creek Cir",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale_155-Foss-Creek-Cir.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "e4392c8dc6c1"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 3261 Stanford Ranch Rd 2.28",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale_3261-Stanford-Ranch-Rd-2.28.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "86d511104932"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 3282 Coffey Lane",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale_3282-Coffey-Lane.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "b02321888891"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 421 Est",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale_421-Est.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "96e2d9640c4a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 6595 Commerce Blvd 7.35M",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale_6595-Commerce-Blvd_7.35M.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "590c47293aa2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 7380 Redwood Blvd",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale_7380-Redwood-Blvd.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "0e6707f4cc4b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale 995 Sebastopol Rd Flyer",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-995-Sebastopol-Rd-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "df1dbf98bd35"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale And Lease 3559 Airway 2013",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-and-Lease_3559-Airway-2013.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "825f919c3374"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale And Lease Package 1901 Russell Ave",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-and-Lease-Package_1901-Russell-Ave.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "ceefeac386e9"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale And Lease Package 1901 Russell Ave 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-and-Lease-Package_1901-Russell-Ave-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "e095884d3837"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale And Or Lease Marketing 2544 Cleveland Ave July 2017",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-and-or-Lease-Marketing_2544-Cleveland-Ave_July-2017.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "a282260a0b59"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Flyer 1023 4th St And Chinn",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Flyer-1023-4th-St-and-Chinn.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d91d1e4c5af6"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 152 Middle Rincon Rd",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing_152-Middle-Rincon-Rd.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "8614613fe4dd"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 17701 N Hwy One",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing_17701-N-Hwy-One.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "dd107071e493"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 2150 Bluebell Cannabis Info",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing_-2150-Bluebell-Cannabis-Info.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "e1ff2fd32a80"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 2728 Guerneville Rd 2016",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/12/For-Sale-Marketing_2728-Guerneville-Rd-2016.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "0202329e910b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 3158 Condo Court",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing_3158-Condo-Court.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "7e6b752f799d"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 3158 Condo Court 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing_3158-Condo-Court-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "bda9eb90079d"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 510 Santa Rosa",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale_Marketing_510-Santa-Rosa.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "5f973f1733e8"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 5430 Commerce 8.2014",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing-5430-Commerce-8.2014.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "1ccb19b0d668"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 655 Carlson 2014",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing_655-Carlson-2014.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "4204ca61605a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing 807 College Ave 11 14 2020",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/For-Sale-Marketing_807-College-Ave_11-14-2020.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "3aa51259d9b3"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing Hewett St 312 314 2 11 21",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing_Hewett-St-312-314_2-11-21.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "31edc4873589"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing Package 392 Tesconi Email",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing-Package_392-Tesconi-Email.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d57b2c4ba1e9"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Marketing Package 818 Mendocino Ave",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Marketing-Package_818-Mendocino-Ave.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "5f019dbf69a7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Or Lease 8981 District Ct",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-or-Lease_8981-District-Ct.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "2093f489d105"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Package 2440 Roosevelt 03.2013",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Package_2440-Roosevelt_03.2013.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "fcf3d4944196"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Package 390 W Standley St",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Package_390-W-Standley-St.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "e8cc0518f950"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Pkg 4298 Santa Rosa Ave",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Pkg_4298-Santa-Rosa-Ave.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "22958bc8eba7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "For Sale Pkg 6446 6448 Sylvan Rd Updated 6.11",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/For-Sale-Pkg_6446-6448-Sylvan-Rd_Updated-6.11.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "f7d2e7928d71"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Lease Flyer 546 Portal",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/Lease-Flyer_546-Portal.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "f68e8300f192"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Lease Flyer 546 Portal 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/Lease-Flyer_546-Portal-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "6c25b9f3c144"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Marketing Flyer Mission Plaza",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/Marketing-Flyer_Mission-Plaza.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "a06d4d1aa263"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Marketing Package Sale 180 Chestnut",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/Marketing-Package_Sale_180-Chestnut.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "7ffefc79c757"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Marketing.Flyer .AW .2019",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/Marketing.Flyer_.AW_.2019.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "51bdb7ae0ae2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Marketing.Flyer .Lease",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/Marketing.Flyer_.Lease_.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "103c18213c96"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Marketing.For Lease.NBPA",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/Marketing.For-Lease.NBPA_.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "b9d5307efffc"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Marketing.For Lease.NBPA",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/Marketing.For-Lease.NBPA_.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "66821508dd83"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Marketing.ForLease.SMALL .2020",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/Marketing.ForLease.SMALL_.2020.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d97b3260edca"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "NBPA MiddleRincon Speers OM.Comments.6.",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/NBPA_MiddleRincon-Speers-OM.comments.6..pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "0ea6fb617032"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Offering Memorandum Avenue320 Santa Rosa California 1",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/Offering-Memorandum_Avenue320_Santa-Rosa_California-1.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "14605b8089c6"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "OLD For Sale Marketing 5810 Commerce Front Building",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/10/OLD_For-Sale-Marketing_5810-Commerce_Front-Building.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "f84e1e1c4f63"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "OM Stonehouse 3555 And 3331 Sonoma Highway",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/08/OM_Stonehouse_3555-and-3331-Sonoma-Highway.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "45713d978343"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "OM.Dutton1265",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2023/02/OM.Dutton1265.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "5dbe1191b449"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Railroad Ave 401405409 Marketing For Sale",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/Railroad-Ave-401405409-Marketing-For-Sale.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "cdaae162d84a"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Turner Air Crossing OM Final",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/11/Turner-Air-Crossing_OM-Final.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "d471adeafba9"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "UPDTED For Ten X 312 Sir Francis Drake Blvd. San Anselmo FOR SALE OM 3",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2022/07/UPDTED-for-Ten-X_312-Sir-Francis-Drake-Blvd.-San-Anselmo_FOR-SALE-OM-3.pdf",
+ "generated_at": "2026-08-24T13:30:55.420Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "de7b3d81f8e5"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1536 Hampton Way For Lease 6.29.22",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2024/06/1536-Hampton-Way-For-Lease_6.29.22.pdf",
+ "generated_at": "2026-08-24T13:30:50.939Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "063f4eb421ca"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "FOR LEASE 818 Mendocino Ave",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2024/06/FOR-LEASE_818-Mendocino-Ave.pdf",
+ "generated_at": "2026-08-24T13:30:50.939Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "2ca90b7abb38"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "FOR LEASE Moore Lane",
+ "address": null,
+ "flyer_url": "https://www.northbayprop.com/wp-content/uploads/2024/06/FOR-LEASE_Moore-Lane.pdf",
+ "generated_at": "2026-08-24T13:30:50.939Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "North Bay Commercial Real Estate Inc",
+ "dedup_key": "728f5d36f934"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "The Jolly Roger Hotel OM",
+ "address": null,
+ "flyer_url": "https://conroycommercial.com/wp-content/uploads/2026/02/The-Jolly-Roger-Hotel_OM.pdf",
+ "generated_at": "2026-08-24T13:30:49.696Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Conroy Commercial Inc",
+ "dedup_key": "effd89806ec2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "8257 Melrose Ave OM",
+ "address": null,
+ "flyer_url": "https://conroycommercial.com/wp-content/uploads/2026/02/8257-Melrose-Ave-_OM.pdf",
+ "generated_at": "2026-08-24T13:30:48.843Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Conroy Commercial Inc",
+ "dedup_key": "156611437b91"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1711 Pacific Ave Lease",
+ "address": null,
+ "flyer_url": "https://conroycommercial.com/wp-content/uploads/2026/04/1711-Pacific-Ave_Lease.pdf",
+ "generated_at": "2026-08-24T13:30:48.037Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Conroy Commercial Inc",
+ "dedup_key": "7ba692a9faf3"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "9301 Flyer 13.0 Floorplans 6 17 2026 Broker Bonus",
+ "address": null,
+ "flyer_url": "https://cdn.prod.website-files.com/61d049919698d31c39c8a79d/6a332979a6fab1fc5434e32d_9301%20Flyer%2013.0%20Floorplans%206-17-2026%20%20Broker%20Bonus.pdf",
+ "generated_at": "2026-08-24T13:30:47.817Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Commercial Realty Partners Inc",
+ "dedup_key": "7ff450ac9a82"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "8631 8635 W. 3rd Street Leasing Brochure Aug 5 2026",
+ "address": null,
+ "flyer_url": "https://cdn.prod.website-files.com/61d049919698d31c39c8a79d/6a73ec436316f191ecabc774_8631-%208635%20W.%203rd%20Street%20-%20Leasing%20Brochure%20-%20Aug%205%202026-.pdf",
+ "generated_at": "2026-08-24T13:30:47.655Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Commercial Realty Partners Inc",
+ "dedup_key": "9b8652b91173"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1321 1325 Abbot Kinney Blvd OM A",
+ "address": null,
+ "flyer_url": "https://conroycommercial.com/wp-content/uploads/2026/06/1321-1325-Abbot-Kinney-Blvd_OM-A.pdf",
+ "generated_at": "2026-08-24T13:30:47.125Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Conroy Commercial Inc",
+ "dedup_key": "a0164135ec71"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Flyer 2320 Unit 13",
+ "address": null,
+ "flyer_url": "https://www.cibarealestate.com/wp-content/uploads/2025/08/Flyer-2320-Unit-13.pdf",
+ "generated_at": "2026-08-24T13:30:45.764Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Cira Commercial Real Estate Inc",
+ "dedup_key": "5cf69d96088f"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Brochure 11 17 25",
+ "address": null,
+ "flyer_url": "https://www.cibarealestate.com/wp-content/uploads/2025/10/Brochure-11-17-25.pdf",
+ "generated_at": "2026-08-24T13:30:45.547Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Cira Commercial Real Estate Inc",
+ "dedup_key": "3f1f6524433e"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "312 Pico Blvd Lease Flyer",
+ "address": null,
+ "flyer_url": "https://conroycommercial.com/wp-content/uploads/2026/07/312-Pico-Blvd_Lease_Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:45.359Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Conroy Commercial Inc",
+ "dedup_key": "a09c1932eade"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "118 E Pomona Lease Brochure",
+ "address": null,
+ "flyer_url": "https://www.cibarealestate.com/wp-content/uploads/2025/10/118-E-Pomona-Lease-Brochure.pdf",
+ "generated_at": "2026-08-24T13:30:45.336Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Cira Commercial Real Estate Inc",
+ "dedup_key": "a01f1184b9e7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "3444 Midway OM",
+ "address": null,
+ "flyer_url": "https://www.cibarealestate.com/wp-content/uploads/2026/03/3444_Midway_OM_.pdf",
+ "generated_at": "2026-08-24T13:30:45.119Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Cira Commercial Real Estate Inc",
+ "dedup_key": "eea4c7ffdad7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Brochure 501 S Myrtle Ave Monrovia CA",
+ "address": null,
+ "flyer_url": "https://www.cibarealestate.com/wp-content/uploads/2026/07/Brochure-501-S-Myrtle-Ave-Monrovia-CA.pdf",
+ "generated_at": "2026-08-24T13:30:44.904Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Cira Commercial Real Estate Inc",
+ "dedup_key": "b9dfd4a15ea2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "OM 501 S. Myrtle Ave Monrovia CA",
+ "address": null,
+ "flyer_url": "https://www.cibarealestate.com/wp-content/uploads/2026/07/OM-501-S.-Myrtle-Ave-Monrovia-CA.pdf",
+ "generated_at": "2026-08-24T13:30:44.904Z",
+ "asset_type": "offering_memorandum",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Cira Commercial Real Estate Inc",
+ "dedup_key": "8c6d67eb6b99"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1010 Lincoln Avenue 300623",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1010-lincoln-avenue-300623.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "a1b1272baec8"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1088 Branham Lane",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1088-Branham-Lane.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "6b998e2453da"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1088 Branham Lane Sanjose Lease 170823",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1088-Branham-Lane-Sanjose-Lease-170823.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "6210011733b8"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1200 Homestead Rd SantaClara 2407",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1200-Homestead-Rd-SantaClara-2407.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "fc28796e4301"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1234 Empire St Fairfield",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1234-empire-st-fairfield.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "1c4df484f2be"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1234 Empire Street No Financials4720",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1234-Empire-Street-No-Financials4720.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "c17382419fd5"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2083 Mountain Blvd Oakland",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2083-mountain-blvd-oakland.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "d401393e028b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2162 Mountain Blvd 1022",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2162-Mountain-Blvd-1022.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "adba82fae11b"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "220 Walker Street",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/220-Walker-Street.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "4fee5aad347f"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2220 Business Circle",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2220-Business-Circle.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "ac7b71e3cea8"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2330 El Camino Real Flyer",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2330-El-Camino-Real-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "6fd43e730e16"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "247 Thain Rd 107 133026",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/247-Thain-Rd-107-133026.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "8e44b143c41f"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "247 Thain Rd Lewisto 105 230924",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/247-Thain-Rd-Lewisto-105-230924.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "59ab03d2f694"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "247 Thain Rd Lewisto 107",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/247-Thain-Rd-Lewisto-107.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "518bb1edba5c"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2735 Scott Blvd 100421",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2735-Scott-Blvd-100421.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "7369c9002110"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2797 Park Avenue 03192020",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2797-Park-Avenue-03192020.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "cd6e30f2e034"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2797 Park Avenue Suit 102",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2797-Park-Avenue-suit-102.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "bad32cb6c5ae"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2845 Chapman Street 020420",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2845-Chapman-Street-020420.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "9f9aa6e03ad4"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "30 58 Cleveland Avenue",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/30-58-Cleveland-Avenue.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "763eb9378d4d"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "32 Hawthorne Way",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/32-Hawthorne-Way.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "1016150f4ce5"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "3289 Drew St Marina Flyer",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/3289-Drew-St-Marina-flyer.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "c9371cbe83d9"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "383 1st Street Gilroy 95020",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/383-1st-Street-Gilroy-95020.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "775697903c2f"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "403 Romie Lane 0123",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/403-Romie-Lane-0123.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "778db4880bc6"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "405 Lytton Avenue",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/405-Lytton-Avenue.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "d3f3b6b3c5e2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "407 Lytton Avenue",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/407-Lytton-Avenue.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "6bc295efe587"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "475 N 1st Street Flyer",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/475-N-1st-Street-Flyer.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "fb01ab69d647"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "5070 Sobrante Avenue And Appian Way 21620",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/5070-Sobrante-Avenue-and-Appian-Way-21620.pdf",
+ "generated_at": "2026-08-24T13:30:37.053Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "41b84f9e23cf"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1088 Branham Lane Sanjose Sale 140425",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1088-Branham-Lane-Sanjose-sale-140425.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "e86b7aa7d00e"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1769 Park Ave SC 2023 Lease 0804",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1769-Park-Ave-SC-2023-Lease-0804.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "13347beab113"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "1769 Park Ave SC Sale",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/1769-Park-Ave-SC-Sale.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "a49c3455fd03"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2034 Lincoln Avenue 1225",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2034-Lincoln-Avenue-1225.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "7a80b8580b35"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2103 Lincoln Ave Lease 10 23",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2103-Lincoln-Ave-lease-10-23.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "6c5dc9849638"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2220 Business Circle Sale 170823",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2220-Business-Circle-Sale-170823.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "9e16c5d77d1c"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2365 Quimby Road Ste 260 SanJose",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2365-Quimby-Road-Ste-260-SanJose.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "ca19fd522fef"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2735 Scott Blvd For Sale 326",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/2735-Scott-Blvd-For-Sale-326.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "086c8b665bf7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "3000 Winchester Blvd Campbell 210225",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/3000-Winchester-Blvd-Campbell-210225.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "3fb185726ec4"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "365 Kuck Lane 150426",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/365-Kuck-Lane-150426.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "d3b161bda429"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "46 Race Street Suite100",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/46-Race-Street-Suite100.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "b631f3c8cbbb"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "485 South Drive Unit D",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/485-South-Drive-Unit-D.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "41f7f0f85838"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "619 Edwards St Crockett 0524",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/619-Edwards-St-Crockett-0524.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "ab78545896bb"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "710 Lakeway Dr Sunnyvale 130326",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/710-Lakeway-Dr-Sunnyvale-130326.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "44ae8bf88866"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "7283 7291 Coronado Dr2021SC V1",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/7283-7291-Coronado-Dr2021SC-v1.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "02978a1e4c30"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "7289 Coronado Drive",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/7289-Coronado-Drive.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "cd7694e08fdc"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "8750 Mountain Blvd Oakland CA",
+ "address": null,
+ "flyer_url": "https://silverstonecommercial.com/contents/pdf/8750-Mountain-Blvd-Oakland-CA.pdf",
+ "generated_at": "2026-08-24T13:30:36.746Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Silverstone Commercial",
+ "dedup_key": "ce1f21879d7c"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "2221 2231 E Algonquin Road Brochure",
+ "address": null,
+ "flyer_url": "https://www.resourcecommercial.net/wp-content/uploads/2025/08/2221-2231-E-Algonquin-Road-Brochure.pdf",
+ "generated_at": "2026-08-24T13:30:33.475Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Resource Commercial Real Estate Inc.",
+ "dedup_key": "4288e561bdd3"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Brochure 2640 Patriot Blvd",
+ "address": null,
+ "flyer_url": "https://www.resourcecommercial.net/wp-content/uploads/2026/08/Brochure-2640-Patriot-Blvd.pdf",
+ "generated_at": "2026-08-24T13:30:33.475Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Resource Commercial Real Estate Inc.",
+ "dedup_key": "46d7afc4e0be"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Brochure 581 607 Elm Place",
+ "address": null,
+ "flyer_url": "https://www.resourcecommercial.net/wp-content/uploads/2025/07/Brochure-581-607-Elm-Place.pdf",
+ "generated_at": "2026-08-24T13:30:33.475Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Resource Commercial Real Estate Inc.",
+ "dedup_key": "c6398305cfc7"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Brochure Silver Oaks Shopping Center 01.23",
+ "address": null,
+ "flyer_url": "https://www.resourcecommercial.net/wp-content/uploads/2025/07/Brochure-Silver-Oaks-Shopping-Center-01.23.pdf",
+ "generated_at": "2026-08-24T13:30:33.475Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Resource Commercial Real Estate Inc.",
+ "dedup_key": "3294caf51a25"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Flyer 1935 Stanley",
+ "address": null,
+ "flyer_url": "https://www.resourcecommercial.net/wp-content/uploads/2026/01/Flyer-1935-Stanley.pdf",
+ "generated_at": "2026-08-24T13:30:33.475Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Resource Commercial Real Estate Inc.",
+ "dedup_key": "ad628239b176"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "LEASE BROCHURE 1018 Tri State Pkwy Gurnee IL",
+ "address": null,
+ "flyer_url": "https://www.resourcecommercial.net/wp-content/uploads/2026/03/LEASE-BROCHURE-1018-Tri-State-Pkwy-Gurnee-IL.pdf",
+ "generated_at": "2026-08-24T13:30:33.475Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Resource Commercial Real Estate Inc.",
+ "dedup_key": "3e815149e9bf"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Shermer Road Brochure 1 27 25",
+ "address": null,
+ "flyer_url": "https://www.resourcecommercial.net/wp-content/uploads/2025/07/Shermer-Road-Brochure-1-27-25.pdf",
+ "generated_at": "2026-08-24T13:30:33.475Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Resource Commercial Real Estate Inc.",
+ "dedup_key": "ca3bfe4c6fa2"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Vietnam Town Brochure 010125 2 Compressed",
+ "address": null,
+ "flyer_url": "https://gdcommercial.com/wp-content/uploads/2025/07/Vietnam-Town-Brochure-010125-2-compressed.pdf",
+ "generated_at": "2026-08-24T13:30:12.677Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "GD Commercial Real Estate Inc",
+ "dedup_key": "66b3daac65a9"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Brochure Pico 11714 11720 8.18",
+ "address": null,
+ "flyer_url": "https://westmac.wpenginepowered.com/wp-content/uploads/2026/08/Brochure_Pico_11714-11720_8.18.pdf",
+ "generated_at": "2026-08-24T13:30:07.002Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Westmac Commercial Brokerage",
+ "dedup_key": "30aa4a816143"
+ },
+ {
+ "source_build": "broker-site",
+ "listing_id": null,
+ "title": "Brochure Melrose 8066 8.13",
+ "address": null,
+ "flyer_url": "https://westmac.wpenginepowered.com/wp-content/uploads/2026/08/Brochure_Melrose_8066_8.13.pdf",
+ "generated_at": "2026-08-24T13:30:06.737Z",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "first_party_broker",
+ "tier": 1,
+ "firm": "Westmac Commercial Brokerage",
+ "dedup_key": "ff48dc47d7ef"
+ },
+ {
+ "source_build": "rentv-spotlight",
+ "listing_id": "35124-0927",
+ "title": "RENTV Property Spotlight — Closed-Sale Recap",
+ "address": null,
+ "flyer_url": "file:///Users/macstudio3/Projects/re-flyer-aggregator/out/spotlight-35124-0927.html",
+ "generated_at": "2026-08-19T16:39:56.261Z",
+ "asset_type": "property_spotlight",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "efa157d2d7ce"
+ },
+ {
+ "source_build": "rentv-spotlight",
+ "listing_id": "34712-2655",
+ "title": "RENTV Property Spotlight — Closed-Sale Recap",
+ "address": null,
+ "flyer_url": "file:///Users/macstudio3/Projects/re-flyer-aggregator/out/spotlight-34712-2655.html",
+ "generated_at": "2026-08-19T16:39:55.630Z",
+ "asset_type": "property_spotlight",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "5aa084fc7531"
+ },
+ {
+ "source_build": "rentv-spotlight",
+ "listing_id": "34776-4336",
+ "title": "RENTV Property Spotlight — Closed-Sale Recap",
+ "address": null,
+ "flyer_url": "file:///Users/macstudio3/Projects/re-flyer-aggregator/out/spotlight-34776-4336.html",
+ "generated_at": "2026-08-19T16:39:55.112Z",
+ "asset_type": "property_spotlight",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "6cf3762807e2"
+ },
+ {
+ "source_build": "rentv-spotlight",
+ "listing_id": "34991-2690",
+ "title": "RENTV Property Spotlight — Closed-Sale Recap",
+ "address": null,
+ "flyer_url": "file:///Users/macstudio3/Projects/re-flyer-aggregator/out/spotlight-34991-2690.html",
+ "generated_at": "2026-08-19T16:39:54.620Z",
+ "asset_type": "property_spotlight",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "b35267aaac12"
+ },
+ {
+ "source_build": "rentv-spotlight",
+ "listing_id": "34974-3025",
+ "title": "RENTV Property Spotlight — Closed-Sale Recap",
+ "address": null,
+ "flyer_url": "file:///Users/macstudio3/Projects/re-flyer-aggregator/out/spotlight-34974-3025.html",
+ "generated_at": "2026-08-19T16:39:54.036Z",
+ "asset_type": "property_spotlight",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "ecf5df392e23"
+ },
+ {
+ "source_build": "rentv-spotlight",
+ "listing_id": "top8",
+ "title": "RENTV Property Spotlight — Closed-Sale Recap",
+ "address": null,
+ "flyer_url": "file:///Users/macstudio3/Projects/re-flyer-aggregator/out/spotlight-top8.html",
+ "generated_at": "2026-08-19T16:07:15.357Z",
+ "asset_type": "property_spotlight",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "a82bf1992e57"
+ },
+ {
+ "source_build": "rentv-spotlight",
+ "listing_id": "top3",
+ "title": "RENTV Property Spotlight — Closed-Sale Recap",
+ "address": null,
+ "flyer_url": "file:///Users/macstudio3/Projects/re-flyer-aggregator/out/spotlight-top3.html",
+ "generated_at": "2026-08-19T15:58:39.389Z",
+ "asset_type": "property_spotlight",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "110890ac43b6"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Self-generated closed-sale recap (35124-0927)",
+ "address": null,
+ "flyer_url": null,
+ "generated_at": "2026-08-19T09:41:10.477774-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "6d0fa7c0cc30"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Self-generated closed-sale recap (34991-2690)",
+ "address": null,
+ "flyer_url": null,
+ "generated_at": "2026-08-19T09:41:10.435692-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "6b3a46f3b5fc"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Self-generated closed-sale recap (34974-3025)",
+ "address": null,
+ "flyer_url": null,
+ "generated_at": "2026-08-19T09:41:10.389991-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "fed1b08268c1"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Self-generated closed-sale recap (34776-4336)",
+ "address": null,
+ "flyer_url": null,
+ "generated_at": "2026-08-19T09:41:10.340393-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "554a74dc5cd9"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Self-generated closed-sale recap (34712-2655)",
+ "address": null,
+ "flyer_url": null,
+ "generated_at": "2026-08-19T09:41:10.295065-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "self_generated",
+ "tier": 2,
+ "dedup_key": "916eb7c2b9e8"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "545wyn — Blanca Commercial RE listing (broker-owned, in firm set)",
+ "address": null,
+ "flyer_url": "https://www.blancacre.com/listings/545wyn",
+ "generated_at": "2026-08-19T09:41:10.206983-07:00",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "broker_owned",
+ "tier": 1,
+ "dedup_key": "13df07634e57"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "545wyn — developer property page (Sterling Bay)",
+ "address": null,
+ "flyer_url": "https://sterlingbay.com/properties/545wyn/",
+ "generated_at": "2026-08-19T09:41:10.149825-07:00",
+ "asset_type": "property_brief",
+ "rights_basis": "first_party",
+ "tier": 1,
+ "dedup_key": "b8d57d183f86"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Terra, Fortune pay record $205M for Key Biscayne site",
+ "address": null,
+ "flyer_url": "https://therealdeal.com/miami/2025/04/10/terra-fortune-pay-205m-for-silver-sands-key-biscayne-site/",
+ "generated_at": "2026-08-19T09:41:10.090462-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "first_party",
+ "tier": 1,
+ "dedup_key": "ca20aaf5fd46"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Terra/Fortune buy Silver Sands (301 Ocean Dr) — buyer newsroom",
+ "address": null,
+ "flyer_url": "https://terragroup.com/news-and-media/terra-fortune-pay-record-205m-for-waterfront-key-biscayne-development-site",
+ "generated_at": "2026-08-19T09:41:10.026456-07:00",
+ "asset_type": "property_brief",
+ "rights_basis": "first_party",
+ "tier": 1,
+ "dedup_key": "7435e7002c9f"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "CBRE named as seller broker for 700 Brickell (no public OM post-close)",
+ "address": null,
+ "flyer_url": "https://www.cbre.com",
+ "generated_at": "2026-08-19T09:41:09.970672-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "broker_owned",
+ "tier": 1,
+ "dedup_key": "0e3cb1b4a326"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "701/700 Brickell sale — Elliott $443M-450M",
+ "address": null,
+ "flyer_url": "https://therealdeal.com/miami/2025/12/29/inside-south-floridas-top-office-sales-of-2025/",
+ "generated_at": "2026-08-19T09:41:09.911503-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "first_party",
+ "tier": 1,
+ "dedup_key": "a14f443c134e"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Collins Ave hotel redevelopment (1751 Collins)",
+ "address": null,
+ "flyer_url": "https://floridayimby.com/2021/08/collins-avenue-hotel-redevelopment-project-delayed-planned-for-1751-collins-avenue-miami-beach-fl-33139.html",
+ "generated_at": "2026-08-19T09:41:09.847856-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "first_party",
+ "tier": 1,
+ "dedup_key": "7282306aaed4"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "1111 Brickell — LoopNet listing (marketplace, GATED)",
+ "address": null,
+ "flyer_url": "https://www.loopnet.com/Listing/1111-Brickell-Ave-Miami-FL/20980545/",
+ "generated_at": "2026-08-19T09:41:09.789294-07:00",
+ "asset_type": "marketing_flyer",
+ "rights_basis": "GATED_needs_review",
+ "tier": 3,
+ "dedup_key": "ebebe64aa247"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "Miami office tower sale closes for $274M",
+ "address": null,
+ "flyer_url": "https://cre-sources.com/miami-office-tower-sale-closes-for-274m/",
+ "generated_at": "2026-08-19T09:41:09.719892-07:00",
+ "asset_type": "deal_recap",
+ "rights_basis": "first_party",
+ "tier": 1,
+ "dedup_key": "04161dc1837d"
+ },
+ {
+ "source_build": "usre-deal",
+ "listing_id": null,
+ "title": "1111 Brickell — property brochure (owner site)",
+ "address": null,
+ "flyer_url": "https://1111brickell.com/overview/",
+ "generated_at": "2026-08-19T09:41:09.655913-07:00",
+ "asset_type": "property_brief",
+ "rights_basis": "first_party",
+ "tier": 1,
+ "dedup_key": "9e8dd855f4f1"
+ }
+ ]
+}
\ No newline at end of file
diff --git a/package.json b/package.json
new file mode 100644
index 0000000..7b1c8c9
--- /dev/null
+++ b/package.json
@@ -0,0 +1,12 @@
+{
+ "name": "re-flyers",
+ "version": "0.1.0",
+ "private": true,
+ "type": "module",
+ "description": "TK-10708 — normalized cross-source RE flyer index (unifies re-flyer-aggregator outputs: broker OMs, usre deal assets, RENTV spotlight recaps) into one deduped feed + sort/density viewer.",
+ "scripts": {
+ "seed": "node scripts/build-seed.mjs",
+ "start": "node server.js"
+ },
+ "engines": { "node": ">=18" }
+}
diff --git a/public/index.html b/public/index.html
new file mode 100644
index 0000000..5c5279f
--- /dev/null
+++ b/public/index.html
@@ -0,0 +1,117 @@
+<!doctype html>
+<html lang="en">
+<head>
+<meta charset="utf-8">
+<meta name="viewport" content="width=device-width, initial-scale=1">
+<title>RE Flyers — Unified Index (TK-10708)</title>
+<style>
+ :root{--blue:#16357A;--navy:#0E2350;--red:#D0202E;--gold:#E8A81C;--ink:#141414;
+ --gray:#6B7280;--panel:#F4F6FB;--cols:4;}
+ *{box-sizing:border-box}
+ body{margin:0;font-family:Inter,Archivo,Helvetica,Arial,sans-serif;color:var(--ink);background:#eef1f6}
+ header{background:var(--navy);color:#fff;padding:18px 22px}
+ header h1{margin:0;font-size:20px;letter-spacing:.3px}
+ header .sub{opacity:.8;font-size:13px;margin-top:4px}
+ .controls{display:flex;gap:18px;align-items:center;flex-wrap:wrap;
+ background:#fff;padding:12px 22px;border-bottom:1px solid #dfe3ec;position:sticky;top:0;z-index:5}
+ .controls label{font-size:12px;color:var(--gray);text-transform:uppercase;letter-spacing:.4px;margin-right:6px}
+ select,input[type=range],input[type=search]{font:inherit}
+ select{padding:6px 8px;border:1px solid #cdd4e0;border-radius:6px;background:#fff}
+ input[type=search]{padding:6px 10px;border:1px solid #cdd4e0;border-radius:6px;min-width:200px}
+ .count{margin-left:auto;color:var(--gray);font-size:13px}
+ .grid{display:grid;grid-template-columns:repeat(var(--cols),1fr);gap:14px;padding:22px}
+ .card{background:#fff;border:1px solid #e2e6ee;border-radius:10px;padding:14px;
+ display:flex;flex-direction:column;gap:8px;min-height:120px}
+ .card .type{font-size:11px;text-transform:uppercase;letter-spacing:.5px;color:var(--blue);font-weight:700}
+ .card .title{font-weight:600;font-size:14px;line-height:1.3}
+ .card .meta{font-size:12px;color:var(--gray);margin-top:auto;display:flex;flex-wrap:wrap;gap:6px}
+ .chip{background:var(--panel);border:1px solid #dfe3ec;border-radius:999px;padding:2px 8px;font-size:11px}
+ .chip.t1{color:#0a7a2f}.chip.t2{color:#8a5a00}.chip.t3{color:#a11}
+ .card a{color:var(--blue);font-size:12px;text-decoration:none;word-break:break-all}
+ .card a:hover{text-decoration:underline}
+ .gated{opacity:.55;border-style:dashed}
+ .gated .title::after{content:' 🔒 GATED';color:var(--red);font-size:11px}
+</style>
+</head>
+<body>
+<header>
+ <h1>RE Flyers — Unified Cross-Source Index</h1>
+ <div class="sub">TK-10708 · normalized aggregate of broker OMs · usre deal assets · RENTV spotlight recaps · read-only</div>
+</header>
+<div class="controls">
+ <div><label>Sort</label>
+ <select id="sort">
+ <option value="newest">Newest</option>
+ <option value="source">Source build</option>
+ <option value="type">Asset type</option>
+ <option value="tier">Tier</option>
+ <option value="title">Title A→Z</option>
+ </select>
+ </div>
+ <div><label>Source</label>
+ <select id="src"><option value="">All</option></select>
+ </div>
+ <div><label>Density</label>
+ <input type="range" id="density" min="2" max="7" value="4">
+ </div>
+ <input type="search" id="q" placeholder="Search title / firm…">
+ <div class="count" id="count"></div>
+</div>
+<div class="grid" id="grid"></div>
+
+<script>
+const LS = 're-flyers-controls';
+const state = Object.assign({sort:'newest',src:'',density:4,q:''}, JSON.parse(localStorage.getItem(LS)||'{}'));
+let ALL = [];
+
+const $ = s => document.querySelector(s);
+$('#sort').value=state.sort; $('#density').value=state.density; $('#q').value=state.q;
+document.documentElement.style.setProperty('--cols',state.density);
+
+function save(){ localStorage.setItem(LS, JSON.stringify(state)); }
+function esc(s){ return (s==null?'':String(s)).replace(/[&<>"]/g,c=>({'&':'&','<':'<','>':'>','"':'"'}[c])); }
+
+function render(){
+ let rows = ALL.slice();
+ if(state.src) rows = rows.filter(r=>r.source_build===state.src);
+ if(state.q){ const q=state.q.toLowerCase(); rows=rows.filter(r=>((r.title||'')+' '+(r.firm||'')).toLowerCase().includes(q)); }
+ const cmp={
+ newest:(a,b)=>(b.generated_at||'').localeCompare(a.generated_at||''),
+ source:(a,b)=>(a.source_build||'').localeCompare(b.source_build||''),
+ type:(a,b)=>(a.asset_type||'').localeCompare(b.asset_type||''),
+ tier:(a,b)=>(a.tier||9)-(b.tier||9),
+ title:(a,b)=>(a.title||'').localeCompare(b.title||''),
+ }[state.sort];
+ rows.sort(cmp);
+ $('#count').textContent = rows.length+' / '+ALL.length+' flyers';
+ $('#grid').innerHTML = rows.map(r=>{
+ const gated=/GATED/i.test(r.rights_basis||'');
+ const when=r.generated_at?new Date(r.generated_at).toLocaleDateString(undefined,{year:'numeric',month:'short',day:'numeric'}):'—';
+ return `<div class="card${gated?' gated':''}">
+ <div class="type">${esc(r.asset_type)}</div>
+ <div class="title">${esc(r.title)}</div>
+ <div class="meta">
+ <span class="chip">${esc(r.source_build)}</span>
+ <span class="chip t${r.tier||''}">tier ${esc(r.tier)}</span>
+ ${r.firm?`<span class="chip">${esc(r.firm)}</span>`:''}
+ <span class="chip">${when}</span>
+ </div>
+ ${r.flyer_url&&!gated?`<a href="${esc(r.flyer_url)}" target="_blank" rel="noopener noreferrer">${esc(r.flyer_url)}</a>`:''}
+ </div>`;
+ }).join('') || '<p style="padding:22px;color:var(--gray)">No flyers match.</p>';
+}
+
+$('#sort').onchange=e=>{state.sort=e.target.value;save();render();};
+$('#src').onchange=e=>{state.src=e.target.value;save();render();};
+$('#density').oninput=e=>{state.density=+e.target.value;document.documentElement.style.setProperty('--cols',state.density);save();render();};
+$('#q').oninput=e=>{state.q=e.target.value;save();render();};
+
+fetch('/api/flyers').then(r=>r.json()).then(d=>{
+ ALL=d.flyers||[];
+ const srcs=[...new Set(ALL.map(r=>r.source_build))].sort();
+ $('#src').innerHTML='<option value="">All</option>'+srcs.map(s=>`<option${s===state.src?' selected':''}>${esc(s)}</option>`).join('');
+ render();
+}).catch(e=>{$('#grid').innerHTML='<p style="padding:22px;color:#a11">Failed to load /api/flyers: '+esc(e.message)+'</p>';});
+</script>
+</body>
+</html>
diff --git a/scripts/build-seed.mjs b/scripts/build-seed.mjs
new file mode 100644
index 0000000..1c15dec
--- /dev/null
+++ b/scripts/build-seed.mjs
@@ -0,0 +1,129 @@
+#!/usr/bin/env node
+// TK-10708 Build data/flyers.json — the NORMALIZED cross-source flyer index.
+// Reads the EXISTING, already-produced flyer/marketing-asset outputs from the live
+// re-flyer-aggregator project (does NOT re-scrape anything) and normalizes them into
+// one common schema, deduped. $0 local, read-only against sibling project + local PG.
+//
+// Common schema (per TK-10708):
+// { source_build, listing_id, title, address, flyer_url, generated_at, asset_type,
+// rights_basis, tier, dedup_key }
+//
+// Sources unified:
+// A. re-flyer-aggregator/public/flyers-found/property-flyers.json (Tier-1 broker OMs/brochures)
+// B. reflyers PG external_marketing_asset (classified deal assets)
+// C. re-flyer-aggregator/out/spotlight-*.html (Tier-2 self-generated recaps)
+
+import { readFileSync, writeFileSync, readdirSync, statSync, existsSync } from 'node:fs';
+import { execFileSync } from 'node:child_process';
+import { fileURLToPath } from 'node:url';
+import { dirname, join } from 'node:path';
+import { createHash } from 'node:crypto';
+
+const ROOT = dirname(dirname(fileURLToPath(import.meta.url)));
+const HOME = process.env.HOME;
+const AGG = join(HOME, 'Projects', 'reflyer-placeholder'); // resolved below
+const AGG_DIR = join(HOME, 'Projects', 're-flyer-aggregator');
+const OUT = join(ROOT, 'data', 'flyers.json');
+
+const rows = [];
+const dedup = new Set();
+function push(r) {
+ const key = (r.flyer_url || r.title || '').trim().toLowerCase();
+ r.dedup_key = createHash('sha1').update(key).digest('hex').slice(0, 12);
+ if (dedup.has(r.dedup_key)) return false;
+ dedup.add(r.dedup_key);
+ rows.push(r);
+ return true;
+}
+
+// ---- Source A: broker-owned property flyers (Tier-1, real OMs/brochures) ----
+try {
+ const p = join(AGG_DIR, 'public', 'flyers-found', 'property-flyers.json');
+ if (existsSync(p)) {
+ const arr = JSON.parse(readFileSync(p, 'utf8'));
+ for (const f of arr) {
+ const title = (f.property || '').trim();
+ const isOM = /\bOM\b|offering.?memo/i.test(title) || /_OM_/i.test(f.pdf || '');
+ push({
+ source_build: 'broker-site',
+ listing_id: null,
+ title: title || 'Untitled brochure',
+ address: null, // broker flyers carry a property name, not a normalized address
+ flyer_url: f.pdf || f.from || null,
+ generated_at: f.found_at || null,
+ asset_type: isOM ? 'offering_memorandum' : 'marketing_flyer',
+ rights_basis: 'first_party_broker',
+ tier: 1,
+ firm: f.firm || null,
+ });
+ }
+ }
+} catch (e) { console.error('source A skipped:', e.message); }
+
+// ---- Source B: classified deal assets from the reflyers staging DB ----
+try {
+ const dbList = execFileSync('psql', ['-lqt'], { encoding: 'utf8' });
+ if (/\breflyers\b/.test(dbList)) {
+ const json = execFileSync('psql', ['reflyers', '-tAc',
+ `SELECT row_to_json(t) FROM (
+ SELECT asset_type, tier, rights_basis, title, source_landing_url,
+ document_url, last_verified_at, created_at
+ FROM external_marketing_asset) t`], { encoding: 'utf8' }).trim();
+ for (const line of json.split('\n').filter(Boolean)) {
+ const a = JSON.parse(line);
+ push({
+ source_build: 'usre-deal',
+ listing_id: null,
+ title: a.title || 'Deal asset',
+ address: null,
+ flyer_url: a.document_url || a.source_landing_url || null,
+ generated_at: a.last_verified_at || a.created_at || null,
+ asset_type: a.asset_type,
+ rights_basis: a.rights_basis || null,
+ tier: a.tier,
+ });
+ }
+ }
+} catch (e) { console.error('source B skipped:', e.message); }
+
+// ---- Source C: Tier-2 self-generated spotlight recaps (our own flyers) ----
+try {
+ const outDir = join(AGG_DIR, 'out');
+ if (existsSync(outDir)) {
+ for (const fn of readdirSync(outDir)) {
+ if (!/^spotlight-.*\.html$/.test(fn)) continue;
+ const full = join(outDir, fn);
+ let title = fn.replace(/\.html$/, '');
+ try {
+ const html = readFileSync(full, 'utf8');
+ const m = html.match(/<title>([^<]+)<\/title>/i);
+ if (m) title = m[1].trim();
+ } catch {}
+ const st = statSync(full);
+ push({
+ source_build: 'rentv-spotlight',
+ listing_id: fn.replace(/^spotlight-|\.html$/g, ''),
+ title,
+ address: null,
+ flyer_url: 'file://' + full, // local Tier-2 artifact (print → PDF)
+ generated_at: st.mtime.toISOString(),
+ asset_type: 'property_spotlight',
+ rights_basis: 'self_generated',
+ tier: 2,
+ });
+ }
+ }
+} catch (e) { console.error('source C skipped:', e.message); }
+
+// sort newest-first (nulls last)
+rows.sort((a, b) => (b.generated_at || '').localeCompare(a.generated_at || ''));
+
+const payload = {
+ generated_at: new Date().toISOString(),
+ count: rows.length,
+ by_source: rows.reduce((m, r) => ((m[r.source_build] = (m[r.source_build] || 0) + 1), m), {}),
+ note: 'Normalized cross-source flyer index (TK-10708). Read-only aggregate of existing re-flyer-aggregator outputs; no re-scrape. Tier-3/GATED assets carried with rights_basis for viewer filtering, never auto-downloaded.',
+ flyers: rows,
+};
+writeFileSync(OUT, JSON.stringify(payload, null, 2));
+console.log(`wrote ${OUT}: ${rows.length} flyers by_source=${JSON.stringify(payload.by_source)}`);
diff --git a/server.js b/server.js
new file mode 100644
index 0000000..adfe744
--- /dev/null
+++ b/server.js
@@ -0,0 +1,52 @@
+#!/usr/bin/env node
+// TK-10708 re-flyers — normalized cross-source flyer index viewer/API.
+// Serves data/flyers.json (built by scripts/build-seed.mjs from the existing
+// re-flyer-aggregator outputs). Zero deps. Basic-auth admin/DW2024! (DW viewer standard).
+//
+// GATED-tier note: rows with rights_basis containing GATED are served WITH their flag so
+// the viewer can visually mark/hide them. This surface NEVER downloads or re-hosts a file.
+
+import http from 'node:http';
+import { readFileSync, existsSync } from 'node:fs';
+import { fileURLToPath } from 'node:url';
+import { dirname, join } from 'node:path';
+
+const ROOT = dirname(fileURLToPath(import.meta.url));
+const PORT = process.env.PORT || 0; // 0 = OS-assigned free port (no permanent port)
+const USER = process.env.BASIC_USER || 'admin';
+const PASS = process.env.BASIC_PASS || 'DW2024!';
+const DATA = join(ROOT, 'data', 'flyers.json');
+
+function loadFlyers() {
+ if (!existsSync(DATA)) return { count: 0, flyers: [] };
+ return JSON.parse(readFileSync(DATA, 'utf8'));
+}
+
+const server = http.createServer((req, res) => {
+ const hdr = req.headers.authorization || '';
+ const [, b64] = hdr.split(' ');
+ const [u, p] = Buffer.from(b64 || '', 'base64').toString().split(':');
+ if (u !== USER || p !== PASS) {
+ res.writeHead(401, { 'WWW-Authenticate': 'Basic realm="re-flyers"' });
+ return res.end('Auth required');
+ }
+ try {
+ if (req.url.startsWith('/api/flyers')) {
+ const data = loadFlyers();
+ res.writeHead(200, { 'content-type': 'application/json' });
+ return res.end(JSON.stringify(data));
+ }
+ if (req.url === '/health') { res.writeHead(200); return res.end('ok'); }
+ const idx = join(ROOT, 'public', 'index.html');
+ res.writeHead(200, { 'content-type': 'text/html' });
+ return res.end(existsSync(idx) ? readFileSync(idx) : '<h1>re-flyers</h1>');
+ } catch (e) {
+ res.writeHead(500, { 'content-type': 'text/plain' });
+ res.end('err: ' + e.message);
+ }
+});
+
+server.listen(PORT, () => {
+ const a = server.address();
+ console.log(`re-flyers viewer on :${a.port} (basic-auth ${USER}) — GET /api/flyers`);
+});
(oldest)
·
back to Re Flyers
·
auto-data-snapshot: 2026-08-24T21:21:09 (1 data files) — RET 75ce824 →