23 Cresta Vista Drive, San Francisco, CA 94127, San Francisco, 94127 - 3 bed, 3 bath

23 Cresta Vista Drive, San Francisco, CA 94127 home-pic-0

23 Cresta Vista Drive

San Francisco, CA 94127

ACTIVE
CONDITION: EXCELLENT
3Beds
3Baths
2,620Sq Ft
5,248.98Lot Size

Property Price

LIST PRICE$2,395,000
EST. MARKET VALUE
$2,608,476
8% BelowMARKET VALUE

SUMMARY

Analysis of 23 Cresta Vista Drive, San Francisco, CA 94127 reveals a Prime Investment Opportunity with a current list price of $2,395,000—significantly undercutting the $2,608,476 Fair Market Value by 8%. This valuation gap indicates a +$213,476 Instant Equity potential for buyers. The property maintains a Excellent Condition Rating (95/100), indicating excellent structural integrity and modern finishes throughout. This turnkey property requires minimal updates and is ready for immediate occupancy. Located in a high-demand neighborhood within the San Francisco Unified School District, this asset is categorized as a low-risk, high-reward acquisition suitable for both Buy-and-Hold Investors and Owner-Occupants willing to undertake light renovation work.

Estimated Market Value

$2,608,476 +$213,476 Equity Potential
Based on Realkey algorithm analyzing recent comparable sales in San Francisco.

Comparable Sales Map

Comparables within 1 miles sold in recently

Address Sold Price BedsBathsSq Ft$/SqftDistance
23 Cresta Vista Drive
Subject
$2,395,000*
List Price
332,620$996-
A
315 San Benito Way
Sold
$2,800,000432,465$1,1360.5 mi
B
185 Upland Drive
Sold
$2,630,000432,486$1,0580.5 mi
C
601 Junipero Serra Boulevard
Sold
$2,412,000422,686$8980.9 mi
D
92 San Pablo Avenue
Sold
$2,685,000432,502$1,0730.3 mi
E
1620 Plymouth Avenue
Sold
$2,550,000422,507$1,0170.3 mi
F
200 Casitas Avenue
Sold
$2,800,000422,495$1,1220.2 mi
G
815 Joost Avenue
Pending
$2,790,000
List Price
442,520$1,1070.4 mi

* Subject property listed price vs sold prices of comps.

Condition Analysis

OVERALL CONDITION SCORE

Excellent
TeardownExcellent

Property is new construction or fully renovated.

Although originally built in 1941, the property has undergone extensive recent renovations and upgrades that bring it to modern standards. Key features include a remodeled primary suite, an updated kitchen, and high-end finishes like a marble fireplace surround and parquet hardwood floors. The integration of new double-pane windows, LED lighting throughout, and solar panels indicates that the major systems and aesthetic components are virtually new and well-maintained, meeting the criteria for excellent condition.

PROSSTRENGTHS & OPPORTUNITIES

  • Great Schools

    Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).

  • Exceptional Views and Outdoor Living

    The property boasts unobstructed views to the Farallones and features a professionally landscaped green space by Michael Painter, complemented by a walk-out deck and hot tub.

  • Modernized Period Architecture

    This 1941 detached home preserves classic details like parquet floors and nine-foot ceilings while integrating modern upgrades such as solar panels, LED lighting, and a remodeled primary suite.

CONSRISKS & DEFICIENCIES

  • Inconsistent Local School Ratings

    While the property has access to high-performing schools like Lowell High, several of the closest assigned public elementary and middle schools have significantly lower ratings.

  • Topography and Walkability

    The home's perched location provides stunning views but is situated in a hilly neighborhood that may limit easy walkability for daily errands compared to flatter, more central urban districts.

About 23 Cresta Vista Drive

With unobstructed views to the Farallones, this alluring, fully detached three bedroom/three bathroom house sits perched overlooking Sherwood Forest and the western part of the City. Significantly upgraded and maintained by the same family for 47 years, the home enjoys classic details of its 1941 construction while reflecting modern touches such as a stunning marble fireplace surround in the living room, updated kitchen, remodeled primary bedroom, home office, fabulous great room with vaulted ceiling and fireplace, walk-out deck complete with hot tub and special green space designed by renowned San Francisco landscape designer, Michael Painter. The home offers striking nine foot ceilings, parquet hardwood floors, crown molding, new double-pane windows, two working fireplaces, LED lighting throughout, a very large garage with extra storage and a room ideal as a wine cellar, and solar panels. The home is conveniently located in the heart of the City - in minutes you can be on West Portal or Market Street. Equally easy is access to 280, 101 and a variety of transit lines. It is the ultimate urban experience when you can live in a tranquility and know that minutes away you're enjoying the best of a thriving city.

Property Details

Public Facts

Property Type
Single Family Residence
Year Built
1941
Lot Size
5,248.98 Sq. Ft.

Interior

Total Bedrooms
3
Total Bathrooms
3 (3 Full, 0 Half)

Exterior & Parking

No exterior & parking available.

Utilities & Misc

HOA Fee
$0 / Month

Neighborhood Insights

San Francisco Unified Schools

Miraloma Elementary School

Grades K-5 • 0.5 mi

8/10

Sunnyside Elementary School

Grades K-5 • 0.7 mi

6/10

Mission Education Center

Grades K-5 • 1.6 mi

1/10

Sensitive Facilities

No sensitive facilities data found.

Neighborhood Comparison

FeatureSubjectAverage HomeNeighborhood Ranking (50 Listings)
Beds3.04.0
47%
Baths3.03.0
50%
Square foot2,6202,284.5
71%
Lot Size5,248.983,804.785
84%
Price$2.40M$2.33M
51%
Price per sq ft$914$1.1K
25%
Built year19411930
68%
HOA$0$0
50%
Days on market60175
9%

Pricing History

Listed for Sale

Jan 6, 2026

$2,395,000

Initial Listing

Browse Properties by State Browse housing market trends by state