1704-1708 Waller Street, San Francisco, CA 94117-2728, USA


Property Overview:

Rarely available Edwardian Building in the heart of Cole Valley, San Francisco. The property includes two residential flats and a large commercial unit at street level.

  • Flat 1: 6 rooms, 2 bedrooms, 1.5 baths (remodeled, delivered vacant).
  • Flat 2: 5 rooms, 2 bedrooms, 1 bath (tenant-occupied, month-to-month at $3,066.60/month, non-protected tenant).
  • Commercial Unit: Remodeled with a private office, kitchenette, and bath (delivered vacant).
  • Garden Patio Access: Available to all units.
  • Parking: Includes 2-car parking at the rear of the property.

Neighborhood Highlights:

  • Prime Location: Close to cafes, restaurants, Golden Gate Park, Whole Foods, UCSF, and public transportation.
  • Walker’s Paradise: Walk Score 98.

Property Features:

  • Edwardian Architecture: Timeless charm with modern updates.
  • Remodeled Units: Middle flat and commercial unit fully updated.
  • Outdoor Space: Shared garden patio for all units.
  • Income Potential: Tenant-occupied flat generates $3,066.60/month.

Location Benefits:

  • Situated in the desirable Cole Valley neighborhood.
  • Perfect for investors or owner-occupiers with flexible occupancy options.
  • Offers due by Wednesday, 3/19/25.

Price and Status History

date type price
2007-07-11 For Sale 1250000
2007-08-10 Delisted NaN
2007-08-15 Sold 1020300
2025-02-20 For Sale 2225000
2025-03-18 For Sale 1989454

Superfund Enterprise Management System

No data found within 1.0 miles for this property.

Toxic Release Inventory

No data found within 1.0 miles for this property.

Integrated Compliance Information System - Air

PLANT NAME ADDRESS OPERATING STATUS DISTANCE (MILES)
GRAND STAR CLEANERS 1422 Haight Street, San Francisco, CA 94117-2911, USA CLS: Permanently Closed 0.36
UCSF/PARNASSUS 3rd Avenue & PARNASSUS, San Francisco, CA 94122, USA OPR: Operating 0.58

Flood Risk Info

fld_zone very high impact: up to 0.0001 miles high impact: up to 0.2 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.5 miles
A 0 0 0 0
AE 0 0 0 0
AH 0 0 0 0
AO 0 0 0 0
VE 0 0 0 0

Flood Zone Type

code meaning
A 1% annual chance flood zone determined using approximate methods. No BFEs shown. Flood insurance and management standards apply.
AE 1% annual chance flood zone determined by detailed methods. BFEs shown. Insurance and floodplain management required.
AH Shallow flooding (ponding) zones with depths between 1-3 feet. BFEs shown. Insurance and management required.
AO Shallow flooding (sheet flow) zones with depths 1-3 feet. BFEs or average depths shown. High-velocity areas may exist.
VE Coastal 1% annual chance flood zone with wave action. BFEs shown. Insurance and management required.

Earthquake Risk Info

zone_name quad_name very high impact: up to 0.0001 miles high impact: up to 2.0 miles moderate impact: up to 10.0 miles
San Andreas - Peninsula San Francisco South 0 0 1

Landslide Risk Info

lscat very high impact: up to 0.0001 miles high impact: up to 0.04 miles moderate impact: up to 0.1 miles low-moderate impact: up to 0.2 miles
8 0 0 0 0

Liquefaction Risk Info

Suscept very high impact: up to 0.0001 miles high impact: up to 0.05 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.0 miles
High 0 0 0 1
Very high 0 0 0 0

Wild fire Risk Info

haz_class very high impact: up to 0.0001 miles high impact: up to 0.5 miles moderate impact: up to 1.5 miles low-moderate impact: up to 3.0 miles
High 0 0 0 0
Very High 0 0 0 0

Traffic Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 NaN 43 46 49 42 NaN 50
1 44 46 44 49 50 47 46
2 42 42 40 43 40 53 45
3 46 47 44 39 41 38 48
4 40 43 39 NaN 48 42 42
5 38 40 42 42 43 NaN 40
6 NaN 41 37 NaN 42 42 40
7 40 38 NaN 38 38 41 39
8 39 38 42 38 40 41 39
9 NaN NaN 39 40 37 39 NaN
10 39 41 39 38 38 38 36
11 39 38 39 38 39 NaN 37
12 37 36 39 36 NaN 37 NaN
13 43 39 40 41 44 40 39
14 NaN 37 38 NaN 45 NaN NaN
15 40 49 42 46 NaN 37 47
16 39 NaN NaN 50 NaN 42 NaN
17 45 NaN 38 45 42 45 38
18 48 40 48 45 45 48 48
19 48 47 42 NaN 41 50 NaN
20 46 47 45 NaN 49 49 49
21 50 48 50 41 42 48 53
22 51 45 42 45 45 50 39
23 51 51 44 51 51 41 50

Airplane Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 3 3 3 2 3 4 3
1 2 2 3 3 3 2 3
2 1 2 3 2 2 3 1
3 1 2 2 1 2 2 1
4 1 1 1 2 1 1 1
5 1 1 1 1 2 1 2
6 1 2 4 2 2 3 1
7 3 3 4 3 3 3 3
8 2 2 3 1 2 2 2
9 3 3 4 3 3 4 2
10 3 3 3 3 4 4 4
11 5 4 3 4 4 7 5
12 5 4 4 6 6 6 6
13 7 6 7 6 6 7 6
14 6 7 7 6 8 7 6
15 5 5 6 4 6 5 6
16 4 4 4 5 5 5 4
17 4 5 6 5 4 5 5
18 4 4 3 4 4 4 4
19 4 4 5 5 5 5 5
20 4 3 2 4 4 3 3
21 4 3 3 2 3 2 3
22 2 2 2 2 3 2 2
23 4 6 4 5 4 5 5