
San Francisco, CA 94117
This Turnkey Duplex is a High-Potential Investment Opportunity, listed at $4,200,000—positioned slightly above the $4,027,884 Fair Market Value. Featuring a Mint Condition Rating after a complete rebuild, this 5,181 SF property includes Thermador appliances, wide-plank white oak floors, and private decks. Located near top-rated schools like the Chinese Immersion School at Deavila, it offers a rare, versatile layout for a multi-generational compound. This is an ideal acquisition for Buy-and-Hold Investors or Owner-Occupants seeking a high-end, move-in ready San Francisco asset.
Rarely available, fully rebuilt 5,181 SF duplex in San Francisco. Mint condition, high-end finishes, and prime location near top schools. Perfect for owner-users.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 1460-1462 Waller Street Subject | $4,200,000* List Price | 7 | 6 | 5,181 | $777 | - |
A 150 Central Avenue Pending | $3,195,000 List Price | 8 | 3 | 4,930 | $648 | 0.3 mi |
* Subject property listed price vs sold prices of comps.
Property is new construction or fully renovated.
This property has been completely rebuilt from the foundation up, featuring brand-new high-end kitchens with Thermador appliances, modern luxury bathrooms, and wide-plank oak flooring. All major systems including HVAC (with AC), electrical, plumbing, and the roof are new, placing it in mint condition with no maintenance required.
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 property has been completely rebuilt from the foundation up, featuring all-new electrical, plumbing, and roofing, along with rare San Francisco amenities like air conditioning and Ethernet wiring.
Situated in a highly walkable and vibrant area, the building is steps away from Haight Street, Cole Valley cafes, Golden Gate Park, and major transit lines, offering an unbeatable urban lifestyle.
Living area discrepancy between mls listing and other public or private record. mls listing living area = 5181, other record living area = 2950.
The property lacks on-site parking, relying instead on a pre-paid leased garage half a block away, which may be a significant inconvenience for luxury buyers.
As the units are positioned for TIC (Tenancy in Common) sales, buyers may face more restrictive financing options and complex legal agreements compared to traditional condominium ownership.
Rarely available, generously sized vacant duplex in an A+ location a great opportunity for a family-and-friends compound or a high-end owner-user building with income. Available as the entire building, or purchased individually as TICs. Completely rebuilt from foundation to finish, each of the two homes spans two full levels, with new kitchens featuring Thermador appliances and Cambria quartz counters, wide-plank white oak floors throughout, and a private deck off each kitchen leading to a huge sunny shared backyard. Over 5,000 SF total across the two homes: 1460 Waller (lower): 3BR/3BA + office, 2,500 SF, primary suite with soaking tub and backyard access 1462 Waller (upper): 4BR/3BA + bonus room, 2,600 SF, showstopper primary suite with peaked ceilings and walk-in closet Huge sunny backyard, pre-paid leased parking in a private garage just half a block away, and steps to both Haight St & Cole Valley cafs and shops, Golden Gate Park, Muni and bike paths walkable, vibrant, unbeatable location. Of course, it's what you can't see that's important: new electrical, new plumbing, foundation, roof, fully sprinklered, and air conditioning! Ethernet wiring in each room, natch! TIC agreement is already drafted, so the path to closing is fast. Don't miss.. this one won't last! TIC Units listed separately as MLS# 426152698 and 426152728.
No exterior & parking available.
Grades K-5 • 0.2 mi
Grades K-5 • 0.4 mi
Grades K-5 • 0.4 mi
No sensitive facilities data found.
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 7.0 | 4.8 |
| Baths | 6.0 | 4.0 |
| Square foot | 5,181 | 3,171.882 |
| Lot Size | 3,437 | 2,678.029 |
| Price | $4.20M | $2.08M |
| Price per sq ft | $811 | $709 |
| Built year | 1904 | 1925 |
| HOA | $0 | $0 |
| Days on market | 34 | 66 |
Aug 6, 2026
$4,200,000
Initial Listing
Apr 7, 2025
$2,050,000
Public Record
Jun 7, 2016
$1,097,500
Public Record