[object Object]

← back to Commercialrealestate

afternoon CRE update 2026-06-26

b6dbc62833bd5ede91e4467faf85c295c5357dd8 · 2026-06-26 13:00:03 -0700 · Steve

Files touched

Diff

commit b6dbc62833bd5ede91e4467faf85c295c5357dd8
Author: Steve <steve@designerwallcoverings.com>
Date:   Fri Jun 26 13:00:03 2026 -0700

    afternoon CRE update 2026-06-26
---
 data/.pre-afternoon-ids.json |    1 +
 data/afternoon-report.html   |  170 ++++-
 data/last-refresh.json       |    8 +-
 data/listings.json           |  306 +++++++++
 data/qwen-cache.json         |  342 ++++++++++
 data/ranked.json             | 1558 +++++++++++++++++++++++++++++++++---------
 6 files changed, 2040 insertions(+), 345 deletions(-)

diff --git a/data/.pre-afternoon-ids.json b/data/.pre-afternoon-ids.json
new file mode 100644
index 0000000..a187584
--- /dev/null
+++ b/data/.pre-afternoon-ids.json
@@ -0,0 +1 @@
+{"at":"2026-06-26T19:55:34.839Z","ids":["victory13350","sepulveda8144","canby7260","canby7304","schoenborn17920","amigo8357","wilbur9014","tilden8843","tilden8837","sanfernando10004","vannuys12872","sherman21627","owensmouth7129","hillhaven10139","wilkinson5214","vannuys6329","sepulveda10011","foothill6851","comercio5301","vanowen15840","canby7454","correnti12600","burbank10701","canoga6020","crx2560155","crx2448930","crx2455873","crx2592616","crx2453716","crx2442308","crx2412907","crx2414372","crx2352672","crx2413973","crx2413999","crx2414120","crx2412240","crx2413606","crx2489729","crx2455604","crx2586908","crx2417808","crx2569960","crx2516882","crx2516587","crx2563662","crx2413947","crx2404653","crx2558648","crx2566665","crx2473428","crx2488780","crx2407231","crx2516979","crx2141640","crx2413442","crx2414348","crx2413131","crx2568125","crx2147226","crx2159323","crx1715584","crx2516747","crx2589903","crx1080991","crx2412770","crx2413872","crx2412328","crx2412878","crx2584910","crx2516918","crx2412641","crx2569982","crx2429890","crx2450078","crx2595754","crx2411991","crx2461695","crx2559966","crx2521992","crx2485727","crx2429895","crx2553265","crx2593834","crx2492613"]}
\ No newline at end of file
diff --git a/data/afternoon-report.html b/data/afternoon-report.html
index 97a58be..60b60f4 100644
--- a/data/afternoon-report.html
+++ b/data/afternoon-report.html
@@ -1,36 +1,164 @@
 <div style="font-family:-apple-system,Segoe UI,Arial,sans-serif;max-width:780px">
 <h2 style="margin:0 0 2px">SFV CRE — 1pm Update: New Listings &amp; Red-Hot Deals</h2>
-<div style="color:#666;font-size:13px">2026-06-26 · San Fernando Valley, CA · $400,000 down (25% / 6.75% / 30yr) · 85 listings tracked</div>
+<div style="color:#666;font-size:13px">2026-06-26 · San Fernando Valley, CA · $400,000 down (25% / 6.75% / 30yr) · 103 listings tracked</div>
 <p style="font-size:13px;color:#444;margin:12px 0">Afternoon re-scrape of Crexi vs this morning. Cap rates are broker/MLS-stated — verify NOI in DD.
 Most SFV multifamily runs negative/breakeven leverage at today's rates; positive-leverage (green CoC) or seller-financed deals are the standouts.</p>
 
-<h3 style="margin:16px 0 4px;font-size:15px">🆕 Additional listings since this morning (3)</h3>
+<h3 style="margin:16px 0 4px;font-size:15px">🆕 Additional listings since this morning (18)</h3>
 <div style="border-top:1px solid #e2e2e2;padding:10px 0">
-    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2553265/california-9350-tampa">9350 Tampa</a>, Northridge</b> &nbsp;<span style="color:#888;font-weight:400">score 54</span></div>
-    <div style="color:#666;font-size:12px">Multifamily · 1 unit · $1,590,000 · cap 9.24% (broker cap)</div>
-    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$437,250</b> (OVER budget) · CoC <span style="color:#178a3a">12.37%</span> · DSCR 1.58 · est NOI $146,916</div>
-    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Northridge offers an attractive cap rate of 9.24%, suggesting strong potential for cash flow and appreciation in a growing market. However, the required down payment of $437,250 exceeds the investor's $400,000 budget, necessitating careful evaluation of financing options or potential compromises in the deal structure.</div>
-    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Insufficient down payment to meet computed requirements without stretching financing terms; Unverified rent control status may impact long-term rental income and tenant stability; Broker-reported cap rate is unverified, requiring due diligence on financials and rent roll</div>
-    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-23. Broker cap 9.24% (unverified). Verify status, rent roll, and financials before acting.</div>
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/1834484/california-5335-harmony-ave">5335 Harmony Avenue</a>, North Hollywood</b> &nbsp;<span style="color:#888;font-weight:400">score 76</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 8 units · $1,195,000 · cap 8.84% (broker cap)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$328,625</b> (in budget) · CoC <span style="color:#178a3a">10.92%</span> · DSCR 1.51 · est NOI $105,638</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This 8-unit multifamily property in North Hollywood offers an attractive 8.84% cap rate with a calculated 10.92% cash-on-cash return using a 25% down payment. The property is positioned in a strong submarket with potential for long-term appreciation and rental growth.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Rent control status needs verification, which could impact future rental increases; Year built and square footage are unknown, which may affect property value and renovation costs; Broker-reported cap rate is unverified; actual financials must be confirmed before purchase</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 8.84% (unverified). Verify status, rent roll, and financials before acting.</div>
   </div>
 <div style="border-top:1px solid #e2e2e2;padding:10px 0">
-    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2414348/california-16122-san-fernando-mission-boulevard">16122 San Fernando Mission Boulevard</a>, Granada Hills</b> &nbsp;<span style="color:#888;font-weight:400">score 53</span></div>
-    <div style="color:#666;font-size:12px">Multifamily · 3 units · built 1954 · $1,298,000 · cap 6.66% (broker cap)</div>
-    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$356,950</b> (in budget) · CoC <span style="color:#178a3a">2.99%</span> · DSCR 1.14 · est NOI $86,447</div>
-    <div style="font-size:13px;color:#222;margin:4px 0">This triplex in Granada Hills offers a value-add opportunity with a strong cap rate and potential for increased rental income through re-leasing the vacant JADU and ADU units. The property is well-positioned for stabilization and appreciation in a growing market.</div>
-    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Occupancy and lease-up risk for the JADU and ADU units, which are currently unoccupied and may take time to re-lease.; Uncertainty around in-place income, as the reported NOI is based on seller-provided data and not verified.; Light expense assumptions may not reflect long-term stabilized costs, potentially impacting cash flow.</div>
-    <div style="font-size:12px;color:#555">DD-CHECKED (True North Realty / MLS SR26083260): renovated front duplex + new-2024 detached ADU. Seller NOI $86,496 -> ~6.66% cap, but that is PRO-FORMA: only the main unit ($3,390/mo) is currently rented; the JADU ($1,990) and ADU ($3,100) are 'previously rented' = lease-up/occupancy risk. Expenses light (~$15.3k: ins $3k + tax $7.5k, RUBS) with NO vacancy/management/reserves -> real stabilized NOI lower. Was in escrow at $1.30M (fell out). NOT marked verified: income is seller/prior, not confirmed in-place. Positive leverage IF re-leased.</div>
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2598330/california-9709-willis">9709 Willis</a>, North Hills</b> &nbsp;<span style="color:#888;font-weight:400">score 48</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 2 units · $1,249,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$343,475</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This 2-unit multifamily property in North Hills presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment. With a $400,000 budget, the investor can cover the down payment and closing costs, positioning them to potentially acquire a value-add asset in a desirable submarket.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> 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 property details (year built, square footage) may indicate potential hidden costs or maintenance issues</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
   </div>
 <div style="border-top:1px solid #e2e2e2;padding:10px 0">
