Triplex
489-491 Guerrero St · San Francisco, CA
Flood risk 1/10 · Minimal
- FEMA flood zone
- X (unshaded)
- Chance of flooding over 30 yrs
- 0.0%
- Est. flood insurance / yr
- $507 – $1,088
Fire risk 1/10 · Minimal
- Est. fire insurance / yr
- $659 – $1,223
Heat risk 2/10 · Minimal
- Hot days now (above 78°F)
- 8 days/yr
- Hot days in 30 yrs
- 19 days/yr
Wind risk 1/10 · Minimal
- Chance of severe wind over 30 yrs
- —
Air-quality risk 8/10 · Major
- Unhealthy air days now
- 15 days/yr
- Unhealthy air days in 30 yrs
- 15 days/yr
Risk factors via First Street. Map © Google.
Why this score? — see what drove the B- grade
The composite is a weighted blend of 9 inputs, each scored 0–100. Each bar is that input's sub-score; the figure is the points it added to the 100-point composite (weight × sub-score).
- Cash flow +27.7/30.0
- DSCR +9.8/10.0
- ARV discount +7.5/15.0
- 1% rule +6.3/10.0
- Rent growth +5.0/5.0
- Schools +5.0/10.0
- Livability +3.8/5.0
- Condition / age +2.5/5.0
- Appreciation +0.0/10.0
$1,495,000
🖨 Deal sheet 📄 Offer letter ✓ Due diligence
Multi-family units
County records classify this as Multi-Family (2-4 Unit). Listing-text estimate: 3 units. confirmed
Listing remarks
Exceptional mixed-use opportunity in the heart of Mission Dolores, featuring three units and a beautifully renovated vacant owner's residence. The property consists of a spacious top-floor 3-bedroom, 1-bathroom residential flat above two ground-floor commercial spaces, offering an ideal opportunity for owner-users, investors, or those seeking a live/work configuration. The recently remodeled residence showcases bright, modern interiors with wide-plank flooring, soaring ceilings, abundant natural light, and a thoughtfully redesigned open-concept kitchen featuring custom cabinetry, stone countertops, stainless steel appliances, and a large center island. The home also includes three well pro
Key facts
- Custom cabinetry
- Stone countertops
- Open-concept kitchen
Tags
Property features AI
Finance
- Financial info: Operating as a triplex with one unit leased and two vacant
- HOA & community: No association fee
Exterior
- Home design: Residential income property configured as a triplex; Three total units (one leased, two vacant)
- Construction: Built in 1906
- Exterior features: Lot has no notable features listed
Interior
- Bedrooms: Three bedrooms (one unit described as a 3-bedroom top floor unit)
- Bathrooms: One full bathroom
- Interior features: Top floor living space (Unit 1 described as a top floor unit)
Neighborhood map
What this means for you Summary
Snapshot
- This is a 3 × 3-bed/1.0-bath units multifamily listed at $1.50M.
Deal economics
- At list price, monthly cash flow is $5k ($54k/yr) — positive. Per door: $2k/mo.
- The deal already cash-flows at list — no discount required.
- Meets the 1% rule at list price ($17k rent vs $1.50M).
- Cap rate 9.9% vs local median 2.1% in San Francisco — top-decile yield for the area; either an underpriced asset or a hidden risk that comps aren't pricing in. Stress-test before assuming the spread holds.
Location & tenants
- Location reads 76/100 on livability (#90 in CA, #3,143 nationally) — a middle-class / working-renter tenant base. Strengths: amenities A+, commute A+, employment A+; Watch: crime F, cost of living F.
- San Francisco Unified (urban): math 50% / reading 56% proficiency, ranked #322 of 1,400 in CA (top 23%) — acceptable for families but not a draw, mixed tenant base, ~2y average lease.
- Market conditions: Rents rising fast (+14.5%/yr); 161 active listings in the ZIP; high-income renter base; 750 units permitted in San Francisco County in 2024 (688 in 5+ unit buildings).
- At $16,821/mo this rent would consume 127% of the median local household income ($158k/yr) (locally 2732% of renters already pay >50% of income on rent) — very limited rent-growth headroom before tenants either downsize or default.
Forward outlook
- Local home prices are declining (-3.0%/yr); year-one equity from $10k of loan paydown is wiped out by about $45k of value loss. Plan a longer hold.
- San Francisco County population projected at +39% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.
- At projected returns (-3.0% appreciation + 8.0% rent growth), your $419k cash investment doubles in ~7 years — after that, you're playing with house money.
Negotiation context
- Only 2 days on market — expect competitive offers; lowballing is unlikely to land.
- 2 sale attempts with the ask held roughly flat each time — persistent listings suggest the price (not the market) is what's stuck; bring a comps-based counter.
Risks & watch-outs
- Watch-outs: built in 1906 — expect roof / HVAC / electrical / plumbing capex.
Questions for the listing agent
- Can we see the unit-by-unit rent roll, current vacancy, and any below-market leases? What's the average tenancy length?
- What capital expenditures (roof, boiler, parking lot, exteriors) have been made in the last 5 years, and what's planned in the next 2?
- Built in 1906 — when were the roof, HVAC, electrical panel, plumbing, and water heater last replaced?
- Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
- Schools are B-rated — typically a magnet for longer-tenancy family renters. What's the average tenant stay here, and is there a school-zone premium baked into asking?
- Crime grade is F in this area — have there been break-ins, vandalism, or insurance claims at this property in the last 3 years? What carrier currently insures it and at what premium?
- What's the average days-on-market for RENTAL listings here right now (not sales)? A rising rental-DOM trend means longer vacancies and softer asking-rent achievability than the comps imply.
- What's the recent tenant-quality profile in this submarket — average credit score on applications, eviction rate, late-payment / NSF rate, and stable-employment percentage? A property-management company in the area should have these aggregated.
- How much new apartment / multifamily construction is in the pipeline within 1–3 miles? Heavy new supply (>2% of stock underway) typically softens rents 12–24 months out; light construction supports rent growth.
Investment metrics
- 1% rule
- 1.13% ✓
- Cap rate
- 9.92%
- Cash-on-cash
- 12.94%
- DSCR
- 1.58
- GRM
- 7.4
CMA / ARV
No comps found within radius.
Projected returns pro-forma
-3.0% appreciation · 8.0% rent growth · sell at horizon
- IRR
- 7.7%
- Equity multiple
- 1.32×
- Total profit
- $133,536
- Equity at exit
- $222,909
- IRR
- 20.6%
- Equity multiple
- 3.12×
- Total profit
- $888,350
- Equity at exit
- $129,260
Cash invested: $418,600 (down + closing). Projections, not guarantees.
Landlord ↔ Tenant lean methodology
- Overall (CITY)
- 0 Strongly Tenant-Friendly
- State California
- 18 Strongly Tenant-Friendly · D+13
- County
- — inherits STATE
- City San Francisco
- 0 Strongly Tenant-Friendly · D+57
ZIP-level market 94110
- Rents YoY
- 14.5%
- Active inventory
- 161
- Price-to-rent
- 22.2×
Monthly cashflow live
- Estimated rent
- $16,821 high interval (Pro) →
- Mortgage (P&I)
- −$7,840
- Tax from tax record
- −$310 /mo · $3,722/yr
- Insurance
- −$623
- HOA
- −$0
- Vacancy / Maint / Mgmt
- −$3,532
- Net cashflow
- $4,516
Break-even live
3-unit breakdown (identical units grouped — click to expand)
| Units | Beds | Baths | Est. rent |
|---|---|---|---|
| 3× units | 3 | 1 | $16,821 |
| #1 | 3 | 1 | $5,607 |
| #2 | 3 | 1 | $5,607 |
| #3 | 3 | 1 | $5,607 |
| Total (3 units) | $16,821 | ||
UW: 25.0% down · 7.5% · 30yr · 1.5% tax · 5.0% vac · 8.0% maint · 8.0% mgmt
Financing live
Cash to close
- Down payment
- $373,750
- Closing costs
- $44,850
- Reserves months
- —
- Total cash needed
- —
Loan-product check · same deal, 3 products live
Conventional
25% down · 7.5% · 30yr
- Down + closing
- —
- Monthly P&I
- —
- Monthly cashflow
- —
- DSCR
- —
- Eligible?
- —
Personal DTI + credit; lowest rate.
DSCR
20% down · 8.5% · 30yr
- Down + closing
- —
- Monthly P&I
- —
- Monthly cashflow
- —
- DSCR
- —
- Eligible?
- —
No personal income docs; deal must DSCR.
Hard money
10% down · 12.0% · 12mo
- Down + closing
- —
- Monthly P&I
- —
- Monthly cashflow
- —
- DSCR
- —
- Eligible?
- —
Short-term bridge; refi at stabilization.
Listing history 3 events
-
2026-06-18days on market $1,495,000 Active 2 DOM
-
2026-06-17remarks 699-char remark
-
2026-06-17$1,495,000 Active 1 DOM
ⓘ Source: listings_history table (triggers on properties + properties_extension) + one-shot
backfill from property_details.listing_events for pre-trigger history.
Tax reassessment forecast CA · Resets to sale price
- Current annual tax
- $3,722 · $310/mo
- Projected year-2 tax
- $11,362 · $947/mo
- Expected delta
- +$7,640/yr (+$637/mo · 205.3%)
ⓘ Screening estimate from a state-policy table — verify with the county assessor before closing.
Climate risk First Street
- Flood 1/10 Low FEMA zone X (unshaded) · 0% chance over 30 yrs
- Wildfire 1/10 Low
- Heat 2/10 Low 8 d/yr ≥78°F today · 19 d/yr by 30 yrs out
- Wind 1/10 Low
- Air quality 8/10 Severe 15 unhealthy d/yr today · 15 by 30 yrs out
Nearby sold comps map
Loading sold comps map…
Walkable amenities ~0.75 mi
Loading nearby amenities…
Taxation est. · year 1
- Rental income
- $201,852
- − Mortgage interest
- −$83,743
- − Property taxes
- −$3,722
- − Insurance
- −$7,475
- − Repairs & maintenance
- −$16,148
- − Management
- −$16,148
- − Depreciation
- −$43,491
- Taxable income
- $31,125
- Est. tax owed @ 24.0%
- −$7,470
- After-tax cash flow
- $46,717/yr
For passive investors: Depreciation is non-cash, so a rental often shows a tax loss while cash-flowing — sheltering income. Rental losses are passive: they offset passive income freely, and up to $25,000/yr can offset ordinary (W-2) income if you actively participate and your MAGI is under $100k (phasing out to $0 by $150k); unused losses carry forward. On sale, claimed depreciation is recaptured at up to 25%, and gains may owe capital-gains tax (a 1031 exchange can defer both). Figures are a year-1 estimate at your 24.0% rate — not tax advice; consult a CPA.
Schools (NCES district)
- District
- San Francisco Unified
- NCES district ID
- 0634410
- Math proficiency
- 50% ▬ 0.00%
- Reading proficiency
- 56% ▲ 1.00%
- Median HH income
- $81,249
- Composite
- 50.14/100
- National rank
- #4088
- State rank
- #322 of 1400 in CA
Livability — San Francisco
- Score
- 76/100
- State rank
- #90
- US rank
- #3143
Category grades
Schools grade is shown separately in the Schools card above.
Census & demographics
- Census place
- San Francisco, CA
- County
- San Francisco County · 827,552 people
- City population
- 827,552
- Metro
- San Francisco-Oakland-Berkeley, CA
- Population (ZIP)
- 66,865
- Household income
- $158,351
- Rent vs Own
- Severe rent burden
- 2732.0
Population outlook (San Francisco County) Hauer SSP2
- Today (2025)
- 1,030,936 people
- By 2030
- 1,110,409 · +7.7%
- By 2040
- 1,270,010 · +23.2%
- By 2050
- 1,435,001 · +39.2%
- By 2075
- 1,779,074 · +72.6%
- By 2100
- 1,966,767 · +90.8%
Race, ethnicity, and origin ACS 2023
- Neighborhood character
- Highly diverse neighborhood (Simpson 0.70)
- Race & ethnicity
- White 41% Hispanic / Latino 32% Asian 16% Two or more races 15% Black 4% Native American 1%
- Hispanic origin (detail)
- Mexican 16% Puerto Rican 1%
- Common ancestry
- Lithuanian 3% Italian 2% Romanian 2%
- Foreign-born
- 28% · Canada, China, Vietnam
- Languages at home
- 58% English-only · Spanish 27% Chinese 5% Other Indo-European 2%
Political lean MEDSL · San Francisco
- 2024 margin
- Solid D (+64.8) · D 80.3% · R 15.5% · Other 4.1%
- 2008→2024 swing
- -5.7pp toward R · 2008: 70.5pp · 2024: 64.8pp
- All cycles
- 2024: D+64.8 2020: D+72.5 2016: D+76.1 2012: D+70.2 2008: D+70.5
Not yet ingested
- Civics
- —
Market trends
- HPI YoY
- ▼ -1385.62%
- Current HPI
- 267.2424
- Rent YoY
- ▲ 14.54%
- Metro
- San Francisco-Oakland-Berkeley, CA
- State GDP YoY
- ▲ 3.21%
- F500 in state
- 116
Industry mix (Fortune 500 HQ in CA)
| Industry | F500 HQs | Revenue |
|---|---|---|
| Technology | 27 | $1,492B |
|
||
| Financial Services | 3 | $174B |
|
||
| Retail | 3 | $44B |
|
||
| Insurance | 3 | $26B |
|
||
| Media / Entertainment | 2 | $115B |
|
||
| Pharmaceuticals / Biotech | 2 | $62B |
|
||
Price history
4 events — show timeline
- 2026-06-16 Listed $1,495,000 San Francisco MLS
- 2025-04-07 Rental Removed $795 ZUMPER1
- 2025-02-07 Price Changed $795 ZUMPER1
- 2025-02-06 Listed for Rent $895 ZUMPER1
Property tax history
+2.7%/yrLatest (2025): $3,722 · -48.0% YoY. Source: county tax records.
Cash-flow waterfall
monthlySold comps — $/sqft
last 12 mo · ≤1 miLoading sold comps…