823 Hampshire St, San Francisco, CA 94110

Sold September 24, 2025 for $894,000 · 0.6% under asking · 131 days on market
$894,000
Sold Price
3
Beds
2
Baths
1,193 SqFt
$749/SqFt
Sep 24, 2025
Sold Date
Listed By Diana Klein. DRE# 002020044. Compass. (415) 465-3782
Source: SFAR/San Francisco, MLS # 425040104

Sold Summary

823 Hampshire St in San Francisco sold for $894,000 on September 24, 2025 — 0.6% below its $899,000 asking price — 131 days after coming on the market. That works out to $749 per square foot for a 3-bedroom, 2-bath home built in 1907. The 1,193 sq ft property sits in Inner Mission, which Houseberry scores 2.5/5 overall, 1.8/5 for schools and 2.8/5 for safety — 88th of 92 neighborhoods in San Francisco — with a median home price of $1.49M.

About This Home
Perched atop a boutique building, this stunning 3 bd/2 ba (+office) penthouse unit offers panoramic vistas of Twin Peaks and the Downtown skyline, framed by the clean lines of a recent modern remodel. The open-concept living, dining, and kitchen space is designed for both entertaining and everyday comfort, flowing seamlessly into a sunroom that captures morning light and houses in-unit laundry for added convenience. The lovely primary suite invites you to unwind with a luxurious bath and serene views, while the second full b...Show More
Prop Type:
Year Built:
Home Size:
Lot Size:
Tenancy in Comm...
1907
1,193 SqFt
4,399 SqFt
Neighborhood:
MLS #:
Days on Houseberry:
HOA:
Inner Mission
425040104
131
$637
Property History
DateEvent & SourcePriceChange
Sep 24, 2025Sold SFAR$894,000−18.4%
May 16, 2025Listed SFAR$1,095,000
Schools serving this Neighborhood
School NameTypeGradesDistanceHouseberry School Score
Bryant Elementary PrimaryK-50.5 mi
Everett Middle Middle6-81.2 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

  • Neighborhood Amenities
    Curb Appeal

    2.8

Overall Amenities score: 3.3

Questions about this home

What neighborhood is 823 Hampshire St in?

823 Hampshire St sits in Inner Mission, San Francisco. Houseberry gives the neighborhood an overall score of 2.5 out of 5, placing it 88th of the 92 neighborhoods we score in San Francisco.

What schools serve 823 Hampshire St?

Houseberry holds attendance boundaries covering 823 Hampshire St for Bryant Elementary (elementary school, K-5) 0.5 mi away and Everett Middle (middle school, 6-8) 1.2 mi away. We hold no high school boundary for this address, which does not mean there is no high school nearby.

How much did 823 Hampshire St sell for?

823 Hampshire St closed at $894,000 on September 24, 2025. It had been asking $899,000.

How long was 823 Hampshire St on the market?

823 Hampshire St was on the market for 131 days — listed on May 16, 2025, sale closed on September 24, 2025.

What is the price per square foot at 823 Hampshire St?

823 Hampshire St works out to $749 per square foot, from the $894,000 sale price across 1,193 square feet.

Is Inner Mission a good place to live?

Houseberry scores Inner Mission 2.5 out of 5 overall, with 1.8 for schools and 2.8 for safety, each on the same five-point scale. The median home price there is $1.49M, against $894,000 for this property.

See the full Inner Mission profile

Explore Inner Mission

Neighborhood Summary
Inner Mission
Home RatingHome RatingHome RatingHome RatingHome Rating
2.5 /5
Personal Score: 3.2/5

Neighborhood Factors

Market Conditions

  • Neighborhood Factors
    Price
    $1.49M
  • Neighborhood Factors
    Undervalued
    $87k
  • Neighborhood Factors
    Appreciation
    20%

Top Neighborhoods in San Francisco, CA

1st
Neighborhood Iamge
Outer Sunset, San Francisco, CA
Overall Score : 4.5
Outer Sunset, located at the western edge of San Francisco, offers a distinct co... See Full Page
2nd
Neighborhood Iamge
Forest Hill, San Francisco, CA
Overall Score : 4.3
Forest Hill, one of San Francisco's most prestigious neighborhoods, is an enclav... See Full Page
3rd
Neighborhood Iamge
Inner Richmond, San Francisco, CA
Overall Score : 4.3
Inner Richmond, nestled in the heart of San Francisco, is a neighborhood brimmin... See Full Page
Neighborhood Map
Contact Houseberry's 2026 Agent Pick for Inner Mission
Homes for Sale in this Neighborhood