-    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.compass.com/homedetails/7304-Canby-Ave-Reseda-CA-91335/1IO7AS_pid/">7302-7304 Canby Ave</a>, Reseda</b> &nbsp;<span style="color:#888;font-weight:400">score 52</span></div>
-    <div style="color:#666;font-size:12px">Mixed-use · 5 units · built 1926 · $1,250,000 · cap 5.96% (✓ verified in-place)</div>
-    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$343,750</b> (in budget) · CoC <span style="color:#178a3a">0.45%</span> · DSCR 1.02 · est NOI $74,500</div>
-    <div style="font-size:13px;color:#222;margin:4px 0">This mixed-use property in Reseda offers a value-add opportunity with a verified in-place cap rate of 5.96% and potential to increase to 7.8% through rent increases and commercial unit optimization. The motivated seller, seller financing, and development optionality under C2 zoning make it an attractive leveraged play for a $400k-down buyer.</div>
-    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Occupancy status is unclear and needs verification; Rent control restrictions may limit rent increases; Value-add projections depend on successful execution of tenant improvements and re-leasing</div>
-    <div style="font-size:12px;color:#555">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.</div>
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2408963/california-14143-victory-boulevard">14143 Victory Boulevard</a>, Van Nuys</b> &nbsp;<span style="color:#888;font-weight:400">score 48</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 4 units · $1,400,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$385,000</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the buyer can secure the property within budget, positioning for potential value appreciation and rental income growth in a desirable San Fernando Valley submarket.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, limiting due diligence potential; Rent control status needs verification, which could impact long-term rental income; Year built and square footage unknown, affecting property condition and value assessment</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2555977/california-14736-gilmore">14736 Gilmore</a>, Van Nuys</b> &nbsp;<span style="color:#888;font-weight:400">score 48</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 3 units · $1,395,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$383,625</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This 3-unit multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially benefiting from long-term appreciation and rental income growth in the San Fernando Valley market.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> 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 are unknown, which may affect property condition and renovation costs</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2528936/california-8435-rincon-avenue">8435 Rincon Avenue</a>, Sun Valley</b> &nbsp;<span style="color:#888;font-weight:400">score 48</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 3 units · $1,275,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$350,625</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Sun Valley presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially benefiting from long-term appreciation and rental income growth in a desirable San Fernando Valley submarket.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, making valuation and return estimation uncertain; Rent control status needs verification, which could impact rental income potential; Property age and square footage are unknown, which may affect maintenance costs and unit desirability</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2454897/california-7313-bakman-ave">7313 Bakman Ave</a>, Sun Valley</b> &nbsp;<span style="color:#888;font-weight:400">score 48</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 4 units · $1,049,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$288,475</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Sun Valley presents an opportunity for a leveraged buyer with $400k available for down 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 area of the San Fernando Valley could support rental income growth, especially if rent control is not in place and the unit mix aligns with market demand.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Cap rate is not disclosed, making it difficult to assess current returns and compare to market benchmarks; Rent control status is unverified, which could limit rental income growth potential; Financials and rent roll are not provided, increasing due diligence risk</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2412676/california-11912-elkwood-street">11912 Elkwood Street</a>, North Hollywood</b> &nbsp;<span style="color:#888;font-weight:400">score 48</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 3 units · $1,449,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$398,475</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in North Hollywood presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can fully fund the purchase, positioning them to potentially benefit from future rent growth and property appreciation in a desirable submarket.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, limiting due diligence potential; Rent control status needs verification, which could impact long-term rental income; Year built and square footage unknown, which may affect property value and maintenance costs</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/1940493/california-897-cap-191kunit-46-upside-in-prime-van-nuys">14216 Calvert St</a>, Van Nuys</b> &nbsp;<span style="color:#888;font-weight:400">score 45</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 1 unit · $1,150,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$316,250</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Van Nuys 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 acquisition and value-add through renovation or repositioning in a growing market.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, increasing uncertainty about cash flow and returns; Rent control status needs verification, which could impact rental income and long-term profitability; Property details such as year built and square footage are missing, making due diligence more challenging</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2459525/california-8010-wheatland-avenue-c">8010 Wheatland Avenue #C</a>, Sun Valley</b> &nbsp;<span style="color:#888;font-weight:400">score 45</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 1 unit · $1,050,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$288,750</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This single-unit multifamily property in Sun Valley presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a low down payment. With $400k available for down and closing, the buyer can secure a 25% down loan at 6.75% over 30 years, requiring only $288,750 in cash. The property's location in a desirable area may support long-term appreciation and rental income potential.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No financials or cap rate disclosed, making valuation and cash flow projections uncertain; Rent control status needs verification, which could impact rental income and tenant stability; Single-unit properties are more vulnerable to vacancies and less diversified compared to larger multifamily assets</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2406533/california-8446-bradley-avenue">8446 Bradley Avenue</a>, Sun Valley</b> &nbsp;<span style="color:#888;font-weight:400">score 45</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 2 units · $989,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$271,975</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This 2-unit multifamily property in Sun Valley presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, leaving room for closing costs and potential value-add strategies. The property's location in a desirable neighborhood may support rental income growth and long-term appreciation.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, increasing uncertainty about cash flow and profitability; Rent control status needs verification, which could impact rental income potential; Lack of property details (year built, square footage) may indicate older or less desirable units</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2599666/california-17615-kingsbury">17615 Kingsbury</a>, Granada Hills</b> &nbsp;<span style="color:#888;font-weight:400">score 45</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 4 units · $1,350,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$371,250</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Granada Hills presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the investor can secure the property within budget, positioning themselves to potentially benefit from long-term appreciation and rental income growth in a desirable San Fernando Valley submarket.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, making valuation and return estimation speculative; Rent control status needs verification, which could impact rental income potential; Property details such as year built and square footage are missing, increasing due diligence risk</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2406488/california-10204-gerald-avenue">10204 Gerald Avenue</a>, North Hills</b> &nbsp;<span style="color:#888;font-weight:400">score 45</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 1 unit · $1,199,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$329,725</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in North Hills 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 appreciation and long-term rental income in a desirable San Fernando Valley submarket.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, making valuation and return estimation uncertain; Rent control status needs verification, which could impact rental income potential; Property details such as year built and square footage are missing, increasing due diligence risk</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2516555/california-9916-whitaker-avenue">9916 Whitaker Avenue</a>, North Hills</b> &nbsp;<span style="color:#888;font-weight:400">score 42</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 1 unit · $1,099,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$302,225</b> (in budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This single-unit multifamily property in North Hills presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a low down payment. With $400,000 available for down and closing costs, the buyer can secure a fully funded purchase at a computed 25% down payment, leaving room for contingencies and potential value-add opportunities.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No cap rate or financials disclosed, making valuation and return estimation speculative; Rent control status needs verification, which could impact long-term rental income potential; Single-unit properties may have higher vacancy and maintenance risks compared to larger multifamily assets</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2593838/california-14642-calvert">14642 Calvert</a>, Van Nuys</b> &nbsp;<span style="color:#888;font-weight:400">score 33</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 4 units · $1,475,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$405,625</b> (OVER budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This 4-unit multifamily property in Van Nuys presents an opportunity for a leveraged investor to acquire a rental asset in a desirable San Fernando Valley submarket. With a $400,000 budget, the investor could potentially secure a fully funded purchase if closing costs and down payment are optimized, though the lack of disclosed cap rate and financials introduces uncertainty.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> No financials or cap rate disclosed, making due diligence critical; Potential rent control implications affecting long-term cash flow; Uncertain property condition and unit size, which could impact value and renovation costs</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2599659/california-7445-oakdale-avenue">7445 Oakdale Avenue</a>, Winnetka</b> &nbsp;<span style="color:#888;font-weight:400">score 31</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 3 units · $1,750,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$481,250</b> (OVER budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Winnetka presents an opportunity for a value-add investor seeking to acquire a small-scale asset in a desirable San Fernando Valley neighborhood. With a $400,000 budget, the investor may need to negotiate the purchase price or secure additional financing to meet the down payment and closing cost requirements.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Insufficient capital to meet the computed down payment and closing costs without additional financing or price negotiation; Lack of disclosed cap rate and financials increases uncertainty around cash flow and return potential; Rent control verification is required, which may impact rental income and long-term appreciation</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2411079/california-5701-corbin-avenue">5701 Corbin Avenue</a>, Tarzana</b> &nbsp;<span style="color:#888;font-weight:400">score 28</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 1 unit · $1,659,000 · cap — (no income data)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$456,225</b> (OVER budget) · CoC <span style="color:#b00">n/a</span> · DSCR n/a · est NOI n/d</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This single-unit multifamily property in Tarzana presents a potential opportunity for a leveraged investor seeking a high-end rental in a desirable area. However, the required down payment and closing costs exceed the available budget, necessitating careful evaluation of financing options and potential value-add strategies.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Insufficient down payment to meet the computed $456,225 requirement; No disclosed cap rate or financials, increasing uncertainty; Rent control status needs verification, which could impact long-term rental income</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2488797/california-7410-vineland-avenue">7410 Vineland Avenue</a>, Sun Valley</b> &nbsp;<span style="color:#888;font-weight:400">score 22</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 4 units · $1,150,000 · cap 4.75% (broker cap)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$316,250</b> (in budget) · CoC <span style="color:#b00">-3.95%</span> · DSCR 0.81 · est NOI $54,625</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This 4-unit multifamily property in Sun Valley offers an entry point into the San Fernando Valley market with a verified 4.75% cap rate, suggesting potential for stable cash flow. With a $400,000 budget covering down payment and closing costs, the investment is feasible, though the negative cash-on-cash return and low DSCR indicate the need for careful evaluation of financials and rent roll.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Negative cash-on-cash return (-3.95%) indicates potential cash outflow in the initial years; Low DSCR (0.81) suggests potential debt service risk; Rent control status and unit-specific financials need verification before purchase</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 4.75% (unverified). Verify status, rent roll, and financials before acting.</div>
+  </div>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#0a7d2c;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">NEW</span><b><a href="https://www.crexi.com/properties/2448190/california-7245-bakman">7245 Bakman</a>, Sun Valley</b> &nbsp;<span style="color:#888;font-weight:400">score 18</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 6 units · $1,565,000 · cap 5.4% (broker cap)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$430,375</b> (OVER budget) · CoC <span style="color:#b00">-1.59%</span> · DSCR 0.93 · est NOI $84,510</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This multifamily property in Sun Valley offers an opportunity to acquire a 6-unit asset with a verified 5.4% cap rate, suggesting potential for stable cash flow and long-term appreciation. However, the required down payment and closing costs exceed the $400k budget, necessitating careful evaluation of financing options and potential value-add strategies.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Insufficient down payment to meet the computed $430,375 requirement; Unverified rent control status may impact rental income and tenant retention; Negative cash-on-cash return (-1.59%) and low DSCR (0.93) indicate potential cash flow and debt service risks</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 5.4% (unverified). Verify status, rent roll, and financials before acting.</div>
   </div>
 
-<h3 style="margin:20px 0 4px;font-size:15px">🔥 Red-hot opportunities (1)</h3>
+<h3 style="margin:20px 0 4px;font-size:15px">🔥 Red-hot opportunities (2)</h3>
+<div style="border-top:1px solid #e2e2e2;padding:10px 0">
+    <div style="font-size:14px"><span style="background:#c81e1e;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">🔥 HOT</span><b><a href="https://www.crexi.com/properties/1834484/california-5335-harmony-ave">5335 Harmony Avenue</a>, North Hollywood</b> &nbsp;<span style="color:#888;font-weight:400">score 76</span></div>
+    <div style="color:#666;font-size:12px">Multifamily · 8 units · $1,195,000 · cap 8.84% (broker cap)</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>$328,625</b> (in budget) · CoC <span style="color:#178a3a">10.92%</span> · DSCR 1.51 · est NOI $105,638</div>
+    <div style="font-size:13px;color:#222;margin:4px 0">This 8-unit multifamily property in North Hollywood offers an attractive 8.84% cap rate with a calculated 10.92% cash-on-cash return using a 25% down payment. The property is positioned in a strong submarket with potential for long-term appreciation and rental growth.</div>
+    <div style="font-size:12px;color:#a15c00;margin:4px 0"><b>Risks:</b> Rent control status needs verification, which could impact future rental increases; Year built and square footage are unknown, which may affect property value and renovation costs; Broker-reported cap rate is unverified; actual financials must be confirmed before purchase</div>
+    <div style="font-size:12px;color:#555">Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 8.84% (unverified). Verify status, rent roll, and financials before acting.</div>
+  </div>
 <div style="border-top:1px solid #e2e2e2;padding:10px 0">
     <div style="font-size:14px"><span style="background:#c81e1e;color:#fff;font-size:10px;font-weight:700;padding:2px 6px;border-radius:3px;margin-right:6px;vertical-align:middle">🔥 HOT</span><b><a href="https://www.compass.com/homedetails/7304-Canby-Ave-Reseda-CA-91335/1IO7AS_pid/">7302-7304 Canby Ave</a>, Reseda</b> &nbsp;<span style="color:#888;font-weight:400">score 52</span></div>
     <div style="color:#666;font-size:12px">Mixed-use · 5 units · built 1926 · $1,250,000 · cap 5.96% (✓ verified in-place)</div>
diff --git a/data/last-refresh.json b/data/last-refresh.json
index 5523a80..8ecf8b7 100644
--- a/data/last-refresh.json
+++ b/data/last-refresh.json
@@ -1,6 +1,6 @@
 {
-  "date": "2026-06-23",
-  "captured": 100,
-  "candidates": 31,
-  "added": 4
+  "date": "2026-06-26",
+  "captured": 188,
+  "candidates": 68,
+  "added": 18
 }
