
San Francisco, CA 94117
This Multi-Unit Residential Income Asset is listed at $2,575,000 compared to a $2,113,024 Fair Market Value, reflecting a premium for its rare 5-unit functionality and 30-year fixed residential financing eligibility. Currently in Fair Condition, the property boasts panoramic city and ocean views and is situated near Top-Rated Schools like Lowell High School. With three units delivered vacant, the asset offers immediate rental upside and a pro-forma 7.01% CAP rate. This is a high-utility Value-Add Opportunity for Buy-and-Hold Investors or Owner-Occupants seeking a premier San Francisco house-hack.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 905 Ashbury Subject | $2,575,000* List Price | 0 | 0 | 3,597 | $587 | - |
A 1215 Oak Street Sold | $2,060,000 | 4 | 4 | 3,930 | $524 | 0.6 mi |
B 446-448 Waller Street Sold | $1,810,000 | 7 | 0 | 3,600 | $503 | 0.9 mi |
C 136 Downey Street Sold | $1,900,000 | 4 | 0 | 2,490 | $763 | 0.1 mi |
D 1012 Page St Active | $2,199,000 List Price | 0 | 0 | 3,780 | $582 | 0.7 mi |
* Subject property listed price vs sold prices of comps.
Property is moderate renovation needed.
This 1906 property is well-maintained but shows significant signs of age, placing it firmly in the 'fair' category. While some living areas feature refinished hardwood floors and updated recessed lighting, the kitchens and bathrooms are dated, featuring older tile countertops, vintage cabinetry, and basic appliances that lack modern styling. The exterior and rear wooden structures show visible wear and tear consistent with a century-old building that has had occasional updates rather than a comprehensive recent renovation.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
Officially classified as a 4-unit residential building, this property qualifies for 30-year fixed residential financing while providing the income of five legal units, offering a rare advantage for investors.
With three units delivered vacant at the close of escrow, including a massive 4BR/2BA duplex, owners can immediately realize market-rate rents or utilize house-hacking strategies without tenant relocation hurdles.
Dating back to 1906, the property may require significant ongoing maintenance or capital expenditures to update aging systems and ensure compliance with modern seismic or building codes.
The advertised 7.01% CAP rate is based on market rent assumptions and the successful lease-up of vacant units, rather than actual day-one stabilized cash flow.
905 ASHBURY ST | 7.01% CAP | 11.51 GRM | RESIDENTIAL FINANCING Prime Haight-Ashbury/Cole Valley investment opportunity. Officially classified as a 4-unit residential building (qualifying for 30-year fixed financing) while functioning as 5 units total with a LEGAL in-law unit. Returns are based on market rent assumptions with 3 units delivered vacant at close of escrow (Units 1, 2, & 5; Units 2 & 5 are vacant now), offering immediate lease-up or house-hacking potential. +4 Unit 2 is a massive 4BR/2BA duplex with yard access and private laundry. Unit 5 is a bright top-floor 1BR with front-to-back exposure and panoramic ocean/western sky views. Units 3 & 4 are rented near market for day-one stability. Extensive document package includes 1948 City permit for 5th unit verification. See Agent Remarks.
No exterior & parking available.
Grades K-5 • 0.3 mi
Grades K-5 • 0.3 mi
Grades K-5 • 0.5 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 0.0 | 5.0 | 7% |
| Baths | 0.0 | 3.0 | 40% |
| Square foot | 3,597 | 3,208 | 60% |
| Lot Size | 2,652 | 2,652 | 50% |
| Price | $2.58M | $2.00M | 67% |
| Price per sq ft | $716 | $600 | 53% |
| Built year | 1906 | 1904 | 60% |
| HOA | $0 | $0 | 50% |
| Days on market | 36 | 189 | 7% |
Mar 17, 2026
$2,575,000
Initial Listing
Sep 16, 2004
$1,260,000
Public Record