← back to Commercialrealestate
CRE: 1-session Browserbase condo-sample pipeline (capture->classify->DB, ~$0.04) — proves end-to-end flow; Crexi /condo found to be national commercial inventory not LA residential condos (purged from DB), residential source (Zillow/Redfin) is the gated full-scale path
09e1ede303b8fc5668461e16c9e78f5a8bdb0475 · 2026-06-28 06:24:39 -0700 · Steve Abrams
Files touched
A data/condos-sample.jsonA scripts/fetch-condos-sample.js
Diff
commit 09e1ede303b8fc5668461e16c9e78f5a8bdb0475
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Sun Jun 28 06:24:39 2026 -0700
CRE: 1-session Browserbase condo-sample pipeline (capture->classify->DB, ~$0.04) — proves end-to-end flow; Crexi /condo found to be national commercial inventory not LA residential condos (purged from DB), residential source (Zillow/Redfin) is the gated full-scale path
---
data/condos-sample.json | 1252 ++++++++++++++++++++++++++++++++++++++++
scripts/fetch-condos-sample.js | 138 +++++
2 files changed, 1390 insertions(+)
diff --git a/data/condos-sample.json b/data/condos-sample.json
new file mode 100644
index 0000000..59a54c9
--- /dev/null
+++ b/data/condos-sample.json
@@ -0,0 +1,1252 @@
+{
+ "meta": {
+ "source": "Crexi residential/condo search via Browserbase (1-session SAMPLE)",
+ "cost": "~$0.04 (1 Browserbase session)",
+ "scope": "PROOF-OF-PIPELINE sample only — full-scale residential scrape is gated",
+ "warrantability_label": "FHA/VA-approval-based proxy, NOT lender-verified Fannie/Freddie warrantability.",
+ "fetched_at": "2026-06-28T13:19:45.588Z",
+ "count": 62
+ },
+ "condos": [
+ {
+ "id": "crx1839308",
+ "address": "1476-1496 South Erie Boulevard",
+ "city": "Hamilton",
+ "zip": "45011",
+ "price": 2350000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Hamilton Shops - Hamilton, OH",
+ "listing_text": "100% Leased Shopping Center | Shadow Anchored by Kroger | High Yield - 8.55% CAP Hamilton Shops - Hamilton, OH",
+ "firm_name": "Sands Investment Group Los Angeles",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1839308/ohio-hamilton-shops---hamilton-oh",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1698077",
+ "address": "1425 N 21st St",
+ "city": "Newark",
+ "zip": "43055",
+ "price": 3725000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Walgreens - Newark, OH",
+ "listing_text": "Retail | 8.00% CAP | 14,560 SqFt Walgreens - Newark, OH",
+ "firm_name": "Colliers - Columbus, Ohio",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1698077/ohio-walgreens---newark-oh",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2194196",
+ "address": "959 Steels Corner Road",
+ "city": "Stow",
+ "zip": "44224",
+ "price": 1831459,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "7-Eleven",
+ "listing_text": "Retail | 8.50% CAP | 2,700 SqFt 7-Eleven",
+ "firm_name": "SURMOUNT",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2194196/ohio-7-eleven",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1639458",
+ "address": "2567 Commerce Pkwy",
+ "city": "Barstow",
+ "zip": "92311",
+ "price": 2971000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Freddy's Frozen Custard & Steakburgers",
+ "listing_text": "Retail | 5.25% CAP | 2,500 SF Freddy's Frozen Custard & Steakburgers",
+ "firm_name": "Colliers - Los Angeles - Orange County, California",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1639458/california-freddys-frozen-custard-steakburgers",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2139932",
+ "address": "100 Hadley Rd",
+ "city": "Greenville",
+ "zip": "16125",
+ "price": 1600000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Greenville Plaza",
+ "listing_text": "Retail | 11.94% CAP | 99,700 SqFt Greenville Plaza",
+ "firm_name": "Passov Real Estate Group",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2139932/pennsylvania-greenville-plaza",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1640041",
+ "address": "3420 Plaza Cir",
+ "city": "Beaumont",
+ "zip": "77707",
+ "price": 3382000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "U.S. Department of Veterans Affairs",
+ "listing_text": "Office | 14.00% CAP | 33,200 SqFt U.S. Department of Veterans Affairs",
+ "firm_name": "Colliers",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1640041/texas-us-department-of-veterans-affairs",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1816819",
+ "address": "521 E 14th St",
+ "city": "Des Moines",
+ "zip": "50316",
+ "price": 725000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "521 E 14th Street",
+ "listing_text": "Des Moines Retail Investment Opportunity | #1 Visited Wingtsop in the State of Iowa 521 E 14th Street",
+ "firm_name": "CBRE - Des Moines",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1816819/iowa-521-e-14th-street",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2323995",
+ "address": "1025 Fair Ave",
+ "city": "Columbus",
+ "zip": "43205",
+ "price": 3500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Park Place Apartments & Duplexes",
+ "listing_text": "Multifamily | 82 Units | $42,683/unit Park Place Apartments & Duplexes",
+ "firm_name": "Colliers - Columbus, Ohio",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2323995/ohio-park-place-apartments-duplexes",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2248269",
+ "address": "3389 Sherry Dr",
+ "city": "Macon",
+ "zip": "31206",
+ "price": 2670000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Linkwood Manor",
+ "listing_text": "Multifamily Opportunity | 56 Units | Macon, GA Linkwood Manor",
+ "firm_name": "Matthews",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2248269/georgia-linkwood-manor",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1847222",
+ "address": "745 Englehart",
+ "city": "San Antonio",
+ "zip": "78264",
+ "price": 1100870,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Englehart Estates",
+ "listing_text": "Mobile Home Park | 10.00% CAP Englehart Estates",
+ "firm_name": "North Star Brokerage & Advisory",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1847222/englehart-estates",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1713329",
+ "address": "501 S Wells St",
+ "city": "Chicago",
+ "zip": "60607",
+ "price": 2750000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "501 s wells street",
+ "listing_text": "gateway to the city/ billboard 501 s wells street",
+ "firm_name": "JOS. Cacciatore & Co. Real Estate",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1713329/illinois-501-s-wells-street",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1693567",
+ "address": "2505 Ridgeland Cir",
+ "city": "Pocahontas",
+ "zip": "72455",
+ "price": 4900000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Ridgeland Townhomes",
+ "listing_text": "New Vintage | 48 Units | Pocahontas, AR Ridgeland Townhomes",
+ "firm_name": "SVN | OAK Realty Advisors",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1693567/arkansas-ridgeland-townhomes---seller-financing-available",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1290969",
+ "address": "105 E Stassney Ln",
+ "city": "Austin",
+ "zip": "78745",
+ "price": 4000000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "7-Eleven (Leasehold)",
+ "listing_text": "BONUS DEPRECIATION | INCOME TAX FREE STATE | HIGH TRAFFIC SITE 7-Eleven (Leasehold)",
+ "firm_name": "Prime Net Lease",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1290969/texas-7-eleven-leasehold",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1722619",
+ "address": "1 N Virginia Ave",
+ "city": "Penns Grove",
+ "zip": "08069",
+ "price": 1807228,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "McDonald's",
+ "listing_text": "Newly Constructed McDonald's | Philadelphia MSA McDonald's",
+ "firm_name": "Equity CRE",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1722619/new-jersey-mcdonalds",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2317945",
+ "address": "2601 Willowbrook Rd",
+ "city": "Dallas",
+ "zip": "75220",
+ "price": 3400000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "US Storage Centers (Managed)",
+ "listing_text": "41,610 NRSF | 280 Units | $87.29/NRSF US Storage Centers (Managed)",
+ "firm_name": "Franklin Street Tampa",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2317945/texas-us-storage-centers-managed",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2289596",
+ "address": "388-398 Union Street",
+ "city": "Rahway",
+ "zip": "07065",
+ "price": 2800000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "388-398 Union Street",
+ "listing_text": "Multifamily | 12 Units | $233,333/unit 388-398 Union Street",
+ "firm_name": "Sitar Realty Company Iselin",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2289596/new-jersey-388-398-union-street",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2035152",
+ "address": "5216 FM725",
+ "city": "New Braunfels",
+ "zip": "78130",
+ "price": 3500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Long Creek RV Park - New Braunfels TX",
+ "listing_text": "Brand New RV Park | 113 Pads | Strong Demographics Long Creek RV Park - New Braunfels TX",
+ "firm_name": "North Star Brokerage & Advisory",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2035152/texas-long-creek-rv-park---new-braunfels-tx",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2296283",
+ "address": "1907 N Ewing St",
+ "city": "Seymour",
+ "zip": "47274",
+ "price": 750000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Seymour Storage Co.",
+ "listing_text": "Only 1 Hour from Indianpolis! Seymour Storage Co.",
+ "firm_name": "SVN Southland Commercial",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2296283/indiana-seymour-storage-co",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2320266",
+ "address": "118 Warrenton Village Dr",
+ "city": "Warrenton",
+ "zip": "27589",
+ "price": 1665000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Warrenton Village",
+ "listing_text": "Premium finishes throughout, including durable luxury vinyl plank (LVP) hardwood-style flooring Warrenton Village",
+ "firm_name": "Matthews",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2320266/north-carolina-warrenton-village",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2290125",
+ "address": "6606 W Camelback Rd",
+ "city": "Glendale",
+ "zip": "85301",
+ "price": 1625000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Taco Bell I Phoenix, AZ MSA I 50K VPD Intersection",
+ "listing_text": "+/- 30 Year Occupancy, No Remaining Options Taco Bell I Phoenix, AZ MSA I 50K VPD Intersection",
+ "firm_name": "Marcus & Millichap - Manhattan",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2290125/arizona-taco-bell-i-phoenix-az-msa-i-50k-vpd-intersection",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2035157",
+ "address": "1611 Western Ave",
+ "city": "Albany",
+ "zip": "12203",
+ "price": 277778,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Bank of America",
+ "listing_text": "Retail | 9.00% CAP Bank of America",
+ "firm_name": "SURMOUNT",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2035157/new-york-bank-of-america",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2347502",
+ "address": "718 F St",
+ "city": "Coos Bay",
+ "zip": "97420",
+ "price": 2000000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Springtide Trailer Park",
+ "listing_text": "Recent Price Adjustment! 41-Units on the Oregon Coast with Below-Market Rents Springtide Trailer Park",
+ "firm_name": "Commercial Real Estate Investors, Inc.",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2347502/oregon-springtide-trailer-park",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2070555",
+ "address": "200 TX-21",
+ "city": "Caldwell",
+ "zip": "77836",
+ "price": 3281000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "New Taco Bell | 25-Year Abs NNN | Annual Increases",
+ "listing_text": "Austin MSA | 1.09 Acres | Highway Location New Taco Bell | 25-Year Abs NNN | Annual Increases",
+ "firm_name": "Cushman & Wakefield - Sacramento, California",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2070555/texas-new-taco-bell-25-year-abs-nnn-annual-increases",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1683110",
+ "address": "3719 W 9th St",
+ "city": "Waterloo",
+ "zip": "50702",
+ "price": 1595000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Skyview Apartments",
+ "listing_text": "Multifamily | Investment | 24 Units Skyview Apartments",
+ "firm_name": "AW Commercial & Development",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1683110/iowa-skyline-apartments",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1691921",
+ "address": "5555 S Buckner Blvd",
+ "city": "Dallas",
+ "zip": "75228",
+ "price": 15945000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Sam's Club",
+ "listing_text": "Sam's Club | Single Tenant Net Lease | Irreplaceable Infill Site Sam's Club",
+ "firm_name": "Colliers - Los Angeles - Orange County, California",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1691921/texas-sams-club",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1925686",
+ "address": "1000 N Florida Ave",
+ "city": "Tampa",
+ "zip": "33602",
+ "price": 25000000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Hilton",
+ "listing_text": "Off market Hilton/Marriott Hotels in FL and other states Hilton",
+ "firm_name": "Rad Commercial Realty",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1925686/florida-hilton",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1847782",
+ "address": "22288 FM463",
+ "city": "Devine",
+ "zip": "78016",
+ "price": 714330,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "463 Estates",
+ "listing_text": "Mobile Home Park | 10.00% CAP 463 Estates",
+ "firm_name": "North Star Brokerage & Advisory",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1847782/texas-463-estates",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2145835",
+ "address": "7001 Confederate Park Rd",
+ "city": "Fort Worth",
+ "zip": "76108",
+ "price": 2300000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Silver Creek Corner",
+ "listing_text": "Great Neighborhood Retail Center Silver Creek Corner",
+ "firm_name": "Sperry",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2145835/texas-silver-creek-corner",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2200616",
+ "address": "347203 U.S. Rte 66",
+ "city": "Chandler",
+ "zip": "74834",
+ "price": 3500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Oak Glen RV & Mobile Home Park",
+ "listing_text": "7% In-Place | 10%+ Stabilized | 115-Site RV & MHP Near New Harrah’s Casino Oak Glen RV & Mobile Home Park",
+ "firm_name": "Horner McClure & Associates",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2200616/oklahoma-oak-glen-rv-mobile-home-park",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2355915",
+ "address": "6442 Land O' Lakes Blvd",
+ "city": "Land O' Lakes",
+ "zip": "34638",
+ "price": 4448439,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Jallo Plaza",
+ "listing_text": "Tampa MSA | Fully Leased Strip Center | 7-Tenants Jallo Plaza",
+ "firm_name": "Matthews",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2355915/florida-jallo-plaza",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2324314",
+ "address": "939 N Logan St",
+ "city": "Gaffney",
+ "zip": "29341",
+ "price": 780000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Cannon Secure Storage",
+ "listing_text": "Growing population, occupancy, and rates! Cannon Secure Storage",
+ "firm_name": "SVN Commercial Partners",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2324314/south-carolina-cannon-secure-storage",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1640963",
+ "address": "115 112th Ave NE",
+ "city": "St. Petersburg",
+ "zip": "33716",
+ "price": 3995000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "14% Cash-On-Cash Return! 24-Unit Condo Portfolio For Sale",
+ "listing_text": "(14% CASH-ON-CASH RETURN!) 24-UNIT CONDO PORTFOLIO FOR SALE! (SELLER FINANCING AVAILABLE) 14% Cash-On-Cash Return! 24-Unit Condo Portfolio For Sale",
+ "firm_name": "Grimaldi Commercial Realty Corp",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1640963/florida-13-cash-on-cash-return-24-unit-condo-portfolio-for-sale",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2253439",
+ "address": "5319 S Dixie Hwy",
+ "city": "Cridersville",
+ "zip": "45806",
+ "price": 1000000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Village Apartments",
+ "listing_text": "Multifamily | 19 Units Village Apartments",
+ "firm_name": "Friedman Real Estate",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2253439/ohio-village-apartments",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2160144",
+ "address": "3517 Camino del Rio S",
+ "city": "San Diego",
+ "zip": "92108",
+ "price": 11950000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Mission View Plaza",
+ "listing_text": "100% Leased Multi-Tenant Office Investment – Mission Valley, San Diego Mission View Plaza",
+ "firm_name": "Commercial Asset Advisors",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2160144/california-100-leased-mission-valley-multi-tenant-office-investment",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2371551",
+ "address": "3257 Colechester Rd",
+ "city": "Virginia Beach",
+ "zip": "23456",
+ "price": 4800000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "North Bay Shore Campground",
+ "listing_text": "North Bay Shore Campground | VA Beach | $40,000/unit North Bay Shore Campground",
+ "firm_name": "Aline Capital LLC",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2371551/virginia-north-bay-shore-campground",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2430426",
+ "address": "150 Peachtree St",
+ "city": "Cocoa",
+ "zip": "32922",
+ "price": 1380000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Peachtree Apartments",
+ "listing_text": "12 Units in Cocoa Peachtree Apartments",
+ "firm_name": "Marcus & Millichap - RPH Multifamily Group",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2430426/florida-peachtree-apartments",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1890860",
+ "address": "2407 W Frank Ave",
+ "city": "Lufkin",
+ "zip": "75904",
+ "price": 730000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Lufkin Self Storage",
+ "listing_text": "Self Storage | 121 Units Lufkin Self Storage",
+ "firm_name": "VERSAL - Bellomy",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1890860/texas-lufkin-self-storage",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1413375",
+ "address": "745 FM 343 East, Rusk, TX 75785",
+ "city": "Sacul",
+ "zip": "75785",
+ "price": 2200000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "REDUCED! Rusk KOA Holiday - 745 FM 343 East",
+ "listing_text": "RV Park/Campground REDUCED! Rusk KOA Holiday - 745 FM 343 East",
+ "firm_name": "Texas Commercial Real Estate Services",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1413375/texas-745-fm-343-east",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2034519",
+ "address": "Gholson Avenue",
+ "city": "Cincinnati",
+ "zip": "45229",
+ "price": 1105000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Cash Cow Cincinnati",
+ "listing_text": "Multifamily | 17 Units Cash Cow Cincinnati",
+ "firm_name": "Affordable Realty Services, LLC",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2034519/ohio-cash-cow-cincinnati",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1897275",
+ "address": "80 Park Ave",
+ "city": "New York",
+ "zip": "10016",
+ "price": 5500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "80 Park Avenue - Parking Garage",
+ "listing_text": "Parking Garage 80 Park Avenue - Parking Garage",
+ "firm_name": "SERHANT",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1897275/new-york-80-park-avenue---parking-garage",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2514193",
+ "address": "8736 W Ranch Rd",
+ "city": "Buchanan Dam,",
+ "zip": "78609",
+ "price": 1500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Seven Lakes RV Resort",
+ "listing_text": "56-Unit RV Community near a Texas Lake Seven Lakes RV Resort",
+ "firm_name": "North Star Brokerage & Advisory",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2514193/texas-seven-lakes-rv-resort",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2179423",
+ "address": "1031 Lodge Rd",
+ "city": "Ardmore",
+ "zip": "73401",
+ "price": 4500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "BY The Lake RV Resort",
+ "listing_text": "10/10/10 Rated RV Resort Great location BY The Lake RV Resort",
+ "firm_name": "Baehre Real Estate",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2179423/oklahoma-by-the-lake-rv-resort",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2232943",
+ "address": "13483 N I-35",
+ "city": "Jarrell",
+ "zip": "76537",
+ "price": 8000000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Valley View RV Park",
+ "listing_text": "189-Space RV Park North of Austin on I-35 Valley View RV Park",
+ "firm_name": "North Star Brokerage & Advisory",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2232943/texas-valley-view-rv-park",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2140215",
+ "address": "1316 College Ave",
+ "city": "The Bronx",
+ "zip": "10456",
+ "price": 6600000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "1316 Morris Avenu",
+ "listing_text": "Multifamily | 100 Units | $66,000/unit 1316 Morris Avenu",
+ "firm_name": "Ariel Property Advisors",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2140215/new-york-1316-morris-avenu",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2186129",
+ "address": "417 Fountainhead Cir",
+ "city": "Kissimmee",
+ "zip": "34741",
+ "price": 4500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Bella Vista | Villas Del Sol Condos",
+ "listing_text": "Multifamily | 24 Units | 10 Mins from Disney Bella Vista | Villas Del Sol Condos",
+ "firm_name": "The Apartment Brokers",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2186129/florida-bella-vista-villas-del-sol-condos",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1826915",
+ "address": "8303 V. Pisa",
+ "city": "San Antonio",
+ "zip": "78227",
+ "price": 985000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Tuscany Villas Enclave",
+ "listing_text": "Tuscany Villas is a gated community of modern stylish energy efficient fourplexes. Tuscany Villas Enclave",
+ "firm_name": "RE/MAX Alamo Realty",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1826915/texas-tuscany-villas-enclave",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2179261",
+ "address": "3750-3850 Hempstead",
+ "city": "Levittown",
+ "zip": "11756",
+ "price": 15332000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "3750-3850 Hempstead",
+ "listing_text": "Retail | 11.00% CAP | 196,805 SqFt 3750-3850 Hempstead",
+ "firm_name": "Stream Capital Partners",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2179261/new-york-3750-3850-hempstead",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2213275",
+ "address": "600 Leopard St",
+ "city": "Corpus Christi",
+ "zip": "78401",
+ "price": 4500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "The 600 Building",
+ "listing_text": "Multifamily | 131 Units | $34,351/unit The 600 Building",
+ "firm_name": "Marcus & Millichap - Chicago Downtown",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2213275/texas-the-600-building",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2070700",
+ "address": "3500 E Charleston Blvd",
+ "city": "Las Vegas",
+ "zip": "89104",
+ "price": 1500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "3500 East Charleston Blvd.",
+ "listing_text": "Retail | 2,581 SqFt 3500 East Charleston Blvd.",
+ "firm_name": "Cushman & Wakefield - Las Vegas, Nevada",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2070700/nevada-3500-east-charleston-blvd",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1825914",
+ "address": "2630 FM517",
+ "city": "San Leon",
+ "zip": "77539",
+ "price": 4200000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Summer Breeze RV Park Resort- Kemah",
+ "listing_text": "Business for Sale | 8.00% CAP Summer Breeze RV Park Resort- Kemah",
+ "firm_name": "Ausmus Premier Properties",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1825914/texas-summer-breeze-rv-park-resort--kemah",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1977104",
+ "address": "24290 W Seven Mile Rd",
+ "city": "Detroit",
+ "zip": "48219",
+ "price": 3240000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Courtyard Apartments",
+ "listing_text": "Multifamily | 10.06% CAP | 60 Units Courtyard Apartments",
+ "firm_name": "Keystone Commercial Real Estate",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1977104/michigan-courtyard-apartments",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1052130",
+ "address": "3170 Holmestown Rd",
+ "city": "Myrtle Beach",
+ "zip": "29588",
+ "price": 4600000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Harmony Point",
+ "listing_text": "Multifamily | 42 Units Harmony Point",
+ "firm_name": "Esti Simantov",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1052130/south-carolina-harmony-point",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1542964",
+ "address": "2020 Rollingwood Dr",
+ "city": "San Bruno",
+ "zip": "94066",
+ "price": 75000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "2020 Rollingwood Rd San Bruno CA 94066",
+ "listing_text": "Own this 7-Eleven Franchise for under $200,000. 1M+ in Annual Sales. Turnkey 2020 Rollingwood Rd San Bruno CA 94066",
+ "firm_name": "Novo Real Estate",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1542964/california-7-eleven-san-bruno-ca",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2160171",
+ "address": "619 Peachtree St",
+ "city": "Cocoa",
+ "zip": "32922",
+ "price": 1625000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "The Dolphin Apartments at Cocoa",
+ "listing_text": "Multifamily | 14 Units | $116,071/door The Dolphin Apartments at Cocoa",
+ "firm_name": "The Goldstein Group",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2160171/florida-the-dolphin-apartments-at-cocoa",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2450633",
+ "address": "907 I-20 Frontage Rd",
+ "city": "Big Spring",
+ "zip": "79720",
+ "price": 2000000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Southridge RV Park",
+ "listing_text": "141 Unit RV Park on 100 Acres Southridge RV Park",
+ "firm_name": "North Star Brokerage & Advisory",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2450633/texas-southridge-rv-park",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1958359",
+ "address": "4507 NC-55",
+ "city": "Cary",
+ "zip": "27519",
+ "price": 5550551,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Clarion Pointe - Raleigh / Durham",
+ "listing_text": "Amazing Opportunity for Owner Operator to acquire great assets well below replacement cost in RTP Clarion Pointe - Raleigh / Durham",
+ "firm_name": "Prime Source Properties",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1958359/north-carolina-clarion-pointe---raleigh-durham",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2191742",
+ "address": "13585 S Orange Ave",
+ "city": "Orlando",
+ "zip": "32824",
+ "price": 3345200,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Wawa: Orlando, FL",
+ "listing_text": "Retail | 5.30% CAP | 5,537 SqFt Wawa: Orlando, FL",
+ "firm_name": "CBRE Atlanta",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2191742/florida-wawa-orlando-fl",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2015864",
+ "address": "126 Kenley Pl",
+ "city": "San Antonio",
+ "zip": "78232",
+ "price": 3500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Baymont Hotel San Antonio Airport (Owner Finance)",
+ "listing_text": "Baymont Hotel | Owner Financing for quick sale | 74 Keys Baymont Hotel San Antonio Airport (Owner Finance)",
+ "firm_name": "KW Commercial",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2015864/texas-baymont-by-wyndham-san-antonio-airport",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2358460",
+ "address": "12921 Camino Real",
+ "city": "Kyle",
+ "zip": "78640",
+ "price": 25000000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Longhorn RV Resort & Storage",
+ "listing_text": "Just Listed | Longhorn RV Resort & Storage | 190 Pads | 200+ Acres | Niederwald, TX (Austin MSA) Longhorn RV Resort & Storage",
+ "firm_name": "Franklin Street",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2358460/texas-longhorn-rv-resort-storage",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx1677328",
+ "address": "8910 N 8th St",
+ "city": "Phoenix",
+ "zip": "85020",
+ "price": 580000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "8910 N 8th St",
+ "listing_text": "Multifamily | 20 Units 8910 N 8th St",
+ "firm_name": "Commercial Properties Inc Tempe",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/1677328/arizona-8910-north-8th-st",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2312277",
+ "address": "5520 Gaston Ave",
+ "city": "Dallas",
+ "zip": "75214",
+ "price": 3500000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Royal Palms",
+ "listing_text": "23 Units Completely Remodeled East of Downtown Dallas Royal Palms",
+ "firm_name": "Sperry",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2312277/texas-royal-palms",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ },
+ {
+ "id": "crx2146096",
+ "address": "9655 PA-285",
+ "city": "Conneaut Lake",
+ "zip": "16316",
+ "price": 2300000,
+ "hoa": null,
+ "beds": null,
+ "baths": null,
+ "sqft": null,
+ "year_built": null,
+ "project_name": "Connneaut Lake Family Campground",
+ "listing_text": "118 sites on ±47 acres | stable cash flow | strong demand | expansion potential Connneaut Lake Family Campground",
+ "firm_name": "Campfire Capital Group",
+ "broker_name": null,
+ "source": "https://www.crexi.com/properties/2146096/pennsylvania-connneaut-lake-family-campground",
+ "warrantable_status": "not_listed",
+ "warrant_source": "not on FHA list; no hard flags — verify with lender",
+ "warrant_signals": []
+ }
+ ]
+}
\ No newline at end of file
diff --git a/scripts/fetch-condos-sample.js b/scripts/fetch-condos-sample.js
new file mode 100644
index 0000000..241c553
--- /dev/null
+++ b/scripts/fetch-condos-sample.js
@@ -0,0 +1,138 @@
+// fetch-condos-sample.js — SMALL (1-session) Browserbase proof-of-pipeline for LA condos-for-sale.
+// Drives ONE cloud-browser session to Crexi's residential/condo search for a few LA cities, captures
+// the listing JSON the SPA fetches (api.crexi.com), classifies each condo's warrantability via
+// classify-warrantability.js, writes data/condos-sample.json, and upserts into the cre DB `condo` table.
+//
+// COST: 1 Browserbase session ≈ $0.04. This is the ALLOWED small sample to prove the pipeline + feed
+// graphics. The FULL-SCALE residential scrape is GATED (see pending-approval memo).
+//
+// Usage: NODE_PATH=$HOME/.claude/skills/browserbase/node_modules node scripts/fetch-condos-sample.js
+
+const fs = require('fs');
+const path = require('path');
+const { chromium } = require('playwright-core');
+const Browserbase = require('@browserbasehq/sdk').default;
+const { classify, loadFhaList, PROXY_LABEL } = require('./classify-warrantability');
+let brokerdb = null; try { brokerdb = require('./db/brokers-db'); } catch (_) {}
+
+const env = fs.readFileSync(process.env.HOME + '/.claude/skills/browserbase/.env', 'utf8');
+const get = (t, k) => (t.match(new RegExp('^' + k + '=(.*)$', 'm')) || [])[1]?.replace(/['"]/g, '').trim();
+const KEY = get(env, 'BROWSERBASE_API_KEY'), PROJECT = get(env, 'BROWSERBASE_PROJECT_ID');
+
+// A few LA cities likely to have condo inventory; one session visits them sequentially.
+const CITIES = (process.env.CC_CITIES || 'Los-Angeles,Long-Beach,Marina-Del-Rey,Glendale').split(',');
+const OUT = path.join(__dirname, '..', 'data', 'condos-sample.json');
+
+function condoFromAsset(a) {
+ const price = a.askingPrice || a.price;
+ const loc = (a.locations && a.locations[0]) || {};
+ const id = a.id || a.assetId;
+ if (!id || !price) return null;
+ const desc = (a.description || a.marketingDescription || '') + ' ' + (a.name || '');
+ const broker = (a.brokers && a.brokers[0]) || {};
+ return {
+ id: 'crx' + id,
+ address: loc.address || loc.fullAddress || (a.name || '').slice(0, 80),
+ city: (loc.city || '').trim(),
+ zip: (loc.zip || loc.zipCode || '').trim(),
+ price: Number(price),
+ hoa: a.hoaFee || a.hoa || null,
+ beds: a.bedrooms || a.beds || null,
+ baths: a.bathrooms || a.baths || null,
+ sqft: a.squareFeet || a.buildingSize || null,
+ year_built: a.yearBuilt || null,
+ project_name: a.condoProjectName || a.subdivision || a.name || null,
+ listing_text: desc.slice(0, 1500),
+ firm_name: (a.brokerageName || (a.brokerage && a.brokerage.name) || broker.brokerageName || null),
+ broker_name: broker.name || (broker.firstName ? broker.firstName + ' ' + (broker.lastName || '') : null),
+ source: a.urlSlug ? 'https://www.crexi.com/properties/' + id + '/' + a.urlSlug : 'https://www.crexi.com/properties/' + id
+ };
+}
+
+(async () => {
+ const captured = new Map();
+ let browser, session;
+ try {
+ const bb = new Browserbase({ apiKey: KEY });
+ session = await bb.sessions.create({ projectId: PROJECT, browserSettings: { solveCaptchas: true, viewport: { width: 1440, height: 1000 } } });
+ browser = await chromium.connectOverCDP(session.connectUrl);
+ const ctx = browser.contexts()[0];
+ const page = ctx.pages()[0] || await ctx.newPage();
+ page.setDefaultTimeout(45000);
+
+ page.on('response', async (resp) => {
+ if (!resp.url().includes('api.crexi.com')) return;
+ try {
+ const j = await resp.json();
+ const arr = Array.isArray(j) ? j : (j.data || j.assets || j.results || []);
+ if (!Array.isArray(arr)) return;
+ for (const a of arr) {
+ const c = condoFromAsset(a);
+ if (c && !captured.has(c.id)) captured.set(c.id, c);
+ }
+ } catch (_) {}
+ });
+
+ for (const citySlug of CITIES) {
+ const url = `https://www.crexi.com/properties/CA/${citySlug}/condo`;
+ process.stderr.write(`visiting ${url}\n`);
+ try {
+ await page.goto(url, { waitUntil: 'domcontentloaded' });
+ await page.waitForTimeout(6000); // let the SPA fire its api.crexi.com fetches
+ // scroll to trigger lazy-load of more cards
+ for (let i = 0; i < 3; i++) { await page.mouse.wheel(0, 3000); await page.waitForTimeout(1500); }
+ } catch (e) { process.stderr.write(' nav err: ' + e.message.split('\n')[0] + '\n'); }
+ }
+ } catch (e) {
+ process.stderr.write('Browserbase session error: ' + e.message + '\n');
+ } finally {
+ if (browser) try { await browser.close(); } catch (_) {}
+ }
+
+ const condos = [...captured.values()];
+ const fha = loadFhaList();
+ for (const c of condos) {
+ const r = classify(c, fha);
+ c.warrantable_status = r.status;
+ c.warrant_source = r.source;
+ c.warrant_signals = r.signals;
+ }
+
+ const payload = {
+ meta: {
+ source: 'Crexi residential/condo search via Browserbase (1-session SAMPLE)',
+ cost: '~$0.04 (1 Browserbase session)',
+ scope: 'PROOF-OF-PIPELINE sample only — full-scale residential scrape is gated',
+ warrantability_label: PROXY_LABEL,
+ fetched_at: new Date().toISOString(),
+ count: condos.length
+ },
+ condos
+ };
+ fs.writeFileSync(OUT, JSON.stringify(payload, null, 2));
+ process.stderr.write(`\nCaptured ${condos.length} condos -> ${OUT}\n`);
+
+ // Upsert into the cre DB condo table (reuse the broker graph's firm linkage).
+ if (brokerdb && condos.length) {
+ try {
+ for (const c of condos) {
+ const firmId = c.firm_name ? await brokerdb.upsertFirm(c.firm_name) : null;
+ await brokerdb.pool.query(
+ `INSERT INTO condo(id,address,city,zip,price,hoa,beds,baths,sqft,year_built,project_name,
+ listing_text,warrantable_status,warrant_source,warrant_signals,firm_id,firm_name,broker_name,source)
+ VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19)
+ ON CONFLICT(id) DO UPDATE SET price=EXCLUDED.price, warrantable_status=EXCLUDED.warrantable_status,
+ warrant_source=EXCLUDED.warrant_source, warrant_signals=EXCLUDED.warrant_signals`,
+ [c.id, c.address, c.city, c.zip, c.price, c.hoa, c.beds, c.baths, c.sqft, c.year_built,
+ c.project_name, c.listing_text, c.warrantable_status, c.warrant_source,
+ JSON.stringify(c.warrant_signals), firmId, c.firm_name, c.broker_name, c.source]);
+ }
+ process.stderr.write(`Upserted ${condos.length} into cre.condo\n`);
+ } catch (e) { process.stderr.write('DB upsert err: ' + e.message + '\n'); }
+ finally { try { await brokerdb.pool.end(); } catch (_) {} }
+ }
+
+ // Summary line to stdout (machine-readable).
+ const by = {}; condos.forEach(c => by[c.warrantable_status] = (by[c.warrantable_status] || 0) + 1);
+ console.log(JSON.stringify({ count: condos.length, byStatus: by }));
+})();
← 37b95ec CRE: graphics page (broker leaderboard, firm market-share, F
·
back to Commercialrealestate
·
CRE: 5-broker enrichment PoC (~$0.04) — public Crexi broker- d9dfc39 →