\ No newline at end of file
diff --git a/data/listings.json b/data/listings.json
index d81a395..82253a6 100644
--- a/data/listings.json
+++ b/data/listings.json
@@ -1557,6 +1557,312 @@
       "status": "Active",
       "upside_note": "Auto-added by weekly Crexi refresh 2026-06-23. Cap not disclosed. Verify status, rent roll, and financials before acting.",
       "source": "https://www.crexi.com/properties/2492613/california-9010-wilbur-avenue"
+    },
+    {
+      "id": "crx1834484",
+      "address": "5335 Harmony Avenue",
+      "city": "North Hollywood",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1195000,
+      "units": 8,
+      "sqft": null,
+      "cap_rate": 8.84,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 8.84% (unverified). Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/1834484/california-5335-harmony-ave"
+    },
+    {
+      "id": "crx2598330",
+      "address": "9709 Willis",
+      "city": "North Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1249000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2598330/california-9709-willis"
+    },
+    {
+      "id": "crx2599659",
+      "address": "7445 Oakdale Avenue",
+      "city": "Winnetka",
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2599659/california-7445-oakdale-avenue"
+    },
+    {
+      "id": "crx2411079",
+      "address": "5701 Corbin Avenue",
+      "city": "Tarzana",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1659000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2411079/california-5701-corbin-avenue"
+    },
+    {
+      "id": "crx2593838",
+      "address": "14642 Calvert",
+      "city": "Van Nuys",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1475000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2593838/california-14642-calvert"
+    },
+    {
+      "id": "crx1940493",
+      "address": "14216 Calvert St",
+      "city": "Van Nuys",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1150000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/1940493/california-897-cap-191kunit-46-upside-in-prime-van-nuys"
+    },
+    {
+      "id": "crx2408963",
+      "address": "14143 Victory Boulevard",
+      "city": "Van Nuys",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1400000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2408963/california-14143-victory-boulevard"
+    },
+    {
+      "id": "crx2555977",
+      "address": "14736 Gilmore",
+      "city": "Van Nuys",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1395000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2555977/california-14736-gilmore"
+    },
+    {
+      "id": "crx2459525",
+      "address": "8010 Wheatland Avenue #C",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1050000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2459525/california-8010-wheatland-avenue-c"
+    },
+    {
+      "id": "crx2528936",
+      "address": "8435 Rincon Avenue",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1275000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2528936/california-8435-rincon-avenue"
+    },
+    {
+      "id": "crx2454897",
+      "address": "7313 Bakman Ave",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1049000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2454897/california-7313-bakman-ave"
+    },
+    {
+      "id": "crx2448190",
+      "address": "7245 Bakman",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1565000,
+      "units": 6,
+      "sqft": null,
+      "cap_rate": 5.4,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 5.4% (unverified). Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2448190/california-7245-bakman"
+    },
+    {
+      "id": "crx2412676",
+      "address": "11912 Elkwood Street",
+      "city": "North Hollywood",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1449000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2412676/california-11912-elkwood-street"
+    },
+    {
+      "id": "crx2406533",
+      "address": "8446 Bradley Avenue",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 989000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2406533/california-8446-bradley-avenue"
+    },
+    {
+      "id": "crx2488797",
+      "address": "7410 Vineland Avenue",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1150000,
+      "units": 4,
+      "sqft": null,
+      "cap_rate": 4.75,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 4.75% (unverified). Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2488797/california-7410-vineland-avenue"
+    },
+    {
+      "id": "crx2599666",
+      "address": "17615 Kingsbury",
+      "city": "Granada Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1350000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2599666/california-17615-kingsbury"
+    },
+    {
+      "id": "crx2406488",
+      "address": "10204 Gerald Avenue",
+      "city": "North Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1199000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2406488/california-10204-gerald-avenue"
+    },
+    {
+      "id": "crx2516555",
+      "address": "9916 Whitaker Avenue",
+      "city": "North Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1099000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2516555/california-9916-whitaker-avenue"
     }
   ]
 }
\ No newline at end of file
diff --git a/data/qwen-cache.json b/data/qwen-cache.json
index d94af89..8ccfa0e 100644
--- a/data/qwen-cache.json
+++ b/data/qwen-cache.json
@@ -1629,5 +1629,347 @@
       "recommendation": "Watch"
     },
     "qwenScore": 65
