RealKey
‪(213) 433-7766‬

400 Franconia Street, San Francisco, CA 94110, San Francisco, 94110 - 5 bed, 5 bath

400 Franconia Street, San Francisco, CA 94110 home-pic-0
ACTIVE$1,100,000
400 Franconia Street, San Francisco, CA 94110
5Beds
5Baths
Sqft
6,651.61Lot
Year Built
1981
Close
-
List price
$1.1M
Original List price
-
Price/Sqft
$0
HOA
$0
Days on market
-
Sold On
-
MLS number
425086186
Home ConditionTear down
Features
Excellent View:
View-

About this home

We found 3 Cons,6 Pros. Rank: price - $1.10M(23th), sqft - 0(13th), beds - 5(95th), baths - 5(98th).

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.

Nearby schools

2/10
Flynn (Leonard R.) Elementary School
Public,•K-5•0.4mi
4/10
Bryant Elementary School
Public,•K-5•0.6mi
6/10
King (Starr) Elementary School
Public,•K-5•0.8mi
4/10
Serra (Junipero) Elementary School
Public,•K-5•0.9mi
3/10
Chavez (Cesar) Elementary School
Public,•K-5•0.9mi
2/10
Fairmount Elementary School
Public,•K-5•1.0mi
1/10
Mission Education Center
Public,•K-5•1.3mi
3/10
Glen Park Elementary School
Public,•K-5•1.7mi
7/10
Alvarado Elementary School
Public,•K-5•1.8mi
9/10
Chinese Immersion School At Deavila
Public,•K-5•2.7mi
/10
Chinese Education Center
Public,•K-5•3.6mi
6/10
San Francisco Public Montessori School
Public,•K-5•3.7mi
2/10
Revere (Paul) Elementary School
Public,•K-8•0.5mi
4/10
Buena Vista/ Horace Mann K-8
Public,•K-8•1.0mi
3/10
Lick (James) Middle School
Public,•6-8•1.4mi
4/10
Everett Middle School
Public,•6-8•1.8mi
3/10
San Francisco Community Alternative School
Public,•K-8•1.8mi
6/10
Rooftop Elementary School
Public,•K-8•2.1mi
3/10
Carmichael (Bessie)/Fec
Public,•K-8•2.2mi
6/10
Aptos Middle School
Public,•6-8•3.3mi
7/10
Hoover (Herbert) Middle School
Public,•6-8•3.4mi
8/10
Yu (Alice Fong) Elementary School
Public,•K-8•3.5mi
9/10
Lilienthal (Claire) Elementary School
Public,•K-8•4.6mi
9/10
Lawton Alternative Elementary School
Public,•K-8•4.6mi
2/10
Marshall (Thurgood) High School
Public,•9-12•0.6mi
2/10
S.F. International High School
Public,•9-12•0.8mi
3/10
O'connell (John) High School
Public,•9-12•1.2mi
1/10
Downtown High School
Public,•9-12•1.2mi
5/10
Burton (Phillip And Sala) Academic High School
Public,•9-12•1.6mi
3/10
Mission High School
Public,•9-12•1.6mi
2/10
Jordan (June) School For Equity
Public,•9-12•1.9mi
7/10
Balboa High School
Public,•9-12•2.3mi
6/10
Academy Of Arts And Sciences
Public,•9-12•2.3mi
9/10
Asawa (Ruth) San Francisco School Of The Arts, A Public School.
Public,•9-12•2.3mi
2/10
Wells (Ida B.) High School
Public,•9-12•2.6mi
7/10
Wallenberg (Raoul) Traditional High School
Public,•9-12•3.3mi
7/10
Lincoln (Abraham) High School
Public,•9-12•4.0mi
10/10
Lowell High School
Public,•9-12•4.2mi
8/10
Galileo High School
Public,•9-12•4.2mi
7/10
Washington (George) High School
Public,•9-12•5.2mi

Price History

Date
Event
Price
11/06/25
Price Change
$1,100,000
07/06/17
Sold
$2,100,000
12/23/13
Sold
$2,015,000
Condition Rating
Tear down
The property is explicitly described as 'not move-in ready' and requires a 'full build-out' with 'approved architectural plans to transform the existing structure into a modern masterpiece.' The images confirm this, showing a dilapidated, graffiti-covered foundation or partial structure, clearly unlivable. There are no existing kitchens or bathrooms to evaluate, as the property's value is based solely on the land and its potential for redevelopment, aligning perfectly with the 'tear-down' criteria.
Pros & Cons

Pros

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).
Development-Ready Opportunity: The property comes with approved architectural plans to transform the existing structure into a 4,841 sq ft modern masterpiece, significantly de-risking the development process.
Premium Bernal Heights Location: Situated in one of San Francisco's most sought-after neighborhoods, offering hillside tranquility and convenient access to vibrant local amenities on Cortland Avenue.
Exceptional Panoramic Views: The approved design is specifically crafted to capture panoramic water views from nearly every window, a highly desirable and value-adding feature in San Francisco.
Generous Lot Size: An expansive 6,651 sq ft lot (or .20-acre as described) is exceptionally large for San Francisco, providing ample space for a substantial residence and outdoor living.
Vision for Luxury Amenities: The approved plans include high-end features such as an elevator, expansive entertaining spaces, and a luxurious primary suite with indoor/outdoor showers, promising an upscale finished product.

Cons

Substantial Construction Investment Required: The current list price of $1.1M is for the land and approved plans, necessitating a significant additional financial outlay for construction to complete the envisioned luxury residence.
Extensive Project Scope: Transforming the existing 1981 structure into a 4,841 sq ft modern home is a major construction project, requiring considerable time, effort, and specialized project management.
Current Unfinished State: The property is not move-in ready and requires a full build-out, which may deter buyers seeking immediate occupancy or those without development experience.

Best solution for experienced home buyers!

Data-driven home buying experience with our licensed real estate agents and cutting-edge AI

Browse Properties by State Browse housing market trends by state