---
listing_id: SF426161979
status: Active
price: 2430000
beds: 0
baths_full: 0
baths_half: 0
sqft_living: 4275
sqft_lot: 2495
lot_acres: 
year_built: 1900
property_type: Residential Income
property_subtype: Triplex
address: "1704 Waller St"
city: San Francisco
state: CA
zip: 94117
county: "San Francisco County"
lat: 37.76864
lng: -122.451998
days_on_market: 5
hoa_fee: 
hoa_frequency: 
garage_spaces: 0
list_agent: "John Asdourian"
list_office: "Sotheby's International Realty"
list_agent_phone: "(415) 308-0499"
list_agent_license: 00952669
mls_source: RESFAR
modified: 2026-09-24
transaction_type: buy
---

Home | San Francisco County | San Francisco | 94117 | 1704 Waller St

1704 Waller St, San Francisco, CA 94117

MLS: SF426161979 | Status: Active | Price: $2,430,000
Beds/Baths: – / –
Property Type: Residential Income

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
– – 4,275 2,495 1900

Upcoming Open Houses

Date Time Hosted By
Sunday, September 27 2:00 am - 4:00 am
Tuesday, September 29 12:00 pm - 2:00 pm

Remarks

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.

MLS Listing Information

Field Value
MLS # SF426161979
MLS Source San Francisco Association of Realtors® MLS
Days on Site 5

Features

Interior Features

Feature Details
Kitchen Varies by Unit
Appliances Cooktop - Electric, Dishwasher, Garbage Disposal, Oven - Gas, Oven Range - Gas, Refrigerator
Flooring Carpet, Simulated Wood, Tile, Varies by Unit, Wood
Heating Baseboard, Central Forced Air, Electric, Gas - Natural, Varies by Unit

Exterior Features

Feature Details
Roof Composition, Shingle
Style Flat, Victorian

Parking, School, and Other Information

Feature Details
Garage/Parking Garage: 0 Car(s)
Sewer Public Sewer
Water Public
HOA Fee $0
Complex Amenities Community Security Gate

Contact Information

Listing Agent Co-Listing Agent
John Asdourian Eun Young Lee
Sotheby's International Realty Sotheby's International Realty
License #: 00952669 License #: 01989877
Phone: (415) 308-0499 Phone: (415) 215-1809

Property Units

# Buildings # Leased Units # Total Units
1 1 3

Unit Details

Unit # Sq Ft Beds Baths Rent
1 1,060 2 0/0 $3,109
2 1,250 0 0/0 –
3 1,290 0 0/0 –

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Grattan Elementary School public K-5 0.34 mi 9
New Traditions Elementary School public K-5 0.38 mi 8
Chinese Immersion School At Deavila public K-5 0.42 mi 10
Independence High School public 9-12 0.74 mi 5
Frank McCoppin Elementary School public K-5 0.85 mi 8
Wallenberg (Raoul) Traditional High School public 9-12 0.86 mi 7
McKinley Elementary School public K-5 0.89 mi 9
Roosevelt Middle School public 6-8 0.98 mi 8
Clarendon Alternative Elementary School public K-5 1.05 mi 9
Rooftop Elementary School public K-8 1.07 mi 8
Wells (Ida B.) High School public 9-12 1.08 mi 2
Milk (Harvey) Civil Rights Elementary School public K-5 1.08 mi 6
Yu (Alice Fong) Elementary School public K-8 1.17 mi 10
Sanchez Elementary School public K-5 1.22 mi 2
Peabody (George) Elementary School public K-5 1.27 mi 10
Everett Middle School public 6-8 1.30 mi 1
Alvarado Elementary School public K-5 1.30 mi 8
Muir (John) Elementary School public K-5 1.32 mi 6
Jefferson Elementary School public K-5 1.41 mi 8
Argonne Elementary School public K-5 1.42 mi 9

Nearby Homes

Address Price Beds Baths Sq Ft Status
630 Haight St $2,675,000 – – 4,600 Contingent
6000 California St $2,200,000 – – 3,900 Active
909 Alvarado St $1,995,000 – – 3,843 Active
990 Baker St $2,500,000 – – 3,960 Active

Disclosures

©2026 San Francisco Association of Realtors® MLS. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from San Francisco Association of Realtors® MLS.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of September 24, 2026. For the most current information, please contact John Asdourian, (415) 308-0499.