+  },
+  "crx1834484": {
+    "key": "6c32084686c7",
+    "qwen": {
+      "thesis": "This 8-unit multifamily property in North Hollywood offers an attractive 8.84% cap rate with a calculated 10.92% cash-on-cash return using a 25% down payment. The property is positioned in a strong submarket with potential for long-term appreciation and rental growth.",
+      "risks": [
+        "Rent control status needs verification, which could impact future rental increases",
+        "Year built and square footage are unknown, which may affect property value and renovation costs",
+        "Broker-reported cap rate is unverified; actual financials must be confirmed before purchase"
+      ],
+      "upside": [
+        "Strong cap rate and cash-on-cash return provide immediate income potential",
+        "North Hollywood is a growing area with demand for multifamily housing",
+        "Potential for value-add through unit upgrades or rent increases post-verification"
+      ],
+      "opportunity_score": 75,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 75
+  },
+  "crx2598330": {
+    "key": "0e6be6818712",
+    "qwen": {
+      "thesis": "This 2-unit multifamily property in North Hills presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment. With a $400,000 budget, the investor can cover the down payment and closing costs, positioning them to potentially acquire a value-add asset in a desirable submarket.",
+      "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 property details (year built, square footage) may indicate potential hidden costs or maintenance issues"
+      ],
+      "upside": [
+        "Potential for value-add through unit upgrades or rental rate increases",
+        "Strategic location in North Hills offers strong long-term appreciation potential",
+        "Leverage available to amplify returns if financials prove favorable"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2599659": {
+    "key": "61e74941166c",
+    "qwen": {
+      "thesis": "This multifamily property in Winnetka presents an opportunity for a value-add investor seeking to acquire a small-scale asset in a desirable San Fernando Valley neighborhood. With a $400,000 budget, the investor may need to negotiate the purchase price or secure additional financing to meet the down payment and closing cost requirements.",
+      "risks": [
+        "Insufficient capital to meet the computed down payment and closing costs without additional financing or price negotiation",
+        "Lack of disclosed cap rate and financials increases uncertainty around cash flow and return potential",
+        "Rent control verification is required, which may impact rental income and long-term appreciation"
+      ],
+      "upside": [
+        "Winnetka is a high-demand area with strong rental market fundamentals and potential for appreciation",
+        "Small multifamily units can be repositioned or improved for increased NOI and value-add opportunities",
+        "Potential for long-term equity growth if the property is acquired at a discount or through favorable terms"
+      ],
+      "opportunity_score": 55,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 55
+  },
+  "crx2411079": {
+    "key": "859a2ae2b4de",
+    "qwen": {
+      "thesis": "This single-unit multifamily property in Tarzana presents a potential opportunity for a leveraged investor seeking a high-end rental in a desirable area. However, the required down payment and closing costs exceed the available budget, necessitating careful evaluation of financing options and potential value-add strategies.",
+      "risks": [
+        "Insufficient down payment to meet the computed $456,225 requirement",
+        "No disclosed cap rate or financials, increasing uncertainty",
+        "Rent control status needs verification, which could impact long-term rental income"
+      ],
+      "upside": [
+        "Potential for value appreciation in the Tarzana market",
+        "High-end unit may command premium rent if properly marketed",
+        "Opportunity to reposition or renovate for increased cash flow"
+      ],
+      "opportunity_score": 50,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 50
+  },
+  "crx2593838": {
+    "key": "b699fcde0121",
+    "qwen": {
+      "thesis": "This 4-unit multifamily property in Van Nuys presents an opportunity for a leveraged investor to acquire a rental asset in a desirable San Fernando Valley submarket. With a $400,000 budget, the investor could potentially secure a fully funded purchase if closing costs and down payment are optimized, though the lack of disclosed cap rate and financials introduces uncertainty.",
+      "risks": [
+        "No financials or cap rate disclosed, making due diligence critical",
+        "Potential rent control implications affecting long-term cash flow",
+        "Uncertain property condition and unit size, which could impact value and renovation costs"
+      ],
+      "upside": [
+        "Strategic location in Van Nuys with strong demand for multifamily housing",
+        "Potential for value-add through renovations or rent increases",
+        "Opportunity to build a diversified multifamily portfolio with a relatively small initial investment"
+      ],
+      "opportunity_score": 60,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 60
+  },
+  "crx1940493": {
+    "key": "11abed562185",
+    "qwen": {
+      "thesis": "This multifamily property in Van Nuys 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 acquisition and value-add through renovation or repositioning in a growing market.",
+      "risks": [
+        "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+        "Rent control status needs verification, which could impact rental income and long-term profitability",
+        "Property details such as year built and square footage are missing, making due diligence more challenging"
+      ],
+      "upside": [
+        "Potential for value-add through renovation in a desirable San Fernando Valley location",
+        "Leverage available to increase returns if cash flow and cap rate are favorable post-acquisition",
+        "Opportunity to secure a property in a competitive market before it is fully vetted by other buyers"
+      ],
+      "opportunity_score": 60,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 60
+  },
+  "crx2408963": {
+    "key": "d4bb80d2f9a6",
+    "qwen": {
+      "thesis": "This multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the buyer can secure the property within budget, positioning for potential value appreciation and rental income growth in a desirable San Fernando Valley submarket.",
+      "risks": [
+        "No cap rate or financials disclosed, limiting due diligence potential",
+        "Rent control status needs verification, which could impact long-term rental income",
+        "Year built and square footage unknown, affecting property condition and value assessment"
+      ],
+      "upside": [
+        "Potential for rental income growth in a stable and growing submarket",
+        "Opportunity to acquire a 4-unit property at a potentially attractive price point",
+        "Leverage available to maximize returns with a lower down payment"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2555977": {
+    "key": "5b3621b5d5dd",
+    "qwen": {
+      "thesis": "This 3-unit multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially benefiting from long-term appreciation and rental income growth in the San Fernando Valley market.",
+      "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 are unknown, which may affect property condition and renovation costs"
+      ],
+      "upside": [
+        "Potential for value-add through renovations or rent increases if the property is undervalued",
+        "Strong demand for multifamily units in the San Fernando Valley",
+        "Leverage available to amplify returns with a 25% down payment"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2459525": {
+    "key": "7ffc866a449e",
+    "qwen": {
+      "thesis": "This single-unit multifamily property in Sun Valley presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a low down payment. With $400k available for down and closing, the buyer can secure a 25% down loan at 6.75% over 30 years, requiring only $288,750 in cash. The property's location in a desirable area may support long-term appreciation and rental income potential.",
+      "risks": [
+        "No financials or cap rate disclosed, making valuation and cash flow projections uncertain",
+        "Rent control status needs verification, which could impact rental income and tenant stability",
+        "Single-unit properties are more vulnerable to vacancies and less diversified compared to larger multifamily assets"
+      ],
+      "upside": [
+        "Potential for appreciation in a growing Sun Valley market",
+        "Ability to leverage a relatively small down payment for a larger asset",
+        "Opportunity to build a portfolio with a strategic first acquisition"
+      ],
+      "opportunity_score": 60,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 60
+  },
+  "crx2528936": {
+    "key": "464219e8ea1c",
+    "qwen": {
+      "thesis": "This multifamily property in Sun Valley presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially benefiting from long-term appreciation and rental income growth in a desirable San Fernando Valley submarket.",
+      "risks": [
+        "No cap rate or financials disclosed, making valuation and return estimation uncertain",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Property age and square footage are unknown, which may affect maintenance costs and unit desirability"
+      ],
+      "upside": [
+        "Potential for value-add through unit upgrades or tenant improvements",
+        "Strategic location in Sun Valley may offer strong demand and appreciation potential",
+        "Leverage available to amplify returns if financials and cap rate prove favorable"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2454897": {
+    "key": "fd541cdf53da",
+    "qwen": {
+      "thesis": "This multifamily property in Sun Valley presents an opportunity for a leveraged buyer with $400k available for down 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 area of the San Fernando Valley could support rental income growth, especially if rent control is not in place and the unit mix aligns with market demand.",
+      "risks": [
+        "Cap rate is not disclosed, making it difficult to assess current returns and compare to market benchmarks",
+        "Rent control status is unverified, which could limit rental income growth potential",
+        "Financials and rent roll are not provided, increasing due diligence risk"
+      ],
+      "upside": [
+        "Potential for rental income growth in a strong submarket like Sun Valley",
+        "Opportunity to acquire a 4-unit property with leverage, enabling scale and diversification",
+        "Possibility of value-add through unit upgrades or tenant retention strategies"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2448190": {
+    "key": "00d600d287c0",
+    "qwen": {
+      "thesis": "This multifamily property in Sun Valley offers an opportunity to acquire a 6-unit asset with a verified 5.4% cap rate, suggesting potential for stable cash flow and long-term appreciation. However, the required down payment and closing costs exceed the $400k budget, necessitating careful evaluation of financing options and potential value-add strategies.",
+      "risks": [
+        "Insufficient down payment to meet the computed $430,375 requirement",
+        "Unverified rent control status may impact rental income and tenant retention",
+        "Negative cash-on-cash return (-1.59%) and low DSCR (0.93) indicate potential cash flow and debt service risks"
+      ],
+      "upside": [
+        "Verified cap rate suggests potential for value appreciation",
+        "Sun Valley's location offers strong long-term growth potential",
+        "Opportunity to reposition the property through value-add improvements or rent increases"
+      ],
+      "opportunity_score": 55,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 55
+  },
+  "crx2412676": {
+    "key": "0fac6bf3df8d",
+    "qwen": {
+      "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can fully fund the purchase, positioning them to potentially benefit from future rent growth and property appreciation in a desirable submarket.",
+      "risks": [
+        "No cap rate or financials disclosed, limiting due diligence potential",
+        "Rent control status needs verification, which could impact long-term rental income",
+        "Year built and square footage unknown, which may affect property value and maintenance costs"
+      ],
+      "upside": [
+        "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+        "Strategic location in North Hollywood, a growing and stable submarket",
+        "Leverage available to amplify returns if financials prove favorable"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2406533": {
+    "key": "9751a822c48a",
+    "qwen": {
+      "thesis": "This 2-unit multifamily property in Sun Valley presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, leaving room for closing costs and potential value-add strategies. The property's location in a desirable neighborhood may support rental income growth and long-term appreciation.",
+      "risks": [
+        "No cap rate or financials disclosed, increasing uncertainty about cash flow and profitability",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Lack of property details (year built, square footage) may indicate older or less desirable units"
+      ],
+      "upside": [
+        "Potential for value-add through unit upgrades or rental rate increases",
+        "Location in Sun Valley offers strong demand for multifamily housing",
+        "Leverage available with 25% down, allowing for higher returns if cash flow assumptions are met"
+      ],
+      "opportunity_score": 60,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 60
+  },
+  "crx2488797": {
+    "key": "e56aa9e863c7",
+    "qwen": {
+      "thesis": "This 4-unit multifamily property in Sun Valley offers an entry point into the San Fernando Valley market with a verified 4.75% cap rate, suggesting potential for stable cash flow. With a $400,000 budget covering down payment and closing costs, the investment is feasible, though the negative cash-on-cash return and low DSCR indicate the need for careful evaluation of financials and rent roll.",
+      "risks": [
+        "Negative cash-on-cash return (-3.95%) indicates potential cash outflow in the initial years",
+        "Low DSCR (0.81) suggests potential debt service risk",
+        "Rent control status and unit-specific financials need verification before purchase"
+      ],
+      "upside": [
+        "Potential for value-add through rent increases or unit improvements",
+        "Strategic location in Sun Valley with strong demand for multifamily housing",
+        "Leverage available with 25% down and 6.75% fixed-rate financing"
+      ],
+      "opportunity_score": 55,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 55
+  },
+  "crx2599666": {
+    "key": "b8e9a7292286",
+    "qwen": {
+      "thesis": "This multifamily property in Granada Hills presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the investor can secure the property within budget, positioning themselves to potentially benefit from long-term appreciation and rental income growth in a desirable San Fernando Valley submarket.",
+      "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 details such as year built and square footage are missing, increasing due diligence risk"
+      ],
+      "upside": [
+        "Potential for value-add through renovations or repositioning in a growing area",
+        "Leverage available to amplify returns if the property performs well",
+        "Strategic location in Granada Hills may offer strong demand and stability"
+      ],
+      "opportunity_score": 60,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 60
+  },
+  "crx2406488": {
+    "key": "92023b9a1988",
+    "qwen": {
+      "thesis": "This multifamily property in North Hills 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 appreciation and long-term rental income in a desirable San Fernando Valley submarket.",
+      "risks": [
+        "No cap rate or financials disclosed, making valuation and return estimation uncertain",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Property details such as year built and square footage are missing, increasing due diligence risk"
+      ],
+      "upside": [
+        "Potential for value-add through renovation or repositioning in a growing area",
+        "Leverage available to amplify returns if financials prove favorable",
+        "Strategic location in North Hills may offer strong long-term appreciation"
+      ],
+      "opportunity_score": 60,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 60
+  },
+  "crx2516555": {
+    "key": "f15deb934690",
+    "qwen": {
+      "thesis": "This single-unit multifamily property in North Hills presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a low down payment. With $400,000 available for down and closing costs, the buyer can secure a fully funded purchase at a computed 25% down payment, leaving room for contingencies and potential value-add opportunities.",
+      "risks": [
+        "No cap rate or financials disclosed, making valuation and return estimation speculative",
+        "Rent control status needs verification, which could impact long-term rental income potential",
+        "Single-unit properties may have higher vacancy and maintenance risks compared to larger multifamily assets"
+      ],
+      "upside": [
+        "Potential for value appreciation in a growing North Hills market",
+        "Opportunity to reposition or renovate the unit for higher rental income",
+        "Leverage available to increase returns if market conditions improve"
+      ],
+      "opportunity_score": 55,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 55
   }
 }
\ No newline at end of file
diff --git a/data/ranked.json b/data/ranked.json
index d417227..cc88012 100644
--- a/data/ranked.json
+++ b/data/ranked.json
@@ -23,6 +23,57 @@
   },
   "generated": null,
   "ranked": [
+    {
+      "id": "crx1834484",
+      "address": "5335 Harmony Avenue",
+      "city": "North Hollywood",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1195000,
+      "units": 8,
+      "sqft": null,
+      "cap_rate": 8.84,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 8.84% (unverified). Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/1834484/california-5335-harmony-ave",
+      "finance": {
+        "down": 298750,
+        "closing": 29875,
+        "cashNeeded": 328625,
+        "loan": 896250,
+        "annualDebtService": 69757,
+        "noi": 105638,
+        "cashFlow": 35881,
+        "coc": 10.92,
+        "dscr": 1.51,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 95,
+      "financeConf": "high",
+      "qwen": {
+        "thesis": "This 8-unit multifamily property in North Hollywood offers an attractive 8.84% cap rate with a calculated 10.92% cash-on-cash return using a 25% down payment. The property is positioned in a strong submarket with potential for long-term appreciation and rental growth.",
+        "risks": [
+          "Rent control status needs verification, which could impact future rental increases",
+          "Year built and square footage are unknown, which may affect property value and renovation costs",
+          "Broker-reported cap rate is unverified; actual financials must be confirmed before purchase"
+        ],
+        "upside": [
+          "Strong cap rate and cash-on-cash return provide immediate income potential",
+          "North Hollywood is a growing area with demand for multifamily housing",
+          "Potential for value-add through unit upgrades or rent increases post-verification"
+        ],
+        "opportunity_score": 75,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 75,
+      "composite": 76,
+      "rank": 1
+    },
     {
       "id": "crx2553265",
       "address": "9350 Tampa",
@@ -72,7 +123,7 @@
       },
       "qwenScore": 65,
       "composite": 54,
-      "rank": 1
+      "rank": 2
     },
     {
       "id": "crx2414348",
@@ -147,7 +198,7 @@
       },
       "qwenScore": 72,
       "composite": 53,
-      "rank": 2
+      "rank": 3
     },
     {
       "id": "canby7304",
@@ -231,7 +282,7 @@
       },
       "qwenScore": 72,
       "composite": 52,
-      "rank": 3
+      "rank": 4
     },
     {
       "id": "sepulveda10011",
@@ -281,7 +332,7 @@
       },
       "qwenScore": 72,
       "composite": 51,
-      "rank": 4
+      "rank": 5
     },
     {
       "id": "foothill6851",
@@ -331,7 +382,7 @@
       },
       "qwenScore": 72,
       "composite": 51,
-      "rank": 5
+      "rank": 6
     },
     {
       "id": "schoenborn17920",
@@ -417,7 +468,7 @@
       },
       "qwenScore": 65,
       "composite": 49,
-      "rank": 6
+      "rank": 7
     },
     {
       "id": "tilden8843",
@@ -467,7 +518,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 7
+      "rank": 8
     },
     {
       "id": "sanfernando10004",
@@ -517,7 +568,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 8
+      "rank": 9
     },
     {
       "id": "sherman21627",
@@ -568,7 +619,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 9
+      "rank": 10
     },
     {
       "id": "owensmouth7129",
@@ -618,7 +669,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 10
+      "rank": 11
     },
     {
       "id": "crx2412240",
@@ -669,7 +720,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 11
+      "rank": 12
     },
     {
       "id": "crx2413606",
@@ -720,7 +771,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 12
+      "rank": 13
     },
     {
       "id": "crx2586908",
@@ -771,7 +822,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 13
+      "rank": 14
     },
     {
       "id": "crx2404653",
@@ -822,7 +873,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 14
+      "rank": 15
     },
     {
       "id": "crx2407231",
@@ -873,7 +924,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 15
+      "rank": 16
     },
     {
       "id": "crx2413131",
@@ -924,7 +975,7 @@
       },
       "qwenScore": 60,
       "composite": 48,
-      "rank": 16
+      "rank": 17
     },
     {
       "id": "crx2568125",
@@ -975,7 +1026,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 17
+      "rank": 18
     },
     {
       "id": "crx2159323",
@@ -1026,7 +1077,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 18
+      "rank": 19
     },
     {
       "id": "crx2516747",
@@ -1077,7 +1128,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 19
+      "rank": 20
     },
     {
       "id": "crx2589903",
@@ -1128,7 +1179,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 20
+      "rank": 21
     },
     {
       "id": "crx1080991",
@@ -1179,7 +1230,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 21
+      "rank": 22
     },
     {
       "id": "crx2413872",
@@ -1230,7 +1281,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 22
+      "rank": 23
     },
     {
       "id": "crx2412328",
@@ -1281,7 +1332,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 23
+      "rank": 24
     },
     {
       "id": "crx2516918",
@@ -1332,7 +1383,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 24
+      "rank": 25
     },
     {
       "id": "crx2450078",
@@ -1383,7 +1434,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 25
+      "rank": 26
     },
     {
       "id": "crx2595754",
@@ -1434,7 +1485,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 26
+      "rank": 27
     },
     {
       "id": "crx2411991",
@@ -1485,7 +1536,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 27
+      "rank": 28
     },
     {
       "id": "crx2461695",
@@ -1536,7 +1587,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 28
+      "rank": 29
     },
     {
       "id": "crx2559966",
@@ -1587,7 +1638,7 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 29
+      "rank": 30
     },
     {
       "id": "crx2492613",
@@ -1638,30 +1689,30 @@
       },
       "qwenScore": 65,
       "composite": 48,
-      "rank": 30
+      "rank": 31
     },
     {
-      "id": "crx2453716",
-      "address": "8045 Darby",
-      "city": "Reseda",
+      "id": "crx2598330",
+      "address": "9709 Willis",
+      "city": "North Hills",
       "zip": "",
       "type": "Multifamily",
-      "price": 1399000,
-      "units": 3,
+      "price": 1249000,
+      "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/2453716/california-8045-darby",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2598330/california-9709-willis",
       "finance": {
-        "down": 349750,
-        "closing": 34975,
-        "cashNeeded": 384725,
-        "loan": 1049250,
-        "annualDebtService": 81665,
+        "down": 312250,
+        "closing": 31225,
+        "cashNeeded": 343475,
+        "loan": 936750,
+        "annualDebtService": 72909,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -1673,45 +1724,46 @@
       "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.",
+        "thesis": "This 2-unit multifamily property in North Hills presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment. With a $400,000 budget, the investor can cover the down payment and closing costs, positioning them to potentially acquire a value-add asset in a desirable submarket.",
         "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."
+          "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 property details (year built, square footage) may indicate potential hidden costs or maintenance issues"
         ],
         "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."
+          "Potential for value-add through unit upgrades or rental rate increases",
+          "Strategic location in North Hills offers strong long-term appreciation potential",
+          "Leverage available to amplify returns if financials prove favorable"
         ],
-        "opportunity_score": 60,
+        "opportunity_score": 65,
         "recommendation": "Watch"
       },
-      "qwenScore": 60,
-      "composite": 45,
-      "rank": 31
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 32
     },
     {
-      "id": "crx2442308",
-      "address": "18216 Hartland Street",
-      "city": "Reseda",
+      "id": "crx2408963",
+      "address": "14143 Victory Boulevard",
+      "city": "Van Nuys",
       "zip": "",
       "type": "Multifamily",
-      "price": 1399000,
-      "units": 3,
+      "price": 1400000,
+      "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/2442308/california-18216-hartland-street",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2408963/california-14143-victory-boulevard",
       "finance": {
-        "down": 349750,
-        "closing": 34975,
-        "cashNeeded": 384725,
-        "loan": 1049250,
-        "annualDebtService": 81665,
+        "down": 350000,
+        "closing": 35000,
+        "cashNeeded": 385000,
+        "loan": 1050000,
+        "annualDebtService": 81723,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -1723,46 +1775,46 @@
       "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.",
+        "thesis": "This multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the buyer can secure the property within budget, positioning for potential value appreciation and rental income growth 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 rental income potential",
-          "Lack of unit and square footage details makes it difficult to assess property condition and efficiency"
+          "No cap rate or financials disclosed, limiting due diligence potential",
+          "Rent control status needs verification, which could impact long-term rental income",
+          "Year built and square footage unknown, affecting property condition and value assessment"
         ],
         "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"
+          "Potential for rental income growth in a stable and growing submarket",
+          "Opportunity to acquire a 4-unit property at a potentially attractive price point",
+          "Leverage available to maximize returns with a lower down payment"
         ],
-        "opportunity_score": 60,
+        "opportunity_score": 65,
         "recommendation": "Watch"
       },
-      "qwenScore": 60,
-      "composite": 45,
-      "rank": 32
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 33
     },
     {
-      "id": "crx2413973",
-      "address": "5658 Willowcrest Ave",
-      "city": "North Hollywood",
+      "id": "crx2555977",
+      "address": "14736 Gilmore",
+      "city": "Van Nuys",
       "zip": "",
       "type": "Multifamily",
-      "price": 998000,
-      "units": 2,
+      "price": 1395000,
+      "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/2413973/california-5658-willowcrest-ave",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2555977/california-14736-gilmore",
       "finance": {
-        "down": 249500,
-        "closing": 24950,
-        "cashNeeded": 274450,
-        "loan": 748500,
-        "annualDebtService": 58257,
+        "down": 348750,
+        "closing": 34875,
+        "cashNeeded": 383625,
+        "loan": 1046250,
+        "annualDebtService": 81431,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -1774,46 +1826,46 @@
       "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.",
+        "thesis": "This 3-unit multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially benefiting from long-term appreciation and rental income growth in the San Fernando Valley market.",
         "risks": [
-          "No cap rate or financials disclosed, making valuation and ROI estimation uncertain",
+          "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 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"
+          "Potential for value-add through renovations or rent increases if the property is undervalued",
+          "Strong demand for multifamily units in the San Fernando Valley",
+          "Leverage available to amplify returns with a 25% down payment"
         ],
-        "opportunity_score": 60,
+        "opportunity_score": 65,
         "recommendation": "Watch"
       },
-      "qwenScore": 60,
-      "composite": 45,
-      "rank": 33
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 34
     },
     {
-      "id": "crx2413947",
-      "address": "14722 Strathern",
-      "city": "Panorama City",
+      "id": "crx2528936",
+      "address": "8435 Rincon Avenue",
+      "city": "Sun Valley",
       "zip": "",
       "type": "Multifamily",
-      "price": 1145000,
-      "units": 2,
+      "price": 1275000,
+      "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/2413947/california-14722-strathern",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2528936/california-8435-rincon-avenue",
       "finance": {
-        "down": 286250,
-        "closing": 28625,
-        "cashNeeded": 314875,
-        "loan": 858750,
-        "annualDebtService": 66838,
+        "down": 318750,
+        "closing": 31875,
+        "cashNeeded": 350625,
+        "loan": 956250,
+        "annualDebtService": 74427,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -1825,46 +1877,46 @@
       "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.",
+        "thesis": "This multifamily property in Sun Valley presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially benefiting from long-term appreciation and rental income growth in a desirable San Fernando Valley submarket.",
         "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"
+          "No cap rate or financials disclosed, making valuation and return estimation uncertain",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Property age and square footage are unknown, which may affect maintenance costs and unit desirability"
         ],
         "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"
+          "Potential for value-add through unit upgrades or tenant improvements",
+          "Strategic location in Sun Valley may offer strong demand and appreciation potential",
+          "Leverage available to amplify returns if financials and cap rate prove favorable"
         ],
-        "opportunity_score": 60,
+        "opportunity_score": 65,
         "recommendation": "Watch"
       },
-      "qwenScore": 60,
-      "composite": 45,
-      "rank": 34
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 35
     },
     {
-      "id": "crx2566665",
-      "address": "14320 Osborne",
-      "city": "Panorama City",
+      "id": "crx2454897",
+      "address": "7313 Bakman Ave",
+      "city": "Sun Valley",
       "zip": "",
       "type": "Multifamily",
-      "price": 1080000,
-      "units": 2,
+      "price": 1049000,
+      "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/2566665/california-14320-osborne",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2454897/california-7313-bakman-ave",
       "finance": {
-        "down": 270000,
-        "closing": 27000,
-        "cashNeeded": 297000,
-        "loan": 810000,
-        "annualDebtService": 63044,
+        "down": 262250,
+        "closing": 26225,
+        "cashNeeded": 288475,
+        "loan": 786750,
+        "annualDebtService": 61234,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -1876,23 +1928,328 @@
       "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.",
+        "thesis": "This multifamily property in Sun Valley presents an opportunity for a leveraged buyer with $400k available for down 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 area of the San Fernando Valley could support rental income growth, especially if rent control is not in place and the unit mix aligns with market demand.",
         "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"
+          "Cap rate is not disclosed, making it difficult to assess current returns and compare to market benchmarks",
+          "Rent control status is unverified, which could limit rental income growth potential",
+          "Financials and rent roll are not provided, increasing due diligence risk"
         ],
         "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"
+          "Potential for rental income growth in a strong submarket like Sun Valley",
+          "Opportunity to acquire a 4-unit property with leverage, enabling scale and diversification",
+          "Possibility of value-add through unit upgrades or tenant retention strategies"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 36
+    },
+    {
+      "id": "crx2412676",
+      "address": "11912 Elkwood Street",
+      "city": "North Hollywood",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1449000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2412676/california-11912-elkwood-street",
+      "finance": {
+        "down": 362250,
+        "closing": 36225,
+        "cashNeeded": 398475,
+        "loan": 1086750,
+        "annualDebtService": 84584,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in North Hollywood presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the buyer can fully fund the purchase, positioning them to potentially benefit from future rent growth and property appreciation in a desirable submarket.",
+        "risks": [
+          "No cap rate or financials disclosed, limiting due diligence potential",
+          "Rent control status needs verification, which could impact long-term rental income",
+          "Year built and square footage unknown, which may affect property value and maintenance costs"
+        ],
+        "upside": [
+          "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+          "Strategic location in North Hollywood, a growing and stable submarket",
+          "Leverage available to amplify returns if financials prove favorable"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 37
+    },
+    {
+      "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,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "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": 38
+    },
+    {
+      "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,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "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": 39
+    },
+    {
+      "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,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "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": 40
+    },
+    {
+      "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,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "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": 41
+    },
+    {
+      "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,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "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": 35
+      "rank": 42
     },
     {
       "id": "crx2516979",
@@ -1943,7 +2300,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 36
+      "rank": 43
     },
     {
       "id": "crx2141640",
@@ -1994,7 +2351,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 37
+      "rank": 44
     },
     {
       "id": "crx2413442",
@@ -2029,46 +2386,300 @@
       "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.",
+        "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": 45
+    },
+    {
+      "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,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "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": 46
+    },
+    {
+      "id": "crx2412770",
+      "address": "15131 Polk Street",
+      "city": "Sylmar",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 949000,
+      "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/2412770/california-15131-polk-street",
+      "finance": {
+        "down": 237250,
+        "closing": 23725,
+        "cashNeeded": 260975,
+        "loan": 711750,
+        "annualDebtService": 55397,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This 2-unit multifamily property in Sylmar presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the buyer can secure the property with significant equity and potential for cash flow generation, assuming favorable rent roll and financials. The location in Sylmar, a growing area within the San Fernando Valley, may offer long-term appreciation and rental growth.",
+        "risks": [
+          "No cap rate or financials disclosed, making it difficult to assess current performance and potential returns.",
+          "Rent control status needs verification, which could impact rental income and long-term profitability.",
+          "Property age and square footage are unknown, which may affect maintenance costs and property value."
+        ],
+        "upside": [
+          "Potential for value-add through property improvements or rent increases if rent control is not in place.",
+          "Leverage available with a 25% down payment, allowing for higher returns if the property performs well."
+        ],
+        "opportunity_score": 60,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 60,
+      "composite": 45,
+      "rank": 47
+    },
+    {
+      "id": "crx2412641",
+      "address": "21511 Bassett St. & 6903 Alabama Ave.",
+      "city": "Canoga Park",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1200000,
+      "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/2412641/california-21511-bassett-st-6903-alabama-ave",
+      "finance": {
+        "down": 300000,
+        "closing": 30000,
+        "cashNeeded": 330000,
+        "loan": 900000,
+        "annualDebtService": 70049,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Canoga Park presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a $1.2M asking price and a 25% down payment requirement, the investor can secure the deal within budget, potentially capitalizing on undervalued assets in a growing market.",
+        "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 property details (year built, square footage) may indicate older or less desirable units"
+        ],
+        "upside": [
+          "Potential for value-add through property improvements or rent increases if rent control is not in place",
+          "Strategic location in Canoga Park may offer long-term appreciation and demand",
+          "Leverage available to amplify returns if financials prove favorable"
+        ],
+        "opportunity_score": 60,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 60,
+      "composite": 45,
+      "rank": 48
+    },
+    {
+      "id": "crx2429890",
+      "address": "4813 Topanga Canyon",
+      "city": "Woodland Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1200000,
+      "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/2429890/california-4813-topanga-canyon",
+      "finance": {
+        "down": 300000,
+        "closing": 30000,
+        "cashNeeded": 330000,
+        "loan": 900000,
+        "annualDebtService": 70049,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This 2-unit multifamily property in Woodland Hills presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a $400,000 budget, offering potential for long-term appreciation and rental income growth. The property's location in a desirable area may support stable or increasing rents, though due diligence on financials and rent control status is critical.",
+        "risks": [
+          "No cap rate or financials disclosed, increasing uncertainty about cash flow and return potential",
+          "Rent control status needs verification, which could impact rental income and profitability",
+          "Lack of property details (year built, square footage) may indicate potential hidden issues or lower quality"
+        ],
+        "upside": [
+          "Strategic location in Woodland Hills may provide strong demand for rental units",
+          "Potential for value-add through unit upgrades or management improvements",
+          "Leverage available to maximize returns with a relatively low down payment"
+        ],
+        "opportunity_score": 60,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 60,
+      "composite": 45,
+      "rank": 49
+    },
+    {
+      "id": "crx2521992",
+      "address": "10064 Sunland Boulevard",
+      "city": "Sunland",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 899999,
+      "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/2521992/california-10064-sunland-boulevard",
+      "finance": {
+        "down": 225000,
+        "closing": 22500,
+        "cashNeeded": 247500,
+        "loan": 674999,
+        "annualDebtService": 52536,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Sunland presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a 25% down payment, potentially offering long-term rental income and appreciation in a desirable neighborhood. Further due diligence is required to assess cap rate, rent control implications, and financial performance.",
         "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"
+          "No cap rate or financials disclosed, increasing uncertainty about returns",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Lack of property details (year built, square footage) limits ability to assess condition and value"
         ],
         "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"
+          "Potential for appreciation in a stable, growing area like Sunland",
+          "Opportunity to leverage a $400k budget for a larger investment with favorable loan terms",
+          "Multifamily properties often provide stable cash flow and diversification"
         ],
         "opportunity_score": 60,
         "recommendation": "Watch"
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 38
+      "rank": 50
     },
     {
-      "id": "crx1715584",
-      "address": "Call Broker For Details!",
+      "id": "crx2429895",
+      "address": "18114 Schoenborn",
       "city": "Northridge",
       "zip": "",
-      "type": "Retail",
-      "price": 999950,
-      "units": 1,
+      "type": "Multifamily",
+      "price": 1099000,
+      "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/1715584/california-authentic-greek-5-star-restaurant",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-23. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2429895/california-18114-schoenborn",
       "finance": {
-        "down": 249988,
-        "closing": 24999,
-        "cashNeeded": 274986,
-        "loan": 749963,
-        "annualDebtService": 58371,
+        "down": 274750,
+        "closing": 27475,
+        "cashNeeded": 302225,
+        "loan": 824250,
+        "annualDebtService": 64153,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -2080,46 +2691,46 @@
       "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.",
+        "thesis": "This 2-unit multifamily property in Northridge presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, offering potential for rental income growth and long-term appreciation. The property's location in a desirable area may support stable cash flow and value appreciation over time.",
         "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"
+          "No financials or cap rate disclosed, limiting due diligence potential",
+          "Rent control status needs verification, which could impact rental income and management complexity",
+          "Year built and square footage unknown, which may affect property condition and renovation costs"
         ],
         "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"
+          "Potential for value-add through unit upgrades or rent increases if market conditions allow",
+          "Strategic location in Northridge may benefit from strong demand for multifamily housing",
+          "Leverage available with a 25% down payment, allowing for higher returns if cash flow and appreciation materialize"
         ],
         "opportunity_score": 60,
         "recommendation": "Watch"
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 39
+      "rank": 51
     },
     {
-      "id": "crx2412770",
-      "address": "15131 Polk Street",
-      "city": "Sylmar",
+      "id": "crx1940493",
+      "address": "14216 Calvert St",
+      "city": "Van Nuys",
       "zip": "",
       "type": "Multifamily",
-      "price": 949000,
-      "units": 2,
+      "price": 1150000,
+      "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/2412770/california-15131-polk-street",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/1940493/california-897-cap-191kunit-46-upside-in-prime-van-nuys",
       "finance": {
-        "down": 237250,
-        "closing": 23725,
-        "cashNeeded": 260975,
-        "loan": 711750,
-        "annualDebtService": 55397,
+        "down": 287500,
+        "closing": 28750,
+        "cashNeeded": 316250,
+        "loan": 862500,
+        "annualDebtService": 67130,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -2131,45 +2742,46 @@
       "financeScore": 38,
       "financeConf": "low",
       "qwen": {
-        "thesis": "This 2-unit multifamily property in Sylmar presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the buyer can secure the property with significant equity and potential for cash flow generation, assuming favorable rent roll and financials. The location in Sylmar, a growing area within the San Fernando Valley, may offer long-term appreciation and rental growth.",
+        "thesis": "This multifamily property in Van Nuys 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 acquisition and value-add through renovation or repositioning in a growing market.",
         "risks": [
-          "No cap rate or financials disclosed, making it difficult to assess current performance and potential returns.",
-          "Rent control status needs verification, which could impact rental income and long-term profitability.",
-          "Property age and square footage are unknown, which may affect maintenance costs and property value."
+          "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+          "Rent control status needs verification, which could impact rental income and long-term profitability",
+          "Property details such as year built and square footage are missing, making due diligence more challenging"
         ],
         "upside": [
-          "Potential for value-add through property improvements or rent increases if rent control is not in place.",
-          "Leverage available with a 25% down payment, allowing for higher returns if the property performs well."
+          "Potential for value-add through renovation in a desirable San Fernando Valley location",
+          "Leverage available to increase returns if cash flow and cap rate are favorable post-acquisition",
+          "Opportunity to secure a property in a competitive market before it is fully vetted by other buyers"
         ],
         "opportunity_score": 60,
         "recommendation": "Watch"
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 40
+      "rank": 52
     },
     {
-      "id": "crx2412641",
-      "address": "21511 Bassett St. & 6903 Alabama Ave.",
-      "city": "Canoga Park",
+      "id": "crx2459525",
+      "address": "8010 Wheatland Avenue #C",
+      "city": "Sun Valley",
       "zip": "",
       "type": "Multifamily",
-      "price": 1200000,
-      "units": 2,
+      "price": 1050000,
+      "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/2412641/california-21511-bassett-st-6903-alabama-ave",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2459525/california-8010-wheatland-avenue-c",
       "finance": {
-        "down": 300000,
-        "closing": 30000,
-        "cashNeeded": 330000,
-        "loan": 900000,
-        "annualDebtService": 70049,
+        "down": 262500,
+        "closing": 26250,
+        "cashNeeded": 288750,
+        "loan": 787500,
+        "annualDebtService": 61293,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -2181,31 +2793,31 @@
       "financeScore": 38,
       "financeConf": "low",
       "qwen": {
-        "thesis": "This multifamily property in Canoga Park presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a $1.2M asking price and a 25% down payment requirement, the investor can secure the deal within budget, potentially capitalizing on undervalued assets in a growing market.",
+        "thesis": "This single-unit multifamily property in Sun Valley presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a low down payment. With $400k available for down and closing, the buyer can secure a 25% down loan at 6.75% over 30 years, requiring only $288,750 in cash. The property's location in a desirable area may support long-term appreciation and rental income potential.",
         "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 property details (year built, square footage) may indicate older or less desirable units"
+          "No financials or cap rate disclosed, making valuation and cash flow projections uncertain",
+          "Rent control status needs verification, which could impact rental income and tenant stability",
+          "Single-unit properties are more vulnerable to vacancies and less diversified compared to larger multifamily assets"
         ],
         "upside": [
-          "Potential for value-add through property improvements or rent increases if rent control is not in place",
-          "Strategic location in Canoga Park may offer long-term appreciation and demand",
-          "Leverage available to amplify returns if financials prove favorable"
+          "Potential for appreciation in a growing Sun Valley market",
+          "Ability to leverage a relatively small down payment for a larger asset",
+          "Opportunity to build a portfolio with a strategic first acquisition"
         ],
         "opportunity_score": 60,
         "recommendation": "Watch"
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 41
+      "rank": 53
     },
     {
-      "id": "crx2429890",
-      "address": "4813 Topanga Canyon",
-      "city": "Woodland Hills",
+      "id": "crx2406533",
+      "address": "8446 Bradley Avenue",
+      "city": "Sun Valley",
       "zip": "",
       "type": "Multifamily",
-      "price": 1200000,
+      "price": 989000,
       "units": 2,
       "sqft": null,
       "cap_rate": null,
@@ -2213,14 +2825,14 @@
       "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/2429890/california-4813-topanga-canyon",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2406533/california-8446-bradley-avenue",
       "finance": {
-        "down": 300000,
-        "closing": 30000,
-        "cashNeeded": 330000,
-        "loan": 900000,
-        "annualDebtService": 70049,
+        "down": 247250,
+        "closing": 24725,
+        "cashNeeded": 271975,
+        "loan": 741750,
+        "annualDebtService": 57732,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -2232,46 +2844,46 @@
       "financeScore": 38,
       "financeConf": "low",
       "qwen": {
-        "thesis": "This 2-unit multifamily property in Woodland Hills presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a $400,000 budget, offering potential for long-term appreciation and rental income growth. The property's location in a desirable area may support stable or increasing rents, though due diligence on financials and rent control status is critical.",
+        "thesis": "This 2-unit multifamily property in Sun Valley presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, leaving room for closing costs and potential value-add strategies. The property's location in a desirable neighborhood may support rental income growth and long-term appreciation.",
         "risks": [
-          "No cap rate or financials disclosed, increasing uncertainty about cash flow and return potential",
-          "Rent control status needs verification, which could impact rental income and profitability",
-          "Lack of property details (year built, square footage) may indicate potential hidden issues or lower quality"
+          "No cap rate or financials disclosed, increasing uncertainty about cash flow and profitability",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Lack of property details (year built, square footage) may indicate older or less desirable units"
         ],
         "upside": [
-          "Strategic location in Woodland Hills may provide strong demand for rental units",
-          "Potential for value-add through unit upgrades or management improvements",
-          "Leverage available to maximize returns with a relatively low down payment"
+          "Potential for value-add through unit upgrades or rental rate increases",
+          "Location in Sun Valley offers strong demand for multifamily housing",
+          "Leverage available with 25% down, allowing for higher returns if cash flow assumptions are met"
         ],
         "opportunity_score": 60,
         "recommendation": "Watch"
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 42
+      "rank": 54
     },
     {
-      "id": "crx2521992",
-      "address": "10064 Sunland Boulevard",
-      "city": "Sunland",
+      "id": "crx2599666",
+      "address": "17615 Kingsbury",
+      "city": "Granada Hills",
       "zip": "",
       "type": "Multifamily",
-      "price": 899999,
-      "units": 2,
+      "price": 1350000,
+      "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/2521992/california-10064-sunland-boulevard",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2599666/california-17615-kingsbury",
       "finance": {
-        "down": 225000,
-        "closing": 22500,
-        "cashNeeded": 247500,
-        "loan": 674999,
-        "annualDebtService": 52536,
+        "down": 337500,
+        "closing": 33750,
+        "cashNeeded": 371250,
+        "loan": 1012500,
+        "annualDebtService": 78805,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -2283,46 +2895,46 @@
       "financeScore": 38,
       "financeConf": "low",
       "qwen": {
-        "thesis": "This multifamily property in Sunland presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a 25% down payment, potentially offering long-term rental income and appreciation in a desirable neighborhood. Further due diligence is required to assess cap rate, rent control implications, and financial performance.",
+        "thesis": "This multifamily property in Granada Hills presents an opportunity for a leveraged buyer with $400k available for down payment and closing costs. With a 25% down payment, the investor can secure the property within budget, positioning themselves to potentially benefit from long-term appreciation and rental income growth in a desirable San Fernando Valley submarket.",
         "risks": [
-          "No cap rate or financials disclosed, increasing uncertainty about returns",
+          "No cap rate or financials 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) limits ability to assess condition and value"
+          "Property details such as year built and square footage are missing, increasing due diligence risk"
         ],
         "upside": [
-          "Potential for appreciation in a stable, growing area like Sunland",
-          "Opportunity to leverage a $400k budget for a larger investment with favorable loan terms",
-          "Multifamily properties often provide stable cash flow and diversification"
+          "Potential for value-add through renovations or repositioning in a growing area",
+          "Leverage available to amplify returns if the property performs well",
+          "Strategic location in Granada Hills may offer strong demand and stability"
         ],
         "opportunity_score": 60,
         "recommendation": "Watch"
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 43
+      "rank": 55
     },
     {
-      "id": "crx2429895",
-      "address": "18114 Schoenborn",
-      "city": "Northridge",
+      "id": "crx2406488",
+      "address": "10204 Gerald Avenue",
+      "city": "North Hills",
       "zip": "",
       "type": "Multifamily",
-      "price": 1099000,
-      "units": 2,
+      "price": 1199000,
+      "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-23. Cap not disclosed. Verify status, rent roll, and financials before acting.",
-      "source": "https://www.crexi.com/properties/2429895/california-18114-schoenborn",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2406488/california-10204-gerald-avenue",
       "finance": {
-        "down": 274750,
-        "closing": 27475,
-        "cashNeeded": 302225,
-        "loan": 824250,
-        "annualDebtService": 64153,
+        "down": 299750,
+        "closing": 29975,
+        "cashNeeded": 329725,
+        "loan": 899250,
+        "annualDebtService": 69990,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -2334,23 +2946,23 @@
       "financeScore": 38,
       "financeConf": "low",
       "qwen": {
-        "thesis": "This 2-unit multifamily property in Northridge presents an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, offering potential for rental income growth and long-term appreciation. The property's location in a desirable area may support stable cash flow and value appreciation over time.",
+        "thesis": "This multifamily property in North Hills 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 appreciation and long-term rental income in a desirable San Fernando Valley submarket.",
         "risks": [
-          "No financials or cap rate disclosed, limiting due diligence potential",
-          "Rent control status needs verification, which could impact rental income and management complexity",
-          "Year built and square footage unknown, which may affect property condition and renovation costs"
+          "No cap rate or financials disclosed, making valuation and return estimation uncertain",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Property details such as year built and square footage are missing, increasing due diligence risk"
         ],
         "upside": [
-          "Potential for value-add through unit upgrades or rent increases if market conditions allow",
-          "Strategic location in Northridge may benefit from strong demand for multifamily housing",
-          "Leverage available with a 25% down payment, allowing for higher returns if cash flow and appreciation materialize"
+          "Potential for value-add through renovation or repositioning in a growing area",
+          "Leverage available to amplify returns if financials prove favorable",
+          "Strategic location in North Hills may offer strong long-term appreciation"
         ],
         "opportunity_score": 60,
         "recommendation": "Watch"
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 44
+      "rank": 56
     },
     {
       "id": "crx2516882",
@@ -2401,7 +3013,7 @@
       },
       "qwenScore": 55,
       "composite": 42,
-      "rank": 45
+      "rank": 57
     },
     {
       "id": "crx2488780",
@@ -2417,14 +3029,64 @@
       "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",
+      "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,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "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": 58
+    },
+    {
+      "id": "crx2516555",
+      "address": "9916 Whitaker Avenue",
+      "city": "North Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1099000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2516555/california-9916-whitaker-avenue",
       "finance": {
-        "down": 328750,
-        "closing": 32875,
-        "cashNeeded": 361625,
-        "loan": 986250,
-        "annualDebtService": 76762,
+        "down": 274750,
+        "closing": 27475,
+        "cashNeeded": 302225,
+        "loan": 824250,
+        "annualDebtService": 64153,
         "noi": null,
         "cashFlow": null,
         "coc": null,
@@ -2436,22 +3098,23 @@
       "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.",
+        "thesis": "This single-unit multifamily property in North Hills presents an opportunity for a leveraged buyer to enter the San Fernando Valley market with a low down payment. With $400,000 available for down and closing costs, the buyer can secure a fully funded purchase at a computed 25% down payment, leaving room for contingencies and potential value-add opportunities.",
         "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."
+          "No cap rate or financials disclosed, making valuation and return estimation speculative",
+          "Rent control status needs verification, which could impact long-term rental income potential",
+          "Single-unit properties may have higher vacancy and maintenance risks compared to larger multifamily assets"
         ],
         "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."
+          "Potential for value appreciation in a growing North Hills market",
+          "Opportunity to reposition or renovate the unit for higher rental income",
+          "Leverage available to increase returns if market conditions improve"
         ],
         "opportunity_score": 55,
         "recommendation": "Watch"
       },
       "qwenScore": 55,
       "composite": 42,
-      "rank": 46
+      "rank": 59
     },
     {
       "id": "correnti12600",
@@ -2501,7 +3164,7 @@
       },
       "qwenScore": 65,
       "composite": 38,
-      "rank": 47
+      "rank": 60
     },
     {
       "id": "crx2414372",
@@ -2552,7 +3215,7 @@
       },
       "qwenScore": 65,
       "composite": 38,
-      "rank": 48
+      "rank": 61
     },
     {
       "id": "amigo8357",
@@ -2628,7 +3291,7 @@
       },
       "qwenScore": 65,
       "composite": 36,
-      "rank": 49
+      "rank": 62
     },
     {
       "id": "wilbur9014",
@@ -2678,7 +3341,7 @@
       },
       "qwenScore": 65,
       "composite": 35,
-      "rank": 50
+      "rank": 63
     },
     {
       "id": "crx2414120",
@@ -2729,7 +3392,7 @@
       },
       "qwenScore": 65,
       "composite": 35,
-      "rank": 51
+      "rank": 64
     },
     {
       "id": "hillhaven10139",
@@ -2779,7 +3442,7 @@
       },
       "qwenScore": 65,
       "composite": 34,
-      "rank": 52
+      "rank": 65
     },
     {
       "id": "crx2413999",
@@ -2830,7 +3493,7 @@
       },
       "qwenScore": 60,
       "composite": 33,
-      "rank": 53
+      "rank": 66
     },
     {
       "id": "crx2417808",
@@ -2881,7 +3544,7 @@
       },
       "qwenScore": 60,
       "composite": 33,
-      "rank": 54
+      "rank": 67
     },
     {
       "id": "crx2558648",
@@ -2932,7 +3595,7 @@
       },
       "qwenScore": 60,
       "composite": 33,
-      "rank": 55
+      "rank": 68
     },
     {
       "id": "crx2485727",
@@ -2983,7 +3646,58 @@
       },
       "qwenScore": 60,
       "composite": 33,
-      "rank": 56
+      "rank": 69
+    },
+    {
+      "id": "crx2593838",
+      "address": "14642 Calvert",
+      "city": "Van Nuys",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1475000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2593838/california-14642-calvert",
+      "finance": {
+        "down": 368750,
+        "closing": 36875,
+        "cashNeeded": 405625,
+        "loan": 1106250,
+        "annualDebtService": 86101,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 20,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This 4-unit multifamily property in Van Nuys presents an opportunity for a leveraged investor to acquire a rental asset in a desirable San Fernando Valley submarket. With a $400,000 budget, the investor could potentially secure a fully funded purchase if closing costs and down payment are optimized, though the lack of disclosed cap rate and financials introduces uncertainty.",
+        "risks": [
+          "No financials or cap rate disclosed, making due diligence critical",
+          "Potential rent control implications affecting long-term cash flow",
+          "Uncertain property condition and unit size, which could impact value and renovation costs"
+        ],
+        "upside": [
+          "Strategic location in Van Nuys with strong demand for multifamily housing",
+          "Potential for value-add through renovations or rent increases",
+          "Opportunity to build a diversified multifamily portfolio with a relatively small initial investment"
+        ],
+        "opportunity_score": 60,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 60,
+      "composite": 33,
+      "rank": 70
     },
     {
       "id": "burbank10701",
@@ -3033,7 +3747,7 @@
       },
       "qwenScore": 55,
       "composite": 32,
-      "rank": 57
+      "rank": 71
     },
     {
       "id": "vannuys6329",
@@ -3084,7 +3798,7 @@
       },
       "qwenScore": 65,
       "composite": 31,
-      "rank": 58
+      "rank": 72
     },
     {
       "id": "crx2455873",
@@ -3135,7 +3849,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 59
+      "rank": 73
     },
     {
       "id": "crx2592616",
@@ -3186,7 +3900,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 60
+      "rank": 74
     },
     {
       "id": "crx2412907",
@@ -3237,7 +3951,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 61
+      "rank": 75
     },
     {
       "id": "crx2473428",
@@ -3288,7 +4002,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 62
+      "rank": 76
     },
     {
       "id": "crx2412878",
@@ -3339,7 +4053,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 63
+      "rank": 77
     },
     {
       "id": "crx2584910",
@@ -3390,7 +4104,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 64
+      "rank": 78
     },
     {
       "id": "crx2569982",
@@ -3441,7 +4155,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 65
+      "rank": 79
     },
     {
       "id": "crx2593834",
@@ -3492,7 +4206,58 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 66
+      "rank": 80
+    },
+    {
+      "id": "crx2599659",
+      "address": "7445 Oakdale Avenue",
+      "city": "Winnetka",
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2599659/california-7445-oakdale-avenue",
+      "finance": {
+        "down": 437500,
+        "closing": 43750,
+        "cashNeeded": 481250,
+        "loan": 1312500,
+        "annualDebtService": 102154,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 20,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Winnetka presents an opportunity for a value-add investor seeking to acquire a small-scale asset in a desirable San Fernando Valley neighborhood. With a $400,000 budget, the investor may need to negotiate the purchase price or secure additional financing to meet the down payment and closing cost requirements.",
+        "risks": [
+          "Insufficient capital to meet the computed down payment and closing costs without additional financing or price negotiation",
+          "Lack of disclosed cap rate and financials increases uncertainty around cash flow and return potential",
+          "Rent control verification is required, which may impact rental income and long-term appreciation"
+        ],
+        "upside": [
+          "Winnetka is a high-demand area with strong rental market fundamentals and potential for appreciation",
+          "Small multifamily units can be repositioned or improved for increased NOI and value-add opportunities",
+          "Potential for long-term equity growth if the property is acquired at a discount or through favorable terms"
+        ],
+        "opportunity_score": 55,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 55,
+      "composite": 31,
+      "rank": 81
     },
     {
       "id": "sepulveda8144",
@@ -3542,7 +4307,7 @@
       },
       "qwenScore": 65,
       "composite": 29,
-      "rank": 67
+      "rank": 82
     },
     {
       "id": "canby7260",
@@ -3592,7 +4357,7 @@
       },
       "qwenScore": 65,
       "composite": 29,
-      "rank": 68
+      "rank": 83
     },
     {
       "id": "wilkinson5214",
@@ -3642,7 +4407,7 @@
       },
       "qwenScore": 65,
       "composite": 29,
-      "rank": 69
+      "rank": 84
     },
     {
       "id": "tilden8837",
@@ -3692,7 +4457,7 @@
       },
       "qwenScore": 55,
       "composite": 28,
-      "rank": 70
+      "rank": 85
     },
     {
       "id": "crx2560155",
@@ -3743,7 +4508,7 @@
       },
       "qwenScore": 50,
       "composite": 28,
-      "rank": 71
+      "rank": 86
     },
     {
       "id": "crx2352672",
@@ -3794,7 +4559,7 @@
       },
       "qwenScore": 55,
       "composite": 28,
-      "rank": 72
+      "rank": 87
     },
     {
       "id": "crx2516587",
@@ -3845,7 +4610,58 @@
       },
       "qwenScore": 50,
       "composite": 28,
