1550 Waller Street, San Francisco, CA 94117-2841, USA


Property Overview:

1550 Waller St is a 4-unit Edwardian/Victorian building in San Francisco’s Haight Ashbury neighborhood, built in 1908. The property spans 4,900 sq. ft. and features a mix of 3-bedroom, 2-bathroom units and 4-bedroom units (one with 1.5 baths, another with 2 baths). Three units are rented, while one is vacant, offering an excellent opportunity for investors or owner-occupants. The building includes a 4-car garage and 4 storage units.


Neighborhood Highlights:

  • Walkability:

    • Walk Score: 97 (Walker’s Paradise).
    • Transit Score: 80 (Excellent Transit).
    • Bike Score: 92 (Biker’s Paradise).
  • Nearby Attractions:

    • Golden Gate Park, Panhandle, Buena Vista Park, and Hippie Hill.
    • Close to Haight St restaurants, shops, and Cole Valley cafes.
  • Schools:
    Nearby schools include Lycee Francais La Perouse, Urban School of San Francisco, and San Francisco High School of the Arts.

  • Convenience:

    • Grocery stores: Haight Street Market, Haight Ashbury Market, and Ashbury Market.
    • Coffee shops: Stanza Coffee Bar, Cafe Cole, and Coffee Cantatass.
    • Restaurants: Cole Valley Cafe, Sparrow Bar and Kitchen, and Street Taco.

Property Features:

  • Units:

    • 2 lower units: 3 bedrooms, 2 bathrooms each.
    • 2 upper units: 4 bedrooms (1 with 1.5 baths, 1 with 2 baths).
    • 3 units updated; 1 unit vacant.
  • Garage & Storage:

    • 4-car garage with 4 storage units.
    • Additional income: $260/month for 1 garage space, $100/month laundry income.
  • Investment Metrics:

    • GRM: 13.55.
    • Cap Rate: 5.77%.

Location Benefits:

  • Prime Haight Ashbury location, near Cole Valley.
  • Close to parks, cafes, and boutiques.
  • Ideal for investors or owner-occupants seeking a vibrant, walkable neighborhood.

Price and Status History

date type price
2018-09-06 Rental 4600
2019-10-03 For Sale NaN
2022-05-31 Off Market NaN
2022-09-15 Pending NaN
2023-03-17 For Sale 2998000
2023-03-18 For Sale NaN
2023-05-16 For Sale NaN
2023-06-08 For Sale 2798000
2023-06-09 For Sale NaN
2023-06-27 Pending 2450000
2023-07-18 Sold 2450000
2023-09-23 Pending NaN
2024-07-17 Sold 1120000
2024-09-11 For Sale 1098000
2024-11-09 For Sale 1075000
2024-11-19 For Sale 998000
2024-11-27 For Sale 1098000
2024-12-16 Pending 998000
2024-12-28 For Sale 1086500
2025-01-03 Sold 1060000

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.23
UCSF/PARNASSUS 3rd Avenue & PARNASSUS, San Francisco, CA 94122, USA OPR: Operating 0.69
DRY CLEAN EXPRESS 900 Oak Street, San Francisco, CA 94117-2332, USA OPR: Operating 0.89

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 36 44 44 45 42 NaN 49
1 43 47 45 46 37 49 49
2 39 37 41 42 41 45 43
3 47 47 41 44 40 45 43
4 40 37 42 41 NaN 47 42
5 36 41 37 38 40 NaN 40
6 NaN 37 40 NaN 36 NaN 37
7 40 38 NaN 38 39 39 38
8 40 37 39 37 38 38 NaN
9 36 39 38 40 37 41 40
10 38 37 40 37 NaN 38 41
11 37 38 41 37 40 NaN 38
12 41 38 40 33 41 39 NaN
13 38 40 37 42 37 37 37
14 NaN 39 39 42 41 40 40
15 42 46 44 NaN 47 36 42
16 42 40 NaN 44 43 44 39
17 NaN 36 39 42 44 48 37
18 41 45 46 44 48 50 50
19 49 45 43 43 41 47 NaN
20 44 NaN 46 46 49 46 43
21 42 47 49 42 46 45 51
22 NaN 43 43 46 36 52 43
23 48 43 41 48 46 47 45

Airplane Noise by Hour x Weekday

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