
San Francisco, CA 94117
This Turnkey Multi-Unit Residence serves as a sophisticated Move-in Ready sanctuary, listed at $4,995,000. This valuation represents a stable acquisition closely aligned with its $4,954,628 Fair Market Value. Boasting a Mint Condition Rating, the property features four newly renovated units with High-End Kitchens, Private Decks, and premium finishes throughout. Located in a vibrant Haight Ashbury pocket, the lifestyle is enhanced by proximity to Top-Rated Schools like Chinese Immersion School At Deavila and Lowell High School. This vacant building is an exceptional choice for Owner-Occupants or Multi-generational Families seeking a refined urban compound.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 1522-1524 Waller Street Subject | $4,995,000* List Price | 7 | 6 | 3,758 | $1,318 | - |
A 482-484 Belvedere Street Pending | $3,990,000 List Price | 5 | 6 | 3,085 | $1,293 | 0.4 mi |
* Subject property listed price vs sold prices of comps.
Property is new construction or fully renovated.
The property is a newly renovated 4-unit building featuring high-end, modern kitchens with waterfall islands and stainless steel appliances. The interior shows mint condition with new flooring, recessed lighting, and updated bathrooms, clearly meeting the criteria for a renovation completed within the last 5 years.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
The building is fully renovated with modern kitchens, baths, and in-unit laundry, offering a move-in ready experience that commands premium market rents.
Delivered completely vacant, this quadruplex provides a rare opportunity for immediate market-rate income, a family compound, or a high-end owner-user setup.
Living area discrepancy between mls listing and other public or private record. mls listing living area = 3758, other record living area = 2800.
The property was recently sold within the past year on 2025-05-27. The sold price is $2,150,000.00.
With only one garage space and one off-street spot for four units and seven total bedrooms, parking availability is a notable constraint for a building of this scale.
Stunning, vacant, newly renovated 4 unit building in a peaceful yet vibrant Haight Ashbury location. Beautiful new kitchens and baths, flooring, lighting, decks and other features. Washer and dryers in all units. One interior garage parking. Wonderful common deck in back and the garden unit has its own private deck as well. (2) one bedroom units, (1) 2 bedroom unit and (1) 2000+ SF 4BR unit with bonus media, office or playroom down. The big unit has interior access to the garage. Can sell the building or split the units as TIC's. A rarely available vacant multi-unit building in an A+ location, this is a great opportunity for a family and friends compound or a high-end owner-user building with income. Units can also be sold individually as TIC's.
No exterior & parking available.
Grades K-5 • 0.3 mi
Grades K-5 • 0.4 mi
Grades K-5 • 0.4 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 7.0 | 5.0 | 80% |
| Baths | 6.0 | 3.5 | 80% |
| Square foot | 3,758 | 3,101.5 | 70% |
| Lot Size | 2,513 | 2,563.5 | 50% |
| Price | $5.00M | $1.84M | 90% |
| Price per sq ft | $1.3K | $542 | 90% |
| Built year | 1900 | 1902 | 50% |
| HOA | $0 | $0 | 50% |
| Days on market | 47 | 204 | 10% |
Apr 30, 2026
$4,995,000
Initial Listing
May 27, 2025
$2,150,000
Public Record