-      "rank": 73
+      "rank": 88
+    },
+    {
+      "id": "crx2411079",
+      "address": "5701 Corbin Avenue",
+      "city": "Tarzana",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1659000,
+      "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-26. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2411079/california-5701-corbin-avenue",
+      "finance": {
+        "down": 414750,
+        "closing": 41475,
+        "cashNeeded": 456225,
+        "loan": 1244250,
+        "annualDebtService": 96842,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 20,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This single-unit multifamily property in Tarzana presents a potential opportunity for a leveraged investor seeking a high-end rental in a desirable area. However, the required down payment and closing costs exceed the available budget, necessitating careful evaluation of financing options and potential value-add strategies.",
+        "risks": [
+          "Insufficient down payment to meet the computed $456,225 requirement",
+          "No disclosed cap rate or financials, increasing uncertainty",
+          "Rent control status needs verification, which could impact long-term rental income"
+        ],
+        "upside": [
+          "Potential for value appreciation in the Tarzana market",
+          "High-end unit may command premium rent if properly marketed",
+          "Opportunity to reposition or renovate for increased cash flow"
+        ],
+        "opportunity_score": 50,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 50,
+      "composite": 28,
+      "rank": 89
     },
     {
       "id": "crx2455604",
@@ -3896,7 +4712,7 @@
       },
       "qwenScore": 55,
       "composite": 27,
-      "rank": 74
+      "rank": 90
     },
     {
       "id": "vannuys12872",
@@ -3946,7 +4762,7 @@
       },
       "qwenScore": 65,
       "composite": 26,
