
San Francisco, CA 94117
A wonderful alternative for your Condo and SFD buyers who can't get into a property in one of the city's most accessible neighborhoods! Located on the border of Cole Valley and the Upper Haight neighborhoods, 1704-08 Waller keeps its original Victorian era charm on a quieter street, just one block from Golden Gate Park. Mixed use residential flats are located above a spacious, open office/commercial space. The top-floor unit has 2 bedrooms and 1 bathroom, while the larger middle unit (vacant) is a 5-room flat with 2 bedrooms and 1.5 bathroom. The ground-floor commercial/office space offers huge open space with high ceilings, a private office, and 1 bathroom. This property presents a unique opportunity for an owner-user to occupy a residential flat, plus a spacious commercial space for a live/work/play environment--for immediate occupancy! Got start-ups? Enjoy a Walk Score of 98, with access to San Francisco's Haight and Cole Valley neighborhoods, as well as much of the city's transit. Each unit has access to the large common garden patio, surrounded by cityscape views and trees lining both Waller and Shrader Streets.
Property is move-in ready.
Although built in 1900, the property has been significantly updated and well-maintained. The residential kitchen features modern cabinetry, stone countertops, and stainless steel appliances, while the bathrooms show updated tiling and vanities. The commercial space includes newer wide-plank flooring and recessed lighting. The overall condition is move-in ready, reflecting a comprehensive renovation likely completed within the last 5-15 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).
Situated on the border of Cole Valley and Upper Haight, just one block from Golden Gate Park, the property boasts an exceptional Walk Score of 98 and convenient transit access via the N Judah and multiple bus lines.
Featuring two independent residential flats above a spacious ground-floor commercial space, this property offers a perfect live/work setup or flexible rental income options for an investor or owner-user.
Built in 1900, this century-old building may require higher ongoing maintenance costs, structural oversight, or capital improvements compared to newer constructions.
Although there are highly-rated elementary schools nearby, several of the assigned public middle and high schools in the district carry lower performance ratings, which may be a consideration for families.
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 |
|---|---|---|
| Beds | 4.0 | 5.3 |
| Baths | 0.0 | 4.0 |
| Square foot | 4,275 | 4,735.5 |
| Lot Size | 2,496 | 1,879.5 |
| Price | $2.43M | $2.60M |
| Price per sq ft | $568 | $547 |
| Built year | 1900 | 1911 |
| HOA | $0 | $0 |
| Days on market | 45 | 123 |
Sep 9, 2026
$2,430,000
Initial Listing
Aug 15, 2007
$1,350,000
Public Record