647 Cole Street, San Francisco, CA 94117-2809, USA


Property Overview:

This elegantly maintained top-floor Edwardian flat is located in the heart of the Haight Ashbury/Cole Valley corridor in San Francisco, CA. It features 3 bedrooms, 1.5 bathrooms, and over 1,800 sq. ft. of flexible living space. The property also includes a 4th room that can serve as a home office or family room, and an exclusive 1,000 sq. ft. finished attic with seven skylights and potential for additional development.


Neighborhood Highlights:

  • Prime Location:
    Situated at the border of Cole Valley and Haight Ashbury, the property is close to Golden Gate Park, Mt. Sutro, and a variety of restaurants, cafes, and shops.

    • Convenient access to public transportation, freeways, and the UCSF expansion.
  • Recreation:
    Blocks from Golden Gate Park, offering over 1,000 acres of meadows, lakes, and vibrant activities for all ages.


Property Features:

  • Interior Highlights:

    • High ceilings, period moldings, and trim details.
    • Gleaming hardwood floors with walnut inlays.
    • Contemporary lighting and abundant natural light.
    • Updated kitchen with a Viking range, Bosch dishwasher, and a center island that opens to a formal dining room with large windows.
  • Unique Spaces:

    • Finished attic (~1,000 sq. ft.) with seven periscope skylights and city views.
    • Book nook leading to the attic.
    • Indoor laundry room.
  • Shared Amenities:

    • Shared backyard space.
    • Bike storage.

Location Benefits:

  • Walkable and Convenient:
    Close to Whole Foods, parks, and dining options.
  • Perfect for those seeking classic charm with modern updates in a vibrant neighborhood.

Price and Status History

date type price
2019-05-09 For Sale 1495000
2019-05-24 Pending NaN
2019-06-12 Sold 1700000
2020-09-22 Sold 1182000
2022-09-23 For Sale NaN
2022-09-24 Pending NaN
2023-09-06 Off Market NaN
2025-03-21 For Sale 1950000

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

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

Airplane Noise by Hour x Weekday

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