-      "rank": 75
+      "rank": 91
     },
     {
       "id": "comercio5301",
@@ -3996,7 +4812,7 @@
       },
       "qwenScore": 65,
       "composite": 26,
-      "rank": 76
+      "rank": 92
     },
     {
       "id": "crx2569960",
@@ -4047,7 +4863,7 @@
       },
       "qwenScore": 55,
       "composite": 26,
-      "rank": 77
+      "rank": 93
     },
     {
       "id": "victory13350",
@@ -4097,7 +4913,7 @@
       },
       "qwenScore": 55,
       "composite": 25,
-      "rank": 78
+      "rank": 94
     },
     {
       "id": "crx2489729",
@@ -4148,7 +4964,58 @@
       },
       "qwenScore": 50,
       "composite": 23,
-      "rank": 79
+      "rank": 95
+    },
+    {
+      "id": "crx2488797",
+      "address": "7410 Vineland Avenue",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1150000,
+      "units": 4,
+      "sqft": null,
+      "cap_rate": 4.75,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 4.75% (unverified). Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2488797/california-7410-vineland-avenue",
+      "finance": {
+        "down": 287500,
+        "closing": 28750,
+        "cashNeeded": 316250,
+        "loan": 862500,
+        "annualDebtService": 67130,
+        "noi": 54625,
+        "cashFlow": -12505,
+        "coc": -3.95,
+        "dscr": 0.81,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 0,
+      "financeConf": "high",
+      "qwen": {
+        "thesis": "This 4-unit multifamily property in Sun Valley offers an entry point into the San Fernando Valley market with a verified 4.75% cap rate, suggesting potential for stable cash flow. With a $400,000 budget covering down payment and closing costs, the investment is feasible, though the negative cash-on-cash return and low DSCR indicate the need for careful evaluation of financials and rent roll.",
+        "risks": [
+          "Negative cash-on-cash return (-3.95%) indicates potential cash outflow in the initial years",
+          "Low DSCR (0.81) suggests potential debt service risk",
+          "Rent control status and unit-specific financials need verification before purchase"
+        ],
+        "upside": [
+          "Potential for value-add through rent increases or unit improvements",
+          "Strategic location in Sun Valley with strong demand for multifamily housing",
+          "Leverage available with 25% down and 6.75% fixed-rate financing"
+        ],
+        "opportunity_score": 55,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 55,
+      "composite": 22,
+      "rank": 96
     },
     {
       "id": "canoga6020",
@@ -4198,7 +5065,7 @@
       },
       "qwenScore": 55,
       "composite": 21,
-      "rank": 80
+      "rank": 97
     },
     {
       "id": "vanowen15840",
@@ -4248,7 +5115,7 @@
       },
       "qwenScore": 60,
       "composite": 18,
-      "rank": 81
+      "rank": 98
     },
     {
       "id": "crx2448930",
@@ -4299,7 +5166,7 @@
       },
       "qwenScore": 50,
       "composite": 18,
