← back to Commercialrealestate
Weekly Crexi refresh job + 38 new SFV listings (62 total)
fc9d273d0d2ec47d029399ba52ce8f11ddca93e5 · 2026-06-21 18:24:41 -0700 · Steve
- scripts/refresh-listings.js: ONE Browserbase session sweeps SFV city/type Crexi pages, captures
the SPA's authed api.crexi.com assets, filters in-band($800k-1.75M)+SFV+active, dedups by address, appends
- scripts/run-weekly-refresh.sh + deploy/com.steve.cre-weekly-refresh.plist: Mon 05:00 launchd (loaded);
refresh -> re-rank -> commit -> George email only if new listings added
- verified: 160 assets captured -> 39 candidates -> 38 added, 0 dups, 0 non-SFV leaks
Files touched
A data/last-refresh.jsonM data/listings.jsonM data/qwen-cache.jsonM data/ranked.jsonA deploy/com.steve.cre-weekly-refresh.plistA scripts/refresh-listings.jsA scripts/run-weekly-refresh.sh
Diff
commit fc9d273d0d2ec47d029399ba52ce8f11ddca93e5
Author: Steve <steve@designerwallcoverings.com>
Date: Sun Jun 21 18:24:41 2026 -0700
Weekly Crexi refresh job + 38 new SFV listings (62 total)
- scripts/refresh-listings.js: ONE Browserbase session sweeps SFV city/type Crexi pages, captures
the SPA's authed api.crexi.com assets, filters in-band($800k-1.75M)+SFV+active, dedups by address, appends
- scripts/run-weekly-refresh.sh + deploy/com.steve.cre-weekly-refresh.plist: Mon 05:00 launchd (loaded);
refresh -> re-rank -> commit -> George email only if new listings added
- verified: 160 assets captured -> 39 candidates -> 38 added, 0 dups, 0 non-SFV leaks
---
data/last-refresh.json | 6 +
data/listings.json | 1160 ++++++++++++++-
data/qwen-cache.json | 720 +++++++++
data/ranked.json | 2252 ++++++++++++++++++++++++++---
deploy/com.steve.cre-weekly-refresh.plist | 28 +
scripts/refresh-listings.js | 86 ++
scripts/run-weekly-refresh.sh | 22 +
7 files changed, 4052 insertions(+), 222 deletions(-)
diff --git a/data/last-refresh.json b/data/last-refresh.json
new file mode 100644
index 0000000..5d39d1e
--- /dev/null
+++ b/data/last-refresh.json
@@ -0,0 +1,6 @@
+{
+ "date": "2026-06-22",
+ "captured": 160,
+ "candidates": 39,
+ "added": 38
+}
\ No newline at end of file
diff --git a/data/listings.json b/data/listings.json
index fa49735..f0ecc49 100644
--- a/data/listings.json
+++ b/data/listings.json
@@ -1,7 +1,11 @@
{
"meta": {
"market": "San Fernando Valley, CA",
- "asset_classes": ["Multifamily", "Retail/Net-lease", "Mixed-use"],
+ "asset_classes": [
+ "Multifamily",
+ "Retail/Net-lease",
+ "Mixed-use"
+ ],
"budget_frame": "leveraged — $400,000 available as down payment + closing",
"sourced": "2026-06-21 via Exa web search (LoopNet/Compass/Crexi/broker sites)",
"caveats": [
@@ -11,29 +15,1133 @@
]
},
"listings": [
- {"id": "victory13350", "address": "13350 Victory Blvd", "city": "Van Nuys", "zip": "91401", "type": "Multifamily", "price": 1299995, "units": 5, "sqft": 3468, "cap_rate": 4.49, "year_built": 1951, "rent_control": "Not on LA RSO (per listing)", "status": "Active", "upside_note": "~30% rent upside; 5 garage spaces add revenue; copper plumbing partial", "source": "https://www.compass.com/homedetails/13350-Victory-Blvd-Van-Nuys-CA-91401/1J7A3S_pid/"},
- {"id": "sepulveda8144", "address": "8144 Sepulveda Pl", "city": "Panorama City", "zip": "91402", "type": "Multifamily", "price": 1400000, "units": 6, "sqft": 5418, "cap_rate": 5.00, "year_built": 1952, "rent_control": "LA RSO (pre-1978) — assume rent controlled", "status": "Active", "upside_note": "All 2bd/1ba unit mix; tremendous upside; newer roof, copper plumbing, owned laundry", "source": "https://www.compass.com/homedetails/8144-Sepulveda-Pl-Panorama-City-CA-91402/1IJRNO_pid/"},
- {"id": "canby7260", "address": "7260 Canby Ave", "city": "Reseda", "zip": "91335", "type": "Multifamily", "price": 1425000, "units": 6, "sqft": 5108, "cap_rate": 4.75, "year_built": 1954, "rent_control": "LAR2; pre-1978 likely RSO", "status": "Active", "upside_note": "RTI plans for 2 ADUs -> projected 7.08% cap, 7.60% pre-tax CoC post-ADU; $272/sf post-ADU; Walk Score 86 near CSUN", "source": "https://www.loopnet.com/Listing/7260-Canby-Ave-Reseda-CA/34975971/"},
- {"id": "canby7304", "address": "7302-7304 Canby Ave", "city": "Reseda", "zip": "91335", "type": "Mixed-use", "price": 1250000, "units": 5, "sqft": 5048, "cap_rate": 5.96, "cap_rate_projected": 7.80, "noi_actual": 74497, "gross_actual": 112200, "expenses": 37703, "verified": true, "rent_roll": [{"unit": 1, "type": "commercial 0bd/1ba", "rent": 2000, "proforma": 4000}, {"unit": 2, "type": "3bd/3ba", "rent": 2550, "proforma": 3000}, {"unit": 3, "type": "1bd/1ba", "rent": 1550}, {"unit": 4, "type": "1bd/1ba", "rent": 1500}, {"unit": 5, "type": "1bd/1ba", "rent": 1750}], "year_built": 1926, "rent_control": "C2 (LAC2) mixed commercial+residential", "status": "Active", "upside_note": "VERIFIED (MLS #26654413): actual in-place cap ~5.96% (NOI $74,497 on $112,200 gross, $37,703 exp) — the 7.8% headline is PROJECTED, achieved mainly by doubling the commercial unit $2,000->$4,000/mo + bumping the 3bd. SELLER FINANCING confirmed. Price CUT $1,399,000->$1,250,000 (motivated seller). Occupancy ambiguous (listing desc says 3 occupied vs MLS 0% vacancy — verify rent roll). C2 development optionality.", "source": "https://www.compass.com/homedetails/7304-Canby-Ave-Reseda-CA-91335/1IO7AS_pid/"},
- {"id": "schoenborn17920", "address": "17920 Schoenborn St", "city": "Northridge", "zip": "91325", "type": "Multifamily", "price": 1395000, "units": 6, "sqft": 4962, "cap_rate": 5.97, "noi_actual": 83282, "gross_actual": 121394, "expenses": 38112, "verified": true, "rent_roll": [{"unit": 1, "type": "1bd/1ba", "rent": 1153}, {"unit": 2, "type": "1bd/1ba", "rent": 1227}, {"unit": 3, "type": "1bd/1ba", "rent": 1299}, {"unit": 4, "type": "2bd/1ba", "rent": 2200}, {"unit": 5, "type": "3bd/1ba", "rent": 2800}, {"unit": 6, "type": "1bd/1ba", "rent": 1750}], "year_built": 1959, "rent_control": "LAR3 / rent controlled (1959); pre-1978 RSO", "status": "Active", "upside_note": "VERIFIED (MLS): actual in-place 5.97% cap (NOI $83,282 on $121,394 gross, $38,112 exp); rent-controlled (LAR3, 1959) limits upside. Live-in-one play near CSUN/Northridge Hospital.", "source": "https://www.compass.com/homedetails/17920-Schoenborn-St-Northridge-CA-91325/1JVU5S_pid/"},
- {"id": "amigo8357", "address": "8357 Amigo Ave", "city": "Northridge", "zip": "91324", "type": "Multifamily", "price": 1249000, "units": 4, "sqft": 3816, "cap_rate": 5.63, "noi_actual": 70270, "gross_actual": 89460, "expenses": 19190, "verified": true, "rent_roll": [{"unit": 1, "type": "2bd/1ba", "rent": 1509}, {"unit": 2, "type": "2bd/1ba", "rent": 2300}, {"unit": 3, "type": "2bd/1ba", "rent": 1651}, {"unit": 4, "type": "2bd/1ba", "rent": 2000}], "year_built": 1960, "rent_control": "LAR3", "status": "Active", "upside_note": "VERIFIED (MLS): honest in-place cap ~5.63% = gross $89,460 - exp $19,190 = NOI $70,270 (the MLS 'NOI $88,310' field ignores expenses — unreliable). Stated expenses $19,190 look LOW (verify taxes/insurance/mgmt in DD). Price cut $1,350,000->$1,249,000 (motivated). Quad near CSUN.", "source": "https://www.compass.com/homedetails/8357-Amigo-Ave-Northridge-CA-91324/1IMLRO_pid/"},
- {"id": "wilbur9014", "address": "9014 Wilbur Ave", "city": "Northridge", "zip": "91324", "type": "Multifamily", "price": 1700000, "units": 4, "sqft": 3211, "cap_rate": null, "year_built": 1980, "rent_control": "Built 1980 -> NOT LA RSO; AB1482 only", "status": "Active", "upside_note": "Cap not disclosed; 1980 build = no LA rent control (higher increases); remodeled + new-construction units; adjacent 2-unit also available", "source": "https://www.compass.com/homedetails/9014-Wilbur-Ave-Northridge-CA-91324/1KTV77_pid/"},
- {"id": "tilden8843", "address": "8843-8845 Tilden Ave", "city": "Panorama City", "zip": "91402", "type": "Multifamily", "price": 1050000, "units": 3, "sqft": 2076, "cap_rate": null, "year_built": 1948, "rent_control": "Pre-1978 -> LA RSO", "status": "Active", "upside_note": "Cap not disclosed; $350k/unit; individually metered; owner-user/house-hack friendly", "source": "https://www.coldwellbankerhomes.com/ca/panorama-city/8843-tilden/pid_69954470/"},
- {"id": "tilden8837", "address": "8837 Tilden Ave", "city": "Panorama City", "zip": "91402", "type": "Multifamily", "price": 899000, "units": 2, "sqft": 1794, "cap_rate": 5.30, "year_built": 1948, "rent_control": "Pre-1978 -> LA RSO", "status": "Active", "upside_note": "Duplex; small entry point; on market 51 days", "source": "https://www.compass.com/homedetails/8837-Tilden-Ave-Panorama-City-CA-91402/1JQEEP_pid/"},
- {"id": "sanfernando10004", "address": "10004 San Fernando Rd", "city": "Pacoima", "zip": "91331", "type": "Mixed-use", "price": 1100000, "units": 3, "sqft": 2270, "cap_rate": null, "year_built": 1933, "rent_control": "Zoned LAC2 (residential/commercial)", "status": "Active", "upside_note": "Cap not disclosed; triplex on commercial-zoned lot, 9,155sf land; SOLD AS-IS (condition risk); redevelopment optionality", "source": "https://www.compass.com/homedetails/10004-San-Fernando-Rd-Pacoima-CA-91331/1J7S8M_pid/"},
- {"id": "vannuys12872", "address": "12872 Van Nuys Blvd", "city": "Pacoima", "zip": "91331", "type": "Multifamily", "price": 949900, "units": 3, "sqft": 2084, "cap_rate": null, "year_built": 1948, "rent_control": "Pre-1978 -> LA RSO", "status": "Active (one source showed Pending — VERIFY)", "upside_note": "Cap not disclosed; renovated triplex, new roof/windows/plumbing; STATUS UNCERTAIN", "source": "https://www.compass.com/homedetails/12872-Van-Nuys-Blvd-Pacoima-CA-91331/1L7DX2_pid/"},
- {"id": "sherman21627", "address": "21627 Sherman Way", "city": "Canoga Park", "zip": "91303", "type": "Retail", "price": 899998, "units": 1, "sqft": 1500, "cap_rate": null, "verified": false, "year_built": 1941, "rent_control": "Commercial — n/a", "status": "Active", "upside_note": "NO in-place income (owner-user barber shop, ~vacant) — return is unverifiable; ranks low by design. Canoga Park Parts District; Opportunity Zone + JEDI Zone incentives; SBA 504 ~10% down; new roof/HVAC 2022. Price cut $998,800->$948,800->$899,998 (motivated).", "source": "https://www.coldwellbankerhomes.com/ca/canoga-park/21627-sherman-way/pid_69748281/"},
- {"id": "owensmouth7129", "address": "7129-7131 1/2 Owensmouth Ave", "city": "Canoga Park", "zip": "91303", "type": "Retail", "price": 1050000, "units": 1, "sqft": 1482, "cap_rate": null, "year_built": 1970, "rent_control": "Commercial — n/a", "status": "Active", "upside_note": "Cap not disclosed; small freestanding retail near Warner Center", "source": "https://www.loopnet.com/Listing/7129-7131-1-2-Owensmouth-Ave-Canoga-Park-CA/35430257/"},
- {"id": "hillhaven10139", "address": "10139 Hillhaven Ave", "city": "Tujunga", "zip": "91042", "type": "Multifamily", "price": 1248888, "units": 3, "sqft": 3929, "cap_rate": 5.40, "year_built": 1949, "rent_control": "LAR3; pre-1978 RSO", "status": "Active", "upside_note": "Broker cap 5.40%; FIXER triplex, value-add (remodel rear units to market) + expand 3->5 units / 2 ADUs (R3, 8,137sf lot). Priced for condition ($318/sf). On market 75 days.", "source": "https://www.compass.com/homedetails/10139-Hillhaven-Ave-Tujunga-CA-91042/1KFS1G_pid/"},
- {"id": "wilkinson5214", "address": "5214 Wilkinson Ave", "city": "Valley Village", "zip": "91607", "type": "Multifamily", "price": 1350000, "units": 4, "sqft": 3664, "cap_rate": 3.95, "year_built": 1956, "rent_control": "LARD1.5; pre-1978 RSO", "status": "Active", "upside_note": "Broker cap 3.95% (low) — all 4 units 2bd/1ba ~900sf, owner's unit (D) delivered VACANT (immediate re-tenant upside); prime VV walk-to-Magnolia; 1031 candidate.", "source": "https://www.compass.com/homedetails/5214-Wilkinson-Ave-Valley-Village-CA-91607/1JM961_pid/"},
- {"id": "vannuys6329", "address": "6329 Van Nuys Blvd", "city": "Van Nuys", "zip": "91401", "type": "Retail", "price": 1350000, "units": 3, "sqft": 3960, "cap_rate": 5.17, "cap_rate_projected": 6.35, "year_built": 1947, "rent_control": "Commercial — n/a", "status": "Active (verify — listing data may be older)", "upside_note": "Broker current cap 5.17% / proforma 6.35%; 3-tenant value-add retail at signalized Van Nuys Blvd & Friar hard corner; tenants below market; 1 block from planned E. SFV light-rail (2027). VERIFY listing is current.", "source": "https://myelisting.com/listing/271977/6329-van-nuys-boulevard-los-angeles-ca-91401/"},
- {"id": "sepulveda10011", "address": "10011 Sepulveda Blvd", "city": "Mission Hills", "zip": "91345", "type": "Multifamily", "price": 1450000, "units": 4, "sqft": 4084, "cap_rate": null, "year_built": 1964, "rent_control": "Pre-1978 -> LA RSO", "status": "Active", "upside_note": "Cap not disclosed; 4-unit detached (no common walls) inside a 2.48ac condo-style complex on Sepulveda; near 405/5/118. Reduced from $1,450,000+ history.", "source": "https://www.compass.com/homedetails/10011-Sepulveda-Blvd-Mission-Hills-CA-91345/1KVV1H_pid/"},
- {"id": "foothill6851", "address": "6851 Foothill Blvd", "city": "Tujunga", "zip": "91042", "type": "Mixed-use", "price": 1179999, "units": 3, "sqft": 1942, "cap_rate": null, "year_built": 1945, "rent_control": "Commercial front + 2 resi (RSO on resi)", "status": "Active", "upside_note": "Cap not disclosed (~5% potential per listing); remodeled freestanding commercial + rear duplex (TWO APNs, can buy one/both), owner-user near Glendale; ADU potential. $608/sf.", "source": "https://www.remax.com/ca/tujunga/home-details/6851-foothill-blvd-tujunga-ca-91042/11511387186448702372/M00000093/GD26109676"},
- {"id": "comercio5301", "address": "5301 Comercio Lane", "city": "Woodland Hills", "zip": "91364", "type": "Mixed-use", "price": 814250, "units": 4, "sqft": 3473, "cap_rate": null, "year_built": 1956, "rent_control": "LAC4 (office/retail mixed)", "status": "Pending (probate/court-confirmation)", "upside_note": "Cap not disclosed; probate trust sale, court-confirmation required (slow/uncertain close); LAC4 flexible use near Ventura Blvd; lowest entry price", "source": "https://www.nuevo-realestate.com/real-estate/5301-comercio-lane-woodland-hills-ca-91364/25577103/183735124"},
- {"id": "vanowen15840", "address": "15840 Vanowen St", "city": "Lake Balboa", "zip": "91406", "type": "Multifamily", "price": 970000, "units": 5, "sqft": 3349, "cap_rate": 5.25, "year_built": 1952, "rent_control": "Pre-1978 -> LA RSO", "status": "Under Contract", "upside_note": "5 units, new roof 2022, copper plumbing, tremendous upside — BUT already in escrow (likely unavailable)", "source": "https://www.loopnet.com/Listing/15840-Vanowen-St-Lake-Balboa-CA/35415601/"},
- {"id": "canby7454", "address": "7454 Canby Ave", "city": "Reseda", "zip": "91335", "type": "Multifamily", "price": 1749000, "units": 9, "sqft": 6784, "cap_rate": null, "year_built": 1962, "rent_control": "Pre-1978 -> LA RSO", "status": "Active Under Contract", "upside_note": "9 units at $194k/unit, diverse mix — but in escrow; back-up only", "source": "https://www.remax.com/ca/reseda/home-details/7454-canby-ave-reseda-ca-91335/13235972936323110093/M00000093/SR26009655"},
- {"id": "correnti12600", "address": "12600 Correnti St", "city": "Pacoima", "zip": "91331", "type": "Multifamily", "price": 3300000, "units": 14, "sqft": 5334, "cap_rate": 7.50, "year_built": null, "rent_control": "Renovated; verify RSO", "status": "Active (OUT OF BUDGET — context)", "upside_note": "ASSUMABLE $2.5M loan at 3.9% fixed thru 09/2027 -> only ~25% (~$825k) down but 12.2% cash-on-cash on current; plans to add 20 units -> proforma 13.9% cap. Exceptional economics but down payment EXCEEDS $400k.", "source": "https://www.compass.com/homedetails/12600-Correnti-St-Pacoima-CA-91331/27H0FQ_pid/"},
- {"id": "burbank10701", "address": "10701 Burbank Blvd", "city": "North Hollywood", "zip": "91601", "type": "Retail/NNN", "price": 2799000, "units": 1, "sqft": 1802, "cap_rate": 7.30, "year_built": 1951, "rent_control": "Commercial NNN — n/a", "status": "Active (OUT OF BUDGET — context)", "upside_note": "Single-tenant NNN cannabis dispensary, $204k NOI, 10-yr lease 2% bumps, fully passive. High cap but cannabis-tenant risk + needs ~$700k down.", "source": "https://www.jayrubin-re.com/file/view-file/580"},
- {"id": "canoga6020", "address": "6020 Canoga Ave", "city": "Woodland Hills", "zip": "91367", "type": "Retail/NNN", "price": 5500000, "units": 2, "sqft": 4896, "cap_rate": 6.35, "year_built": null, "rent_control": "Commercial NNN — n/a", "status": "Active (OUT OF BUDGET — context)", "upside_note": "2-tenant NNN (sushi + credit union) in Warner Center across from future Rams HQ; 18.2yr avg occupancy; trophy passive asset but far above budget.", "source": "https://www.brandonmichaelsgroup.com/6020canogaave"}
+ {
+ "id": "victory13350",
+ "address": "13350 Victory Blvd",
+ "city": "Van Nuys",
+ "zip": "91401",
+ "type": "Multifamily",
+ "price": 1299995,
+ "units": 5,
+ "sqft": 3468,
+ "cap_rate": 4.49,
+ "year_built": 1951,
+ "rent_control": "Not on LA RSO (per listing)",
+ "status": "Active",
+ "upside_note": "~30% rent upside; 5 garage spaces add revenue; copper plumbing partial",
+ "source": "https://www.compass.com/homedetails/13350-Victory-Blvd-Van-Nuys-CA-91401/1J7A3S_pid/"
+ },
+ {
+ "id": "sepulveda8144",
+ "address": "8144 Sepulveda Pl",
+ "city": "Panorama City",
+ "zip": "91402",
+ "type": "Multifamily",
+ "price": 1400000,
+ "units": 6,
+ "sqft": 5418,
+ "cap_rate": 5,
+ "year_built": 1952,
+ "rent_control": "LA RSO (pre-1978) — assume rent controlled",
+ "status": "Active",
+ "upside_note": "All 2bd/1ba unit mix; tremendous upside; newer roof, copper plumbing, owned laundry",
+ "source": "https://www.compass.com/homedetails/8144-Sepulveda-Pl-Panorama-City-CA-91402/1IJRNO_pid/"
+ },
+ {
+ "id": "canby7260",
+ "address": "7260 Canby Ave",
+ "city": "Reseda",
+ "zip": "91335",
+ "type": "Multifamily",
+ "price": 1425000,
+ "units": 6,
+ "sqft": 5108,
+ "cap_rate": 4.75,
+ "year_built": 1954,
+ "rent_control": "LAR2; pre-1978 likely RSO",
+ "status": "Active",
+ "upside_note": "RTI plans for 2 ADUs -> projected 7.08% cap, 7.60% pre-tax CoC post-ADU; $272/sf post-ADU; Walk Score 86 near CSUN",
+ "source": "https://www.loopnet.com/Listing/7260-Canby-Ave-Reseda-CA/34975971/"
+ },
+ {
+ "id": "canby7304",
+ "address": "7302-7304 Canby Ave",
+ "city": "Reseda",
+ "zip": "91335",
+ "type": "Mixed-use",
+ "price": 1250000,
+ "units": 5,
+ "sqft": 5048,
+ "cap_rate": 5.96,
+ "cap_rate_projected": 7.8,
+ "noi_actual": 74497,
+ "gross_actual": 112200,
+ "expenses": 37703,
+ "verified": true,
+ "rent_roll": [
+ {
+ "unit": 1,
+ "type": "commercial 0bd/1ba",
+ "rent": 2000,
+ "proforma": 4000
+ },
+ {
+ "unit": 2,
+ "type": "3bd/3ba",
+ "rent": 2550,
+ "proforma": 3000
+ },
+ {
+ "unit": 3,
+ "type": "1bd/1ba",
+ "rent": 1550
+ },
+ {
+ "unit": 4,
+ "type": "1bd/1ba",
+ "rent": 1500
+ },
+ {
+ "unit": 5,
+ "type": "1bd/1ba",
+ "rent": 1750
+ }
+ ],
+ "year_built": 1926,
+ "rent_control": "C2 (LAC2) mixed commercial+residential",
+ "status": "Active",
+ "upside_note": "VERIFIED (MLS #26654413): actual in-place cap ~5.96% (NOI $74,497 on $112,200 gross, $37,703 exp) — the 7.8% headline is PROJECTED, achieved mainly by doubling the commercial unit $2,000->$4,000/mo + bumping the 3bd. SELLER FINANCING confirmed. Price CUT $1,399,000->$1,250,000 (motivated seller). Occupancy ambiguous (listing desc says 3 occupied vs MLS 0% vacancy — verify rent roll). C2 development optionality.",
+ "source": "https://www.compass.com/homedetails/7304-Canby-Ave-Reseda-CA-91335/1IO7AS_pid/"
+ },
+ {
+ "id": "schoenborn17920",
+ "address": "17920 Schoenborn St",
+ "city": "Northridge",
+ "zip": "91325",
+ "type": "Multifamily",
+ "price": 1395000,
+ "units": 6,
+ "sqft": 4962,
+ "cap_rate": 5.97,
+ "noi_actual": 83282,
+ "gross_actual": 121394,
+ "expenses": 38112,
+ "verified": true,
+ "rent_roll": [
+ {
+ "unit": 1,
+ "type": "1bd/1ba",
+ "rent": 1153
+ },
+ {
+ "unit": 2,
+ "type": "1bd/1ba",
+ "rent": 1227
+ },
+ {
+ "unit": 3,
+ "type": "1bd/1ba",
+ "rent": 1299
+ },
+ {
+ "unit": 4,
+ "type": "2bd/1ba",
+ "rent": 2200
+ },
+ {
+ "unit": 5,
+ "type": "3bd/1ba",
+ "rent": 2800
+ },
+ {
+ "unit": 6,
+ "type": "1bd/1ba",
+ "rent": 1750
+ }
+ ],
+ "year_built": 1959,
+ "rent_control": "LAR3 / rent controlled (1959); pre-1978 RSO",
+ "status": "Active",
+ "upside_note": "VERIFIED (MLS): actual in-place 5.97% cap (NOI $83,282 on $121,394 gross, $38,112 exp); rent-controlled (LAR3, 1959) limits upside. Live-in-one play near CSUN/Northridge Hospital.",
+ "source": "https://www.compass.com/homedetails/17920-Schoenborn-St-Northridge-CA-91325/1JVU5S_pid/"
+ },
+ {
+ "id": "amigo8357",
+ "address": "8357 Amigo Ave",
+ "city": "Northridge",
+ "zip": "91324",
+ "type": "Multifamily",
+ "price": 1249000,
+ "units": 4,
+ "sqft": 3816,
+ "cap_rate": 5.63,
+ "noi_actual": 70270,
+ "gross_actual": 89460,
+ "expenses": 19190,
+ "verified": true,
+ "rent_roll": [
+ {
+ "unit": 1,
+ "type": "2bd/1ba",
+ "rent": 1509
+ },
+ {
+ "unit": 2,
+ "type": "2bd/1ba",
+ "rent": 2300
+ },
+ {
+ "unit": 3,
+ "type": "2bd/1ba",
+ "rent": 1651
+ },
+ {
+ "unit": 4,
+ "type": "2bd/1ba",
+ "rent": 2000
+ }
+ ],
+ "year_built": 1960,
+ "rent_control": "LAR3",
+ "status": "Active",
+ "upside_note": "VERIFIED (MLS): honest in-place cap ~5.63% = gross $89,460 - exp $19,190 = NOI $70,270 (the MLS 'NOI $88,310' field ignores expenses — unreliable). Stated expenses $19,190 look LOW (verify taxes/insurance/mgmt in DD). Price cut $1,350,000->$1,249,000 (motivated). Quad near CSUN.",
+ "source": "https://www.compass.com/homedetails/8357-Amigo-Ave-Northridge-CA-91324/1IMLRO_pid/"
+ },
+ {
+ "id": "wilbur9014",
+ "address": "9014 Wilbur Ave",
+ "city": "Northridge",
+ "zip": "91324",
+ "type": "Multifamily",
+ "price": 1700000,
+ "units": 4,
+ "sqft": 3211,
+ "cap_rate": null,
+ "year_built": 1980,
+ "rent_control": "Built 1980 -> NOT LA RSO; AB1482 only",
+ "status": "Active",
+ "upside_note": "Cap not disclosed; 1980 build = no LA rent control (higher increases); remodeled + new-construction units; adjacent 2-unit also available",
+ "source": "https://www.compass.com/homedetails/9014-Wilbur-Ave-Northridge-CA-91324/1KTV77_pid/"
+ },
+ {
+ "id": "tilden8843",
+ "address": "8843-8845 Tilden Ave",
+ "city": "Panorama City",
+ "zip": "91402",
+ "type": "Multifamily",
+ "price": 1050000,
+ "units": 3,
+ "sqft": 2076,
+ "cap_rate": null,
+ "year_built": 1948,
+ "rent_control": "Pre-1978 -> LA RSO",
+ "status": "Active",
+ "upside_note": "Cap not disclosed; $350k/unit; individually metered; owner-user/house-hack friendly",
+ "source": "https://www.coldwellbankerhomes.com/ca/panorama-city/8843-tilden/pid_69954470/"
+ },
+ {
+ "id": "tilden8837",
+ "address": "8837 Tilden Ave",
+ "city": "Panorama City",
+ "zip": "91402",
+ "type": "Multifamily",
+ "price": 899000,
+ "units": 2,
+ "sqft": 1794,
+ "cap_rate": 5.3,
+ "year_built": 1948,
+ "rent_control": "Pre-1978 -> LA RSO",
+ "status": "Active",
+ "upside_note": "Duplex; small entry point; on market 51 days",
+ "source": "https://www.compass.com/homedetails/8837-Tilden-Ave-Panorama-City-CA-91402/1JQEEP_pid/"
+ },
+ {
+ "id": "sanfernando10004",
+ "address": "10004 San Fernando Rd",
+ "city": "Pacoima",
+ "zip": "91331",
+ "type": "Mixed-use",
+ "price": 1100000,
+ "units": 3,
+ "sqft": 2270,
+ "cap_rate": null,
+ "year_built": 1933,
+ "rent_control": "Zoned LAC2 (residential/commercial)",
+ "status": "Active",
+ "upside_note": "Cap not disclosed; triplex on commercial-zoned lot, 9,155sf land; SOLD AS-IS (condition risk); redevelopment optionality",
+ "source": "https://www.compass.com/homedetails/10004-San-Fernando-Rd-Pacoima-CA-91331/1J7S8M_pid/"
+ },
+ {
+ "id": "vannuys12872",
+ "address": "12872 Van Nuys Blvd",
+ "city": "Pacoima",
+ "zip": "91331",
+ "type": "Multifamily",
+ "price": 949900,
+ "units": 3,
+ "sqft": 2084,
+ "cap_rate": null,
+ "year_built": 1948,
+ "rent_control": "Pre-1978 -> LA RSO",
+ "status": "Active (one source showed Pending — VERIFY)",
+ "upside_note": "Cap not disclosed; renovated triplex, new roof/windows/plumbing; STATUS UNCERTAIN",
+ "source": "https://www.compass.com/homedetails/12872-Van-Nuys-Blvd-Pacoima-CA-91331/1L7DX2_pid/"
+ },
+ {
+ "id": "sherman21627",
+ "address": "21627 Sherman Way",
+ "city": "Canoga Park",
+ "zip": "91303",
+ "type": "Retail",
+ "price": 899998,
+ "units": 1,
+ "sqft": 1500,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": 1941,
+ "rent_control": "Commercial — n/a",
+ "status": "Active",
+ "upside_note": "NO in-place income (owner-user barber shop, ~vacant) — return is unverifiable; ranks low by design. Canoga Park Parts District; Opportunity Zone + JEDI Zone incentives; SBA 504 ~10% down; new roof/HVAC 2022. Price cut $998,800->$948,800->$899,998 (motivated).",
+ "source": "https://www.coldwellbankerhomes.com/ca/canoga-park/21627-sherman-way/pid_69748281/"
+ },
+ {
+ "id": "owensmouth7129",
+ "address": "7129-7131 1/2 Owensmouth Ave",
+ "city": "Canoga Park",
+ "zip": "91303",
+ "type": "Retail",
+ "price": 1050000,
+ "units": 1,
+ "sqft": 1482,
+ "cap_rate": null,
+ "year_built": 1970,
+ "rent_control": "Commercial — n/a",
+ "status": "Active",
+ "upside_note": "Cap not disclosed; small freestanding retail near Warner Center",
+ "source": "https://www.loopnet.com/Listing/7129-7131-1-2-Owensmouth-Ave-Canoga-Park-CA/35430257/"
+ },
+ {
+ "id": "hillhaven10139",
+ "address": "10139 Hillhaven Ave",
+ "city": "Tujunga",
+ "zip": "91042",
+ "type": "Multifamily",
+ "price": 1248888,
+ "units": 3,
+ "sqft": 3929,
+ "cap_rate": 5.4,
+ "year_built": 1949,
+ "rent_control": "LAR3; pre-1978 RSO",
+ "status": "Active",
+ "upside_note": "Broker cap 5.40%; FIXER triplex, value-add (remodel rear units to market) + expand 3->5 units / 2 ADUs (R3, 8,137sf lot). Priced for condition ($318/sf). On market 75 days.",
+ "source": "https://www.compass.com/homedetails/10139-Hillhaven-Ave-Tujunga-CA-91042/1KFS1G_pid/"
+ },
+ {
+ "id": "wilkinson5214",
+ "address": "5214 Wilkinson Ave",
+ "city": "Valley Village",
+ "zip": "91607",
+ "type": "Multifamily",
+ "price": 1350000,
+ "units": 4,
+ "sqft": 3664,
+ "cap_rate": 3.95,
+ "year_built": 1956,
+ "rent_control": "LARD1.5; pre-1978 RSO",
+ "status": "Active",
+ "upside_note": "Broker cap 3.95% (low) — all 4 units 2bd/1ba ~900sf, owner's unit (D) delivered VACANT (immediate re-tenant upside); prime VV walk-to-Magnolia; 1031 candidate.",
+ "source": "https://www.compass.com/homedetails/5214-Wilkinson-Ave-Valley-Village-CA-91607/1JM961_pid/"
+ },
+ {
+ "id": "vannuys6329",
+ "address": "6329 Van Nuys Blvd",
+ "city": "Van Nuys",
+ "zip": "91401",
+ "type": "Retail",
+ "price": 1350000,
+ "units": 3,
+ "sqft": 3960,
+ "cap_rate": 5.17,
+ "cap_rate_projected": 6.35,
+ "year_built": 1947,
+ "rent_control": "Commercial — n/a",
+ "status": "Active (verify — listing data may be older)",
+ "upside_note": "Broker current cap 5.17% / proforma 6.35%; 3-tenant value-add retail at signalized Van Nuys Blvd & Friar hard corner; tenants below market; 1 block from planned E. SFV light-rail (2027). VERIFY listing is current.",
+ "source": "https://myelisting.com/listing/271977/6329-van-nuys-boulevard-los-angeles-ca-91401/"
+ },
+ {
+ "id": "sepulveda10011",
+ "address": "10011 Sepulveda Blvd",
+ "city": "Mission Hills",
+ "zip": "91345",
+ "type": "Multifamily",
+ "price": 1450000,
+ "units": 4,
+ "sqft": 4084,
+ "cap_rate": null,
+ "year_built": 1964,
+ "rent_control": "Pre-1978 -> LA RSO",
+ "status": "Active",
+ "upside_note": "Cap not disclosed; 4-unit detached (no common walls) inside a 2.48ac condo-style complex on Sepulveda; near 405/5/118. Reduced from $1,450,000+ history.",
+ "source": "https://www.compass.com/homedetails/10011-Sepulveda-Blvd-Mission-Hills-CA-91345/1KVV1H_pid/"
+ },
+ {
+ "id": "foothill6851",
+ "address": "6851 Foothill Blvd",
+ "city": "Tujunga",
+ "zip": "91042",
+ "type": "Mixed-use",
+ "price": 1179999,
+ "units": 3,
+ "sqft": 1942,
+ "cap_rate": null,
+ "year_built": 1945,
+ "rent_control": "Commercial front + 2 resi (RSO on resi)",
+ "status": "Active",
+ "upside_note": "Cap not disclosed (~5% potential per listing); remodeled freestanding commercial + rear duplex (TWO APNs, can buy one/both), owner-user near Glendale; ADU potential. $608/sf.",
+ "source": "https://www.remax.com/ca/tujunga/home-details/6851-foothill-blvd-tujunga-ca-91042/11511387186448702372/M00000093/GD26109676"
+ },
+ {
+ "id": "comercio5301",
+ "address": "5301 Comercio Lane",
+ "city": "Woodland Hills",
+ "zip": "91364",
+ "type": "Mixed-use",
+ "price": 814250,
+ "units": 4,
+ "sqft": 3473,
+ "cap_rate": null,
+ "year_built": 1956,
+ "rent_control": "LAC4 (office/retail mixed)",
+ "status": "Pending (probate/court-confirmation)",
+ "upside_note": "Cap not disclosed; probate trust sale, court-confirmation required (slow/uncertain close); LAC4 flexible use near Ventura Blvd; lowest entry price",
+ "source": "https://www.nuevo-realestate.com/real-estate/5301-comercio-lane-woodland-hills-ca-91364/25577103/183735124"
+ },
+ {
+ "id": "vanowen15840",
+ "address": "15840 Vanowen St",
+ "city": "Lake Balboa",
+ "zip": "91406",
+ "type": "Multifamily",
+ "price": 970000,
+ "units": 5,
+ "sqft": 3349,
+ "cap_rate": 5.25,
+ "year_built": 1952,
+ "rent_control": "Pre-1978 -> LA RSO",
+ "status": "Under Contract",
+ "upside_note": "5 units, new roof 2022, copper plumbing, tremendous upside — BUT already in escrow (likely unavailable)",
+ "source": "https://www.loopnet.com/Listing/15840-Vanowen-St-Lake-Balboa-CA/35415601/"
+ },
+ {
+ "id": "canby7454",
+ "address": "7454 Canby Ave",
+ "city": "Reseda",
+ "zip": "91335",
+ "type": "Multifamily",
+ "price": 1749000,
+ "units": 9,
+ "sqft": 6784,
+ "cap_rate": null,
+ "year_built": 1962,
+ "rent_control": "Pre-1978 -> LA RSO",
+ "status": "Active Under Contract",
+ "upside_note": "9 units at $194k/unit, diverse mix — but in escrow; back-up only",
+ "source": "https://www.remax.com/ca/reseda/home-details/7454-canby-ave-reseda-ca-91335/13235972936323110093/M00000093/SR26009655"
+ },
+ {
+ "id": "correnti12600",
+ "address": "12600 Correnti St",
+ "city": "Pacoima",
+ "zip": "91331",
+ "type": "Multifamily",
+ "price": 3300000,
+ "units": 14,
+ "sqft": 5334,
+ "cap_rate": 7.5,
+ "year_built": null,
+ "rent_control": "Renovated; verify RSO",
+ "status": "Active (OUT OF BUDGET — context)",
+ "upside_note": "ASSUMABLE $2.5M loan at 3.9% fixed thru 09/2027 -> only ~25% (~$825k) down but 12.2% cash-on-cash on current; plans to add 20 units -> proforma 13.9% cap. Exceptional economics but down payment EXCEEDS $400k.",
+ "source": "https://www.compass.com/homedetails/12600-Correnti-St-Pacoima-CA-91331/27H0FQ_pid/"
+ },
+ {
+ "id": "burbank10701",
+ "address": "10701 Burbank Blvd",
+ "city": "North Hollywood",
+ "zip": "91601",
+ "type": "Retail/NNN",
+ "price": 2799000,
+ "units": 1,
+ "sqft": 1802,
+ "cap_rate": 7.3,
+ "year_built": 1951,
+ "rent_control": "Commercial NNN — n/a",
+ "status": "Active (OUT OF BUDGET — context)",
+ "upside_note": "Single-tenant NNN cannabis dispensary, $204k NOI, 10-yr lease 2% bumps, fully passive. High cap but cannabis-tenant risk + needs ~$700k down.",
+ "source": "https://www.jayrubin-re.com/file/view-file/580"
+ },
+ {
+ "id": "canoga6020",
+ "address": "6020 Canoga Ave",
+ "city": "Woodland Hills",
+ "zip": "91367",
+ "type": "Retail/NNN",
+ "price": 5500000,
+ "units": 2,
+ "sqft": 4896,
+ "cap_rate": 6.35,
+ "year_built": null,
+ "rent_control": "Commercial NNN — n/a",
+ "status": "Active (OUT OF BUDGET — context)",
+ "upside_note": "2-tenant NNN (sushi + credit union) in Warner Center across from future Rams HQ; 18.2yr avg occupancy; trophy passive asset but far above budget.",
+ "source": "https://www.brandonmichaelsgroup.com/6020canogaave"
+ },
+ {
+ "id": "crx2560155",
+ "address": "6852 CLAIRE AVE",
+ "city": "RESEDA",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1499000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2560155/california-6852-claire-ave-reseda-ca-91335-3840"
+ },
+ {
+ "id": "crx2448930",
+ "address": "17852 Saticoy Street",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1749000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": 5.12,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.12% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2448930/california-17852-saticoy-street"
+ },
+ {
+ "id": "crx2455873",
+ "address": "18238 Hartland Street",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1699000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2455873/california-18238-hartland-street"
+ },
+ {
+ "id": "crx2592616",
+ "address": "6900 Corbin Avenue",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1595000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2592616/california-6900-corbin-avenue"
+ },
+ {
+ "id": "crx2453716",
+ "address": "8045 Darby",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1399000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2453716/california-8045-darby"
+ },
+ {
+ "id": "crx2442308",
+ "address": "18216 Hartland Street",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1399000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2442308/california-18216-hartland-street"
+ },
+ {
+ "id": "crx2412907",
+ "address": "5887 Whitnall",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1489000,
+ "units": 9,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2412907/california-5887-whitnall"
+ },
+ {
+ "id": "crx2414372",
+ "address": "6651 Beck",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1550000,
+ "units": 6,
+ "sqft": null,
+ "cap_rate": 7,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 7% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2414372/california-6651-beck"
+ },
+ {
+ "id": "crx2352672",
+ "address": "6820 Ben Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1675000,
+ "units": 8,
+ "sqft": null,
+ "cap_rate": 6.28,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 6.28% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2352672/california-6820-ben-avenue"
+ },
+ {
+ "id": "crx2413973",
+ "address": "5658 Willowcrest Ave",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 998000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413973/california-5658-willowcrest-ave"
+ },
+ {
+ "id": "crx2413999",
+ "address": "6905 Agnes",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1599000,
+ "units": 5,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413999/california-6905-agnes"
+ },
+ {
+ "id": "crx2414120",
+ "address": "6153 Clybourn Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1550000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2414120/california-6153-clybourn-avenue"
+ },
+ {
+ "id": "crx2412240",
+ "address": "5241 Cahuenga Boulevard",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1200000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2412240/california-5241-cahuenga-boulevard"
+ },
+ {
+ "id": "crx2413606",
+ "address": "5431 Cartwright",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1125000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413606/california-5431-cartwright"
+ },
+ {
+ "id": "crx2489729",
+ "address": "5629 Cleon",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1350000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": 5.33,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.33% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2489729/california-5629-cleon-ave"
+ },
+ {
+ "id": "crx2455604",
+ "address": "11849 Hart St",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1195000,
+ "units": 5,
+ "sqft": null,
+ "cap_rate": 5.57,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.57% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2455604/california-11849-hart-st"
+ },
+ {
+ "id": "crx2586908",
+ "address": "6924 Gentry",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1099000,
+ "units": 5,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2586908/california-6924-gentry"
+ },
+ {
+ "id": "crx2417808",
+ "address": "6401 Denny Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1750000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2417808/california-6401-denny-avenue"
+ },
+ {
+ "id": "crx2569960",
+ "address": "6441 Satsuma Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1750000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": 5.9,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.9% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2569960/california-6441-satsuma-avenue"
+ },
+ {
+ "id": "crx2516882",
+ "address": "6624 Farmdale Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1199000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2516882/california-6624-farmdale-avenue"
+ },
+ {
+ "id": "crx2516587",
+ "address": "6305 Carpenter",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1599000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2516587/california-6305-carpenter"
+ },
+ {
+ "id": "crx2563662",
+ "address": "11234 Hatteras",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1250000,
+ "units": 5,
+ "sqft": null,
+ "cap_rate": 3.67,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 3.67% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2563662/california-11234-hatteras"
+ },
+ {
+ "id": "crx2413947",
+ "address": "14722 Strathern",
+ "city": "Panorama City",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1145000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413947/california-14722-strathern"
+ },
+ {
+ "id": "crx2404653",
+ "address": "8106 Bevis Avenue",
+ "city": "Panorama City",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1300000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2404653/california-8106-bevis-avenue"
+ },
+ {
+ "id": "crx2558648",
+ "address": "14831 Nordhoff Street",
+ "city": "Panorama City",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1750000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2558648/california-14831-nordhoff-street"
+ },
+ {
+ "id": "crx2566665",
+ "address": "14320 Osborne",
+ "city": "Panorama City",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1080000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2566665/california-14320-osborne"
+ },
+ {
+ "id": "crx2473428",
+ "address": "14918 Wyandotte",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1550000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2473428/california-14918-wyandotte-street"
+ },
+ {
+ "id": "crx2488780",
+ "address": "16057 Knapp",
+ "city": "North Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1315000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2488780/california-16057-knapp"
+ },
+ {
+ "id": "crx2407231",
+ "address": "4617 Tilden Avenue",
+ "city": "Sherman Oaks",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1229000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2407231/california-4617-tilden-avenue"
+ },
+ {
+ "id": "crx2516979",
+ "address": "5759 Hazeltine",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 928000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2516979/california-5759-hazeltine"
+ },
+ {
+ "id": "crx2141640",
+ "address": "6402 Graves Ave",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1069000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2141640/california-6402-graves-ave-van-nuys-ca-91406"
+ },
+ {
+ "id": "crx2413442",
+ "address": "6648 Gaviota Avenue",
+ "city": "Lake Balboa",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1169000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413442/california-6648-gaviota-avenue"
+ },
+ {
+ "id": "crx2414348",
+ "address": "16122 San Fernando Mission Boulevard",
+ "city": "Granada Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1298000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": 7,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 7% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2414348/california-16122-san-fernando-mission-boulevard"
+ },
+ {
+ "id": "crx2413131",
+ "address": "15801-15803 Chatsworth",
+ "city": "Granada Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1149000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": 6.6,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 6.6% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413131/california-15801-chatsworth"
+ },
+ {
+ "id": "crx2568125",
+ "address": "10527 Danube Avenue",
+ "city": "Granada Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1250000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2568125/california-10527-danube-avenue"
+ },
+ {
+ "id": "crx2147226",
+ "address": "7214 Sepulveda Blvd",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Retail",
+ "price": 928000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": 3.74,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 3.74% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2147226/california-liquid-zoo"
+ },
+ {
+ "id": "crx2159323",
+ "address": "14540 Sylvan Street",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Retail",
+ "price": 895000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2159323/california-van-nuys-office-building"
+ },
+ {
+ "id": "crx1715584",
+ "address": "Call Broker For Details!",
+ "city": "Northridge",
+ "zip": "",
+ "type": "Retail",
+ "price": 999950,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/1715584/california-authentic-greek-5-star-restaurant"
+ }
]
-}
+}
\ No newline at end of file
diff --git a/data/qwen-cache.json b/data/qwen-cache.json
index 0a1b88d..a2914e5 100644
--- a/data/qwen-cache.json
+++ b/data/qwen-cache.json
@@ -473,5 +473,725 @@
"recommendation": "Watch"
},
"qwenScore": 72
+ },
+ "crx2560155": {
+ "key": "8d272140ff92",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged investor to acquire a single-unit asset in a growing market, though the lack of financials and cap rate disclosure introduces uncertainty. With a $400k budget, the investor would need to adjust terms or seek additional financing to meet the required down payment and closing costs.",
+ "risks": [
+ "No financials or cap rate disclosed, making valuation and return estimation speculative",
+ "Rent control status needs verification, which could impact long-term rental income",
+ "Insufficient budget to meet computed down payment and closing costs without renegotiation or alternative financing"
+ ],
+ "upside": [
+ "Potential for value-add through renovation or repositioning in a competitive market",
+ "Opportunity to secure a property in a desirable location with future appreciation potential",
+ "Possibility of leveraging additional capital for higher returns if terms are adjusted"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50
+ },
+ "crx2448930": {
+ "key": "d7f18372717c",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda offers an entry point into the San Fernando Valley market with a verified cap rate of 5.12%, suggesting potential for stable cash flow. However, the required down payment exceeds the investor's budget, and the computed cash-on-cash return is negative, indicating a need for careful evaluation of financing and value-add opportunities.",
+ "risks": [
+ "Down payment requirement exceeds budget by $80,975",
+ "Negative cash-on-cash return suggests poor initial returns",
+ "Need to verify rent control status and financials before proceeding"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rental rate increases",
+ "Strategic location in growing Reseda market",
+ "Opportunity to leverage additional capital for improved returns"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50
+ },
+ "crx2455873": {
+ "key": "fbc0c6f98d7f",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged investor seeking value in a growing submarket, though the asking price exceeds the $400k down payment budget, requiring additional capital or renegotiation. Further due diligence on cap rate, rent roll, and financials is essential before proceeding.",
+ "risks": [
+ "Insufficient down payment to meet computed cash requirement of $467,225",
+ "No cap rate or financials disclosed, increasing uncertainty",
+ "Rent control status unknown, which could impact long-term rental income and property value"
+ ],
+ "upside": [
+ "Potential for value-add through property management or unit upgrades",
+ "Location in Reseda offers growth potential and demand for multifamily housing",
+ "Opportunity to acquire a 3-unit property at a potentially attractive price if financials justify"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2592616": {
+ "key": "05ba9d657285",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged buyer to enter the San Fernando Valley market, though the required down payment exceeds the available budget. Further due diligence on cap rate, rent roll, and rent control status is essential before proceeding.",
+ "risks": [
+ "Insufficient down payment to meet computed requirement of $438,625",
+ "No cap rate or financials disclosed, increasing uncertainty",
+ "Rent control status needs verification, which could impact long-term rental income and value"
+ ],
+ "upside": [
+ "Potential for value-add through property management or unit upgrades",
+ "Strategic location in growing Reseda submarket",
+ "Opportunity to acquire a multifamily asset with leverage if financing can be adjusted"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2453716": {
+ "key": "26631702ba39",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the buyer can enter the market with a manageable cash outlay, potentially capturing value in a growing submarket. Further due diligence is needed to confirm financials, rent control status, and cap rate to fully assess the investment potential.",
+ "risks": [
+ "Lack of disclosed cap rate and financials increases uncertainty about the property's performance and potential returns.",
+ "Rent control status in Reseda could limit rental income growth and affect long-term profitability.",
+ "No unit or square footage data available, making it difficult to assess the property's physical condition and marketability."
+ ],
+ "upside": [
+ "Leverage available with a 25% down payment allows for a significant purchase with a relatively low initial outlay.",
+ "Reseda is a growing area within the San Fernando Valley, offering potential for appreciation and rental demand."
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2442308": {
+ "key": "5999402d3910",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda offers an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, potentially capturing long-term appreciation and rental income growth. The location in Reseda, a growing area within the Valley, may provide stability and future value enhancement.",
+ "risks": [
+ "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of unit and square footage details makes it difficult to assess property condition and efficiency"
+ ],
+ "upside": [
+ "Potential for appreciation in a growing submarket like Reseda",
+ "Ability to leverage a relatively small down payment for a larger asset",
+ "Opportunity to fill in missing data and potentially reposition the property for higher returns"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2412907": {
+ "key": "8a09ef9833c5",
+ "qwen": {
+ "thesis": "This 9-unit multifamily property in North Hollywood presents an opportunity for a leveraged buyer with a $400k budget, assuming the cap rate is attractive and the property is in good condition. However, the required down payment exceeds the available budget, and critical financials are not disclosed, requiring further due diligence.",
+ "risks": [
+ "Insufficient down payment to meet the computed $409,475 requirement",
+ "No cap rate or financials disclosed, increasing uncertainty",
+ "Potential rent control implications affecting long-term cash flow"
+ ],
+ "upside": [
+ "Strategic location in North Hollywood with strong demand for multifamily housing",
+ "Potential for value-add through renovations or rent increases",
+ "Opportunity to acquire a 9-unit asset with room for operational scaling"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2414372": {
+ "key": "346b23072ba0",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood offers an attractive cap rate of 7% and is located in a high-demand submarket. While the computed cash needed exceeds the $400k budget, the property presents value with potential for rent growth and long-term appreciation in a strong rental market.",
+ "risks": [
+ "Insufficient down payment to meet computed cash requirement",
+ "Unverified rent control status may limit rent increases",
+ "Broker cap rate is unverified, requiring further due diligence on financials and rent roll"
+ ],
+ "upside": [
+ "Strong cap rate suggests potential for immediate cash flow",
+ "North Hollywood is a growing market with upward pressure on rents",
+ "Opportunity to negotiate terms or secure financing with lower down payment"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2352672": {
+ "key": "e43ceef6221f",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood offers a compelling opportunity with a verified cap rate of 6.28%, suggesting potential for stable cash flow. However, the required down payment and closing costs exceed the investor's $400,000 budget, necessitating careful evaluation of financing options and risk mitigation strategies.",
+ "risks": [
+ "Insufficient down payment to meet the computed $460,625 requirement without additional financing or cost reduction",
+ "Unverified rent control status may impact long-term rental income and tenant retention",
+ "Low cash-on-cash return (1.61%) and DSCR (1.08) indicate tight margins and limited buffer for unexpected expenses"
+ ],
+ "upside": [
+ "Verified cap rate suggests potential for value-add through operational improvements or repositioning",
+ "North Hollywood's strong multifamily market may support rental growth and property appreciation",
+ "Opportunity to negotiate price or closing costs to align with budget constraints"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2413973": {
+ "key": "48bb3928bee2",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the required cash is within budget, allowing for potential cash-on-cash returns once financials are verified. The property's location in a desirable area may support rental growth and long-term appreciation.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and ROI estimation uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Year built and square footage are unknown, which may affect property condition and renovation costs"
+ ],
+ "upside": [
+ "Strategic location in North Hollywood may allow for rent increases or value appreciation",
+ "Potential for value-add through renovations or repositioning",
+ "Leverage available to amplify returns if financials prove favorable"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2413999": {
+ "key": "63d639455e5d",
+ "qwen": {
+ "thesis": "This 5-unit multifamily property in North Hollywood presents an opportunity for value-add investment, assuming the undisclosed cap rate is competitive and the property is in need of renovation. With a $400,000 budget, the investor could potentially secure a favorable deal with a lower down payment or negotiate terms to stay within budget.",
+ "risks": [
+ "Cap rate is not disclosed, making it difficult to assess potential returns",
+ "Rent control status needs verification, which could impact rental income and long-term profitability",
+ "Financials and rent roll are not provided, increasing uncertainty around cash flow and property condition"
+ ],
+ "upside": [
+ "Potential for value-add through renovations or repositioning",
+ "Strategic location in North Hollywood, a growing submarket with strong demand for multifamily housing",
+ "Opportunity to leverage limited capital for a larger asset with scalable returns"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2414120": {
+ "key": "aed7485fe87d",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged buyer to acquire a 4-unit asset in a high-demand submarket. While the asking price exceeds the $400k budget for a 25% down purchase, the property's location and potential for value-add improvements could justify a strategic acquisition with careful financing and due diligence.",
+ "risks": [
+ "Insufficient financial data (cap rate, NOI, rent roll not disclosed)",
+ "Potential rent control restrictions impacting rental income",
+ "Higher-than-expected closing costs may further strain the $400k budget"
+ ],
+ "upside": [
+ "Strong demand in North Hollywood for multifamily housing",
+ "Potential for rental rate increases or unit upgrades",
+ "Opportunity to acquire a property below market cap rate if financials are favorable upon due diligence"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2412240": {
+ "key": "984f32926070",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a $400,000 down payment, potentially acquiring a value-add asset in a high-demand submarket. With the ability to finance the remaining $800,000 at 6.75%, the investor could position the property for rental growth and long-term appreciation.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of property details (year built, square footage) limits due diligence and renovation planning"
+ ],
+ "upside": [
+ "North Hollywood is a growing area with strong employment and population trends",
+ "Potential for value-add through unit upgrades or rent increases",
+ "Leverage available to amplify returns if financials and cap rate are favorable"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2413606": {
+ "key": "02a50f7c4a00",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a $400k budget, potentially securing a property in a high-demand submarket. With a 25% down payment, the investor can control the asset with minimal upfront capital, allowing for future value appreciation and potential rental income growth.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+ "Rent control status needs verification, which could impact long-term rental income potential",
+ "Property age and square footage unknown, which may affect maintenance costs and desirability"
+ ],
+ "upside": [
+ "Potential for value-add through renovations or repositioning",
+ "Strong demand in North Hollywood for multifamily units",
+ "Leverage available to increase returns if cash flow is strong"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2489729": {
+ "key": "68af5741bcd7",
+ "qwen": {
+ "thesis": "This single-unit multifamily property in North Hollywood offers an entry point into the multifamily market with a verified cap rate of 5.33%, though the low cash-on-cash return and DSCR below 1.0 indicate potential financial strain. The property may be suitable for a buyer looking to build a portfolio or test the market with a leveraged purchase.",
+ "risks": [
+ "Low cash-on-cash return (-1.85%) indicates poor immediate profitability",
+ "DSCR of 0.91 suggests potential cash flow shortfall",
+ "Lack of verified rent roll and financials increases uncertainty"
+ ],
+ "upside": [
+ "Potential for rent increases if rent control is not in place",
+ "Opportunity to acquire a property in a strong submarket (North Hollywood)",
+ "Leverage available to maximize exposure with limited capital"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50
+ },
+ "crx2455604": {
+ "key": "267eb074349e",
+ "qwen": {
+ "thesis": "This 5-unit multifamily property in North Hollywood offers an entry point into a competitive market with a verified cap rate of 5.57%, suggesting potential for stable cash flow. With a $400k budget covering down payment and closing costs, the deal is leveraged but requires careful evaluation of financials and rent control status before proceeding.",
+ "risks": [
+ "Rent control may limit rental growth potential",
+ "Financials and rent roll need verification before final decision",
+ "Low cash-on-cash return (-0.97%) and DSCR (0.95) indicate high leverage and potential cash flow stress"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or tenant retention",
+ "Strategic location in North Hollywood with strong demand for multifamily housing",
+ "Opportunity to secure a property at a verified cap rate in a growing market"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2586908": {
+ "key": "28370a8f21f8",
+ "qwen": {
+ "thesis": "This 5-unit multifamily property in North Hollywood presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the investor can secure the property with significant equity and potential for cash flow growth, assuming favorable rent roll and financials.",
+ "risks": [
+ "Cap rate and NOI are not disclosed, increasing uncertainty about profitability",
+ "Rent control status needs verification, which could impact long-term rental income",
+ "Year built and square footage are unknown, potentially affecting property value and maintenance costs"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rental rate increases",
+ "Strong demand in North Hollywood for multifamily housing",
+ "Leverage available to maximize returns with a relatively low down payment"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2417808": {
+ "key": "ec71e63e7499",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged investor seeking value in a high-demand submarket. With $400,000 allocated for down payment and closing costs, the investor may need to negotiate terms or seek alternative financing to bridge the gap between the required $481,250 and available capital.",
+ "risks": [
+ "Lack of disclosed cap rate and financials increases uncertainty about the property's performance",
+ "Rent control status needs verification, which could impact long-term rental income and tenant stability",
+ "Insufficient information on unit size, year built, and current rent roll may obscure potential risks or opportunities"
+ ],
+ "upside": [
+ "North Hollywood is a growing area with strong demand for multifamily housing",
+ "Potential for value-add through renovations or repositioning if the property is undervalued",
+ "Opportunity to secure a property in a competitive market with a strategic down payment and closing cost budget"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2569960": {
+ "key": "ca69a6ff7734",
+ "qwen": {
+ "thesis": "This 4-unit multifamily property in North Hollywood offers an attractive entry point with a verified 5.9% cap rate, suggesting potential for stable cash flow. However, the required down payment and closing costs exceed the $400k budget, necessitating careful evaluation of financing options and potential value-add opportunities.",
+ "risks": [
+ "Insufficient down payment to meet the computed $481,250 requirement without additional funding or negotiation",
+ "Lack of verified rent roll and financials, which could impact NOI assumptions",
+ "Rent control status may limit rental growth and affect long-term profitability"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or operational efficiencies",
+ "Strategic repositioning could increase rental rates and NOI",
+ "Strong location in North Hollywood with demand for multifamily housing"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2516882": {
+ "key": "c6b4f1484351",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a $400k budget, potentially securing a property in a high-demand submarket. With a 25% down payment, the investor can structure a loan that fits within budget, though due diligence on financials, rent control status, and unit specifics is critical before proceeding.",
+ "risks": [
+ "No cap rate or NOI disclosed, making valuation and return estimation speculative",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of property details (year built, square footage) may indicate incomplete or outdated data"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+ "North Hollywood is a growing area with strong demand for multifamily housing",
+ "Leverage allows for entry with a relatively low down payment compared to full purchase"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2516587": {
+ "key": "15306521ad52",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a modest down payment, though the required cash investment exceeds the available budget. Further due diligence on financials, rent control status, and property condition is essential before proceeding.",
+ "risks": [
+ "Insufficient cash to meet the computed down payment and closing costs",
+ "Lack of disclosed cap rate and financials increases uncertainty",
+ "Rent control status may impact long-term rental income and property value"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases",
+ "Strategic location in North Hollywood may offer appreciation potential",
+ "Multifamily properties can provide stable cash flow with proper management"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50
+ },
+ "crx2563662": {
+ "key": "44113cbc6eb8",
+ "qwen": {
+ "thesis": "This 5-unit multifamily property in North Hollywood offers an entry point into a high-demand market with a verified cap rate of 3.67%, though the negative cash-on-cash return and low DSCR indicate significant financial risk. With $400k available for down and closing, the purchase is feasible but requires careful evaluation of rent control status, financials, and market conditions.",
+ "risks": [
+ "Negative cash-on-cash return (-7.88%) indicates potential cash outflow",
+ "Low DSCR (0.63) suggests high leverage and potential default risk",
+ "Rent control status and in-place financials need verification before proceeding"
+ ],
+ "upside": [
+ "Potential for value-add through rent increases or unit improvements",
+ "Strategic location in North Hollywood with strong long-term appreciation potential",
+ "Opportunity to acquire a multifamily asset in a competitive market with leverage"
+ ],
+ "opportunity_score": 45,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 45
+ },
+ "crx2413947": {
+ "key": "3c7154b9341c",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Panorama City presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a $400k budget. With a 25% down payment, the investor can secure a loan with a 6.75% interest rate over 30 years, leaving room for closing costs and potential value-add opportunities.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and income potential uncertain",
+ "Rent control status needs verification, which could impact rental income and long-term cash flow",
+ "Year built and square footage are unknown, which may affect property condition and renovation costs"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+ "Strategic location in Panorama City may offer appreciation potential",
+ "Leverage available to increase returns if NOI is strong"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2404653": {
+ "key": "d72c4a618550",
+ "qwen": {
+ "thesis": "This 3-unit multifamily property in Panorama City presents an opportunity for a leveraged investor to acquire a rental asset in a growing submarket with potential for long-term appreciation and cash flow. With a $400k budget covering down payment and closing costs, the investor can secure a position in a desirable area with strong demand for rental housing.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Year built and square footage not disclosed, limiting insight into property condition and value"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+ "Leverage available to maximize returns with a relatively low down payment",
+ "Panorama City's proximity to major employment centers and transit options may support strong tenant retention and demand"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2558648": {
+ "key": "e8ad94e68725",
+ "qwen": {
+ "thesis": "This multifamily property in Panorama City presents an opportunity for a value-add investor seeking to leverage a $400,000 budget for a down payment and closing costs. With the San Fernando Valley's strong rental demand and potential for rent growth, the property could benefit from renovations and improved management to increase NOI and cap rate.",
+ "risks": [
+ "Cap rate is not disclosed, making it difficult to assess current returns",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Financials and rent roll are not provided, increasing due diligence risk"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades and operational improvements",
+ "Strong demand in the San Fernando Valley multifamily market",
+ "Opportunity to acquire a property below market cap rate if financials justify it"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2566665": {
+ "key": "25dd2145e662",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Panorama City presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the cash needed is within budget, allowing for potential value-add through rent increases, unit upgrades, or conversion to a larger multifamily asset if market conditions allow.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and cash flow projections speculative",
+ "Rent control status needs verification, which could limit rental income growth",
+ "Lack of property details (year built, square footage) may indicate potential hidden costs or maintenance issues"
+ ],
+ "upside": [
+ "Potential for rent growth in a growing area like Panorama City",
+ "Opportunity to add value through renovations or repositioning",
+ "Leverage available to amplify returns if cash flow and NOI are strong"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2473428": {
+ "key": "7aef34ae321a",
+ "qwen": {
+ "thesis": "This multifamily property in Van Nuys presents a potential opportunity for a leveraged buyer with a $400k budget, though the required down payment and closing costs exceed the available funds. Further due diligence on the property's financials, cap rate, and rent control status is essential before considering an offer.",
+ "risks": [
+ "Insufficient funds to meet the required down payment and closing costs without additional financing or budget adjustments",
+ "Lack of disclosed cap rate and financial details increases uncertainty about the property's performance",
+ "Rent control status could impact long-term rental income and property value"
+ ],
+ "upside": [
+ "Strategic location in Van Nuys, a growing area within the San Fernando Valley",
+ "Potential for value-add through renovations or improved management",
+ "Multifamily sector remains resilient in the current market"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2488780": {
+ "key": "393ad7fbac1e",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hills presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a $400k down payment. While key financials are not disclosed, the property's location in a desirable submarket may support rental income growth and long-term appreciation.",
+ "risks": [
+ "Lack of disclosed cap rate, NOI, and rent roll data increases uncertainty about the property's current performance and potential returns.",
+ "Rent control status needs verification, which could impact rental income growth and tenant retention.",
+ "Year built and square footage are not disclosed, making it difficult to assess the property's condition and potential for value-add improvements."
+ ],
+ "upside": [
+ "North Hills is a stable and growing area within the San Fernando Valley, offering strong demand for multifamily housing.",
+ "With a 25% down payment, the buyer can leverage the remaining $900k in financing to acquire the property within budget, potentially allowing for value-add strategies if the property is undervalued."
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55
+ },
+ "crx2407231": {
+ "key": "8246e51072b2",
+ "qwen": {
+ "thesis": "This multifamily property in Sherman Oaks presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the cash needed is within budget, allowing for potential appreciation and rental income in a desirable area of the San Fernando Valley.",
+ "risks": [
+ "Cap rate is not disclosed, making it difficult to assess current returns",
+ "Rent control status needs verification, which could impact long-term rental income",
+ "Financials and rent roll are not provided, increasing due diligence risk"
+ ],
+ "upside": [
+ "Potential for value-add through property management or unit upgrades",
+ "Strong demand in Sherman Oaks for multifamily housing",
+ "Leverage available to increase returns if NOI is strong"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2516979": {
+ "key": "348773ba59f9",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Van Nuys presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a $400k budget, offering potential for cash flow and long-term appreciation. With a 25% down payment, the investor can secure the property with a manageable cash outlay and benefit from the area's strong demand for rental housing.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and return estimation uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of property details (year built, square footage) may indicate potential hidden issues or lower quality"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases",
+ "Strategic location in Van Nuys with strong rental market demand",
+ "Leverage available to maximize returns with a relatively low down payment"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2141640": {
+ "key": "1b65435e5c47",
+ "qwen": {
+ "thesis": "This 4-unit multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing costs. With a 25% down payment, the required cash is within budget, allowing for potential acquisition and value-add through renovations or rent increases, assuming favorable market conditions and accurate financials.",
+ "risks": [
+ "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+ "Rent control status needs verification, which could limit rental income growth",
+ "Year built and square footage not provided, making it difficult to assess property condition and potential for value-add"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or operational improvements",
+ "Strategic location in Van Nuys, a stable and growing submarket within the San Fernando Valley",
+ "Leverage available to amplify returns if financials and cap rate prove favorable"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2413442": {
+ "key": "0c272d79bfea",
+ "qwen": {
+ "thesis": "This multifamily property in Lake Balboa presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the required cash is within budget, allowing for potential appreciation and rental income generation in a desirable San Fernando Valley submarket.",
+ "risks": [
+ "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+ "Rent control status needs verification, which could impact long-term rental income and tenant stability",
+ "Year built and square footage are unknown, potentially affecting property value and renovation costs"
+ ],
+ "upside": [
+ "Potential for value-add through property improvements or rent increases if rent control is not in place",
+ "Strategic location in Lake Balboa may offer strong demand and appreciation potential",
+ "Leverage available to amplify returns if financials prove favorable"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2414348": {
+ "key": "0cc2d17db17b",
+ "qwen": {
+ "thesis": "This multifamily property in Granada Hills offers an attractive entry point for a leveraged buyer with a $400k budget, targeting a 7% cap rate and potential for cash-on-cash returns. With a computed DSCR of 1.2, the property may be viable if stabilized, but further due diligence is required to confirm financials and rent control status.",
+ "risks": [
+ "Uncertain rent control status may limit rental growth potential",
+ "Missing unit count and square footage data could affect value and operational efficiency",
+ "Broker cap rate is unverified, requiring confirmation of actual in-place NOI"
+ ],
+ "upside": [
+ "Potential for value-add through unit improvements or rent increases if rent control is not in place",
+ "Leverage available to maximize returns with a 25% down payment",
+ "Strategic location in Granada Hills with strong demand for multifamily housing"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2413131": {
+ "key": "60bbe56673ea",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Granada Hills offers an attractive entry point for a leveraged buyer with a $400k budget, providing a 6.6% cap rate and potential for value-add through rent increases or unit improvements. The computed cash-on-cash return of 2.77% and DSCR of 1.13 suggest moderate risk, but the property's location and potential for rent growth could enhance returns over time.",
+ "risks": [
+ "Uncertain rent control status could limit rental income growth",
+ "Lack of verified financials and rent roll data increases due diligence risk",
+ "Low DSCR indicates potential cash flow stress under adverse conditions"
+ ],
+ "upside": [
+ "Potential for rent increases in a growing market like Granada Hills",
+ "Opportunity to add value through unit upgrades or management improvements",
+ "Leverage available to increase returns with a lower down payment"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
+ },
+ "crx2568125": {
+ "key": "5b3e54b2ffc9",
+ "qwen": {
+ "thesis": "This multifamily property in Granada Hills presents an opportunity for a leveraged buyer with $400,000 available for down payment and closing costs. With a 25% down payment, the investor can secure a loan with a 6.75% interest rate over 30 years, staying within budget. The property’s location in a desirable San Fernando Valley neighborhood offers potential for stable rental income and long-term appreciation.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and return estimation speculative",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Property age and square footage unknown, which may affect maintenance costs and unit desirability"
+ ],
+ "upside": [
+ "Strategic location in Granada Hills with strong demand for multifamily housing",
+ "Potential for rent increases or property value appreciation in a growing area",
+ "Leverage available to amplify returns if financials and cap rate prove favorable"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx2147226": {
+ "key": "885a7888fe44",
+ "qwen": {
+ "thesis": "This retail property in Van Nuys offers an entry point into the San Fernando Valley retail market with a verified cap rate of 3.74%, though the negative cash-on-cash return and low DSCR indicate potential financial stress. The $400k budget allows for a leveraged purchase with 25% down, but due diligence on rent control, tenant stability, and financials is critical.",
+ "risks": [
+ "Negative cash-on-cash return (-7.63%) indicates potential cash outflow",
+ "Low DSCR (0.64) suggests high debt servicing risk",
+ "Uncertain rent control status may limit rental growth and tenant retention"
+ ],
+ "upside": [
+ "Potential for rent increases if rent control is not in place",
+ "Stable retail location in Van Nuys with long-term appreciation potential",
+ "Opportunity to acquire a verified cap rate asset with room for value-add improvements"
+ ],
+ "opportunity_score": 45,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 45
+ },
+ "crx2159323": {
+ "key": "d7dbf701ad39",
+ "qwen": {
+ "thesis": "This retail property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing, offering potential for long-term appreciation and rental income in a growing submarket. With a 25% down payment, the buyer can secure a loan with favorable terms, assuming the property's financials and cap rate justify the investment.",
+ "risks": [
+ "Cap rate and financials are not disclosed, increasing uncertainty about cash flow and return potential",
+ "Rent control status needs verification, which could impact rental income and tenant retention",
+ "Property age and square footage are unknown, potentially affecting maintenance costs and value"
+ ],
+ "upside": [
+ "Potential for value-add through tenant improvements or repositioning the retail space",
+ "Strategic location in Van Nuys may benefit from continued demand in retail and commercial sectors",
+ "Leverage available to maximize returns with a relatively low down payment"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65
+ },
+ "crx1715584": {
+ "key": "64d253eea620",
+ "qwen": {
+ "thesis": "This Northridge retail property presents an opportunity for a leveraged buyer with $400k available for down and closing, offering potential for long-term appreciation and income generation in a growing market. With a 25% down payment, the buyer can secure the property within budget, though due diligence on financials, rent roll, and cap rate is essential before proceeding.",
+ "risks": [
+ "No cap rate or NOI disclosed, limiting ability to assess income potential",
+ "Rent control status needs verification, which could impact rental rates and tenant stability",
+ "Property details (year built, sqft) are not disclosed, increasing uncertainty about condition and value"
+ ],
+ "upside": [
+ "Potential for value-add through tenant improvements or repositioning",
+ "Strategic location in Northridge may benefit from continued retail demand",
+ "Leverage available to maximize returns with a lower down payment"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60
}
}
\ No newline at end of file
diff --git a/data/ranked.json b/data/ranked.json
index 9132657..41ba64b 100644
--- a/data/ranked.json
+++ b/data/ranked.json
@@ -21,8 +21,57 @@
"amortYears": 30,
"closingPct": 2.5
},
- "generated": null,
+ "generated": "2026-06-21",
"ranked": [
+ {
+ "id": "crx2414348",
+ "address": "16122 San Fernando Mission Boulevard",
+ "city": "Granada Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1298000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": 7,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 7% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2414348/california-16122-san-fernando-mission-boulevard",
+ "finance": {
+ "down": 324500,
+ "closing": 32450,
+ "cashNeeded": 356950,
+ "loan": 973500,
+ "annualDebtService": 75769,
+ "noi": 90860,
+ "cashFlow": 15091,
+ "coc": 4.23,
+ "dscr": 1.2,
+ "affordable": true
+ },
+ "financeScore": 57,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This multifamily property in Granada Hills offers an attractive entry point for a leveraged buyer with a $400k budget, targeting a 7% cap rate and potential for cash-on-cash returns. With a computed DSCR of 1.2, the property may be viable if stabilized, but further due diligence is required to confirm financials and rent control status.",
+ "risks": [
+ "Uncertain rent control status may limit rental growth potential",
+ "Missing unit count and square footage data could affect value and operational efficiency",
+ "Broker cap rate is unverified, requiring confirmation of actual in-place NOI"
+ ],
+ "upside": [
+ "Potential for value-add through unit improvements or rent increases if rent control is not in place",
+ "Leverage available to maximize returns with a 25% down payment",
+ "Strategic location in Granada Hills with strong demand for multifamily housing"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 54,
+ "rank": 1
+ },
{
"id": "canby7304",
"address": "7302-7304 Canby Ave",
@@ -103,7 +152,7 @@
},
"qwenScore": 72,
"composite": 52,
- "rank": 1
+ "rank": 2
},
{
"id": "sepulveda10011",
@@ -151,7 +200,7 @@
},
"qwenScore": 72,
"composite": 51,
- "rank": 2
+ "rank": 3
},
{
"id": "foothill6851",
@@ -199,7 +248,7 @@
},
"qwenScore": 72,
"composite": 51,
- "rank": 3
+ "rank": 4
},
{
"id": "schoenborn17920",
@@ -283,7 +332,7 @@
},
"qwenScore": 65,
"composite": 49,
- "rank": 4
+ "rank": 5
},
{
"id": "tilden8843",
@@ -331,7 +380,7 @@
},
"qwenScore": 65,
"composite": 48,
- "rank": 5
+ "rank": 6
},
{
"id": "sanfernando10004",
@@ -379,7 +428,7 @@
},
"qwenScore": 65,
"composite": 48,
- "rank": 6
+ "rank": 7
},
{
"id": "sherman21627",
@@ -428,7 +477,7 @@
},
"qwenScore": 65,
"composite": 48,
- "rank": 7
+ "rank": 8
},
{
"id": "owensmouth7129",
@@ -476,243 +525,1417 @@
},
"qwenScore": 65,
"composite": 48,
- "rank": 8
+ "rank": 9
},
{
- "id": "correnti12600",
- "address": "12600 Correnti St",
- "city": "Pacoima",
- "zip": "91331",
+ "id": "crx2412240",
+ "address": "5241 Cahuenga Boulevard",
+ "city": "North Hollywood",
+ "zip": "",
"type": "Multifamily",
- "price": 3300000,
- "units": 14,
- "sqft": 5334,
- "cap_rate": 7.5,
+ "price": 1200000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
"year_built": null,
- "rent_control": "Renovated; verify RSO",
- "status": "Active (OUT OF BUDGET — context)",
- "upside_note": "ASSUMABLE $2.5M loan at 3.9% fixed thru 09/2027 -> only ~25% (~$825k) down but 12.2% cash-on-cash on current; plans to add 20 units -> proforma 13.9% cap. Exceptional economics but down payment EXCEEDS $400k.",
- "source": "https://www.compass.com/homedetails/12600-Correnti-St-Pacoima-CA-91331/27H0FQ_pid/",
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2412240/california-5241-cahuenga-boulevard",
"finance": {
- "down": 825000,
- "closing": 82500,
- "cashNeeded": 907500,
- "loan": 2475000,
- "annualDebtService": 192634,
- "noi": 247500,
- "cashFlow": 54866,
- "coc": 6.05,
- "dscr": 1.28,
- "affordable": false
+ "down": 300000,
+ "closing": 30000,
+ "cashNeeded": 330000,
+ "loan": 900000,
+ "annualDebtService": 70049,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
},
- "financeScore": 28,
- "financeConf": "high",
+ "financeScore": 38,
+ "financeConf": "low",
"qwen": {
- "thesis": "This multifamily property in Pacoima offers strong long-term value with a verified 7.5% cap rate and potential for significant upside through unit expansion. While the current cash-on-cash return is lower due to the high down payment requirement, the proforma cap rate of 13.9% and assumable loan terms present a compelling opportunity for a buyer with a $400k budget if alternative financing or value-add strategies can be implemented.",
+ "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a $400,000 down payment, potentially acquiring a value-add asset in a high-demand submarket. With the ability to finance the remaining $800,000 at 6.75%, the investor could position the property for rental growth and long-term appreciation.",
"risks": [
- "Down payment requirement exceeds budget, limiting immediate purchase feasibility",
- "Need to verify RSO status and rent control implications",
- "Proforma projections depend on successful unit expansion and market absorption"
+ "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of property details (year built, square footage) limits due diligence and renovation planning"
],
"upside": [
- "Assumable loan at 3.9% provides favorable financing terms",
- "Potential for 13.9% proforma cap rate with unit addition",
- "Strong location in growing San Fernando Valley market"
+ "North Hollywood is a growing area with strong employment and population trends",
+ "Potential for value-add through unit upgrades or rent increases",
+ "Leverage available to amplify returns if financials and cap rate are favorable"
],
"opportunity_score": 65,
"recommendation": "Watch"
},
"qwenScore": 65,
- "composite": 38,
- "rank": 9
+ "composite": 48,
+ "rank": 10
},
{
- "id": "amigo8357",
- "address": "8357 Amigo Ave",
- "city": "Northridge",
- "zip": "91324",
+ "id": "crx2413606",
+ "address": "5431 Cartwright",
+ "city": "North Hollywood",
+ "zip": "",
"type": "Multifamily",
- "price": 1249000,
- "units": 4,
- "sqft": 3816,
- "cap_rate": 5.63,
- "noi_actual": 70270,
- "gross_actual": 89460,
- "expenses": 19190,
- "verified": true,
- "rent_roll": [
- {
- "unit": 1,
- "type": "2bd/1ba",
- "rent": 1509
- },
- {
- "unit": 2,
- "type": "2bd/1ba",
- "rent": 2300
- },
- {
- "unit": 3,
- "type": "2bd/1ba",
- "rent": 1651
- },
- {
- "unit": 4,
- "type": "2bd/1ba",
- "rent": 2000
- }
- ],
- "year_built": 1960,
- "rent_control": "LAR3",
+ "price": 1125000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
"status": "Active",
- "upside_note": "VERIFIED (MLS): honest in-place cap ~5.63% = gross $89,460 - exp $19,190 = NOI $70,270 (the MLS 'NOI $88,310' field ignores expenses — unreliable). Stated expenses $19,190 look LOW (verify taxes/insurance/mgmt in DD). Price cut $1,350,000->$1,249,000 (motivated). Quad near CSUN.",
- "source": "https://www.compass.com/homedetails/8357-Amigo-Ave-Northridge-CA-91324/1IMLRO_pid/",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413606/california-5431-cartwright",
"finance": {
- "down": 312250,
- "closing": 31225,
- "cashNeeded": 343475,
- "loan": 936750,
- "annualDebtService": 72909,
- "noi": 70319,
- "cashFlow": -2590,
- "coc": -0.75,
- "dscr": 0.96,
+ "down": 281250,
+ "closing": 28125,
+ "cashNeeded": 309375,
+ "loan": 843750,
+ "annualDebtService": 65671,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
"affordable": true
},
- "financeScore": 13,
- "financeConf": "high",
+ "financeScore": 38,
+ "financeConf": "low",
"qwen": {
- "thesis": "This 4-unit multifamily property in Northridge offers an attractive entry point for a leveraged buyer with a $400k budget, given its verified cap rate of 5.63% and proximity to CSUN, which supports long-term rental demand. The price reduction and low down payment requirement make it a compelling opportunity for value-add strategies.",
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a $400k budget, potentially securing a property in a high-demand submarket. With a 25% down payment, the investor can control the asset with minimal upfront capital, allowing for future value appreciation and potential rental income growth.",
"risks": [
- "Low cash-on-cash return (-0.75%) indicates poor initial returns",
- "Potential underestimation of expenses (taxes, insurance, management) may impact NOI",
- "LAR3 rent control may limit rental growth potential"
+ "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+ "Rent control status needs verification, which could impact long-term rental income potential",
+ "Property age and square footage unknown, which may affect maintenance costs and desirability"
],
"upside": [
- "Proximity to CSUN provides stable and growing tenant base",
- "Price reduction suggests seller motivation and potential for negotiation",
- "Value-add opportunities through unit upgrades or management improvements"
+ "Potential for value-add through renovations or repositioning",
+ "Strong demand in North Hollywood for multifamily units",
+ "Leverage available to increase returns if cash flow is strong"
],
"opportunity_score": 65,
"recommendation": "Watch"
},
"qwenScore": 65,
- "composite": 36,
- "rank": 10
+ "composite": 48,
+ "rank": 11
},
{
- "id": "wilbur9014",
- "address": "9014 Wilbur Ave",
- "city": "Northridge",
- "zip": "91324",
+ "id": "crx2586908",
+ "address": "6924 Gentry",
+ "city": "North Hollywood",
+ "zip": "",
"type": "Multifamily",
- "price": 1700000,
- "units": 4,
- "sqft": 3211,
+ "price": 1099000,
+ "units": 5,
+ "sqft": null,
"cap_rate": null,
- "year_built": 1980,
- "rent_control": "Built 1980 -> NOT LA RSO; AB1482 only",
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
"status": "Active",
- "upside_note": "Cap not disclosed; 1980 build = no LA rent control (higher increases); remodeled + new-construction units; adjacent 2-unit also available",
- "source": "https://www.compass.com/homedetails/9014-Wilbur-Ave-Northridge-CA-91324/1KTV77_pid/",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2586908/california-6924-gentry",
"finance": {
- "down": 425000,
- "closing": 42500,
- "cashNeeded": 467500,
- "loan": 1275000,
- "annualDebtService": 99236,
+ "down": 274750,
+ "closing": 27475,
+ "cashNeeded": 302225,
+ "loan": 824250,
+ "annualDebtService": 64153,
"noi": null,
"cashFlow": null,
"coc": null,
"dscr": null,
- "affordable": false
+ "affordable": true
},
- "financeScore": 20,
+ "financeScore": 38,
"financeConf": "low",
"qwen": {
- "thesis": "This 4-unit multifamily property in Northridge offers an opportunity to purchase a remodeled and upgraded asset in a desirable area with no rent control restrictions, allowing for higher rental income potential. While the asking price exceeds the $400k budget for a 25% down purchase, the adjacent 2-unit property may provide a bundled acquisition opportunity that could enhance overall returns.",
+ "thesis": "This 5-unit multifamily property in North Hollywood presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the investor can secure the property with significant equity and potential for cash flow growth, assuming favorable rent roll and financials.",
"risks": [
- "Insufficient down payment for a 25% LTV purchase without additional financing or budget adjustments",
- "No disclosed cap rate limits ability to estimate returns and compare to market benchmarks",
- "Adjacent 2-unit property availability may complicate due diligence and increase complexity of the deal"
+ "Cap rate and NOI are not disclosed, increasing uncertainty about profitability",
+ "Rent control status needs verification, which could impact long-term rental income",
+ "Year built and square footage are unknown, potentially affecting property value and maintenance costs"
],
"upside": [
- "No rent control in Northridge (built 1980) allows for higher rent increases and greater NOI potential",
- "Remodeled and new-construction units may contribute to higher occupancy and rental rates",
- "Potential for bundled acquisition with adjacent 2-unit property may offer scale and diversification"
+ "Potential for value-add through unit upgrades or rental rate increases",
+ "Strong demand in North Hollywood for multifamily housing",
+ "Leverage available to maximize returns with a relatively low down payment"
],
"opportunity_score": 65,
"recommendation": "Watch"
},
"qwenScore": 65,
- "composite": 35,
- "rank": 11
+ "composite": 48,
+ "rank": 12
},
{
- "id": "hillhaven10139",
- "address": "10139 Hillhaven Ave",
- "city": "Tujunga",
- "zip": "91042",
+ "id": "crx2404653",
+ "address": "8106 Bevis Avenue",
+ "city": "Panorama City",
+ "zip": "",
"type": "Multifamily",
- "price": 1248888,
+ "price": 1300000,
"units": 3,
- "sqft": 3929,
- "cap_rate": 5.4,
- "year_built": 1949,
- "rent_control": "LAR3; pre-1978 RSO",
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
"status": "Active",
- "upside_note": "Broker cap 5.40%; FIXER triplex, value-add (remodel rear units to market) + expand 3->5 units / 2 ADUs (R3, 8,137sf lot). Priced for condition ($318/sf). On market 75 days.",
- "source": "https://www.compass.com/homedetails/10139-Hillhaven-Ave-Tujunga-CA-91042/1KFS1G_pid/",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2404653/california-8106-bevis-avenue",
"finance": {
- "down": 312222,
- "closing": 31222,
- "cashNeeded": 343444,
- "loan": 936666,
- "annualDebtService": 72902,
- "noi": 67440,
- "cashFlow": -5462,
- "coc": -1.59,
- "dscr": 0.93,
+ "down": 325000,
+ "closing": 32500,
+ "cashNeeded": 357500,
+ "loan": 975000,
+ "annualDebtService": 75886,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
"affordable": true
},
- "financeScore": 8,
- "financeConf": "high",
+ "financeScore": 38,
+ "financeConf": "low",
"qwen": {
- "thesis": "This fixer triplex in Tujunga offers a value-add opportunity with potential to significantly increase NOI through unit expansion and remodeling. The current cap rate of 5.4% and pricing for condition make it an attractive entry point for a buyer with $400k available for down and closing.",
+ "thesis": "This 3-unit multifamily property in Panorama City presents an opportunity for a leveraged investor to acquire a rental asset in a growing submarket with potential for long-term appreciation and cash flow. With a $400k budget covering down payment and closing costs, the investor can secure a position in a desirable area with strong demand for rental housing.",
"risks": [
- "Significant rehab costs required to bring units up to market standards",
- "Rent control restrictions may limit rental income growth",
- "Long-term vacancy risk due to property condition and location"
+ "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Year built and square footage not disclosed, limiting insight into property condition and value"
],
"upside": [
- "Potential to expand from 3 to 5 units or add 2 ADUs, increasing income streams",
- "Remodeling rear units could improve occupancy and rental rates",
- "Priced below replacement cost with room for value creation"
+ "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+ "Leverage available to maximize returns with a relatively low down payment",
+ "Panorama City's proximity to major employment centers and transit options may support strong tenant retention and demand"
],
"opportunity_score": 65,
"recommendation": "Watch"
},
"qwenScore": 65,
- "composite": 34,
- "rank": 12
+ "composite": 48,
+ "rank": 13
},
{
- "id": "burbank10701",
- "address": "10701 Burbank Blvd",
- "city": "North Hollywood",
- "zip": "91601",
- "type": "Retail/NNN",
- "price": 2799000,
- "units": 1,
- "sqft": 1802,
- "cap_rate": 7.3,
- "year_built": 1951,
- "rent_control": "Commercial NNN — n/a",
- "status": "Active (OUT OF BUDGET — context)",
- "upside_note": "Single-tenant NNN cannabis dispensary, $204k NOI, 10-yr lease 2% bumps, fully passive. High cap but cannabis-tenant risk + needs ~$700k down.",
- "source": "https://www.jayrubin-re.com/file/view-file/580",
+ "id": "crx2407231",
+ "address": "4617 Tilden Avenue",
+ "city": "Sherman Oaks",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1229000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2407231/california-4617-tilden-avenue",
"finance": {
- "down": 699750,
+ "down": 307250,
+ "closing": 30725,
+ "cashNeeded": 337975,
+ "loan": 921750,
+ "annualDebtService": 71741,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Sherman Oaks presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the cash needed is within budget, allowing for potential appreciation and rental income in a desirable area of the San Fernando Valley.",
+ "risks": [
+ "Cap rate is not disclosed, making it difficult to assess current returns",
+ "Rent control status needs verification, which could impact long-term rental income",
+ "Financials and rent roll are not provided, increasing due diligence risk"
+ ],
+ "upside": [
+ "Potential for value-add through property management or unit upgrades",
+ "Strong demand in Sherman Oaks for multifamily housing",
+ "Leverage available to increase returns if NOI is strong"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 48,
+ "rank": 14
+ },
+ {
+ "id": "crx2413131",
+ "address": "15801-15803 Chatsworth",
+ "city": "Granada Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1149000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": 6.6,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 6.6% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413131/california-15801-chatsworth",
+ "finance": {
+ "down": 287250,
+ "closing": 28725,
+ "cashNeeded": 315975,
+ "loan": 861750,
+ "annualDebtService": 67072,
+ "noi": 75834,
+ "cashFlow": 8762,
+ "coc": 2.77,
+ "dscr": 1.13,
+ "affordable": true
+ },
+ "financeScore": 49,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Granada Hills offers an attractive entry point for a leveraged buyer with a $400k budget, providing a 6.6% cap rate and potential for value-add through rent increases or unit improvements. The computed cash-on-cash return of 2.77% and DSCR of 1.13 suggest moderate risk, but the property's location and potential for rent growth could enhance returns over time.",
+ "risks": [
+ "Uncertain rent control status could limit rental income growth",
+ "Lack of verified financials and rent roll data increases due diligence risk",
+ "Low DSCR indicates potential cash flow stress under adverse conditions"
+ ],
+ "upside": [
+ "Potential for rent increases in a growing market like Granada Hills",
+ "Opportunity to add value through unit upgrades or management improvements",
+ "Leverage available to increase returns with a lower down payment"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 48,
+ "rank": 15
+ },
+ {
+ "id": "crx2568125",
+ "address": "10527 Danube Avenue",
+ "city": "Granada Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1250000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2568125/california-10527-danube-avenue",
+ "finance": {
+ "down": 312500,
+ "closing": 31250,
+ "cashNeeded": 343750,
+ "loan": 937500,
+ "annualDebtService": 72967,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Granada Hills presents an opportunity for a leveraged buyer with $400,000 available for down payment and closing costs. With a 25% down payment, the investor can secure a loan with a 6.75% interest rate over 30 years, staying within budget. The property’s location in a desirable San Fernando Valley neighborhood offers potential for stable rental income and long-term appreciation.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and return estimation speculative",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Property age and square footage unknown, which may affect maintenance costs and unit desirability"
+ ],
+ "upside": [
+ "Strategic location in Granada Hills with strong demand for multifamily housing",
+ "Potential for rent increases or property value appreciation in a growing area",
+ "Leverage available to amplify returns if financials and cap rate prove favorable"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 48,
+ "rank": 16
+ },
+ {
+ "id": "crx2159323",
+ "address": "14540 Sylvan Street",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Retail",
+ "price": 895000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2159323/california-van-nuys-office-building",
+ "finance": {
+ "down": 223750,
+ "closing": 22375,
+ "cashNeeded": 246125,
+ "loan": 671250,
+ "annualDebtService": 52245,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This retail property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing, offering potential for long-term appreciation and rental income in a growing submarket. With a 25% down payment, the buyer can secure a loan with favorable terms, assuming the property's financials and cap rate justify the investment.",
+ "risks": [
+ "Cap rate and financials are not disclosed, increasing uncertainty about cash flow and return potential",
+ "Rent control status needs verification, which could impact rental income and tenant retention",
+ "Property age and square footage are unknown, potentially affecting maintenance costs and value"
+ ],
+ "upside": [
+ "Potential for value-add through tenant improvements or repositioning the retail space",
+ "Strategic location in Van Nuys may benefit from continued demand in retail and commercial sectors",
+ "Leverage available to maximize returns with a relatively low down payment"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 48,
+ "rank": 17
+ },
+ {
+ "id": "crx2453716",
+ "address": "8045 Darby",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1399000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2453716/california-8045-darby",
+ "finance": {
+ "down": 349750,
+ "closing": 34975,
+ "cashNeeded": 384725,
+ "loan": 1049250,
+ "annualDebtService": 81665,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the buyer can enter the market with a manageable cash outlay, potentially capturing value in a growing submarket. Further due diligence is needed to confirm financials, rent control status, and cap rate to fully assess the investment potential.",
+ "risks": [
+ "Lack of disclosed cap rate and financials increases uncertainty about the property's performance and potential returns.",
+ "Rent control status in Reseda could limit rental income growth and affect long-term profitability.",
+ "No unit or square footage data available, making it difficult to assess the property's physical condition and marketability."
+ ],
+ "upside": [
+ "Leverage available with a 25% down payment allows for a significant purchase with a relatively low initial outlay.",
+ "Reseda is a growing area within the San Fernando Valley, offering potential for appreciation and rental demand."
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 18
+ },
+ {
+ "id": "crx2442308",
+ "address": "18216 Hartland Street",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1399000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2442308/california-18216-hartland-street",
+ "finance": {
+ "down": 349750,
+ "closing": 34975,
+ "cashNeeded": 384725,
+ "loan": 1049250,
+ "annualDebtService": 81665,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda offers an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, potentially capturing long-term appreciation and rental income growth. The location in Reseda, a growing area within the Valley, may provide stability and future value enhancement.",
+ "risks": [
+ "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of unit and square footage details makes it difficult to assess property condition and efficiency"
+ ],
+ "upside": [
+ "Potential for appreciation in a growing submarket like Reseda",
+ "Ability to leverage a relatively small down payment for a larger asset",
+ "Opportunity to fill in missing data and potentially reposition the property for higher returns"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 19
+ },
+ {
+ "id": "crx2413973",
+ "address": "5658 Willowcrest Ave",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 998000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413973/california-5658-willowcrest-ave",
+ "finance": {
+ "down": 249500,
+ "closing": 24950,
+ "cashNeeded": 274450,
+ "loan": 748500,
+ "annualDebtService": 58257,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the required cash is within budget, allowing for potential cash-on-cash returns once financials are verified. The property's location in a desirable area may support rental growth and long-term appreciation.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and ROI estimation uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Year built and square footage are unknown, which may affect property condition and renovation costs"
+ ],
+ "upside": [
+ "Strategic location in North Hollywood may allow for rent increases or value appreciation",
+ "Potential for value-add through renovations or repositioning",
+ "Leverage available to amplify returns if financials prove favorable"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 20
+ },
+ {
+ "id": "crx2413947",
+ "address": "14722 Strathern",
+ "city": "Panorama City",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1145000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413947/california-14722-strathern",
+ "finance": {
+ "down": 286250,
+ "closing": 28625,
+ "cashNeeded": 314875,
+ "loan": 858750,
+ "annualDebtService": 66838,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Panorama City presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a $400k budget. With a 25% down payment, the investor can secure a loan with a 6.75% interest rate over 30 years, leaving room for closing costs and potential value-add opportunities.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and income potential uncertain",
+ "Rent control status needs verification, which could impact rental income and long-term cash flow",
+ "Year built and square footage are unknown, which may affect property condition and renovation costs"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+ "Strategic location in Panorama City may offer appreciation potential",
+ "Leverage available to increase returns if NOI is strong"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 21
+ },
+ {
+ "id": "crx2566665",
+ "address": "14320 Osborne",
+ "city": "Panorama City",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1080000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2566665/california-14320-osborne",
+ "finance": {
+ "down": 270000,
+ "closing": 27000,
+ "cashNeeded": 297000,
+ "loan": 810000,
+ "annualDebtService": 63044,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Panorama City presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the cash needed is within budget, allowing for potential value-add through rent increases, unit upgrades, or conversion to a larger multifamily asset if market conditions allow.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and cash flow projections speculative",
+ "Rent control status needs verification, which could limit rental income growth",
+ "Lack of property details (year built, square footage) may indicate potential hidden costs or maintenance issues"
+ ],
+ "upside": [
+ "Potential for rent growth in a growing area like Panorama City",
+ "Opportunity to add value through renovations or repositioning",
+ "Leverage available to amplify returns if cash flow and NOI are strong"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 22
+ },
+ {
+ "id": "crx2516979",
+ "address": "5759 Hazeltine",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 928000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2516979/california-5759-hazeltine",
+ "finance": {
+ "down": 232000,
+ "closing": 23200,
+ "cashNeeded": 255200,
+ "loan": 696000,
+ "annualDebtService": 54171,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in Van Nuys presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a $400k budget, offering potential for cash flow and long-term appreciation. With a 25% down payment, the investor can secure the property with a manageable cash outlay and benefit from the area's strong demand for rental housing.",
+ "risks": [
+ "No cap rate or financials disclosed, making valuation and return estimation uncertain",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of property details (year built, square footage) may indicate potential hidden issues or lower quality"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases",
+ "Strategic location in Van Nuys with strong rental market demand",
+ "Leverage available to maximize returns with a relatively low down payment"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 23
+ },
+ {
+ "id": "crx2141640",
+ "address": "6402 Graves Ave",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1069000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2141640/california-6402-graves-ave-van-nuys-ca-91406",
+ "finance": {
+ "down": 267250,
+ "closing": 26725,
+ "cashNeeded": 293975,
+ "loan": 801750,
+ "annualDebtService": 62402,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 4-unit multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing costs. With a 25% down payment, the required cash is within budget, allowing for potential acquisition and value-add through renovations or rent increases, assuming favorable market conditions and accurate financials.",
+ "risks": [
+ "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+ "Rent control status needs verification, which could limit rental income growth",
+ "Year built and square footage not provided, making it difficult to assess property condition and potential for value-add"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or operational improvements",
+ "Strategic location in Van Nuys, a stable and growing submarket within the San Fernando Valley",
+ "Leverage available to amplify returns if financials and cap rate prove favorable"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 24
+ },
+ {
+ "id": "crx2413442",
+ "address": "6648 Gaviota Avenue",
+ "city": "Lake Balboa",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1169000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413442/california-6648-gaviota-avenue",
+ "finance": {
+ "down": 292250,
+ "closing": 29225,
+ "cashNeeded": 321475,
+ "loan": 876750,
+ "annualDebtService": 68239,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Lake Balboa presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the required cash is within budget, allowing for potential appreciation and rental income generation in a desirable San Fernando Valley submarket.",
+ "risks": [
+ "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+ "Rent control status needs verification, which could impact long-term rental income and tenant stability",
+ "Year built and square footage are unknown, potentially affecting property value and renovation costs"
+ ],
+ "upside": [
+ "Potential for value-add through property improvements or rent increases if rent control is not in place",
+ "Strategic location in Lake Balboa may offer strong demand and appreciation potential",
+ "Leverage available to amplify returns if financials prove favorable"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 25
+ },
+ {
+ "id": "crx1715584",
+ "address": "Call Broker For Details!",
+ "city": "Northridge",
+ "zip": "",
+ "type": "Retail",
+ "price": 999950,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/1715584/california-authentic-greek-5-star-restaurant",
+ "finance": {
+ "down": 249988,
+ "closing": 24999,
+ "cashNeeded": 274986,
+ "loan": 749963,
+ "annualDebtService": 58371,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This Northridge retail property presents an opportunity for a leveraged buyer with $400k available for down and closing, offering potential for long-term appreciation and income generation in a growing market. With a 25% down payment, the buyer can secure the property within budget, though due diligence on financials, rent roll, and cap rate is essential before proceeding.",
+ "risks": [
+ "No cap rate or NOI disclosed, limiting ability to assess income potential",
+ "Rent control status needs verification, which could impact rental rates and tenant stability",
+ "Property details (year built, sqft) are not disclosed, increasing uncertainty about condition and value"
+ ],
+ "upside": [
+ "Potential for value-add through tenant improvements or repositioning",
+ "Strategic location in Northridge may benefit from continued retail demand",
+ "Leverage available to maximize returns with a lower down payment"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 45,
+ "rank": 26
+ },
+ {
+ "id": "crx2516882",
+ "address": "6624 Farmdale Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1199000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2516882/california-6624-farmdale-avenue",
+ "finance": {
+ "down": 299750,
+ "closing": 29975,
+ "cashNeeded": 329725,
+ "loan": 899250,
+ "annualDebtService": 69990,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a $400k budget, potentially securing a property in a high-demand submarket. With a 25% down payment, the investor can structure a loan that fits within budget, though due diligence on financials, rent control status, and unit specifics is critical before proceeding.",
+ "risks": [
+ "No cap rate or NOI disclosed, making valuation and return estimation speculative",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Lack of property details (year built, square footage) may indicate incomplete or outdated data"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+ "North Hollywood is a growing area with strong demand for multifamily housing",
+ "Leverage allows for entry with a relatively low down payment compared to full purchase"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 42,
+ "rank": 27
+ },
+ {
+ "id": "crx2488780",
+ "address": "16057 Knapp",
+ "city": "North Hills",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1315000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2488780/california-16057-knapp",
+ "finance": {
+ "down": 328750,
+ "closing": 32875,
+ "cashNeeded": 361625,
+ "loan": 986250,
+ "annualDebtService": 76762,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": true
+ },
+ "financeScore": 38,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hills presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a $400k down payment. While key financials are not disclosed, the property's location in a desirable submarket may support rental income growth and long-term appreciation.",
+ "risks": [
+ "Lack of disclosed cap rate, NOI, and rent roll data increases uncertainty about the property's current performance and potential returns.",
+ "Rent control status needs verification, which could impact rental income growth and tenant retention.",
+ "Year built and square footage are not disclosed, making it difficult to assess the property's condition and potential for value-add improvements."
+ ],
+ "upside": [
+ "North Hills is a stable and growing area within the San Fernando Valley, offering strong demand for multifamily housing.",
+ "With a 25% down payment, the buyer can leverage the remaining $900k in financing to acquire the property within budget, potentially allowing for value-add strategies if the property is undervalued."
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 42,
+ "rank": 28
+ },
+ {
+ "id": "correnti12600",
+ "address": "12600 Correnti St",
+ "city": "Pacoima",
+ "zip": "91331",
+ "type": "Multifamily",
+ "price": 3300000,
+ "units": 14,
+ "sqft": 5334,
+ "cap_rate": 7.5,
+ "year_built": null,
+ "rent_control": "Renovated; verify RSO",
+ "status": "Active (OUT OF BUDGET — context)",
+ "upside_note": "ASSUMABLE $2.5M loan at 3.9% fixed thru 09/2027 -> only ~25% (~$825k) down but 12.2% cash-on-cash on current; plans to add 20 units -> proforma 13.9% cap. Exceptional economics but down payment EXCEEDS $400k.",
+ "source": "https://www.compass.com/homedetails/12600-Correnti-St-Pacoima-CA-91331/27H0FQ_pid/",
+ "finance": {
+ "down": 825000,
+ "closing": 82500,
+ "cashNeeded": 907500,
+ "loan": 2475000,
+ "annualDebtService": 192634,
+ "noi": 247500,
+ "cashFlow": 54866,
+ "coc": 6.05,
+ "dscr": 1.28,
+ "affordable": false
+ },
+ "financeScore": 28,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This multifamily property in Pacoima offers strong long-term value with a verified 7.5% cap rate and potential for significant upside through unit expansion. While the current cash-on-cash return is lower due to the high down payment requirement, the proforma cap rate of 13.9% and assumable loan terms present a compelling opportunity for a buyer with a $400k budget if alternative financing or value-add strategies can be implemented.",
+ "risks": [
+ "Down payment requirement exceeds budget, limiting immediate purchase feasibility",
+ "Need to verify RSO status and rent control implications",
+ "Proforma projections depend on successful unit expansion and market absorption"
+ ],
+ "upside": [
+ "Assumable loan at 3.9% provides favorable financing terms",
+ "Potential for 13.9% proforma cap rate with unit addition",
+ "Strong location in growing San Fernando Valley market"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 38,
+ "rank": 29
+ },
+ {
+ "id": "crx2414372",
+ "address": "6651 Beck",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1550000,
+ "units": 6,
+ "sqft": null,
+ "cap_rate": 7,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 7% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2414372/california-6651-beck",
+ "finance": {
+ "down": 387500,
+ "closing": 38750,
+ "cashNeeded": 426250,
+ "loan": 1162500,
+ "annualDebtService": 90479,
+ "noi": 108500,
+ "cashFlow": 18021,
+ "coc": 4.23,
+ "dscr": 1.2,
+ "affordable": false
+ },
+ "financeScore": 39,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood offers an attractive cap rate of 7% and is located in a high-demand submarket. While the computed cash needed exceeds the $400k budget, the property presents value with potential for rent growth and long-term appreciation in a strong rental market.",
+ "risks": [
+ "Insufficient down payment to meet computed cash requirement",
+ "Unverified rent control status may limit rent increases",
+ "Broker cap rate is unverified, requiring further due diligence on financials and rent roll"
+ ],
+ "upside": [
+ "Strong cap rate suggests potential for immediate cash flow",
+ "North Hollywood is a growing market with upward pressure on rents",
+ "Opportunity to negotiate terms or secure financing with lower down payment"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 38,
+ "rank": 30
+ },
+ {
+ "id": "amigo8357",
+ "address": "8357 Amigo Ave",
+ "city": "Northridge",
+ "zip": "91324",
+ "type": "Multifamily",
+ "price": 1249000,
+ "units": 4,
+ "sqft": 3816,
+ "cap_rate": 5.63,
+ "noi_actual": 70270,
+ "gross_actual": 89460,
+ "expenses": 19190,
+ "verified": true,
+ "rent_roll": [
+ {
+ "unit": 1,
+ "type": "2bd/1ba",
+ "rent": 1509
+ },
+ {
+ "unit": 2,
+ "type": "2bd/1ba",
+ "rent": 2300
+ },
+ {
+ "unit": 3,
+ "type": "2bd/1ba",
+ "rent": 1651
+ },
+ {
+ "unit": 4,
+ "type": "2bd/1ba",
+ "rent": 2000
+ }
+ ],
+ "year_built": 1960,
+ "rent_control": "LAR3",
+ "status": "Active",
+ "upside_note": "VERIFIED (MLS): honest in-place cap ~5.63% = gross $89,460 - exp $19,190 = NOI $70,270 (the MLS 'NOI $88,310' field ignores expenses — unreliable). Stated expenses $19,190 look LOW (verify taxes/insurance/mgmt in DD). Price cut $1,350,000->$1,249,000 (motivated). Quad near CSUN.",
+ "source": "https://www.compass.com/homedetails/8357-Amigo-Ave-Northridge-CA-91324/1IMLRO_pid/",
+ "finance": {
+ "down": 312250,
+ "closing": 31225,
+ "cashNeeded": 343475,
+ "loan": 936750,
+ "annualDebtService": 72909,
+ "noi": 70319,
+ "cashFlow": -2590,
+ "coc": -0.75,
+ "dscr": 0.96,
+ "affordable": true
+ },
+ "financeScore": 13,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This 4-unit multifamily property in Northridge offers an attractive entry point for a leveraged buyer with a $400k budget, given its verified cap rate of 5.63% and proximity to CSUN, which supports long-term rental demand. The price reduction and low down payment requirement make it a compelling opportunity for value-add strategies.",
+ "risks": [
+ "Low cash-on-cash return (-0.75%) indicates poor initial returns",
+ "Potential underestimation of expenses (taxes, insurance, management) may impact NOI",
+ "LAR3 rent control may limit rental growth potential"
+ ],
+ "upside": [
+ "Proximity to CSUN provides stable and growing tenant base",
+ "Price reduction suggests seller motivation and potential for negotiation",
+ "Value-add opportunities through unit upgrades or management improvements"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 36,
+ "rank": 31
+ },
+ {
+ "id": "wilbur9014",
+ "address": "9014 Wilbur Ave",
+ "city": "Northridge",
+ "zip": "91324",
+ "type": "Multifamily",
+ "price": 1700000,
+ "units": 4,
+ "sqft": 3211,
+ "cap_rate": null,
+ "year_built": 1980,
+ "rent_control": "Built 1980 -> NOT LA RSO; AB1482 only",
+ "status": "Active",
+ "upside_note": "Cap not disclosed; 1980 build = no LA rent control (higher increases); remodeled + new-construction units; adjacent 2-unit also available",
+ "source": "https://www.compass.com/homedetails/9014-Wilbur-Ave-Northridge-CA-91324/1KTV77_pid/",
+ "finance": {
+ "down": 425000,
+ "closing": 42500,
+ "cashNeeded": 467500,
+ "loan": 1275000,
+ "annualDebtService": 99236,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 4-unit multifamily property in Northridge offers an opportunity to purchase a remodeled and upgraded asset in a desirable area with no rent control restrictions, allowing for higher rental income potential. While the asking price exceeds the $400k budget for a 25% down purchase, the adjacent 2-unit property may provide a bundled acquisition opportunity that could enhance overall returns.",
+ "risks": [
+ "Insufficient down payment for a 25% LTV purchase without additional financing or budget adjustments",
+ "No disclosed cap rate limits ability to estimate returns and compare to market benchmarks",
+ "Adjacent 2-unit property availability may complicate due diligence and increase complexity of the deal"
+ ],
+ "upside": [
+ "No rent control in Northridge (built 1980) allows for higher rent increases and greater NOI potential",
+ "Remodeled and new-construction units may contribute to higher occupancy and rental rates",
+ "Potential for bundled acquisition with adjacent 2-unit property may offer scale and diversification"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 35,
+ "rank": 32
+ },
+ {
+ "id": "crx2414120",
+ "address": "6153 Clybourn Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1550000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2414120/california-6153-clybourn-avenue",
+ "finance": {
+ "down": 387500,
+ "closing": 38750,
+ "cashNeeded": 426250,
+ "loan": 1162500,
+ "annualDebtService": 90479,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged buyer to acquire a 4-unit asset in a high-demand submarket. While the asking price exceeds the $400k budget for a 25% down purchase, the property's location and potential for value-add improvements could justify a strategic acquisition with careful financing and due diligence.",
+ "risks": [
+ "Insufficient financial data (cap rate, NOI, rent roll not disclosed)",
+ "Potential rent control restrictions impacting rental income",
+ "Higher-than-expected closing costs may further strain the $400k budget"
+ ],
+ "upside": [
+ "Strong demand in North Hollywood for multifamily housing",
+ "Potential for rental rate increases or unit upgrades",
+ "Opportunity to acquire a property below market cap rate if financials are favorable upon due diligence"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 35,
+ "rank": 33
+ },
+ {
+ "id": "hillhaven10139",
+ "address": "10139 Hillhaven Ave",
+ "city": "Tujunga",
+ "zip": "91042",
+ "type": "Multifamily",
+ "price": 1248888,
+ "units": 3,
+ "sqft": 3929,
+ "cap_rate": 5.4,
+ "year_built": 1949,
+ "rent_control": "LAR3; pre-1978 RSO",
+ "status": "Active",
+ "upside_note": "Broker cap 5.40%; FIXER triplex, value-add (remodel rear units to market) + expand 3->5 units / 2 ADUs (R3, 8,137sf lot). Priced for condition ($318/sf). On market 75 days.",
+ "source": "https://www.compass.com/homedetails/10139-Hillhaven-Ave-Tujunga-CA-91042/1KFS1G_pid/",
+ "finance": {
+ "down": 312222,
+ "closing": 31222,
+ "cashNeeded": 343444,
+ "loan": 936666,
+ "annualDebtService": 72902,
+ "noi": 67440,
+ "cashFlow": -5462,
+ "coc": -1.59,
+ "dscr": 0.93,
+ "affordable": true
+ },
+ "financeScore": 8,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This fixer triplex in Tujunga offers a value-add opportunity with potential to significantly increase NOI through unit expansion and remodeling. The current cap rate of 5.4% and pricing for condition make it an attractive entry point for a buyer with $400k available for down and closing.",
+ "risks": [
+ "Significant rehab costs required to bring units up to market standards",
+ "Rent control restrictions may limit rental income growth",
+ "Long-term vacancy risk due to property condition and location"
+ ],
+ "upside": [
+ "Potential to expand from 3 to 5 units or add 2 ADUs, increasing income streams",
+ "Remodeling rear units could improve occupancy and rental rates",
+ "Priced below replacement cost with room for value creation"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 34,
+ "rank": 34
+ },
+ {
+ "id": "crx2413999",
+ "address": "6905 Agnes",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1599000,
+ "units": 5,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2413999/california-6905-agnes",
+ "finance": {
+ "down": 399750,
+ "closing": 39975,
+ "cashNeeded": 439725,
+ "loan": 1199250,
+ "annualDebtService": 93340,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 5-unit multifamily property in North Hollywood presents an opportunity for value-add investment, assuming the undisclosed cap rate is competitive and the property is in need of renovation. With a $400,000 budget, the investor could potentially secure a favorable deal with a lower down payment or negotiate terms to stay within budget.",
+ "risks": [
+ "Cap rate is not disclosed, making it difficult to assess potential returns",
+ "Rent control status needs verification, which could impact rental income and long-term profitability",
+ "Financials and rent roll are not provided, increasing uncertainty around cash flow and property condition"
+ ],
+ "upside": [
+ "Potential for value-add through renovations or repositioning",
+ "Strategic location in North Hollywood, a growing submarket with strong demand for multifamily housing",
+ "Opportunity to leverage limited capital for a larger asset with scalable returns"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 33,
+ "rank": 35
+ },
+ {
+ "id": "crx2417808",
+ "address": "6401 Denny Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1750000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2417808/california-6401-denny-avenue",
+ "finance": {
+ "down": 437500,
+ "closing": 43750,
+ "cashNeeded": 481250,
+ "loan": 1312500,
+ "annualDebtService": 102154,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged investor seeking value in a high-demand submarket. With $400,000 allocated for down payment and closing costs, the investor may need to negotiate terms or seek alternative financing to bridge the gap between the required $481,250 and available capital.",
+ "risks": [
+ "Lack of disclosed cap rate and financials increases uncertainty about the property's performance",
+ "Rent control status needs verification, which could impact long-term rental income and tenant stability",
+ "Insufficient information on unit size, year built, and current rent roll may obscure potential risks or opportunities"
+ ],
+ "upside": [
+ "North Hollywood is a growing area with strong demand for multifamily housing",
+ "Potential for value-add through renovations or repositioning if the property is undervalued",
+ "Opportunity to secure a property in a competitive market with a strategic down payment and closing cost budget"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 33,
+ "rank": 36
+ },
+ {
+ "id": "crx2558648",
+ "address": "14831 Nordhoff Street",
+ "city": "Panorama City",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1750000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2558648/california-14831-nordhoff-street",
+ "finance": {
+ "down": 437500,
+ "closing": 43750,
+ "cashNeeded": 481250,
+ "loan": 1312500,
+ "annualDebtService": 102154,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Panorama City presents an opportunity for a value-add investor seeking to leverage a $400,000 budget for a down payment and closing costs. With the San Fernando Valley's strong rental demand and potential for rent growth, the property could benefit from renovations and improved management to increase NOI and cap rate.",
+ "risks": [
+ "Cap rate is not disclosed, making it difficult to assess current returns",
+ "Rent control status needs verification, which could impact rental income potential",
+ "Financials and rent roll are not provided, increasing due diligence risk"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades and operational improvements",
+ "Strong demand in the San Fernando Valley multifamily market",
+ "Opportunity to acquire a property below market cap rate if financials justify it"
+ ],
+ "opportunity_score": 60,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 60,
+ "composite": 33,
+ "rank": 37
+ },
+ {
+ "id": "burbank10701",
+ "address": "10701 Burbank Blvd",
+ "city": "North Hollywood",
+ "zip": "91601",
+ "type": "Retail/NNN",
+ "price": 2799000,
+ "units": 1,
+ "sqft": 1802,
+ "cap_rate": 7.3,
+ "year_built": 1951,
+ "rent_control": "Commercial NNN — n/a",
+ "status": "Active (OUT OF BUDGET — context)",
+ "upside_note": "Single-tenant NNN cannabis dispensary, $204k NOI, 10-yr lease 2% bumps, fully passive. High cap but cannabis-tenant risk + needs ~$700k down.",
+ "source": "https://www.jayrubin-re.com/file/view-file/580",
+ "finance": {
+ "down": 699750,
"closing": 69975,
"cashNeeded": 769725,
"loan": 2099250,
@@ -742,7 +1965,7 @@
},
"qwenScore": 55,
"composite": 32,
- "rank": 13
+ "rank": 38
},
{
"id": "vannuys6329",
@@ -772,26 +1995,222 @@
"dscr": 0.89,
"affordable": true
},
- "financeScore": 3,
- "financeConf": "high",
+ "financeScore": 3,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This 3-unit retail property at a high-traffic signalized intersection in Van Nuys offers a value-add opportunity with strong long-term potential due to its proximity to the planned East San Fernando Valley light rail (2027) and current below-market tenants. With a projected cap rate increase to 6.35% after improvements, the property is well-positioned for rental growth and repositioning.",
+ "risks": [
+ "Current tenants are below market, which may require time and effort to retenant at higher rates",
+ "The property is older (1947), potentially requiring significant capital for renovations",
+ "The light rail is not yet operational (2027), and its impact on value is speculative"
+ ],
+ "upside": [
+ "Significant NOI growth potential through tenant improvements and re-leasing",
+ "Strategic location with high visibility at a signalized corner",
+ "Proximity to future light rail could drive long-term appreciation and rental growth"
+ ],
+ "opportunity_score": 65,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 65,
+ "composite": 31,
+ "rank": 39
+ },
+ {
+ "id": "crx2455873",
+ "address": "18238 Hartland Street",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1699000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2455873/california-18238-hartland-street",
+ "finance": {
+ "down": 424750,
+ "closing": 42475,
+ "cashNeeded": 467225,
+ "loan": 1274250,
+ "annualDebtService": 99177,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged investor seeking value in a growing submarket, though the asking price exceeds the $400k down payment budget, requiring additional capital or renegotiation. Further due diligence on cap rate, rent roll, and financials is essential before proceeding.",
+ "risks": [
+ "Insufficient down payment to meet computed cash requirement of $467,225",
+ "No cap rate or financials disclosed, increasing uncertainty",
+ "Rent control status unknown, which could impact long-term rental income and property value"
+ ],
+ "upside": [
+ "Potential for value-add through property management or unit upgrades",
+ "Location in Reseda offers growth potential and demand for multifamily housing",
+ "Opportunity to acquire a 3-unit property at a potentially attractive price if financials justify"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 31,
+ "rank": 40
+ },
+ {
+ "id": "crx2592616",
+ "address": "6900 Corbin Avenue",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1595000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2592616/california-6900-corbin-avenue",
+ "finance": {
+ "down": 398750,
+ "closing": 39875,
+ "cashNeeded": 438625,
+ "loan": 1196250,
+ "annualDebtService": 93106,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged buyer to enter the San Fernando Valley market, though the required down payment exceeds the available budget. Further due diligence on cap rate, rent roll, and rent control status is essential before proceeding.",
+ "risks": [
+ "Insufficient down payment to meet computed requirement of $438,625",
+ "No cap rate or financials disclosed, increasing uncertainty",
+ "Rent control status needs verification, which could impact long-term rental income and value"
+ ],
+ "upside": [
+ "Potential for value-add through property management or unit upgrades",
+ "Strategic location in growing Reseda submarket",
+ "Opportunity to acquire a multifamily asset with leverage if financing can be adjusted"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 31,
+ "rank": 41
+ },
+ {
+ "id": "crx2412907",
+ "address": "5887 Whitnall",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1489000,
+ "units": 9,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2412907/california-5887-whitnall",
+ "finance": {
+ "down": 372250,
+ "closing": 37225,
+ "cashNeeded": 409475,
+ "loan": 1116750,
+ "annualDebtService": 86919,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 9-unit multifamily property in North Hollywood presents an opportunity for a leveraged buyer with a $400k budget, assuming the cap rate is attractive and the property is in good condition. However, the required down payment exceeds the available budget, and critical financials are not disclosed, requiring further due diligence.",
+ "risks": [
+ "Insufficient down payment to meet the computed $409,475 requirement",
+ "No cap rate or financials disclosed, increasing uncertainty",
+ "Potential rent control implications affecting long-term cash flow"
+ ],
+ "upside": [
+ "Strategic location in North Hollywood with strong demand for multifamily housing",
+ "Potential for value-add through renovations or rent increases",
+ "Opportunity to acquire a 9-unit asset with room for operational scaling"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 31,
+ "rank": 42
+ },
+ {
+ "id": "crx2473428",
+ "address": "14918 Wyandotte",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1550000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2473428/california-14918-wyandotte-street",
+ "finance": {
+ "down": 387500,
+ "closing": 38750,
+ "cashNeeded": 426250,
+ "loan": 1162500,
+ "annualDebtService": 90479,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
"qwen": {
- "thesis": "This 3-unit retail property at a high-traffic signalized intersection in Van Nuys offers a value-add opportunity with strong long-term potential due to its proximity to the planned East San Fernando Valley light rail (2027) and current below-market tenants. With a projected cap rate increase to 6.35% after improvements, the property is well-positioned for rental growth and repositioning.",
+ "thesis": "This multifamily property in Van Nuys presents a potential opportunity for a leveraged buyer with a $400k budget, though the required down payment and closing costs exceed the available funds. Further due diligence on the property's financials, cap rate, and rent control status is essential before considering an offer.",
"risks": [
- "Current tenants are below market, which may require time and effort to retenant at higher rates",
- "The property is older (1947), potentially requiring significant capital for renovations",
- "The light rail is not yet operational (2027), and its impact on value is speculative"
+ "Insufficient funds to meet the required down payment and closing costs without additional financing or budget adjustments",
+ "Lack of disclosed cap rate and financial details increases uncertainty about the property's performance",
+ "Rent control status could impact long-term rental income and property value"
],
"upside": [
- "Significant NOI growth potential through tenant improvements and re-leasing",
- "Strategic location with high visibility at a signalized corner",
- "Proximity to future light rail could drive long-term appreciation and rental growth"
+ "Strategic location in Van Nuys, a growing area within the San Fernando Valley",
+ "Potential for value-add through renovations or improved management",
+ "Multifamily sector remains resilient in the current market"
],
- "opportunity_score": 65,
+ "opportunity_score": 55,
"recommendation": "Watch"
},
- "qwenScore": 65,
+ "qwenScore": 55,
"composite": 31,
- "rank": 14
+ "rank": 43
},
{
"id": "sepulveda8144",
@@ -839,7 +2258,7 @@
},
"qwenScore": 65,
"composite": 29,
- "rank": 15
+ "rank": 44
},
{
"id": "canby7260",
@@ -887,7 +2306,7 @@
},
"qwenScore": 65,
"composite": 29,
- "rank": 16
+ "rank": 45
},
{
"id": "wilkinson5214",
@@ -935,7 +2354,7 @@
},
"qwenScore": 65,
"composite": 29,
- "rank": 17
+ "rank": 46
},
{
"id": "tilden8837",
@@ -983,7 +2402,203 @@
},
"qwenScore": 55,
"composite": 28,
- "rank": 18
+ "rank": 47
+ },
+ {
+ "id": "crx2560155",
+ "address": "6852 CLAIRE AVE",
+ "city": "RESEDA",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1499000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2560155/california-6852-claire-ave-reseda-ca-91335-3840",
+ "finance": {
+ "down": 374750,
+ "closing": 37475,
+ "cashNeeded": 412225,
+ "loan": 1124250,
+ "annualDebtService": 87502,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda presents an opportunity for a leveraged investor to acquire a single-unit asset in a growing market, though the lack of financials and cap rate disclosure introduces uncertainty. With a $400k budget, the investor would need to adjust terms or seek additional financing to meet the required down payment and closing costs.",
+ "risks": [
+ "No financials or cap rate disclosed, making valuation and return estimation speculative",
+ "Rent control status needs verification, which could impact long-term rental income",
+ "Insufficient budget to meet computed down payment and closing costs without renegotiation or alternative financing"
+ ],
+ "upside": [
+ "Potential for value-add through renovation or repositioning in a competitive market",
+ "Opportunity to secure a property in a desirable location with future appreciation potential",
+ "Possibility of leveraging additional capital for higher returns if terms are adjusted"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50,
+ "composite": 28,
+ "rank": 48
+ },
+ {
+ "id": "crx2352672",
+ "address": "6820 Ben Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1675000,
+ "units": 8,
+ "sqft": null,
+ "cap_rate": 6.28,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 6.28% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2352672/california-6820-ben-avenue",
+ "finance": {
+ "down": 418750,
+ "closing": 41875,
+ "cashNeeded": 460625,
+ "loan": 1256250,
+ "annualDebtService": 97776,
+ "noi": 105190,
+ "cashFlow": 7414,
+ "coc": 1.61,
+ "dscr": 1.08,
+ "affordable": false
+ },
+ "financeScore": 24,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This multifamily property in North Hollywood offers a compelling opportunity with a verified cap rate of 6.28%, suggesting potential for stable cash flow. However, the required down payment and closing costs exceed the investor's $400,000 budget, necessitating careful evaluation of financing options and risk mitigation strategies.",
+ "risks": [
+ "Insufficient down payment to meet the computed $460,625 requirement without additional financing or cost reduction",
+ "Unverified rent control status may impact long-term rental income and tenant retention",
+ "Low cash-on-cash return (1.61%) and DSCR (1.08) indicate tight margins and limited buffer for unexpected expenses"
+ ],
+ "upside": [
+ "Verified cap rate suggests potential for value-add through operational improvements or repositioning",
+ "North Hollywood's strong multifamily market may support rental growth and property appreciation",
+ "Opportunity to negotiate price or closing costs to align with budget constraints"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 28,
+ "rank": 49
+ },
+ {
+ "id": "crx2516587",
+ "address": "6305 Carpenter",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1599000,
+ "units": 2,
+ "sqft": null,
+ "cap_rate": null,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2516587/california-6305-carpenter",
+ "finance": {
+ "down": 399750,
+ "closing": 39975,
+ "cashNeeded": 439725,
+ "loan": 1199250,
+ "annualDebtService": 93340,
+ "noi": null,
+ "cashFlow": null,
+ "coc": null,
+ "dscr": null,
+ "affordable": false
+ },
+ "financeScore": 20,
+ "financeConf": "low",
+ "qwen": {
+ "thesis": "This 2-unit multifamily property in North Hollywood presents an opportunity for a leveraged investor to enter the market with a modest down payment, though the required cash investment exceeds the available budget. Further due diligence on financials, rent control status, and property condition is essential before proceeding.",
+ "risks": [
+ "Insufficient cash to meet the computed down payment and closing costs",
+ "Lack of disclosed cap rate and financials increases uncertainty",
+ "Rent control status may impact long-term rental income and property value"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rent increases",
+ "Strategic location in North Hollywood may offer appreciation potential",
+ "Multifamily properties can provide stable cash flow with proper management"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50,
+ "composite": 28,
+ "rank": 50
+ },
+ {
+ "id": "crx2455604",
+ "address": "11849 Hart St",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1195000,
+ "units": 5,
+ "sqft": null,
+ "cap_rate": 5.57,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.57% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2455604/california-11849-hart-st",
+ "finance": {
+ "down": 298750,
+ "closing": 29875,
+ "cashNeeded": 328625,
+ "loan": 896250,
+ "annualDebtService": 69757,
+ "noi": 66562,
+ "cashFlow": -3195,
+ "coc": -0.97,
+ "dscr": 0.95,
+ "affordable": true
+ },
+ "financeScore": 12,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This 5-unit multifamily property in North Hollywood offers an entry point into a competitive market with a verified cap rate of 5.57%, suggesting potential for stable cash flow. With a $400k budget covering down payment and closing costs, the deal is leveraged but requires careful evaluation of financials and rent control status before proceeding.",
+ "risks": [
+ "Rent control may limit rental growth potential",
+ "Financials and rent roll need verification before final decision",
+ "Low cash-on-cash return (-0.97%) and DSCR (0.95) indicate high leverage and potential cash flow stress"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or tenant retention",
+ "Strategic location in North Hollywood with strong demand for multifamily housing",
+ "Opportunity to secure a property at a verified cap rate in a growing market"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 27,
+ "rank": 51
},
{
"id": "vannuys12872",
@@ -1031,7 +2646,7 @@
},
"qwenScore": 65,
"composite": 26,
- "rank": 19
+ "rank": 52
},
{
"id": "comercio5301",
@@ -1079,7 +2694,56 @@
},
"qwenScore": 65,
"composite": 26,
- "rank": 20
+ "rank": 53
+ },
+ {
+ "id": "crx2569960",
+ "address": "6441 Satsuma Avenue",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1750000,
+ "units": 4,
+ "sqft": null,
+ "cap_rate": 5.9,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.9% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2569960/california-6441-satsuma-avenue",
+ "finance": {
+ "down": 437500,
+ "closing": 43750,
+ "cashNeeded": 481250,
+ "loan": 1312500,
+ "annualDebtService": 102154,
+ "noi": 103250,
+ "cashFlow": 1096,
+ "coc": 0.23,
+ "dscr": 1.01,
+ "affordable": false
+ },
+ "financeScore": 16,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This 4-unit multifamily property in North Hollywood offers an attractive entry point with a verified 5.9% cap rate, suggesting potential for stable cash flow. However, the required down payment and closing costs exceed the $400k budget, necessitating careful evaluation of financing options and potential value-add opportunities.",
+ "risks": [
+ "Insufficient down payment to meet the computed $481,250 requirement without additional funding or negotiation",
+ "Lack of verified rent roll and financials, which could impact NOI assumptions",
+ "Rent control status may limit rental growth and affect long-term profitability"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or operational efficiencies",
+ "Strategic repositioning could increase rental rates and NOI",
+ "Strong location in North Hollywood with demand for multifamily housing"
+ ],
+ "opportunity_score": 55,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 55,
+ "composite": 26,
+ "rank": 54
},
{
"id": "victory13350",
@@ -1127,7 +2791,56 @@
},
"qwenScore": 55,
"composite": 25,
- "rank": 21
+ "rank": 55
+ },
+ {
+ "id": "crx2489729",
+ "address": "5629 Cleon",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1350000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": 5.33,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.33% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2489729/california-5629-cleon-ave",
+ "finance": {
+ "down": 337500,
+ "closing": 33750,
+ "cashNeeded": 371250,
+ "loan": 1012500,
+ "annualDebtService": 78805,
+ "noi": 71955,
+ "cashFlow": -6850,
+ "coc": -1.85,
+ "dscr": 0.91,
+ "affordable": true
+ },
+ "financeScore": 7,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This single-unit multifamily property in North Hollywood offers an entry point into the multifamily market with a verified cap rate of 5.33%, though the low cash-on-cash return and DSCR below 1.0 indicate potential financial strain. The property may be suitable for a buyer looking to build a portfolio or test the market with a leveraged purchase.",
+ "risks": [
+ "Low cash-on-cash return (-1.85%) indicates poor immediate profitability",
+ "DSCR of 0.91 suggests potential cash flow shortfall",
+ "Lack of verified rent roll and financials increases uncertainty"
+ ],
+ "upside": [
+ "Potential for rent increases if rent control is not in place",
+ "Opportunity to acquire a property in a strong submarket (North Hollywood)",
+ "Leverage available to maximize exposure with limited capital"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50,
+ "composite": 23,
+ "rank": 56
},
{
"id": "canoga6020",
@@ -1175,7 +2888,7 @@
},
"qwenScore": 55,
"composite": 21,
- "rank": 22
+ "rank": 57
},
{
"id": "vanowen15840",
@@ -1223,7 +2936,154 @@
},
"qwenScore": 60,
"composite": 18,
- "rank": 23
+ "rank": 58
+ },
+ {
+ "id": "crx2448930",
+ "address": "17852 Saticoy Street",
+ "city": "Reseda",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1749000,
+ "units": 3,
+ "sqft": null,
+ "cap_rate": 5.12,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 5.12% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2448930/california-17852-saticoy-street",
+ "finance": {
+ "down": 437250,
+ "closing": 43725,
+ "cashNeeded": 480975,
+ "loan": 1311750,
+ "annualDebtService": 102096,
+ "noi": 89549,
+ "cashFlow": -12547,
+ "coc": -2.61,
+ "dscr": 0.88,
+ "affordable": false
+ },
+ "financeScore": 0,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This multifamily property in Reseda offers an entry point into the San Fernando Valley market with a verified cap rate of 5.12%, suggesting potential for stable cash flow. However, the required down payment exceeds the investor's budget, and the computed cash-on-cash return is negative, indicating a need for careful evaluation of financing and value-add opportunities.",
+ "risks": [
+ "Down payment requirement exceeds budget by $80,975",
+ "Negative cash-on-cash return suggests poor initial returns",
+ "Need to verify rent control status and financials before proceeding"
+ ],
+ "upside": [
+ "Potential for value-add through unit upgrades or rental rate increases",
+ "Strategic location in growing Reseda market",
+ "Opportunity to leverage additional capital for improved returns"
+ ],
+ "opportunity_score": 50,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 50,
+ "composite": 18,
+ "rank": 59
+ },
+ {
+ "id": "crx2563662",
+ "address": "11234 Hatteras",
+ "city": "North Hollywood",
+ "zip": "",
+ "type": "Multifamily",
+ "price": 1250000,
+ "units": 5,
+ "sqft": null,
+ "cap_rate": 3.67,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 3.67% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2563662/california-11234-hatteras",
+ "finance": {
+ "down": 312500,
+ "closing": 31250,
+ "cashNeeded": 343750,
+ "loan": 937500,
+ "annualDebtService": 72967,
+ "noi": 45875,
+ "cashFlow": -27092,
+ "coc": -7.88,
+ "dscr": 0.63,
+ "affordable": true
+ },
+ "financeScore": 0,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This 5-unit multifamily property in North Hollywood offers an entry point into a high-demand market with a verified cap rate of 3.67%, though the negative cash-on-cash return and low DSCR indicate significant financial risk. With $400k available for down and closing, the purchase is feasible but requires careful evaluation of rent control status, financials, and market conditions.",
+ "risks": [
+ "Negative cash-on-cash return (-7.88%) indicates potential cash outflow",
+ "Low DSCR (0.63) suggests high leverage and potential default risk",
+ "Rent control status and in-place financials need verification before proceeding"
+ ],
+ "upside": [
+ "Potential for value-add through rent increases or unit improvements",
+ "Strategic location in North Hollywood with strong long-term appreciation potential",
+ "Opportunity to acquire a multifamily asset in a competitive market with leverage"
+ ],
+ "opportunity_score": 45,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 45,
+ "composite": 18,
+ "rank": 60
+ },
+ {
+ "id": "crx2147226",
+ "address": "7214 Sepulveda Blvd",
+ "city": "Van Nuys",
+ "zip": "",
+ "type": "Retail",
+ "price": 928000,
+ "units": 1,
+ "sqft": null,
+ "cap_rate": 3.74,
+ "verified": false,
+ "year_built": null,
+ "rent_control": "verify",
+ "status": "Active",
+ "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Broker cap 3.74% (unverified). Verify status, rent roll, and financials before acting.",
+ "source": "https://www.crexi.com/properties/2147226/california-liquid-zoo",
+ "finance": {
+ "down": 232000,
+ "closing": 23200,
+ "cashNeeded": 255200,
+ "loan": 696000,
+ "annualDebtService": 54171,
+ "noi": 34707,
+ "cashFlow": -19464,
+ "coc": -7.63,
+ "dscr": 0.64,
+ "affordable": true
+ },
+ "financeScore": 0,
+ "financeConf": "high",
+ "qwen": {
+ "thesis": "This retail property in Van Nuys offers an entry point into the San Fernando Valley retail market with a verified cap rate of 3.74%, though the negative cash-on-cash return and low DSCR indicate potential financial stress. The $400k budget allows for a leveraged purchase with 25% down, but due diligence on rent control, tenant stability, and financials is critical.",
+ "risks": [
+ "Negative cash-on-cash return (-7.63%) indicates potential cash outflow",
+ "Low DSCR (0.64) suggests high debt servicing risk",
+ "Uncertain rent control status may limit rental growth and tenant retention"
+ ],
+ "upside": [
+ "Potential for rent increases if rent control is not in place",
+ "Stable retail location in Van Nuys with long-term appreciation potential",
+ "Opportunity to acquire a verified cap rate asset with room for value-add improvements"
+ ],
+ "opportunity_score": 45,
+ "recommendation": "Watch"
+ },
+ "qwenScore": 45,
+ "composite": 18,
+ "rank": 61
},
{
"id": "canby7454",
@@ -1271,7 +3131,7 @@
},
"qwenScore": 55,
"composite": 16,
- "rank": 24
+ "rank": 62
}
]
}
\ No newline at end of file
diff --git a/deploy/com.steve.cre-weekly-refresh.plist b/deploy/com.steve.cre-weekly-refresh.plist
new file mode 100644
index 0000000..0f1cf33
--- /dev/null
+++ b/deploy/com.steve.cre-weekly-refresh.plist
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
+<plist version="1.0">
+<dict>
+ <key>Label</key>
+ <string>com.steve.cre-weekly-refresh</string>
+ <key>ProgramArguments</key>
+ <array>
+ <string>/bin/zsh</string>
+ <string>/Users/stevestudio2/Projects/commercialrealestate/scripts/run-weekly-refresh.sh</string>
+ </array>
+ <key>StartCalendarInterval</key>
+ <dict>
+ <key>Weekday</key>
+ <integer>1</integer>
+ <key>Hour</key>
+ <integer>5</integer>
+ <key>Minute</key>
+ <integer>0</integer>
+ </dict>
+ <key>RunAtLoad</key>
+ <false/>
+ <key>StandardOutPath</key>
+ <string>/tmp/cre-weekly-refresh.out</string>
+ <key>StandardErrorPath</key>
+ <string>/tmp/cre-weekly-refresh.err</string>
+</dict>
+</plist>
diff --git a/scripts/refresh-listings.js b/scripts/refresh-listings.js
new file mode 100644
index 0000000..8577ffa
--- /dev/null
+++ b/scripts/refresh-listings.js
@@ -0,0 +1,86 @@
+// refresh-listings.js — weekly Browserbase/Crexi sweep that APPENDS new in-band active SFV listings
+// to data/listings.json (deduped). ONE Browserbase session navigates all city/type pages and captures
+// Crexi's own authed api.crexi.com asset JSON. No API key needed. Run with NODE_PATH pointing at the
+// browserbase skill node_modules. Idempotent: only adds listings whose address isn't already present.
+const fs = require('fs');
+const path = require('path');
+const { chromium } = require('playwright-core');
+const Browserbase = require('@browserbasehq/sdk').default;
+
+const ROOT = path.join(__dirname, '..');
+const bbEnv = 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 NAV_CITIES = ['Van Nuys', 'Reseda', 'North Hollywood', 'Northridge', 'Panorama City', 'Canoga Park', 'Sherman Oaks', 'Sun Valley', 'Encino', 'Granada Hills'];
+const TYPES = [['multifamily', 'Multifamily'], ['retail', 'Retail']];
+// Accept captured assets whose city is anywhere in the SFV:
+const SFV = new Set(['van nuys', 'reseda', 'north hollywood', 'northridge', 'panorama city', 'canoga park',
+ 'sherman oaks', 'sun valley', 'encino', 'granada hills', 'tarzana', 'woodland hills', 'winnetka', 'west hills',
+ 'lake balboa', 'valley village', 'valley glen', 'studio city', 'toluca lake', 'arleta', 'pacoima', 'mission hills',
+ 'sylmar', 'tujunga', 'sunland', 'porter ranch', 'chatsworth', 'north hills'].map(s => s));
+const MINP = 800000, MAXP = 1750000;
+const norm = s => String(s || '').toLowerCase().replace(/[^a-z0-9 ]/g, '').replace(/\b(ave|avenue|st|street|blvd|boulevard|dr|drive|rd|road|ln|lane|pl|place|ct|court)\b/g, '').replace(/\s+/g, ' ').trim();
+
+(async () => {
+ const assets = new Map();
+ let browser;
+ try {
+ const bb = new Browserbase({ apiKey: get(bbEnv, 'BROWSERBASE_API_KEY') });
+ const session = await bb.sessions.create({ projectId: get(bbEnv, 'BROWSERBASE_PROJECT_ID'), browserSettings: { solveCaptchas: true, viewport: { width: 1440, height: 1000 } } });
+ console.log('bb session', session.id);
+ 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)) for (const a of arr) {
+ const id = a.id || a.assetId, price = a.askingPrice || a.price, loc = (a.locations && a.locations[0]) || {};
+ if (id && price && loc.city && !assets.has(id)) assets.set(id, {
+ id, price: +price, city: loc.city, address: loc.address || (a.name || ''),
+ cap: typeof a.capRate === 'number' ? a.capRate : null, urlSlug: a.urlSlug || '',
+ desc: String(a.description || ''), types: a.types || []
+ });
+ }
+ } catch (_) {}
+ });
+ for (const [slug, label] of TYPES) {
+ for (const city of NAV_CITIES) {
+ const url = `https://www.crexi.com/properties/CA/${city.replace(/\s+/g, '-')}/${slug}`;
+ try { await page.goto(url, { waitUntil: 'domcontentloaded' }); await page.waitForTimeout(4500); await page.mouse.wheel(0, 3000).catch(() => {}); await page.waitForTimeout(1500); }
+ catch (e) { console.log('nav err', city, slug, e.message.split('\n')[0]); }
+ }
+ }
+ } catch (e) { console.error('FATAL', e.message); }
+ finally { if (browser) await browser.close().catch(() => {}); }
+
+ // Filter to in-band, SFV, plausible
+ const cand = [...assets.values()].filter(a => a.city && SFV.has(a.city.toLowerCase()) && a.price >= MINP && a.price <= MAXP && a.address);
+ console.log(`captured ${assets.size} assets, ${cand.length} in-band SFV candidates`);
+
+ const data = JSON.parse(fs.readFileSync(path.join(ROOT, 'data', 'listings.json'), 'utf8'));
+ const have = new Set(data.listings.map(l => norm(l.address)));
+ const today = new Date().toISOString().slice(0, 10);
+ let added = 0;
+ for (const a of cand) {
+ const key = norm(a.address);
+ if (!key || have.has(key)) continue;
+ have.add(key);
+ const type = (a.types || []).some(t => /retail/i.test(t)) ? 'Retail' : (a.types || []).some(t => /mixed/i.test(t)) ? 'Mixed-use' : 'Multifamily';
+ const units = (() => { const m = a.desc.match(/(?:\|\s*)?\b(\d{1,3})\s*units?\b/i); if (m) { const n = +m[1]; if (n >= 1 && n <= 500 && a.price / n >= 50000) return n; } return null; })();
+ data.listings.push({
+ id: 'crx' + a.id, address: a.address, city: a.city, zip: '', type,
+ price: a.price, units: units || 1, sqft: null, cap_rate: a.cap, verified: false,
+ year_built: null, rent_control: 'verify', status: 'Active',
+ upside_note: `Auto-added by weekly Crexi refresh ${today}. ${a.cap ? 'Broker cap ' + a.cap + '% (unverified).' : 'Cap not disclosed.'} Verify status, rent roll, and financials before acting.`,
+ source: 'https://www.crexi.com/properties/' + a.id + (a.urlSlug ? '/' + a.urlSlug : '')
+ });
+ added++;
+ }
+ fs.writeFileSync(path.join(ROOT, 'data', 'listings.json'), JSON.stringify(data, null, 2));
+ fs.writeFileSync(path.join(ROOT, 'data', 'last-refresh.json'), JSON.stringify({ date: today, captured: assets.size, candidates: cand.length, added }, null, 2));
+ console.log(`ADDED ${added} new listings (total ${data.listings.length}).`);
+})();
diff --git a/scripts/run-weekly-refresh.sh b/scripts/run-weekly-refresh.sh
new file mode 100755
index 0000000..d08991a
--- /dev/null
+++ b/scripts/run-weekly-refresh.sh
@@ -0,0 +1,22 @@
+#!/bin/zsh
+# Weekly Browserbase/Crexi refresh: append new in-band active SFV listings, re-rank, commit, notify.
+# Wired to launchd com.steve.cre-weekly-refresh (Mon 05:00 America/Los_Angeles, before the Mon 06:00 report).
+export PATH="/usr/local/bin:/opt/homebrew/bin:$HOME/.npm-global/bin:$HOME/.claude/local:$PATH"
+export NODE_PATH="$HOME/.claude/skills/browserbase/node_modules"
+cd "$HOME/Projects/commercialrealestate" || exit 1
+LOG=/tmp/cre-weekly-refresh.log
+echo "===== refresh $(date) =====" >> "$LOG"
+
+/usr/local/bin/node scripts/refresh-listings.js >> "$LOG" 2>&1
+/usr/local/bin/node scripts/analyze.js >> "$LOG" 2>&1
+
+git -c user.email=steve@designerwallcoverings.com -c user.name="Steve" add -A >> "$LOG" 2>&1
+git -c user.email=steve@designerwallcoverings.com -c user.name="Steve" commit -q -m "weekly Crexi refresh $(date +%Y-%m-%d)" >> "$LOG" 2>&1
+
+ADDED=$(/usr/local/bin/node -e 'try{process.stdout.write(String(require("./data/last-refresh.json").added))}catch(e){process.stdout.write("0")}')
+echo "added=$ADDED" >> "$LOG"
+if [ "$ADDED" -gt 0 ] 2>/dev/null; then
+ "$HOME/.npm-global/bin/claude" -p "Send a short plain-text email via mcp__george__gmail_send account 'steve-office' to steve@designerwallcoverings.com. Subject: 'SFV CRE weekly refresh: $ADDED new listings'. Body: 'The weekly Crexi refresh added $ADDED new in-band active SFV listing(s) to the ranker; they are now in the daily Top-10 at http://127.0.0.1:9911. Auto-added listings carry broker/unverified caps - verify before acting.' Send only that one email." \
+ --allowedTools "mcp__george__gmail_send" --dangerously-skip-permissions >> "$LOG" 2>&1
+fi
+echo "===== done $(date) =====" >> "$LOG"
← c09a426 Daily 6am top-10 report -> steve-office via George (launchd)
·
back to Commercialrealestate
·
Verify Granada Hills #1 (pro-forma 6.66%, lease-up risk) + d f205d2c →