238 28th Avenue, San Francisco, CA 94121, San Francisco, 94121 - 4 bed, 4 bath

238 28th Avenue, San Francisco, CA 94121 home-pic-0

238 28th Avenue

San Francisco, CA 94121

ACTIVE
CONDITION: EXCELLENT
4Beds
4Baths
3,200Sq Ft
2,996.93Lot Size

Property Price

LIST PRICE$5,498,000
EST. MARKET VALUE
$5,098,748
7% AboveMARKET VALUE

SUMMARY

Analysis of 238 28th Avenue, San Francisco, CA 94121 reveals a property with a current list price of $5,498,000, which is 7% above the estimated $5,098,748 Fair Market Value. Buyers should carefully evaluate the pricing and consider negotiation opportunities. 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

$5,098,748
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
238 28th Avenue
Subject
$5,498,000*
List Price
443,200$1,593-
A
2144 Lake Street
Sold
$6,700,000543,715$1,8030.3 mi
B
1638 Lake Street
Sold
$5,600,000444,368$1,2820.6 mi
C
368 17th Avenue
Sold
$4,200,000440.7 mi

* Subject property listed price vs sold prices of comps.

Condition Analysis

OVERALL CONDITION SCORE

Excellent
TeardownExcellent

Property is new construction or fully renovated.

This property has undergone a comprehensive 'down to the studs' renovation including a lower-level excavation, new foundation, roof, HVAC, plumbing, and 200-amp electrical panel. The interior features high-end contemporary finishes such as wide-plank European white oak flooring, a gourmet kitchen with Thermador appliances and Cambria quartz waterfall islands, and spa-like bathrooms with custom vanities and rainfall showers, meeting all criteria for a newly renovated, like-new home.

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).

  • Prime Sea Cliff Location

    Situated in one of San Francisco's most prestigious and sought-after neighborhoods, this property offers exceptional curb appeal and long-term value in a high-demand luxury enclave.

  • Comprehensive Modern Renovation

    The home has been meticulously renovated down to the studs, including a lower-level excavation and all-new systems (HVAC, plumbing, electrical, and foundation), providing a turn-key experience with contemporary high-end finishes.

CONSRISKS & DEFICIENCIES

  • MLS Listing Discrepancy

    Living area discrepancy between mls listing and other public or private record. mls listing living area = 3200, other record living area = 2316. Bedroom count discrepancy between mls listing and other public or private record. mls listing bedroom count = 4, other record bedroom count = 3.

  • Low Available Lot Utilization

    The property has a small lot size, more than 70 percent of which is taken by its living area. lot size in square feet = 2996, living area = 3200.

  • Limited Outdoor Space

    With a lot size of approximately 2,996 square feet, the property offers relatively constrained outdoor yard space compared to other luxury estates at this price point.

About 238 28th Avenue

Nestled in the prestigious and highly sought-after Sea Cliff neighborhood, this newly renovated single-family residence offers exceptional curb appeal and a thoughtfully designed layout. A separate gated entrance provides direct access to the lower level, adding versatility and privacy. Newly renovated down to the studs and lower level excavation, the home embodies a refined contemporary aesthetic. Bathed in natural light, it features high ceilings, a flowing open floor plan, recessed LED lighting, and wide-plank European white oak flooring throughout. The main level showcases a gracious living room with sleek electric fireplace and French doors opening to a balcony with neighborhood views. The gourmet kitchen features pendant lighting by Visual Comfort, custom rift white oak cabinetry, an expansive Cambria quartz waterfall island, deep farmhouse sink, and Thermador appliances including gas cooktop and double oven. A butler's pantry with wet bar enhances entertaining. The kitchen flows into the dining area and rear den, with two sets of doors opening to a wraparound deck. A powder room completes this level. Upstairs are three bedrooms, a large den or optional fourth bedroom, and two full baths. The primary suite offers a walk-in closet and spa-like bath with soaking tub, rainfall shower, and custom double vanity. The expansive lower level provides remarkable versatility--ideal as a media lounge, guest retreat, or au pair suite. The lower level includes a separate gated entrance, wet bar with wine and beverage refrigerator, full bath, bonus room (currently a gym), under-stair Harry Potter'' storage nook, and sliding doors to a private patio. Extensive renovation with lower level expansion, new plumbing, 200-amp electric panel, kitchen, baths, HVAC, foundation, roof, etc (SEE LIST OF UPGRADES ON WEBSITE).

Property Details

Public Facts

Property Type
Single Family Residence
Year Built
1919
Lot Size
2,996.93 Sq. Ft.

Interior

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

Exterior & Parking

No exterior & parking available.

Utilities & Misc

HOA Fee
$0 / Month

Neighborhood Insights

San Francisco Unified Schools

Alamo Elementary School

Grades K-5 • 0.3 mi

8/10

Chinese Immersion School At Deavila

Grades K-5 • 2.6 mi

9/10

San Francisco Public Montessori School

Grades K-5 • 3.0 mi

6/10

Sensitive Facilities

No sensitive facilities data found.

Neighborhood Comparison

FeatureSubjectAverage HomeNeighborhood Ranking (50 Listings)
Beds4.04.0
50%
Baths4.03.0
64%
Square foot3,2002,147.5
88%
Lot Size2,996.932,996.93
50%
Price$5.50M$2.21M
92%
Price per sq ft$1.7K$1.0K
96%
Built year19191922
36%
HOA$0$0
50%
Days on market34173
4%

Pricing History

Listed for Sale

Feb 1, 2026

$5,498,000

Initial Listing

Sold

Nov 30, 2023

$2,625,000

Public Record

Browse Properties by State Browse housing market trends by state