-      "rank": 82
+      "rank": 99
     },
     {
       "id": "crx2563662",
@@ -4350,7 +5217,7 @@
       },
       "qwenScore": 45,
       "composite": 18,
-      "rank": 83
+      "rank": 100
     },
     {
       "id": "crx2147226",
@@ -4401,7 +5268,58 @@
       },
       "qwenScore": 45,
       "composite": 18,
-      "rank": 84
+      "rank": 101
+    },
+    {
+      "id": "crx2448190",
+      "address": "7245 Bakman",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1565000,
+      "units": 6,
+      "sqft": null,
+      "cap_rate": 5.4,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-26. Broker cap 5.4% (unverified). Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2448190/california-7245-bakman",
+      "finance": {
+        "down": 391250,
+        "closing": 39125,
+        "cashNeeded": 430375,
+        "loan": 1173750,
+        "annualDebtService": 91355,
+        "noi": 84510,
+        "cashFlow": -6845,
+        "coc": -1.59,
+        "dscr": 0.93,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 0,
+      "financeConf": "high",
+      "qwen": {
+        "thesis": "This multifamily property in Sun Valley offers an opportunity to acquire a 6-unit asset with a verified 5.4% cap rate, suggesting potential for stable cash flow and long-term appreciation. However, the required down payment and closing costs exceed the $400k budget, necessitating careful evaluation of financing options and potential value-add strategies.",
+        "risks": [
+          "Insufficient down payment to meet the computed $430,375 requirement",
+          "Unverified rent control status may impact rental income and tenant retention",
+          "Negative cash-on-cash return (-1.59%) and low DSCR (0.93) indicate potential cash flow and debt service risks"
+        ],
+        "upside": [
+          "Verified cap rate suggests potential for value appreciation",
+          "Sun Valley's location offers strong long-term growth potential",
+          "Opportunity to reposition the property through value-add improvements or rent increases"
+        ],
+        "opportunity_score": 55,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 55,
+      "composite": 18,
+      "rank": 102
     },
     {
       "id": "canby7454",
@@ -4451,7 +5369,7 @@
       },
       "qwenScore": 55,
       "composite": 16,
-      "rank": 85
+      "rank": 103
     }
   ]
 }
\ No newline at end of file

← 133b583 morning CRE report: add steve-personal as second recipient  ·  back to Commercialrealestate  ·  afternoon CRE update 2026-06-26 8101926 →