
San Francisco, CA 94117
This Multi-Unit Residential Income Asset is listed at $2,575,000, representing a high-utility acquisition with a 7.01% pro-forma CAP rate. Although priced above the $2,161,270 Fair Market Value, the building justifies its position with three vacant units—including a massive 4BR duplex—and a completed $120,000 seismic retrofit. Boasting sweeping water views and access to Top-Rated Schools like Lowell High, the property’s Fair Condition offers immediate value-add potential through interior modernization. This is a strategic choice 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 Street Subject | $2,575,000* List Price | 6 | 4 | 3,597 | $601 | - |
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 905 Ashbury Active | $2,575,000 List Price | 0 | 0 | 3,597 | $716 | 0.0 mi |
* Subject property listed price vs sold prices of comps.
Property is moderate renovation needed.
The property is a well-maintained 1906 multi-unit building that has undergone a seismic retrofit, but the interiors are significantly dated. The kitchens and bathrooms feature vintage tile-work, older appliances, and pedestal sinks that show their age. While the units are functional and the hardwood floors appear to be in decent condition, the property requires substantial interior modernization to meet current luxury standards.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
With three units delivered vacant—including a large 4BR/2BA and a top-floor 1BR—this property offers rare flexibility for owner-occupiers or investors to immediately capture market-rate rents without the complications of tenant buyouts.
The property has already undergone a $120,000 soft-story seismic retrofit, a critical structural upgrade that ensures compliance with San Francisco mandates and saves the buyer significant future capital expenditure.
The inclusion of an 'extra studio' and the explicit advisory for buyers to investigate permit history suggests potential issues with non-conforming units or unpermitted work that could impact financing and legal use.
Given the 1906 construction and 'original details,' the property likely requires substantial interior updates and capital improvements to bring the units up to modern luxury standards and maximize the investment's yield.
Located on a tree-lined street in one of the city's most desirable neighborhoods, just a short walk to vibrant Cole Street, this is a rare investment opportunity with both immediate income and strong upside. The property offers classic San Francisco charm with original details, views, and flexibility to move in or upgrade units over time. Officially a 4-unit building with an extra studio, it presents a unique opportunity for both investors and owner-users. Three units (1, 2, and 5) are vacant and easy to show. Unit 1: vacant studio Unit 2: vacant spacious two-level 4BR/2BA with direct yard access and in-unit laundry Unit 5: vacant top-floor 1BR with sweeping views. Units 3 & 4: currently rented near market, providing stable in-place income. Financials: 7.01% cap rate (owner-user scenario) / 11.51 GRM. Completed $120,000 soft-story seismic retrofit.Buyer to investigate the permit history and do their own due diligence.
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 | 6.0 | 5.0 | 53% |
| Baths | 4.0 | 3.0 | 53% |
| Square foot | 3,597 | 3,208 | 60% |
| Lot Size | 2,653 | 2,653 | 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 | 24 | 189 | 7% |
Mar 29, 2026
$2,575,000
Initial Listing
Sep 16, 2004
$1,260,000
Public Record