[object Object]

← back to Commercialrealestate

Add rent-yield (rent÷price) metric + broader SFV sweep (81 listings)

39b655cb0e94f13bacd31709659606ad23ead9fd · 2026-06-21 18:52:23 -0700 · Steve

- finance.js: grossYield = annual gross rent / price (from rent_roll/gross_actual) — surfaces 'rent close to price'
- viewer: Rent Yield sort + per-card 'rent yld' badge; morning-report: rent yield in recap
- broader Crexi sweep (+19 cities) -> 81 listings total

Files touched

Diff

commit 39b655cb0e94f13bacd31709659606ad23ead9fd
Author: Steve <steve@designerwallcoverings.com>
Date:   Sun Jun 21 18:52:23 2026 -0700

    Add rent-yield (rent÷price) metric + broader SFV sweep (81 listings)
    
    - finance.js: grossYield = annual gross rent / price (from rent_roll/gross_actual) — surfaces 'rent close to price'
    - viewer: Rent Yield sort + per-card 'rent yld' badge; morning-report: rent yield in recap
    - broader Crexi sweep (+19 cities) -> 81 listings total
---
 data/last-refresh.json      |    6 +-
 data/listings.json          |  346 ++++++++++-
 data/qwen-cache.json        |  360 +++++++++++
 data/ranked.json            | 1390 ++++++++++++++++++++++++++++++++++++++-----
 public/finance.js           |    8 +-
 public/index.html           |    4 +-
 scripts/morning-report.js   |    2 +-
 scripts/refresh-listings.js |    2 +-
 8 files changed, 1958 insertions(+), 160 deletions(-)

diff --git a/data/last-refresh.json b/data/last-refresh.json
index 5d39d1e..0c31df3 100644
--- a/data/last-refresh.json
+++ b/data/last-refresh.json
@@ -1,6 +1,6 @@
 {
   "date": "2026-06-22",
-  "captured": 160,
-  "candidates": 39,
-  "added": 38
+  "captured": 72,
+  "candidates": 23,
+  "added": 19
 }
\ No newline at end of file
diff --git a/data/listings.json b/data/listings.json
index 3c9fd39..833d134 100644
--- a/data/listings.json
+++ b/data/listings.json
@@ -1051,15 +1051,30 @@
       "units": 3,
       "sqft": 2580,
       "cap_rate": 6.66,
-      "cap_rate_projected": 7.0,
+      "cap_rate_projected": 7,
       "noi_seller": 86496,
       "gross_proforma": 101760,
       "expenses": 15264,
       "verified": false,
       "rent_roll": [
-        {"unit": 1, "type": "main 2bd/2ba 1250sf", "rent": 3390, "note": "currently rented"},
-        {"unit": 2, "type": "attached 1bd/1ba JADU 500sf", "rent": 1990, "note": "PREVIOUSLY rented - lease-up risk"},
-        {"unit": 3, "type": "detached 2bd/2ba ADU 830sf (new 2024)", "rent": 3100, "note": "PREVIOUSLY rented - lease-up risk"}
+        {
+          "unit": 1,
+          "type": "main 2bd/2ba 1250sf",
+          "rent": 3390,
+          "note": "currently rented"
+        },
+        {
+          "unit": 2,
+          "type": "attached 1bd/1ba JADU 500sf",
+          "rent": 1990,
+          "note": "PREVIOUSLY rented - lease-up risk"
+        },
+        {
+          "unit": 3,
+          "type": "detached 2bd/2ba ADU 830sf (new 2024)",
+          "rent": 3100,
+          "note": "PREVIOUSLY rented - lease-up risk"
+        }
       ],
       "year_built": 1954,
       "rent_control": "Triplex (1bd JADU + new 2024 ADU likely AB1482-only, not LA RSO); verify",
@@ -1151,6 +1166,329 @@
       "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"
+    },
+    {
+      "id": "crx2516747",
+      "address": "4538 Tujunga Avenue",
+      "city": "Studio City",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1399000,
+      "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/2516747/california-4538-tujunga-avenue"
+    },
+    {
+      "id": "crx2589903",
+      "address": "17144 Burton Street",
+      "city": "Lake Balboa",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1250000,
+      "units": 3,
+      "sqft": null,
+      "cap_rate": null,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2589903/california-17144-burton-street"
+    },
+    {
+      "id": "crx1080991",
+      "address": "14690 Hubbard Street",
+      "city": "Sylmar",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1388000,
+      "units": 7,
+      "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/1080991/california-14690-hubbard-street"
+    },
+    {
+      "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"
+    },
+    {
+      "id": "crx2413872",
+      "address": "15057 Paddock",
+      "city": "Sylmar",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1329000,
+      "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/2413872/california-15057-paddock"
+    },
+    {
+      "id": "crx2412328",
+      "address": "20528-& 20526 Hamlin Street",
+      "city": "Winnetka",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1229777,
+      "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/2412328/california-20528-hamlin-street"
+    },
+    {
+      "id": "crx2412878",
+      "address": "22137 Gault Street",
+      "city": "Canoga Park",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1585000,
+      "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/2412878/california-22137-gault"
+    },
+    {
+      "id": "crx2584910",
+      "address": "22130 Gault Street",
+      "city": "Canoga Park",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1695000,
+      "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/2584910/california-22130-gault-street"
+    },
+    {
+      "id": "crx2516918",
+      "address": "23130 Victory",
+      "city": "Woodland Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1250000,
+      "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/2516918/california-23130-victory"
+    },
+    {
+      "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"
+    },
+    {
+      "id": "crx2569982",
+      "address": "7228 Independence",
+      "city": "Canoga Park",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1495000,
+      "units": 5,
+      "sqft": null,
+      "cap_rate": null,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2569982/california-7228-independence"
+    },
+    {
+      "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"
+    },
+    {
+      "id": "crx2450078",
+      "address": "10018 Tujunga Canyon Boulevard",
+      "city": "Tujunga",
+      "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/2450078/california-10018-tujunga-canyon-boulevard"
+    },
+    {
+      "id": "crx2595754",
+      "address": "6911 Valmont Street",
+      "city": "Tujunga",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1399999,
+      "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/2595754/california-6911-valmont-street"
+    },
+    {
+      "id": "crx2411991",
+      "address": "10155 Mount Gleason",
+      "city": "Sunland",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1075000,
+      "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/2411991/california-10155-mount-gleason"
+    },
+    {
+      "id": "crx2461695",
+      "address": "11034 Scoville",
+      "city": "Sunland",
+      "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-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2461695/california-11034-scoville"
+    },
+    {
+      "id": "crx2559966",
+      "address": "10058 Sunland Boulevard",
+      "city": "Sunland",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1299900,
+      "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/2559966/california-10058-sunland-boulevard"
+    },
+    {
+      "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"
+    },
+    {
+      "id": "crx2485727",
+      "address": "10802 Crockett Street",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1495000,
+      "units": 5,
+      "sqft": null,
+      "cap_rate": null,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2485727/california-10802-crockett-street"
     }
   ]
 }
\ No newline at end of file
diff --git a/data/qwen-cache.json b/data/qwen-cache.json
index 27c854f..d31e961 100644
--- a/data/qwen-cache.json
+++ b/data/qwen-cache.json
@@ -1193,5 +1193,365 @@
       "recommendation": "Watch"
     },
     "qwenScore": 60
