$1,100,000
400 Franconia St
@ Esmeralda Ave - 9 - Bernal Heights, San Francisco
- 0 Bed
- 0 Bath
- 0 Park
- San Francisco
-
A Once-in-a-Lifetime Opportunity in Bernal Heights! Discover the extraordinary potential of 400 Franconia St, an unmatched opportunity to create your dream residence atop one of San Francisco's most sought-after neighborhoods. This rare property comes with approved architectural plans to transform the existing structure into a modern masterpiece - the largest home ever built in Bernal Heights, spanning over 4,841 square feet on an expansive .20-acre lot. Designed to capture panoramic water views from nearly every window, this three-story residence is envisioned to blend sophisticated design with seamless indoor-outdoor living. The plans include an elevator, expansive entertaining spaces, and a spectacular primary suite featuring a luxurious spa-like bath with both indoor and outdoor showersa true private retreat. Imagine waking up to the sunrise over the Bay, hosting unforgettable gatherings in light-filled open spaces, and enjoying the best of San Francisco's hillside tranquility just minutes from Cortland Avenue's vibrant shops & restaurants. his is a truly one-of-a-kind opportunity to bring your vision to life in one of San Francisco's most charming and dynamic neighborhoods. Whether you're an end user or developer, 400 Franconia Street offers endless potential and prestige.
- Days on Market
- 2 days
- Current Status
- Active
- Original Price
- $1,100,000
- List Price
- $1,100,000
- On Market Date
- Nov 6, 2025
- Property Type
- Single Family Residence
- District
- 9 - Bernal Heights
- Zip Code
- 94110
- MLS ID
- 425086186
- APN
- 5556-070
- Year Built
- 0
- Stories in Building
- 0
- Possession
- Close Of Escrow
- Data Source
- SFAR
- Origin MLS System
Oakes Children's Center
Private K-8 Special Education, Elementary, Coed
Students: 18 Distance: 0.3mi
Flynn (Leonard R.) Elementary School
Public K-5 Elementary
Students: 432 Distance: 0.4mi
St. Anthony Immaculate Conception
Private K-8 Elementary, Religious, Coed
Students: 113 Distance: 0.4mi
Meadows-Livingstone School
Private K-6 Elementary, Coed
Students: 19 Distance: 0.5mi
S.F. County Opportunity (Hilltop) School
Public 6-12 Opportunity Community
Students: 41 Distance: 0.5mi
Revere (Paul) Elementary School
Public K-8 Special Education Program, Elementary, Gifted Talented
Students: 477 Distance: 0.5mi
- Bed
- 0
- Bath
- 0
- Parking
- 0
- SQ FT
- 0
- SQ FT Source
- Unavailable
- Lot SQ FT
- 6,650.0
- Lot Acres
- 0.1527 Acres
- Views
- City, City Lights, Panoramic
- Possession
- Close Of Escrow
- Special Listing Conditions
- Real Estate Owned
- Fee
- $0
MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.
School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.