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.2/5 for safety — 49th of 92 neighborhoods in San Francisco — with a median home price of $3.45M.

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

Questions about this home

What neighborhood is 504 Cole St in?

504 Cole St sits in Haight Ashbury, San Francisco. Houseberry gives the neighborhood an overall score of 3.5 out of 5, placing it 49th 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.2 for safety, each on the same five-point scale. The median home price there is $3.45M, against $2,210,000 for this property.

See the full Haight Ashbury profile

Explore Haight Ashbury