+  },
+  "crx2516747": {
+    "key": "7fa1a2a6ab86",
+    "qwen": {
+      "thesis": "This multifamily property in the desirable Studio City neighborhood 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, potentially benefiting from long-term appreciation and rental income growth in a strong submarket.",
+      "risks": [
+        "Cap rate is not disclosed, making it difficult to assess current returns and compare to market benchmarks",
+        "Rent control status needs verification, which could impact rental income potential and tenant retention",
+        "Financials and rent roll are not provided, increasing due diligence risk and uncertainty around cash flow"
+      ],
+      "upside": [
+        "Studio City is a high-demand area with strong rental market fundamentals and limited new supply",
+        "Potential for value-add through unit upgrades or repositioning",
+        "Leverage available to amplify returns if the property performs well"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2589903": {
+    "key": "7af198e71dd5",
+    "qwen": {
+      "thesis": "This multifamily property in Lake Balboa 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",
+        "Lack of property details (year built, square footage) may indicate potential hidden maintenance or renovation costs"
+      ],
+      "upside": [
+        "Potential for value-add through renovations or repositioning in a stable, growing neighborhood",
+        "Leverage available to increase returns if cash flow and appreciation materialize",
+        "Lake Balboa is a sought-after area with strong demand for rental housing"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx1080991": {
+    "key": "f5171568f7f5",
+    "qwen": {
+      "thesis": "This multifamily property in Sylmar presents an opportunity for a leveraged buyer with a $400k budget to acquire a 7-unit asset in a growing submarket of the San Fernando Valley. With a 25% down payment, the purchase is within budget, and the property could benefit from value-add strategies such as rent increases or unit upgrades.",
+      "risks": [
+        "No cap rate or financials disclosed, making due diligence critical",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Year built and square footage not provided, limiting assessment of property condition and value"
+      ],
+      "upside": [
+        "Potential for rental income growth through market-rate repositioning",
+        "Opportunity to capitalize on Sylmar’s stable and growing population",
+        "Leverage available to increase returns if financials justify"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2412770": {
+    "key": "cb4382bfa784",
+    "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
+  },
+  "crx2413872": {
+    "key": "c65712c7def8",
+    "qwen": {
+      "thesis": "This multifamily property in Sylmar presents an opportunity for a leveraged buyer with $400k available for down and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially capturing value in a growing area of the San Fernando Valley. Further due diligence on rent control status, cap rate, and financials is critical to assess long-term viability.",
+      "risks": [
+        "Rent control may limit rental income growth potential",
+        "Cap rate and NOI are not disclosed, increasing uncertainty",
+        "Year built and square footage unknown, which could impact property value and maintenance costs"
+      ],
+      "upside": [
+        "Potential for value appreciation in Sylmar’s real estate market",
+        "Leverage available to increase returns if financials are strong",
+        "Opportunity to acquire a 3-unit property at a potentially attractive price point"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2412328": {
+    "key": "e15dfd6d4d62",
+    "qwen": {
+      "thesis": "This multifamily property in Winnetka offers an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, potentially benefiting from strong demand in the area. With $400k available for down and closing, the purchase is financially feasible, though due diligence on financials, rent control status, and property condition is critical.",
+      "risks": [
+        "No cap rate or NOI disclosed, making valuation and return estimation uncertain",
+        "Rent control status needs verification, which could impact long-term rental income and tenant stability",
+        "Year built and square footage are unknown, which may affect property value and renovation costs"
+      ],
+      "upside": [
+        "Winnetka is a desirable location with strong rental demand and appreciation potential",
+        "Leverage of $400k allows for a significant purchase with relatively low initial capital",
+        "Potential for value-add through renovations or rent increases if rent control is not in place"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2412878": {
+    "key": "70bc00b19c73",
+    "qwen": {
+      "thesis": "This multifamily property in Canoga Park presents an opportunity for a leveraged buyer to acquire a 3-unit investment with potential for value-add through rent increases and property improvements. However, the required down payment exceeds the available budget, necessitating careful evaluation of financing options and property-specific risks.",
+      "risks": [
+        "Insufficient down payment to meet lender requirements without additional capital or alternative financing",
+        "Lack of disclosed cap rate and financials increases uncertainty around cash flow and returns",
+        "Rent control status may limit rental income growth potential"
+      ],
+      "upside": [
+        "Potential for rental income growth through market-rate repositioning if rent control is not in place",
+        "Value-add opportunities through unit upgrades or operational efficiencies",
+        "Strategic location in the San Fernando Valley with long-term appreciation potential"
+      ],
+      "opportunity_score": 55,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 55
+  },
+  "crx2584910": {
+    "key": "0d4561748be3",
+    "qwen": {
+      "thesis": "This multifamily property in Canoga Park presents an opportunity for a value-add investor with a $400k budget, assuming the asking price is negotiable or financing terms can be adjusted. The location in the San Fernando Valley offers strong long-term appreciation potential and demand for rental housing, though due diligence on cap rate, rent control status, and financials is critical before proceeding.",
+      "risks": [
+        "Insufficient down payment (computed $466k vs $400k budget)",
+        "No cap rate or financials disclosed, increasing uncertainty",
+        "Potential rent control restrictions impacting rental income and flexibility"
+      ],
+      "upside": [
+        "Strong location in a growing submarket with demand for multifamily units",
+        "Potential for value-add through unit upgrades or rent increases",
+        "Opportunity to secure a property at a discount if the asking price is negotiable"
+      ],
+      "opportunity_score": 55,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 55
+  },
+  "crx2516918": {
+    "key": "067653d53c95",
+    "qwen": {
+      "thesis": "This 2-unit multifamily property in Woodland Hills presents an opportunity for a leveraged investor to acquire a rental asset in a high-demand submarket with strong employment and population growth. With a $400k budget covering down payment and closing costs, the investor can secure a position in a desirable area with potential for long-term appreciation and rental income growth.",
+      "risks": [
+        "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Lack of property details (year built, square footage) may indicate older or less efficient units"
+      ],
+      "upside": [
+        "Strong demand in Woodland Hills for rental properties due to proximity to employment centers and lifestyle amenities",
+        "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+        "Opportunity to leverage a relatively low down payment for higher cash-on-cash returns if financials prove favorable"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2412641": {
+    "key": "69eacf003302",
+    "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
+  },
+  "crx2569982": {
+    "key": "7a64beb5f9cd",
+    "qwen": {
+      "thesis": "This 5-unit multifamily property in Canoga Park presents an opportunity for a leveraged investor to acquire a rental asset in a high-demand submarket. However, the required down payment and closing costs exceed the $400k budget, necessitating careful evaluation of the property’s financials, rent roll, and cap rate before proceeding.",
+      "risks": [
+        "Insufficient down payment to meet the computed $411,125 requirement",
+        "Lack of disclosed cap rate and financials increases uncertainty",
+        "Rent control status may impact long-term rental income and property value"
+      ],
+      "upside": [
+        "Potential for value-add through unit upgrades or operational improvements",
+        "Strong demand in the San Fernando Valley for multifamily housing",
+        "Strategic location in Canoga Park with growth potential"
+      ],
+      "opportunity_score": 55,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 55
+  },
+  "crx2429890": {
+    "key": "76349f0974af",
+    "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
+  },
+  "crx2450078": {
+    "key": "74259fa5405c",
+    "qwen": {
+      "thesis": "This 2-unit multifamily property in Tujunga presents an opportunity for a leveraged buyer with $400,000 available for down and closing. With a 25% down payment, the buyer can secure the property with significant remaining equity, potentially allowing for value-add strategies or rental growth in a historically stable market.",
+      "risks": [
+        "No cap rate or financials disclosed, making due diligence critical",
+        "Potential rent control implications could limit rental income growth",
+        "Year built and square footage unknown, which may affect property value and renovation costs"
+      ],
+      "upside": [
+        "Potential for rental income growth in a stable multifamily market",
+        "Opportunity to add value through unit upgrades or management improvements",
+        "Leverage available to increase returns if financials justify the purchase"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2595754": {
+    "key": "13cff24ca2d3",
+    "qwen": {
+      "thesis": "This 2-unit multifamily property in Tujunga 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 value-add through rent increases, unit upgrades, or repositioning in a growing area.",
+      "risks": [
+        "No financials or cap rate disclosed, making due diligence critical",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Year built and square footage unknown, complicating assessment of property condition and value"
+      ],
+      "upside": [
+        "Potential for rent growth in Tujunga, a historically stable multifamily market",
+        "Opportunity to add value through renovations or rebranding",
+        "Leverage available to amplify returns with a relatively low down payment"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2411991": {
+    "key": "641cb0b4a2f5",
+    "qwen": {
+      "thesis": "This 2-unit multifamily property in Sunland presents an opportunity for a leveraged buyer with $400,000 available for down and closing. With a 25% down payment, the buyer can secure the property with significant remaining equity, potentially allowing for value-add strategies or future refinancing. Sunland’s strong market fundamentals and proximity to desirable amenities may support rental growth and long-term appreciation.",
+      "risks": [
+        "Lack of disclosed cap rate and financials increases uncertainty around cash flow and profitability.",
+        "Rent control status needs verification, which could impact rental income and long-term returns.",
+        "Missing property details (year built, square footage) may indicate lack of transparency or potential hidden issues."
+      ],
+      "upside": [
+        "Potential for value-add through unit upgrades, tenant improvements, or repositioning.",
+        "Sunland’s stable and growing market offers favorable conditions for multifamily investment.",
+        "Leverage available with a 25% down payment, allowing for higher returns if NOI is strong."
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2461695": {
+    "key": "04c477bfc62b",
+    "qwen": {
+      "thesis": "This multifamily property in Sunland presents an opportunity for a leveraged buyer with $400k available for down and closing costs. With a 25% down payment, the buyer can secure a loan with a 6.75% interest rate over 30 years, staying within budget. The location in Sunland, a desirable area within the San Fernando Valley, may offer long-term appreciation and stable rental demand.",
+      "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 value"
+      ],
+      "upside": [
+        "Potential for rental income growth in a stable and growing neighborhood",
+        "Opportunity to acquire a property in a high-demand area with potential for future appreciation",
+        "Leverage available to increase return on equity if NOI is strong"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2559966": {
+    "key": "84a935e228e1",
+    "qwen": {
+      "thesis": "This multifamily property in Sunland presents an opportunity for a leveraged investor to acquire a 3-unit asset in a desirable San Fernando Valley neighborhood with potential for rental income growth. With a $400k budget covering down payment and closing costs, the investor can secure a position in a market with strong long-term appreciation potential.",
+      "risks": [
+        "No cap rate or financials disclosed, limiting due diligence capabilities",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Year built and square footage unknown, affecting property value and renovation needs"
+      ],
+      "upside": [
+        "Potential for value-add through renovations or rent increases if rent control is not in place",
+        "Strong location in Sunland with demand for multifamily housing",
+        "Leverage available to maximize returns with a relatively low down payment"
+      ],
+      "opportunity_score": 65,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 65
+  },
+  "crx2521992": {
+    "key": "bf3cfe0584aa",
+    "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 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 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
+  },
+  "crx2485727": {
+    "key": "b560b95891d7",
+    "qwen": {
+      "thesis": "This multifamily property in Sun Valley presents an opportunity for a leveraged investor to acquire a 5-unit asset in a desirable San Fernando Valley submarket. With the right financing and market conditions, there is potential for long-term appreciation and stable cash flow, though due diligence is critical given the lack of disclosed financials.",
+      "risks": [
+        "No cap rate or financials disclosed, increasing uncertainty around returns",
+        "Rent control status needs verification, which could impact rental income potential",
+        "Cash needed exceeds budget, requiring alternative financing or price negotiation"
+      ],
+      "upside": [
+        "Strong demand in Sun Valley for multifamily housing",
+        "Potential for value-add through unit upgrades or operational improvements",
+        "Strategic location in a growing submarket with limited inventory"
+      ],
+      "opportunity_score": 60,
+      "recommendation": "Watch"
+    },
+    "qwenScore": 60
   }
 }
\ No newline at end of file
diff --git a/data/ranked.json b/data/ranked.json
index 95203ae..0fce07a 100644
--- a/data/ranked.json
+++ b/data/ranked.json
@@ -73,7 +73,9 @@
         "cashFlow": 10678,
         "coc": 2.99,
         "dscr": 1.14,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": 101760,
+        "grossYield": 7.84
       },
       "financeScore": 50,
       "financeConf": "high",
@@ -155,7 +157,9 @@
         "cashFlow": 1533,
         "coc": 0.45,
         "dscr": 1.02,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": 112200,
+        "grossYield": 8.98
       },
       "financeScore": 35,
       "financeConf": "high",
@@ -203,7 +207,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -251,7 +257,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -335,7 +343,9 @@
         "cashFlow": 1851,
         "coc": 0.48,
         "dscr": 1.02,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": 121394,
+        "grossYield": 8.7
       },
       "financeScore": 35,
       "financeConf": "high",
@@ -383,7 +393,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -431,7 +443,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -480,7 +494,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -528,7 +544,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -577,7 +595,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -626,7 +646,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -675,7 +697,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -724,7 +748,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -773,7 +799,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -822,7 +850,9 @@
         "cashFlow": 8762,
         "coc": 2.77,
         "dscr": 1.13,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 49,
       "financeConf": "high",
@@ -871,7 +901,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -920,7 +952,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -943,6 +977,567 @@
       "composite": 48,
       "rank": 17
     },
+    {
+      "id": "crx2516747",
+      "address": "4538 Tujunga Avenue",
+      "city": "Studio City",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1399000,
+      "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/2516747/california-4538-tujunga-avenue",
+      "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 the desirable Studio City neighborhood 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, potentially benefiting from long-term appreciation and rental income growth in a strong submarket.",
+        "risks": [
+          "Cap rate is not disclosed, making it difficult to assess current returns and compare to market benchmarks",
+          "Rent control status needs verification, which could impact rental income potential and tenant retention",
+          "Financials and rent roll are not provided, increasing due diligence risk and uncertainty around cash flow"
+        ],
+        "upside": [
+          "Studio City is a high-demand area with strong rental market fundamentals and limited new supply",
+          "Potential for value-add through unit upgrades or repositioning",
+          "Leverage available to amplify returns if the property performs well"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 18
+    },
+    {
+      "id": "crx2589903",
+      "address": "17144 Burton Street",
+      "city": "Lake Balboa",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1250000,
+      "units": 3,
+      "sqft": null,
+      "cap_rate": null,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2589903/california-17144-burton-street",
+      "finance": {
+        "down": 312500,
+        "closing": 31250,
+        "cashNeeded": 343750,
+        "loan": 937500,
+        "annualDebtService": 72967,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Lake Balboa 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",
+          "Lack of property details (year built, square footage) may indicate potential hidden maintenance or renovation costs"
+        ],
+        "upside": [
+          "Potential for value-add through renovations or repositioning in a stable, growing neighborhood",
+          "Leverage available to increase returns if cash flow and appreciation materialize",
+          "Lake Balboa is a sought-after area with strong demand for rental housing"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 19
+    },
+    {
+      "id": "crx1080991",
+      "address": "14690 Hubbard Street",
+      "city": "Sylmar",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1388000,
+      "units": 7,
+      "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/1080991/california-14690-hubbard-street",
+      "finance": {
+        "down": 347000,
+        "closing": 34700,
+        "cashNeeded": 381700,
+        "loan": 1041000,
+        "annualDebtService": 81023,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Sylmar presents an opportunity for a leveraged buyer with a $400k budget to acquire a 7-unit asset in a growing submarket of the San Fernando Valley. With a 25% down payment, the purchase is within budget, and the property could benefit from value-add strategies such as rent increases or unit upgrades.",
+        "risks": [
+          "No cap rate or financials disclosed, making due diligence critical",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Year built and square footage not provided, limiting assessment of property condition and value"
+        ],
+        "upside": [
+          "Potential for rental income growth through market-rate repositioning",
+          "Opportunity to capitalize on Sylmar’s stable and growing population",
+          "Leverage available to increase returns if financials justify"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 20
+    },
+    {
+      "id": "crx2413872",
+      "address": "15057 Paddock",
+      "city": "Sylmar",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1329000,
+      "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/2413872/california-15057-paddock",
+      "finance": {
+        "down": 332250,
+        "closing": 33225,
+        "cashNeeded": 365475,
+        "loan": 996750,
+        "annualDebtService": 77579,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Sylmar presents an opportunity for a leveraged buyer with $400k available for down and closing costs. With a 25% down payment, the buyer can secure the property within budget, potentially capturing value in a growing area of the San Fernando Valley. Further due diligence on rent control status, cap rate, and financials is critical to assess long-term viability.",
+        "risks": [
+          "Rent control may limit rental income growth potential",
+          "Cap rate and NOI are not disclosed, increasing uncertainty",
+          "Year built and square footage unknown, which could impact property value and maintenance costs"
+        ],
+        "upside": [
+          "Potential for value appreciation in Sylmar’s real estate market",
+          "Leverage available to increase returns if financials are strong",
+          "Opportunity to acquire a 3-unit property at a potentially attractive price point"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 21
+    },
+    {
+      "id": "crx2412328",
+      "address": "20528-& 20526 Hamlin Street",
+      "city": "Winnetka",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1229777,
+      "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/2412328/california-20528-hamlin-street",
+      "finance": {
+        "down": 307444,
+        "closing": 30744,
+        "cashNeeded": 338189,
+        "loan": 922333,
+        "annualDebtService": 71787,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Winnetka offers an opportunity for a leveraged investor to enter the San Fernando Valley market with a 25% down payment, potentially benefiting from strong demand in the area. With $400k available for down and closing, the purchase is financially feasible, though due diligence on financials, rent control status, and property condition is critical.",
+        "risks": [
+          "No cap rate or NOI disclosed, making valuation and return estimation uncertain",
+          "Rent control status needs verification, which could impact long-term rental income and tenant stability",
+          "Year built and square footage are unknown, which may affect property value and renovation costs"
+        ],
+        "upside": [
+          "Winnetka is a desirable location with strong rental demand and appreciation potential",
+          "Leverage of $400k allows for a significant purchase with relatively low initial capital",
+          "Potential for value-add through renovations or rent increases if rent control is not in place"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 22
+    },
+    {
+      "id": "crx2516918",
+      "address": "23130 Victory",
+      "city": "Woodland Hills",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1250000,
+      "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/2516918/california-23130-victory",
+      "finance": {
+        "down": 312500,
+        "closing": 31250,
+        "cashNeeded": 343750,
+        "loan": 937500,
+        "annualDebtService": 72967,
+        "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 acquire a rental asset in a high-demand submarket with strong employment and population growth. With a $400k budget covering down payment and closing costs, the investor can secure a position in a desirable area with potential for long-term appreciation and rental income growth.",
+        "risks": [
+          "No cap rate or financials disclosed, making valuation and cash flow projections uncertain",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Lack of property details (year built, square footage) may indicate older or less efficient units"
+        ],
+        "upside": [
+          "Strong demand in Woodland Hills for rental properties due to proximity to employment centers and lifestyle amenities",
+          "Potential for value-add through unit upgrades or rent increases if rent control is not in place",
+          "Opportunity to leverage a relatively low down payment for higher cash-on-cash returns if financials prove favorable"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 23
+    },
+    {
+      "id": "crx2450078",
+      "address": "10018 Tujunga Canyon Boulevard",
+      "city": "Tujunga",
+      "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/2450078/california-10018-tujunga-canyon-boulevard",
+      "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 Tujunga presents an opportunity for a leveraged buyer with $400,000 available for down and closing. With a 25% down payment, the buyer can secure the property with significant remaining equity, potentially allowing for value-add strategies or rental growth in a historically stable market.",
+        "risks": [
+          "No cap rate or financials disclosed, making due diligence critical",
+          "Potential rent control implications could limit rental income growth",
+          "Year built and square footage unknown, which may affect property value and renovation costs"
+        ],
+        "upside": [
+          "Potential for rental income growth in a stable multifamily market",
+          "Opportunity to add value through unit upgrades or management improvements",
+          "Leverage available to increase returns if financials justify the purchase"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 24
+    },
+    {
+      "id": "crx2595754",
+      "address": "6911 Valmont Street",
+      "city": "Tujunga",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1399999,
+      "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/2595754/california-6911-valmont-street",
+      "finance": {
+        "down": 350000,
+        "closing": 35000,
+        "cashNeeded": 385000,
+        "loan": 1049999,
+        "annualDebtService": 81723,
+        "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 Tujunga 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 value-add through rent increases, unit upgrades, or repositioning in a growing area.",
+        "risks": [
+          "No financials or cap rate disclosed, making due diligence critical",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Year built and square footage unknown, complicating assessment of property condition and value"
+        ],
+        "upside": [
+          "Potential for rent growth in Tujunga, a historically stable multifamily market",
+          "Opportunity to add value through renovations or rebranding",
+          "Leverage available to amplify returns with a relatively low down payment"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 25
+    },
+    {
+      "id": "crx2411991",
+      "address": "10155 Mount Gleason",
+      "city": "Sunland",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1075000,
+      "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/2411991/california-10155-mount-gleason",
+      "finance": {
+        "down": 268750,
+        "closing": 26875,
+        "cashNeeded": 295625,
+        "loan": 806250,
+        "annualDebtService": 62752,
+        "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 Sunland presents an opportunity for a leveraged buyer with $400,000 available for down and closing. With a 25% down payment, the buyer can secure the property with significant remaining equity, potentially allowing for value-add strategies or future refinancing. Sunland’s strong market fundamentals and proximity to desirable amenities may support rental growth and long-term appreciation.",
+        "risks": [
+          "Lack of disclosed cap rate and financials increases uncertainty around cash flow and profitability.",
+          "Rent control status needs verification, which could impact rental income and long-term returns.",
+          "Missing property details (year built, square footage) may indicate lack of transparency or potential hidden issues."
+        ],
+        "upside": [
+          "Potential for value-add through unit upgrades, tenant improvements, or repositioning.",
+          "Sunland’s stable and growing market offers favorable conditions for multifamily investment.",
+          "Leverage available with a 25% down payment, allowing for higher returns if NOI is strong."
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 26
+    },
+    {
+      "id": "crx2461695",
+      "address": "11034 Scoville",
+      "city": "Sunland",
+      "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-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2461695/california-11034-scoville",
+      "finance": {
+        "down": 247250,
+        "closing": 24725,
+        "cashNeeded": 271975,
+        "loan": 741750,
+        "annualDebtService": 57732,
+        "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 with $400k available for down and closing costs. With a 25% down payment, the buyer can secure a loan with a 6.75% interest rate over 30 years, staying within budget. The location in Sunland, a desirable area within the San Fernando Valley, may offer long-term appreciation and stable rental demand.",
+        "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 value"
+        ],
+        "upside": [
+          "Potential for rental income growth in a stable and growing neighborhood",
+          "Opportunity to acquire a property in a high-demand area with potential for future appreciation",
+          "Leverage available to increase return on equity if NOI is strong"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 27
+    },
+    {
+      "id": "crx2559966",
+      "address": "10058 Sunland Boulevard",
+      "city": "Sunland",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1299900,
+      "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/2559966/california-10058-sunland-boulevard",
+      "finance": {
+        "down": 324975,
+        "closing": 32498,
+        "cashNeeded": 357473,
+        "loan": 974925,
+        "annualDebtService": 75880,
+        "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 investor to acquire a 3-unit asset in a desirable San Fernando Valley neighborhood with potential for rental income growth. With a $400k budget covering down payment and closing costs, the investor can secure a position in a market with strong long-term appreciation potential.",
+        "risks": [
+          "No cap rate or financials disclosed, limiting due diligence capabilities",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Year built and square footage unknown, affecting property value and renovation needs"
+        ],
+        "upside": [
+          "Potential for value-add through renovations or rent increases if rent control is not in place",
+          "Strong location in Sunland with demand for multifamily housing",
+          "Leverage available to maximize returns with a relatively low down payment"
+        ],
+        "opportunity_score": 65,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 65,
+      "composite": 48,
+      "rank": 28
+    },
     {
       "id": "crx2453716",
       "address": "8045 Darby",
@@ -969,7 +1564,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -989,7 +1586,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 18
+      "rank": 29
     },
     {
       "id": "crx2442308",
@@ -1017,7 +1614,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -1038,7 +1637,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 19
+      "rank": 30
     },
     {
       "id": "crx2413973",
@@ -1066,7 +1665,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -1087,7 +1688,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 20
+      "rank": 31
     },
     {
       "id": "crx2413947",
@@ -1115,7 +1716,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -1136,7 +1739,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 21
+      "rank": 32
     },
     {
       "id": "crx2566665",
@@ -1164,7 +1767,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -1185,7 +1790,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 22
+      "rank": 33
     },
     {
       "id": "crx2516979",
@@ -1213,7 +1818,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -1234,7 +1841,7 @@
       },
       "qwenScore": 60,
       "composite": 45,
-      "rank": 23
+      "rank": 34
     },
     {
       "id": "crx2141640",
@@ -1262,36 +1869,241 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This 4-unit multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing costs. With a 25% down payment, the required cash is within budget, allowing for potential acquisition and value-add through renovations or rent increases, assuming favorable market conditions and accurate financials.",
+        "risks": [
+          "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+          "Rent control status needs verification, which could limit rental income growth",
+          "Year built and square footage not provided, making it difficult to assess property condition and potential for value-add"
+        ],
+        "upside": [
+          "Potential for value-add through unit upgrades or operational improvements",
+          "Strategic location in Van Nuys, a stable and growing submarket within the San Fernando Valley",
+          "Leverage available to amplify returns if financials and cap rate prove favorable"
+        ],
+        "opportunity_score": 60,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 60,
+      "composite": 45,
+      "rank": 35
+    },
+    {
+      "id": "crx2413442",
+      "address": "6648 Gaviota Avenue",
+      "city": "Lake Balboa",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1169000,
+      "units": 2,
+      "sqft": null,
+      "cap_rate": null,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2413442/california-6648-gaviota-avenue",
+      "finance": {
+        "down": 292250,
+        "closing": 29225,
+        "cashNeeded": 321475,
+        "loan": 876750,
+        "annualDebtService": 68239,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 38,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Lake Balboa presents an opportunity for a leveraged buyer with $400k available for down and closing. With a 25% down payment, the required cash is within budget, allowing for potential appreciation and rental income generation in a desirable San Fernando Valley submarket.",
+        "risks": [
+          "No cap rate or financials disclosed, increasing uncertainty about cash flow and returns",
+          "Rent control status needs verification, which could impact long-term rental income and tenant stability",
+          "Year built and square footage are unknown, potentially affecting property value and renovation costs"
+        ],
+        "upside": [
+          "Potential for value-add through property improvements or rent increases if rent control is not in place",
+          "Strategic location in Lake Balboa may offer strong demand and appreciation potential",
+          "Leverage available to amplify returns if financials prove favorable"
+        ],
+        "opportunity_score": 60,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 60,
+      "composite": 45,
+      "rank": 36
+    },
+    {
+      "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": 37
+    },
+    {
+      "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": 38
+    },
+    {
+      "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 4-unit multifamily property in Van Nuys presents an opportunity for a leveraged buyer with $400k available for down and closing costs. With a 25% down payment, the required cash is within budget, allowing for potential acquisition and value-add through renovations or rent increases, assuming favorable market conditions and accurate financials.",
+        "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 limit rental income growth",
-          "Year built and square footage not provided, making it difficult to assess property condition and potential for value-add"
+          "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 operational improvements",
-          "Strategic location in Van Nuys, a stable and growing submarket within the San Fernando Valley",
-          "Leverage available to amplify returns if financials and cap rate prove favorable"
+          "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": 24
+      "rank": 39
     },
     {
-      "id": "crx2413442",
-      "address": "6648 Gaviota Avenue",
-      "city": "Lake Balboa",
+      "id": "crx2429890",
+      "address": "4813 Topanga Canyon",
+      "city": "Woodland Hills",
       "zip": "",
       "type": "Multifamily",
-      "price": 1169000,
+      "price": 1200000,
       "units": 2,
       "sqft": null,
       "cap_rate": null,
@@ -1300,48 +2112,50 @@
       "rent_control": "verify",
       "status": "Active",
       "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
-      "source": "https://www.crexi.com/properties/2413442/california-6648-gaviota-avenue",
+      "source": "https://www.crexi.com/properties/2429890/california-4813-topanga-canyon",
       "finance": {
-        "down": 292250,
-        "closing": 29225,
-        "cashNeeded": 321475,
-        "loan": 876750,
-        "annualDebtService": 68239,
+        "down": 300000,
+        "closing": 30000,
+        "cashNeeded": 330000,
+        "loan": 900000,
+        "annualDebtService": 70049,
         "noi": null,
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "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 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 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 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": [
-          "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"
+          "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": 25
+      "rank": 40
     },
     {
-      "id": "crx1715584",
-      "address": "Call Broker For Details!",
-      "city": "Northridge",
+      "id": "crx2521992",
+      "address": "10064 Sunland Boulevard",
+      "city": "Sunland",
       "zip": "",
-      "type": "Retail",
-      "price": 999950,
-      "units": 1,
+      "type": "Multifamily",
+      "price": 899999,
+      "units": 2,
       "sqft": null,
       "cap_rate": null,
       "verified": false,
@@ -1349,39 +2163,41 @@
       "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",
+      "source": "https://www.crexi.com/properties/2521992/california-10064-sunland-boulevard",
       "finance": {
-        "down": 249988,
-        "closing": 24999,
-        "cashNeeded": 274986,
-        "loan": 749963,
-        "annualDebtService": 58371,
+        "down": 225000,
+        "closing": 22500,
+        "cashNeeded": 247500,
+        "loan": 674999,
+        "annualDebtService": 52536,
         "noi": null,
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "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.",
+        "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 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 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 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 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": 26
+      "rank": 41
     },
     {
       "id": "crx2516882",
@@ -1409,7 +2225,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -1430,7 +2248,7 @@
       },
       "qwenScore": 55,
       "composite": 42,
-      "rank": 27
+      "rank": 42
     },
     {
       "id": "crx2488780",
@@ -1458,7 +2276,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 38,
       "financeConf": "low",
@@ -1478,7 +2298,7 @@
       },
       "qwenScore": 55,
       "composite": 42,
-      "rank": 28
+      "rank": 43
     },
     {
       "id": "correnti12600",
@@ -1505,7 +2325,9 @@
         "cashFlow": 54866,
         "coc": 6.05,
         "dscr": 1.28,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 28,
       "financeConf": "high",
@@ -1526,7 +2348,7 @@
       },
       "qwenScore": 65,
       "composite": 38,
-      "rank": 29
+      "rank": 44
     },
     {
       "id": "crx2414372",
@@ -1554,7 +2376,9 @@
         "cashFlow": 18021,
         "coc": 4.23,
         "dscr": 1.2,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 39,
       "financeConf": "high",
@@ -1575,7 +2399,7 @@
       },
       "qwenScore": 65,
       "composite": 38,
-      "rank": 30
+      "rank": 45
     },
     {
       "id": "amigo8357",
@@ -1628,7 +2452,9 @@
         "cashFlow": -2590,
         "coc": -0.75,
         "dscr": 0.96,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": 89460,
+        "grossYield": 7.16
       },
       "financeScore": 13,
       "financeConf": "high",
@@ -1649,7 +2475,7 @@
       },
       "qwenScore": 65,
       "composite": 36,
-      "rank": 31
+      "rank": 46
     },
     {
       "id": "wilbur9014",
@@ -1676,7 +2502,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -1697,7 +2525,7 @@
       },
       "qwenScore": 65,
       "composite": 35,
-      "rank": 32
+      "rank": 47
     },
     {
       "id": "crx2414120",
@@ -1725,7 +2553,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -1746,7 +2576,7 @@
       },
       "qwenScore": 65,
       "composite": 35,
-      "rank": 33
+      "rank": 48
     },
     {
       "id": "hillhaven10139",
@@ -1773,7 +2603,9 @@
         "cashFlow": -5462,
         "coc": -1.59,
         "dscr": 0.93,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 8,
       "financeConf": "high",
@@ -1794,7 +2626,7 @@
       },
       "qwenScore": 65,
       "composite": 34,
-      "rank": 34
+      "rank": 49
     },
     {
       "id": "crx2413999",
@@ -1822,7 +2654,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -1843,7 +2677,7 @@
       },
       "qwenScore": 60,
       "composite": 33,
-      "rank": 35
+      "rank": 50
     },
     {
       "id": "crx2417808",
@@ -1871,7 +2705,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -1892,7 +2728,7 @@
       },
       "qwenScore": 60,
       "composite": 33,
-      "rank": 36
+      "rank": 51
     },
     {
       "id": "crx2558648",
@@ -1920,7 +2756,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -1941,7 +2779,58 @@
       },
       "qwenScore": 60,
       "composite": 33,
-      "rank": 37
+      "rank": 52
+    },
+    {
+      "id": "crx2485727",
+      "address": "10802 Crockett Street",
+      "city": "Sun Valley",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1495000,
+      "units": 5,
+      "sqft": null,
+      "cap_rate": null,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2485727/california-10802-crockett-street",
+      "finance": {
+        "down": 373750,
+        "closing": 37375,
+        "cashNeeded": 411125,
+        "loan": 1121250,
+        "annualDebtService": 87269,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 20,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Sun Valley presents an opportunity for a leveraged investor to acquire a 5-unit asset in a desirable San Fernando Valley submarket. With the right financing and market conditions, there is potential for long-term appreciation and stable cash flow, though due diligence is critical given the lack of disclosed financials.",
+        "risks": [
+          "No cap rate or financials disclosed, increasing uncertainty around returns",
+          "Rent control status needs verification, which could impact rental income potential",
+          "Cash needed exceeds budget, requiring alternative financing or price negotiation"
+        ],
+        "upside": [
+          "Strong demand in Sun Valley for multifamily housing",
+          "Potential for value-add through unit upgrades or operational improvements",
+          "Strategic location in a growing submarket with limited inventory"
+        ],
+        "opportunity_score": 60,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 60,
+      "composite": 33,
+      "rank": 53
     },
     {
       "id": "burbank10701",
@@ -1968,7 +2857,9 @@
         "cashFlow": 40939,
         "coc": 5.32,
         "dscr": 1.25,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 24,
       "financeConf": "high",
@@ -1989,7 +2880,7 @@
       },
       "qwenScore": 55,
       "composite": 32,
-      "rank": 38
+      "rank": 54
     },
     {
       "id": "vannuys6329",
@@ -2017,7 +2908,9 @@
         "cashFlow": -9010,
         "coc": -2.43,
         "dscr": 0.89,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 3,
       "financeConf": "high",
@@ -2038,7 +2931,7 @@
       },
       "qwenScore": 65,
       "composite": 31,
-      "rank": 39
+      "rank": 55
     },
     {
       "id": "crx2455873",
@@ -2066,7 +2959,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -2087,7 +2982,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 40
+      "rank": 56
     },
     {
       "id": "crx2592616",
@@ -2115,7 +3010,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -2136,7 +3033,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 41
+      "rank": 57
     },
     {
       "id": "crx2412907",
@@ -2164,7 +3061,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -2185,7 +3084,7 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 42
+      "rank": 58
     },
     {
       "id": "crx2473428",
@@ -2213,7 +3112,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -2234,7 +3135,160 @@
       },
       "qwenScore": 55,
       "composite": 31,
-      "rank": 43
+      "rank": 59
+    },
+    {
+      "id": "crx2412878",
+      "address": "22137 Gault Street",
+      "city": "Canoga Park",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1585000,
+      "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/2412878/california-22137-gault",
+      "finance": {
+        "down": 396250,
+        "closing": 39625,
+        "cashNeeded": 435875,
+        "loan": 1188750,
+        "annualDebtService": 92523,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 20,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Canoga Park presents an opportunity for a leveraged buyer to acquire a 3-unit investment with potential for value-add through rent increases and property improvements. However, the required down payment exceeds the available budget, necessitating careful evaluation of financing options and property-specific risks.",
+        "risks": [
+          "Insufficient down payment to meet lender requirements without additional capital or alternative financing",
+          "Lack of disclosed cap rate and financials increases uncertainty around cash flow and returns",
+          "Rent control status may limit rental income growth potential"
+        ],
+        "upside": [
+          "Potential for rental income growth through market-rate repositioning if rent control is not in place",
+          "Value-add opportunities through unit upgrades or operational efficiencies",
+          "Strategic location in the San Fernando Valley with long-term appreciation potential"
+        ],
+        "opportunity_score": 55,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 55,
+      "composite": 31,
+      "rank": 60
+    },
+    {
+      "id": "crx2584910",
+      "address": "22130 Gault Street",
+      "city": "Canoga Park",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1695000,
+      "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/2584910/california-22130-gault-street",
+      "finance": {
+        "down": 423750,
+        "closing": 42375,
+        "cashNeeded": 466125,
+        "loan": 1271250,
+        "annualDebtService": 98944,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 20,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This multifamily property in Canoga Park presents an opportunity for a value-add investor with a $400k budget, assuming the asking price is negotiable or financing terms can be adjusted. The location in the San Fernando Valley offers strong long-term appreciation potential and demand for rental housing, though due diligence on cap rate, rent control status, and financials is critical before proceeding.",
+        "risks": [
+          "Insufficient down payment (computed $466k vs $400k budget)",
+          "No cap rate or financials disclosed, increasing uncertainty",
+          "Potential rent control restrictions impacting rental income and flexibility"
+        ],
+        "upside": [
+          "Strong location in a growing submarket with demand for multifamily units",
+          "Potential for value-add through unit upgrades or rent increases",
+          "Opportunity to secure a property at a discount if the asking price is negotiable"
+        ],
+        "opportunity_score": 55,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 55,
+      "composite": 31,
+      "rank": 61
+    },
+    {
+      "id": "crx2569982",
+      "address": "7228 Independence",
+      "city": "Canoga Park",
+      "zip": "",
+      "type": "Multifamily",
+      "price": 1495000,
+      "units": 5,
+      "sqft": null,
+      "cap_rate": null,
+      "verified": false,
+      "year_built": null,
+      "rent_control": "verify",
+      "status": "Active",
+      "upside_note": "Auto-added by weekly Crexi refresh 2026-06-22. Cap not disclosed. Verify status, rent roll, and financials before acting.",
+      "source": "https://www.crexi.com/properties/2569982/california-7228-independence",
+      "finance": {
+        "down": 373750,
+        "closing": 37375,
+        "cashNeeded": 411125,
+        "loan": 1121250,
+        "annualDebtService": 87269,
+        "noi": null,
+        "cashFlow": null,
+        "coc": null,
+        "dscr": null,
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
+      },
+      "financeScore": 20,
+      "financeConf": "low",
+      "qwen": {
+        "thesis": "This 5-unit multifamily property in Canoga Park presents an opportunity for a leveraged investor to acquire a rental asset in a high-demand submarket. However, the required down payment and closing costs exceed the $400k budget, necessitating careful evaluation of the property’s financials, rent roll, and cap rate before proceeding.",
+        "risks": [
+          "Insufficient down payment to meet the computed $411,125 requirement",
+          "Lack of disclosed cap rate and financials increases uncertainty",
+          "Rent control status may impact long-term rental income and property value"
+        ],
+        "upside": [
+          "Potential for value-add through unit upgrades or operational improvements",
+          "Strong demand in the San Fernando Valley for multifamily housing",
+          "Strategic location in Canoga Park with growth potential"
+        ],
+        "opportunity_score": 55,
+        "recommendation": "Watch"
+      },
+      "qwenScore": 55,
+      "composite": 31,
+      "rank": 62
     },
     {
       "id": "sepulveda8144",
@@ -2261,7 +3315,9 @@
         "cashFlow": -11723,
         "coc": -3.04,
         "dscr": 0.86,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -2282,7 +3338,7 @@
       },
       "qwenScore": 65,
       "composite": 29,
-      "rank": 44
+      "rank": 63
     },
     {
       "id": "canby7260",
@@ -2309,7 +3365,9 @@
         "cashFlow": -15495,
         "coc": -3.95,
         "dscr": 0.81,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -2330,7 +3388,7 @@
       },
       "qwenScore": 65,
       "composite": 29,
-      "rank": 45
+      "rank": 64
     },
     {
       "id": "wilkinson5214",
@@ -2357,7 +3415,9 @@
         "cashFlow": -25480,
         "coc": -6.86,
         "dscr": 0.68,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -2378,7 +3438,7 @@
       },
       "qwenScore": 65,
       "composite": 29,
-      "rank": 46
+      "rank": 65
     },
     {
       "id": "tilden8837",
@@ -2405,7 +3465,9 @@
         "cashFlow": -4831,
         "coc": -1.95,
         "dscr": 0.91,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 6,
       "financeConf": "high",
@@ -2426,7 +3488,7 @@
       },
       "qwenScore": 55,
       "composite": 28,
-      "rank": 47
+      "rank": 66
     },
     {
       "id": "crx2560155",
@@ -2454,7 +3516,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -2475,7 +3539,7 @@
       },
       "qwenScore": 50,
       "composite": 28,
-      "rank": 48
+      "rank": 67
     },
     {
       "id": "crx2352672",
@@ -2503,7 +3567,9 @@
         "cashFlow": 7414,
         "coc": 1.61,
         "dscr": 1.08,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 24,
       "financeConf": "high",
@@ -2524,7 +3590,7 @@
       },
       "qwenScore": 55,
       "composite": 28,
-      "rank": 49
+      "rank": 68
     },
     {
       "id": "crx2516587",
@@ -2552,7 +3618,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 20,
       "financeConf": "low",
@@ -2573,7 +3641,7 @@
       },
       "qwenScore": 50,
       "composite": 28,
-      "rank": 50
+      "rank": 69
     },
     {
       "id": "crx2455604",
@@ -2601,7 +3669,9 @@
         "cashFlow": -3195,
         "coc": -0.97,
         "dscr": 0.95,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 12,
       "financeConf": "high",
@@ -2622,7 +3692,7 @@
       },
       "qwenScore": 55,
       "composite": 27,
-      "rank": 51
+      "rank": 70
     },
     {
       "id": "vannuys12872",
@@ -2649,7 +3719,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 13,
       "financeConf": "low",
@@ -2670,7 +3742,7 @@
       },
       "qwenScore": 65,
       "composite": 26,
-      "rank": 52
+      "rank": 71
     },
     {
       "id": "comercio5301",
@@ -2697,7 +3769,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 13,
       "financeConf": "low",
@@ -2718,7 +3792,7 @@
       },
       "qwenScore": 65,
       "composite": 26,
-      "rank": 53
+      "rank": 72
     },
     {
       "id": "crx2569960",
@@ -2746,7 +3820,9 @@
         "cashFlow": 1096,
         "coc": 0.23,
         "dscr": 1.01,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 16,
       "financeConf": "high",
@@ -2767,7 +3843,7 @@
       },
       "qwenScore": 55,
       "composite": 26,
-      "rank": 54
+      "rank": 73
     },
     {
       "id": "victory13350",
@@ -2794,7 +3870,9 @@
         "cashFlow": -17516,
         "coc": -4.9,
         "dscr": 0.77,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -2815,7 +3893,7 @@
       },
       "qwenScore": 55,
       "composite": 25,
-      "rank": 55
+      "rank": 74
     },
     {
       "id": "crx2489729",
@@ -2843,7 +3921,9 @@
         "cashFlow": -6850,
         "coc": -1.85,
         "dscr": 0.91,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 7,
       "financeConf": "high",
@@ -2864,7 +3944,7 @@
       },
       "qwenScore": 50,
       "composite": 23,
-      "rank": 56
+      "rank": 75
     },
     {
       "id": "canoga6020",
@@ -2891,7 +3971,9 @@
         "cashFlow": 28194,
         "coc": 1.86,
         "dscr": 1.09,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -2912,7 +3994,7 @@
       },
       "qwenScore": 55,
       "composite": 21,
-      "rank": 57
+      "rank": 76
     },
     {
       "id": "vanowen15840",
@@ -2939,7 +4021,9 @@
         "cashFlow": -5698,
         "coc": -2.14,
         "dscr": 0.9,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -2960,7 +4044,7 @@
       },
       "qwenScore": 60,
       "composite": 18,
-      "rank": 58
+      "rank": 77
     },
     {
       "id": "crx2448930",
@@ -2988,7 +4072,9 @@
         "cashFlow": -12547,
         "coc": -2.61,
         "dscr": 0.88,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -3009,7 +4095,7 @@
       },
       "qwenScore": 50,
       "composite": 18,
-      "rank": 59
+      "rank": 78
     },
     {
       "id": "crx2563662",
@@ -3037,7 +4123,9 @@
         "cashFlow": -27092,
         "coc": -7.88,
         "dscr": 0.63,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -3058,7 +4146,7 @@
       },
       "qwenScore": 45,
       "composite": 18,
-      "rank": 60
+      "rank": 79
     },
     {
       "id": "crx2147226",
@@ -3086,7 +4174,9 @@
         "cashFlow": -19464,
         "coc": -7.63,
         "dscr": 0.64,
-        "affordable": true
+        "affordable": true,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "high",
@@ -3107,7 +4197,7 @@
       },
       "qwenScore": 45,
       "composite": 18,
-      "rank": 61
+      "rank": 80
     },
     {
       "id": "canby7454",
@@ -3134,7 +4224,9 @@
         "cashFlow": null,
         "coc": null,
         "dscr": null,
-        "affordable": false
+        "affordable": false,
+        "grossAnnual": null,
+        "grossYield": null
       },
       "financeScore": 0,
       "financeConf": "low",
@@ -3155,7 +4247,7 @@
       },
       "qwenScore": 55,
       "composite": 16,
-      "rank": 62
+      "rank": 81
     }
   ]
 }
\ No newline at end of file
diff --git a/public/finance.js b/public/finance.js
index 64507d5..7649286 100644
--- a/public/finance.js
+++ b/public/finance.js
@@ -29,8 +29,14 @@
       dscr = ads > 0 ? +(noi / ads).toFixed(2) : null; // null = all-cash (no debt)
     }
     const affordable = cashNeeded <= A.budget;
+    // Gross rent yield ("rent close to price") = annual gross rent / price, from ACTUAL rent data only.
+    let grossAnnual = null;
+    if (L.gross_actual) grossAnnual = L.gross_actual;
+    else if (L.gross_proforma) grossAnnual = L.gross_proforma;
+    else if (Array.isArray(L.rent_roll) && L.rent_roll.length) grossAnnual = L.rent_roll.reduce((s, u) => s + (u.rent || 0), 0) * 12;
+    const grossYield = grossAnnual ? +(grossAnnual / L.price * 100).toFixed(2) : null;
     return { down: Math.round(down), closing: Math.round(closing), cashNeeded, loan: Math.round(loan),
-      annualDebtService: Math.round(ads), noi, cashFlow, coc, dscr, affordable };
+      annualDebtService: Math.round(ads), noi, cashFlow, coc, dscr, affordable, grossAnnual, grossYield };
   }
 
   // Deterministic finance score 0-100 (return-driven; honest about negative leverage)
diff --git a/public/index.html b/public/index.html
index 3f0b58c..b77cc58 100644
--- a/public/index.html
+++ b/public/index.html
@@ -98,6 +98,7 @@
     <select id="sort">
       <option value="composite">Best Investment (blended)</option>
       <option value="coc">Cash-on-Cash ↓</option>
+      <option value="yield">Rent Yield (rent÷price) ↓</option>
       <option value="cap">Cap Rate ↓</option>
       <option value="dscr">DSCR ↓</option>
       <option value="priceAsc">Price ↑</option>
@@ -166,7 +167,7 @@ function card(p){
       <div><div class="rank">#${p.rank} · score</div><div class="addr">${p.address}</div><div class="city">${p.city}, CA ${p.zip||''}</div></div>
       <div class="score">${p.composite}<small>fin ${p.financeScore}${p.qwenScore!=null?' · ai '+p.qwenScore:''}</small></div>
     </div>
-    <div class="badges"><span class="b type">${p.type}</span><span class="b">${p.units} unit${p.units>1?'s':''}</span><span class="b">${fmt(p.price)}</span>${capB}${verB}${statusB} ${aff} ${rec}</div>
+    <div class="badges"><span class="b type">${p.type}</span><span class="b">${p.units} unit${p.units>1?'s':''}</span><span class="b">${fmt(p.price)}</span>${capB}${verB}${f.grossYield?`<span class="b ok" title="Annual gross rent ÷ price — higher = rent closer to price">${f.grossYield}% rent yld</span>`:''}${statusB} ${aff} ${rec}</div>
     <div class="metrics">
       <div><span class="k">Cash-on-cash</span><span class="v ${cls(f.coc,6,3)}">${pct(f.coc)}</span></div>
       <div><span class="k">DSCR</span><span class="v ${cls(f.dscr,1.25,1.0)}">${f.dscr??'—'}</span></div>
@@ -191,6 +192,7 @@ function render(){
   if(maxPrice) r=r.filter(p=>p.price<=maxPrice);
   const s=$('#sort').value, num=v=>v==null?-1e9:v;
   const S={ composite:(a,b)=>b.composite-a.composite, coc:(a,b)=>num(b.finance.coc)-num(a.finance.coc),
+    yield:(a,b)=>num(b.finance.grossYield)-num(a.finance.grossYield),
     cap:(a,b)=>num(b.cap_rate)-num(a.cap_rate), dscr:(a,b)=>num(b.finance.dscr)-num(a.finance.dscr),
     priceAsc:(a,b)=>a.price-b.price, priceDesc:(a,b)=>b.price-a.price, cashNeeded:(a,b)=>a.finance.cashNeeded-b.finance.cashNeeded };
   r.sort(S[s]);
diff --git a/scripts/morning-report.js b/scripts/morning-report.js
index aa19a00..ad0dad3 100644
--- a/scripts/morning-report.js
+++ b/scripts/morning-report.js
@@ -52,7 +52,7 @@ const recap = (p, i) => {
   return `<div style="border-top:1px solid #e2e2e2;padding:10px 0">
     <div style="font-size:14px"><b>#${i + 1}. <a href="${p.source}">${p.address}</a>, ${p.city}</b> &nbsp;<span style="color:#888;font-weight:400">score ${p.composite}</span></div>
     <div style="color:#666;font-size:12px">${p.type} · ${p.units} unit${p.units > 1 ? 's' : ''}${p.year_built ? ` · built ${p.year_built}` : ''} · ${fmt(p.price)} · cap ${cap} (${ver})</div>
-    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>${fmt(f.cashNeeded)}</b> (${f.affordable ? 'in budget' : 'OVER budget'}) · CoC ${f.coc != null ? f.coc + '%' : 'n/a'} · DSCR ${f.dscr ?? 'n/a'} · est NOI ${f.noi ? fmt(f.noi) : 'n/d'}</div>
+    <div style="font-size:12px;color:#333;margin:3px 0">Cash to close <b>${fmt(f.cashNeeded)}</b> (${f.affordable ? 'in budget' : 'OVER budget'}) · CoC ${f.coc != null ? f.coc + '%' : 'n/a'} · DSCR ${f.dscr ?? 'n/a'} · est NOI ${f.noi ? fmt(f.noi) : 'n/d'}${f.grossYield ? ' · rent yield ' + f.grossYield + '% (rent÷price)' : ''}</div>
     ${p.qwen && p.qwen.thesis ? `<div style="font-size:13px;color:#222;margin:4px 0">${p.qwen.thesis}</div>` : ''}
     ${rr}${risks}
     <div style="font-size:12px;color:#555">${p.upside_note || ''}</div>
diff --git a/scripts/refresh-listings.js b/scripts/refresh-listings.js
index 8577ffa..8ac05b3 100644
--- a/scripts/refresh-listings.js
+++ b/scripts/refresh-listings.js
@@ -11,7 +11,7 @@ const ROOT = path.join(__dirname, '..');
 const bbEnv = fs.readFileSync(process.env.HOME + '/.claude/skills/browserbase/.env', 'utf8');
 const get = (t, k) => (t.match(new RegExp('^' + k + '=(.*)$', 'm')) || [])[1]?.replace(/['"]/g, '').trim();
 
-const NAV_CITIES = ['Van Nuys', 'Reseda', 'North Hollywood', 'Northridge', 'Panorama City', 'Canoga Park', 'Sherman Oaks', 'Sun Valley', 'Encino', 'Granada Hills'];
+const NAV_CITIES = (process.env.CC_NAV ? process.env.CC_NAV.split(',').map(s => s.trim()) : ['Van Nuys', 'Reseda', 'North Hollywood', 'Northridge', 'Panorama City', 'Canoga Park', 'Sherman Oaks', 'Sun Valley', 'Encino', 'Granada Hills']);
 const TYPES = [['multifamily', 'Multifamily'], ['retail', 'Retail']];
 // Accept captured assets whose city is anywhere in the SFV:
 const SFV = new Set(['van nuys', 'reseda', 'north hollywood', 'northridge', 'panorama city', 'canoga park',

← f205d2c Verify Granada Hills #1 (pro-forma 6.66%, lease-up risk) + d  ·  back to Commercialrealestate  ·  weekly Crexi refresh 2026-06-22 a3711a1 →