3152 Lyon Street, San Francisco, CA 94123, San Francisco, 94123 - 4 bed, 4 bath
Loading property details...
San Francisco, CA 94123
This 1920s Mediterranean Value-Add Residence is listed at $3,799,000, representing a stable acquisition at its $3,799,000 Fair Market Value. Currently holding a Fair Condition Rating, the property offers a significant "opportunity to transform" into a luxury estate with iconic Golden Gate Bridge and Bay views. The home features a walk-out deck, a versatile in-law studio, and access to top-rated schools like Claire Lilienthal (9/10) and Lowell High (10/10). This strategic asset is an ideal project for Fix-and-Flip Investors or Owner-Occupants looking to build equity through modernization.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 3152 Lyon Street Subject | $3,799,000* List Price | 4 | 4 | 3,080 | $1,233 | - |
A 25 Retiro Way Sold | $3,375,000 | 4 | 3 | 2,565 | $1,316 | 0.6 mi |
* Subject property listed price vs sold prices of comps.
Property is moderate renovation needed.
This 1927 Mediterranean residence is well-maintained but largely outdated, fitting the 'fair' criteria. While the architectural details like the grand staircase and hardwood floors are preserved, the kitchen features 1980s/90s-style oak cabinetry and tiled countertops. The listing explicitly markets the property as an 'opportunity to transform' and is being sold 'As-Is' via a trust sale, indicating that while the home is functional and livable, it requires significant cosmetic and system updates to meet modern luxury standards.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
Situated directly across from the Presidio National Park, the property offers exceptional proximity to world-class hiking trails and the Palace of Fine Arts, complemented by sweeping views of the Golden Gate Bridge and San Francisco Bay.
This 1920s Mediterranean residence features grand proportions across three levels, including a versatile lower-level in-law studio with garden access and an oversized garage with high ceilings, providing significant potential for a custom luxury transformation.
Living area discrepancy between mls listing and other public or private record. mls listing living area = 3080, other record living area = 2460.
The property has a small lot size, more than 70 percent of which is taken by its living area. lot size in square feet = 2414, living area = 3080.
Marketed as an 'opportunity to transform,' the property likely requires a substantial capital investment to modernize its original 1920s systems and finishes to meet contemporary luxury standards.
Incredible opportunity to transform this classic 1920s Mediterranean residence into your dream home. Ideally located across from the Presidio, this gracious three-level home offers timeless elegance, generous proportions, and exceptional potential. The property also provides exceptional proximity to the Presidio National Park's renowned hiking trails, The Palace of Fine Arts, and sweeping views of the Golden Gate Bridge and San Francisco Bay. The main level features a grand formal entry, leading to beautifully scaled living, dining, and breakfast rooms. Both dining spaces provide direct access to a walk-out deck, creating seamless indoor-outdoor flow-perfect for everyday living and entertaining. The formal dining room is ideal for memorable gatherings and special occasions. The spacious kitchen offers ample room for chefs of all levels. A stunning grand staircase leads to the upper level, adding to the home's classic architectural appeal. Upstairs, the top floor features three large, light-filled bedrooms. A charming pop-out bonus room provides a cozy and intimate retreat, ideal for relaxing or reading. The oversized primary suite includes an en-suite bathroom and three closets-one of which is a walk-in with a dedicated seating area, perfect for a vanity or dressing space. This level also includes a full second bathroom and three additional hall closets for ample storage. The lower level presents a versatile in-law studio apartment with direct access to the garden, offering flexibility for guests, extended family, or rental income. An oversized garage with high ceilings accommodates one or more vehicles and provides abundant storage space. This is a trust sale and is being sold AS-IS.
No exterior & parking available.
Grades K-5 • 0.9 mi
Grades K-5 • 0.9 mi
Grades K-5 • 1.7 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 4.0 | 4.0 | 50% |
| Baths | 4.0 | 4.0 | 50% |
| Square foot | 3,080 | 3,314.5 | 50% |
| Lot Size | 2,414 | 2,752.99 | 33% |
| Price | $3.80M | $4.99M | 29% |
| Price per sq ft | $1.2K | $1.4K | 33% |
| Built year | 1927 | 1925 | 63% |
| HOA | $0 | $0 | 50% |
| Days on market | 160 | 207 | 29% |
Nov 13, 2025
$3,799,000
Initial Listing