504 Cole St, San Francisco, CA 94117

Sold April 9, 2026 for $2,210,000 · 19.5% over asking · 27 days on market
$2,210,000
Sold Price
3
Beds
2.5
Baths
1,799 SqFt
$1,228/SqFt
Apr 9, 2026
Sold Date
Listed By Steve Gallagher. DRE# 001193002. Coldwell Banker Realty. (415) 250-3779
Source: SFAR/San Francisco, MLS # 426111620

Sold Summary

504 Cole St in San Francisco sold for $2,210,000 on April 9, 2026 — 19.5% above its $1,850,000 asking price — 27 days after coming on the market. That works out to $1,228 per square foot for a 3-bedroom, 2.5-bath condo built in 1894. The 1,799 sq ft condo sits in Haight Ashbury, which Houseberry scores 3.5/5 overall, 3.8/5 for schools and 3.7/5 for safety — 46th of 92 neighborhoods in San Francisco — with a typical home price of $1.66M.

About This Home

This unique, townhouse style home occupies the top two floors of a 4 unit building constructed in 1894 by Robert Dickie Cranston, a prominent builder in the Haight-Ashbury district at the time and was featured in the second edition of The Painted Ladies books. The home encompasses 1799 sq. ft. (per tax records) on two floors of living space, including 3 bedrooms and 2.5 baths. Enhanced by east and west light-filled exposures, dramatic Victorian era volumes, well-preserved period details and pristine softwood floors, the livi...Show More
Prop Type:
Year Built:
Home Size:
Lot Size:
Condominium
1894
1,799 SqFt
3,034 SqFt
Neighborhood:
MLS #:
Days on Houseberry:
HOA:
Haight Ashbury
426111620
27
$420

Property History

DateEvent & SourcePriceChange
Apr 09, 2026Sold SFAR$2,210,000+19.5%
Mar 13, 2026Listed SFAR$1,850,000

Schools serving this Neighborhood

School NameTypeGradesDistanceHouseberry School Score
Grattan Elementary PrimaryK-50.5 mi
Giannini (A.P.) Middle Middle6-82.9 mi

Click links for school listing

info at GreatSchools.org

Houseberry School Score Data

from CA Dept. of Education

Houseberry recommends using these scores as only a starting point, and conducting your own investigation into what schools fit best for your preferences. School boundaries are not guaranteed and may change. It is important to contact the appropriate school district to confirm enrollment eligibility before making any decision to move to a neighborhood.

Neighborhood Amenities

  • Neighborhood Amenities
    Near Good Merchants

    5.0

  • Neighborhood Amenities
    Public Spaces

    3.5

  • Neighborhood Amenities
    Curb Appeal

    3

Overall Amenities score: 3.6

Other sales on Cole St

3 other sales recorded on Cole St since September 2025

The 3 sales on Cole St
AddressSoldPricePer sq ft
1010 Cole StJul 2026$1.83M$1,464
507 Cole St #AJun 2026$1.8M$1,261
1327 Cole StApr 2026$2.05M$1,604

This home's $1,228 per square foot ranks 4th of the 4 sales on Cole St that record one, including this sale.

Questions about this home

What neighborhood is 504 Cole St in?

504 Cole St sits in Haight Ashbury, San Francisco. Houseberry ranks Haight Ashbury 46th of the 92 neighborhoods we score in San Francisco.

What schools serve 504 Cole St?

Houseberry holds attendance boundaries covering 504 Cole St for Grattan Elementary (elementary school, K-5) 0.5 mi away and Giannini (A.P.) Middle (middle school, 6-8) 2.9 mi away. We hold no high school boundary for this address, which does not mean there is no high school nearby.

How much did 504 Cole St sell for?

504 Cole St closed at $2,210,000 on April 9, 2026. It had been asking $1,850,000.

How long was 504 Cole St on the market?

504 Cole St was on the market for 27 days — listed on March 13, 2026, sale closed on April 9, 2026.

What is the price per square foot at 504 Cole St?

504 Cole St works out to $1,228 per square foot, from the $2,210,000 sale price across 1,799 square feet.

Is Haight Ashbury a good place to live?

Houseberry scores Haight Ashbury 3.5 out of 5 overall, with 3.8 for schools and 3.7 for safety, each on the same five-point scale.

See the full Haight Ashbury profile

Explore Haight Ashbury

Haight Ashbury scores and market conditions

Houseberry has recorded 35 sales in Haight Ashbury since September 2025.

Neighborhood data last updated September 25, 2026

Haight Ashbury
Home RatingHome RatingHome RatingHome RatingHome Rating
3.5 /5
Personal Score: 4.2/5

Neighborhood Factors

Market Conditions

  • Neighborhood Factors
    Price
    $1.66M
  • Neighborhood Factors
    Overvalued
    $67k
  • Neighborhood Factors
    Appreciation
    5%

Top Neighborhoods in San Francisco, CA

1st
Neighborhood Iamge
Jordan Park / Laurel Heights, San Francisco, CA
Overall Score : 4.2
Jordan Park / Laurel Heights offers a harmonious mix of urban sophistication and... See Full Page
2nd
Neighborhood Iamge
Outer Sunset, San Francisco, CA
Overall Score : 4.2
Outer Sunset, located at the western edge of San Francisco, offers a distinct co... See Full Page
3rd
Neighborhood Iamge
Presidio Heights, San Francisco, CA
Overall Score : 4.2
Presidio Heights, one of San Francisco's most affluent neighborhoods, offers an ... See Full Page
Neighborhood Map
Contact Houseberry's 2026 Agent Pick for Haight Ashbury