← Off-Market Pipeline
18612 Selma Ave
APN: 5549-029-059 Hollywood / Franklin Village 39 units Built 1948 Untouched
45
Signal Score
Score Breakdown — Show Your Work 10 signals · 0–100 scale
Long hold
28.7 years
Prop 13 locks assessed value near purchase price; longer hold = larger gap to market
📂 LA County Assessor — Deed transfer records (last_sale_date field)
years_held
+22
Prop 13 equity gap
Assessed $5.85M vs ~$10.7M est. market (55% of comp)
At 55% of submarket comp, locked equity creates sell/refi pressure
📂 LA County Assessor 2024 roll — annual assessed value (data.lacounty.gov)
assessed_total, units
+8
Owner entity: trust
Lopez Trust
Trust ownership signals estate/succession planning; trustee sales common
📂 LA County Assessor — owner-of-record (assessment roll)
owner_type, owner_name
+15
Refi recency pending
data pending
Recorder ingestion pending for this parcel; signal excluded from score
📂 LA County Recorder (rrcc.lacounty.gov) — Deed of Trust records
years_since_last_dot
Final Score (0–100 cap) 45
Ownership LA County Assessor — owner of record
Current Owner
Lopez Trust
Held 28.7 years (since 1997)
trust
Full deed chain data pending — Recorder data loads as parcels are processed via jobs/recorder-ingest.js.
Most recent recorded transfer type: foreclosure
Loan & Deed of Trust History LA County RR/CC — rrcc.lacounty.gov
NOD Filed data pending
Current Lender data pending
Years Since Last Refi data pending
Recorder Data Not yet ingested
Deed of Trust detail loads after jobs/recorder-ingest.js runs for this parcel. LA County RR/CC is intermittently unreachable; data populates when the server responds.
LA Underwriting Flags Pending — run jobs/la-flags-ingest.js
🔵 RSO Status
data pending
Run jobs/la-flags-ingest.js to populate RSO status from LAHD dataset.
Source: LAHD RSO dataset · LAMC §151.02
🟡 ULA Mansion Tax
data pending
Run la-flags-ingest job to compute ULA exposure.
Source: Measure ULA · LA City Ordinance 187382 (Apr 2023)
🔴 Soft-Story Retrofit
data pending
Run jobs/la-flags-ingest.js to pull LADBS Soft-Story list data.
Source: LADBS Soft-Story Retrofit Program · Ordinance #183893
Owner Contact Enrichment
One-click lookups — opens in new tab
Saved Contacts (0)
No contacts saved yet. Use the lookup buttons above to research, then log what you find below.
Add Contact
LA Underwriting Pro-Forma RSO · ULA · Soft-story · Cap rate — every number cited
🔵 RSO Rent Roll Model ?
RSO status unknown — run jobs/la-flags-ingest.js to populate LAHD data.
🟡 ULA Mansion Tax Exposure ?
Projected sale price $10.72M
Formula: max(AV × 1.5 = $$8.78M, submarket $/unit × units = $$10.72M)
ULA Tier Tier 2 — $10.3M+ (5.5%)
ULA Tax Exposure $590K
Source: Measure ULA · LA City Ordinance 187382, effective Apr 1, 2023.
Tax is paid by seller at close of escrow. This is the seller's largest hidden transaction cost.
🔴 Soft-Story Retrofit Capex
data pending — run jobs/la-flags-ingest.js to check LADBS soft-story status for this APN.
📊 Implied Cap Rate — AV vs Market
Rent basis submarket median rent
Gross Scheduled Income (GSI) $913K/yr
Effective Gross Income (95.0% occ.) $867K/yr
Net Operating Income (65.0% of EGI) $564K/yr
At Assessed Value
(Prop-13 locked — understated)
9.6%
$5.85M AV
At Market Value
(comp-adjusted)
5.3%
$10.72M market est.
Vacancy: 5.0% assumed (CBRE LA Multifamily 2024 avg).
Opex: 35.0% of EGI (industry standard for LA multifamily — mgmt, taxes, insurance, maintenance).
AV cap is artificially high because Prop-13 AV is locked near purchase price. Gap = owner's hidden equity.
Honesty disclaimer: All figures cite public-record sources or carry a "data pending" label. No fabricated rents, no assumed financing terms, no fake NOI. Rent estimates use LAHD / HUD FMR medians — actual rents may vary. Cap rates use assumed vacancy and opex ratios standard for LA multifamily.
Comparable Sales Last 24 months · Hollywood / Franklin Village submarket (no lat/lon for radius)
No comps within Hollywood / Franklin Village submarket in last 24 months with recorded sale prices.
This is real data — no fabrication. LA County Recorder data for recent sales may lag 60–90 days.
Notes & Outreach Untouched
Update Outreach State
Raw Parcel Data
{ "id": 882, "apn": "5549-029-059", "address": "18612 Selma Ave", "city": "Los Angeles", "submarket": "Hollywood / Franklin Village", "units": 39, "year_built": 1948, "use_code": "0504", "use_code_label": "Apartment Building (31+ units)", "assessed_land": "3571000", "assessed_improvement": "2281000", "assessed_total": "5852000", "last_sale_date": "1997-09-07T00:00:00.000Z", "last_sale_price": "13450000", "last_transfer_type": "foreclosure", "years_held": "28.7", "owner_name": "Lopez Trust", "owner_type": "trust", "signal_score": 45, "signals_fired": [ { "note": "Prop 13 locks assessed value near purchase price; longer hold = larger gap to market", "field": "years_held", "value": "28.7 years", "points": 22, "signal": "Long hold", "pending": false, "source_dataset": "LA County Assessor — Deed transfer records (last_sale_date field)" }, { "note": "At 55% of submarket comp, locked equity creates sell/refi pressure", "field": "assessed_total, units", "value": "Assessed $5.85M vs ~$10.7M est. market (55% of comp)", "points": 8, "signal": "Prop 13 equity gap", "pending": false, "source_dataset": "LA County Assessor 2024 roll — annual assessed value (data.lacounty.gov)" }, { "note": "Trust ownership signals estate/succession planning; trustee sales common", "field": "owner_type, owner_name", "value": "Lopez Trust", "points": 15, "signal": "Owner entity: trust", "pending": false, "source_dataset": "LA County Assessor — owner-of-record (assessment roll)" }, { "note": "Recorder ingestion pending for this parcel; signal excluded from score", "field": "years_since_last_dot", "value": "data pending", "points": 0, "signal": "Refi recency", "pending": true, "source_dataset": "LA County Recorder (rrcc.lacounty.gov) — Deed of Trust records" } ], "signal_type": "long_hold", "status": "active", "created_at": "2026-05-22T20:25:56.441Z", "updated_at": "2026-05-22T21:17:01.935Z", "years_since_last_dot": null, "current_lender": null, "ownership_chain": [], "has_recent_nod": null, "recorder_raw": {}, "recorder_fetched_at": null, "assessor_enriched_at": null, "score_breakdown": [ { "note": "Prop 13 locks assessed value near purchase price; longer hold = larger gap to market", "field": "years_held", "value": "28.7 years", "points": 22, "signal": "Long hold", "pending": false, "source_dataset": "LA County Assessor — Deed transfer records (last_sale_date field)" }, { "note": "At 55% of submarket comp, locked equity creates sell/refi pressure", "field": "assessed_total, units", "value": "Assessed $5.85M vs ~$10.7M est. market (55% of comp)", "points": 8, "signal": "Prop 13 equity gap", "pending": false, "source_dataset": "LA County Assessor 2024 roll — annual assessed value (data.lacounty.gov)" }, { "note": "Trust ownership signals estate/succession planning; trustee sales common", "field": "owner_type, owner_name", "value": "Lopez Trust", "points": 15, "signal": "Owner entity: trust", "pending": false, "source_dataset": "LA County Assessor — owner-of-record (assessment roll)" }, { "note": "Recorder ingestion pending for this parcel; signal excluded from score", "field": "years_since_last_dot", "value": "data pending", "points": 0, "signal": "Refi recency", "pending": true, "source_dataset": "LA County Recorder (rrcc.lacounty.gov) — Deed of Trust records" } ], "submarket_velocity": null, "scored_at": "2026-05-22T21:17:01.935Z", "rso_status": "unknown", "ula_flag": null, "soft_story_status": "unknown", "la_flags_ingest_at": null, "owner_normalized": "LOPEZ", "lat": null, "lng": null, "last_contact_verified_at": null }