154 Funston Ave, San Francisco, CA 94118

For sale at $4,888,000 · listed October 31, 2025
Price and status as of September 25, 2026
$4,888,000
Price
9
Beds
8
Baths
3,230 SqFt
$1,513/SqFt
Oct 31, 2025
Listed Date
Listed By Mark Venegas. DRE# 001858283. Pinnacle Realty Advisors. (415) 955-7968
Source: SFAR/San Francisco, MLS # 425084624

Listing Summary

154 Funston Ave in San Francisco is for sale at $4,888,000, listed October 31, 2025. That works out to $1,513 per square foot for a 9-bedroom, 8-bath single-family home built in 1915. The 3,230 sq ft house sits in Lake Street, which Houseberry scores 4.1/5 overall, 4.2/5 for schools and 4.5/5 for safety — 9th of 92 neighborhoods in San Francisco — with a typical home price of $3.63M.

About This Home

Vacant and ready. Located in the prestigious Lake District. In 2024, this 2-Unit Building was fully upgraded and renovated. Why buy a house when you can live in this modern and luxury two-unit building? Top Unit #154 has 1727 sq ft, 4 beds and 2 baths. The Two Level Unit #156 has 2180 sq ft, 4 beds and 3 baths. 2-Car Garage plus storage. Live in one of the units and rent out the other unit for a potential $10k a month or use the other unit for offices, additional guest rooms, a library, theater/media room and a nanny room. G...Show More
Prop Type:
Year Built:
Home Size:
Lot Size:
Single Family
1915
3,230 SqFt
3,001 SqFt
Neighborhood:
MLS #:
Listed:
HOA:
Lake Street
425084624
Oct 31, 2025
-

Property History

DateEvent & SourcePriceChange
Oct 31, 2025Listed SFAR$4,888,000

Schools serving this Neighborhood

School NameTypeGradesDistanceHouseberry School Score
Sutro Elementary PrimaryK-50.1 mi
Roosevelt Middle Middle6-80.8 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

    4

Overall Amenities score: 4

Other sales on Funston Ave

2 other sales recorded on Funston Ave since September 2025

The 2 sales on Funston Ave
AddressSoldPricePer sq ft
1701 Funston AveMar 2026$2.8M$691
2123 Funston AveFeb 2026$3.5M$915

At its asking price, this home's $1,513 per square foot would rank 1st of 3 alongside the recorded sales on Funston Ave that state one.

Questions about this home

What neighborhood is 154 Funston Ave in?

154 Funston Ave sits in Lake Street, San Francisco. Houseberry ranks Lake Street 9th of the 92 neighborhoods we score in San Francisco.

What schools serve 154 Funston Ave?

Houseberry holds attendance boundaries covering 154 Funston Ave for Sutro Elementary (elementary school, K-5) 0.1 mi away and Roosevelt Middle (middle school, 6-8) 0.8 mi away. We hold no high school boundary for this address, which does not mean there is no high school nearby.

What is the asking price for 154 Funston Ave?

154 Funston Ave is asking $4,888,000, on the market since October 31, 2025.

What is the price per square foot at 154 Funston Ave?

154 Funston Ave works out to $1,513 per square foot, from the $4,888,000 asking price across 3,230 square feet.

Is Lake Street a good place to live?

Houseberry scores Lake Street 4.1 out of 5 overall, with 4.2 for schools and 4.5 for safety, each on the same five-point scale.

See the full Lake Street profile

Explore Lake Street

Lake Street scores and market conditions

Houseberry has recorded 24 sales in Lake Street since September 2025.

Neighborhood data last updated September 25, 2026

Lake Street
Home RatingHome RatingHome RatingHome RatingHome Rating
4.1 /5
Personal Score: 4.6/5

Neighborhood Factors

Market Conditions

  • Neighborhood Factors
    Price
    $3.63M
  • Neighborhood Factors
    Undervalued
    $41k
  • Neighborhood Factors
    Appreciation
    18%

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 Lake Street