647 Madrid Street, San Francisco, CA 94112-3544, USA

Property CA
, , , , , , , , , , ,
1

Property Overview:

647 Madrid St is a single-family home in San Francisco, CA, built in 1912. It features 2 bedrooms, 1 bathroom, and 1,100 sq. ft. of living space on the main floor, with an additional in-law unit downstairs (1 bedroom, 1 bathroom, legality not warranted). The home includes a parking garage and has an estimated value of $1,154,000.

Neighborhood Highlights:

  • Crime Rate:

    • Personal crime risk: 20% (higher than state average of 11.8%).
    • Property crime risk: 15.9% (higher than state average of 10.8%).

  • Schools:
    Nearby schools include Cleveland Elementary, Balboa High, and Denman (James) Middle.

    • Average SAT score: 849 (below state average of 975).

  • Job Market:

    • 54.6% white-collar jobs, 45.4% blue-collar jobs.
    • Unemployment rate: 5.0% (higher than state average of 4.7%).

  • Demographics:

    • Community population: 70,296 (9% growth since 2000).
    • 69% families with children.
    • Largest age group: 45-54 years (15.27%).

  • Natural Disaster Risk:

    • Low flood risk, low tornado risk, high earthquake risk.

  • Weather:

    • Average temperature: 48.6°F (January), 62.1°F (July).
    • Average rainfall: 20.1 inches/year.
    • Average snowfall: 0 inches/year.

  • Cost of Living:

    • Median household income: $65,103.
    • Average annual spending: $51,430.

Property Features:

  • Main Floor:

    • 2 bedrooms, 1 bathroom.
    • Spacious living room with high ceilings and bay windows offering panoramic views.
    • Large eat-in kitchen with garden access.

  • Lower Level:

    • Bonus space with 1 bedroom, 1 bathroom (legality not warranted).
    • Unfinished laundry room and direct backyard access.

  • Upgrades:

    • New roof, fresh paint (interior and exterior), polished hardwood floors, and new carpets.

  • Outdoor Space:

    • Terraced garden with a new deck and mature landscaping.

  • Parking:

    • 1-car garage accessible from street level.

Location Benefits:

  • Located in the Excelsior neighborhood, close to Excelsior Playground and McLaren Park (San Francisco’s second-largest park).
  • Convenient access to shopping, dining, public transit, and freeways.
  • Perfect for family living and outdoor enthusiasts.
2

Price and Status History

date type price
1997-02-13 For Sale 219000.0
1997-04-24 Sold 221000.0
1999-10-06 Sold 307000.0
2007-11-02 For Sale 699000.0
2008-01-08 Sold 665000.0
2012-01-19 For Sale 498000.0
2012-02-24 Pending NaN
2012-03-22 Sold 485000.0
2023-09-07 Off Market NaN
2024-11-15 For Sale 1016635.5
3

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

No data found within 1.0 miles for this property.

4

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 Montara Mountain 0 0 1
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 0
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 1 0
5

Traffic Noise by Hour x Weekday

Not enough data points

6

Airplane Noise by Hour x Weekday

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