400 Franconia St

$1,100,000
Price
5
Beds
4,845 Sq. Ft.
$227 / Sq. Ft.
4,845
Sq. Ft.
$227
per Sq. Ft.

Description

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...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.
  1. Listed by Anh H Pham • DRE #01432176 • SkyGroup Realty Inc.

Property Details for 400 Franconia Street

Directions to Property
Please use GPS.
View Description
City, City Lights, Panoramic
Cross Street
Esmeralda Ave
Total Parking Spaces
0
LISTING UPDATED: 11/11/2025 11:11 PM

Property Details for 400 Franconia Street

StatusActive
MLS #425086186
Days on Compass47
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built1981
Lot Size0.15 AC / 6,651 SF
CountySan Francisco County

Location

Listing Courtesy of SkyGroup Realty Inc., Anh H Pham, DRE #01432176
Add your commute

Virtual Tour

Building Information for 400 Franconia Street

Stories-Year Built1981Building Size-Lot Size0.15 AC / 6,651 SF

Payment Calculator

$7,857 per month

30 year fixed, 6.28% Interest

Principal and Interest

$5,435

Property Taxes

$2,422

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 400 Franconia Street

Summary
Location and General Information
  • Area/District: SF District 9
  • Area Short Display: 9
  • Subdistrict: Bernal Heights
  • Location Description: SF District 9, Bernal Heights, SF District 9 Bernal Heights
Taxes and HOA Information
  • APN: 5556-070
  • City Transfer Tax Rate: .00%
  • County Transfer Tax Rate: .00%
  • Association: No
Parking
  • Carport Spaces: 0
  • Garage Spaces: 0
  • Open Parking Spaces: 0
  • Parking Fee $: $.00
  • Num of Parking Spaces: 0.0
Virtual Tour
Property
Lot Information
  • Square Footage Source: Not Verified
  • Year Built Source: Assessor Agent-Fill
  • Lot Size Source: Assessor Auto-Fill
Property and Assessments
  • Possession: Close of Escrow
  • Picture Count: 34
  • Photos Provided By: 3rd Party Photographer
  • Elevation: 0
Green Features
  • Green Verification Year: 0
Interior and Exterior Features
Exterior Features
  • Stories: 0
Interior Features
  • # of Fireplaces: 0
  • Entry Level: 0
  • Possible Bedrooms: 0.0
  • Full Bathrooms: 4
  • # of Rooms: 15
Room Information
Master Bedroom
  • Primary Bedroom Dimensions Area: 0.0
  • Primary Bedroom Dimensions Length: 0.0
  • Primary Bedroom Dimensions Width: 0.0
Bedroom 2
  • Bedroom 2 Dimensions Area: 0.0
  • Bedroom 2 Dimensions Length: 0.0
  • Bedroom 2 Dimensions Width: 0.0
Bedroom 3
  • Bedroom 3 Dimensions Area: 0.0
  • Bedroom 3 Dimensions Length: 0.0
  • Bedroom 3 Dimensions Width: 0.0
Bedroom 4
  • Bedroom 4 Dimensions Area: 0.0
  • Bedroom 4 Dimensions Length: 0.0
  • Bedroom 4 Dimensions Width: 0.0
Living
  • Living Room Dimensions Area: 0.0
  • Living Room Dimensions Length: 0.0
  • Living Room Dimensions Width: 0.0
Dining
  • Dining Room Dimensions Area: 0.0
  • Dining Room Dimensions Length: 0.0
  • Dining Room Dimensions Width: 0.0
Family Room
  • Family Room Dimensions Area: 0.0
  • Family Room Dimensions Length: 0.0
  • Family Room Dimensions Width: 0.0
Kitchen
  • Kitchen Dimensions Area: 0.0
  • Kitchen Dimensions Length: 0.0
  • Kitchen Dimensions Width: 0.0
Multi Family
Multi-Family Information
  • # of Units: 0
Multi-Family Additional Information
  • 2nd Unit Approx SqFt: 0.0
  • 2nd Unit Rents for: $.00
Mobile/Manufactured Home
  • Remodeled/Updated: No
Rental
Rent Information
  • Occupant Type: Vacant
  • Current Rent: $.00

Property History for 400 Franconia Street

DateEvent & SourcePriceAppreciation
Nov 6, 2025

Listed (Active)

RESFAR #425086186

$1,100,000
Oct 2, 2025

Withdrawn

RESFAR #425074313

$1,650,000
May 8, 2025

Expired

EBRD #41078459

May 8, 2025

Expired

MLSListings #BE41078459

$1,400,000
May 7, 2025

Expired

CRMLS #41078459

Apr 7, 2025

Price Change

MLSListings #BE41078459

$1,400,000
Apr 7, 2025

Price Change

EBRD #41078459

$1,400,000
Apr 6, 2025

Price Change

CRMLS #41078459

$1,400,000
Nov 7, 2024

Listed (Active)

EBRD #41078459

$1,500,000
Nov 7, 2024

Listed (Active)

MLSListings #BE41078459

$1,500,000
Nov 7, 2024

Listed (Active)

CRMLS #41078459

$1,500,000
May 31, 2020

Withdrawn

RESFAR #492451

Nov 8, 2019

Listed (Active)

RESFAR #492451

$1,800,000
Oct 1, 2019

Expired

SFAR #484384

$1,800,000
Sep 17, 2019

Temporarily Off Market

SFAR #484384

May 3, 2019

Listed (Active)

SFAR #484384

$1,800,000
Jan 7, 2019

Withdrawn

SFAR #479832

Jan 7, 2019

Listed (Active)

SFAR #479832

$2,395,000
Jul 6, 2017

Sold

EBRD #SF454109

$2,100,000
Jul 6, 2017

Sold

RESFAR #454109

$2,100,000
Jun 22, 2017

Sold (Public Record)

Public Record #600923839

$2,100,000

+1.2% / yr

Apr 14, 2017

Pending

RESFAR #454109

Apr 14, 2017

Pending

EBRD #SF454109

Jan 30, 2017

Price Change

RESFAR #454109

$2,250,000
Jan 30, 2017

Listed (Active)

EBRD #SF454109

$2,585,000
Jan 29, 2017

Listed (Active)

RESFAR #454109

$2,585,000
Dec 30, 2016

Withdrawn

RESFAR #447997

Dec 2, 2016

Price Change

RESFAR #447997

$2,700,000
Jul 12, 2016

Listed (Active)

RESFAR #447997

$2,995,000
Dec 18, 2013

Sold

RESFAR #415921

$2,400,000
Dec 16, 2013

Sold (Public Record)

Public Record #392557395

$2,015,000
Dec 16, 2013

Sold

MLSListings #BE40640834

$2,400,000
Dec 13, 2013

Expired

MLSListings #BE40590038

$2,449,000
Sep 26, 2013

Expired

RESFAR #401472

$2,449,000
Sep 26, 2013

Expired

EBRD #SF401472

Aug 28, 2013

Pending

MLSListings #BE40640834

Aug 23, 2013

Pending

RESFAR #415921

Aug 1, 2013

Listed (Active)

RESFAR #415921

$2,449,000
Aug 1, 2013

Listed (Active)

MLSListings #BE40640834

$2,449,000
Sep 27, 2012

Price Change

RESFAR #401472

$2,599,000
Sep 27, 2012

Listed (Active)

RESFAR #401472

$2,449,000
Sep 27, 2012

Listed (Active)

EBRD #SF401472

$2,599,000
Sep 20, 2012

Listed (Active)

MLSListings #BE40590038

$2,599,000
DateEvent & SourcePrice
11/06/2025

Listed (Active)

RESFAR #425086186

$1,100,000
10/02/2025

Withdrawn

RESFAR #425074313

$1,650,000
05/08/2025

Expired

EBRD #41078459

05/08/2025

Expired

MLSListings #BE41078459

$1,400,000
05/07/2025

Expired

CRMLS #41078459

04/07/2025

Price Change

MLSListings #BE41078459

$1,400,000
04/07/2025

Price Change

EBRD #41078459

$1,400,000
04/06/2025

Price Change

CRMLS #41078459

$1,400,000
11/07/2024

Listed (Active)

EBRD #41078459

$1,500,000
11/07/2024

Listed (Active)

MLSListings #BE41078459

$1,500,000
11/07/2024

Listed (Active)

CRMLS #41078459

$1,500,000
05/31/2020

Withdrawn

RESFAR #492451

11/08/2019

Listed (Active)

RESFAR #492451

$1,800,000
10/01/2019

Expired

SFAR #484384

$1,800,000
09/17/2019

Temporarily Off Market

SFAR #484384

05/03/2019

Listed (Active)

SFAR #484384

$1,800,000
01/07/2019

Withdrawn

SFAR #479832

01/07/2019

Listed (Active)

SFAR #479832

$2,395,000
07/06/2017

Sold

EBRD #SF454109

$2,100,000
07/06/2017

Sold

RESFAR #454109

$2,100,000
06/22/2017

Sold (Public Record)

Public Record #600923839

$2,100,000

+1.2% / yr

04/14/2017

Pending

RESFAR #454109

04/14/2017

Pending

EBRD #SF454109

01/30/2017

Price Change

RESFAR #454109

$2,250,000
01/30/2017

Listed (Active)

EBRD #SF454109

$2,585,000
01/29/2017

Listed (Active)

RESFAR #454109

$2,585,000
12/30/2016

Withdrawn

RESFAR #447997

12/02/2016

Price Change

RESFAR #447997

$2,700,000
07/12/2016

Listed (Active)

RESFAR #447997

$2,995,000
12/18/2013

Sold

RESFAR #415921

$2,400,000
12/16/2013

Sold (Public Record)

Public Record #392557395

$2,015,000
12/16/2013

Sold

MLSListings #BE40640834

$2,400,000
12/13/2013

Expired

MLSListings #BE40590038

$2,449,000
09/26/2013

Expired

RESFAR #401472

$2,449,000
09/26/2013

Expired

EBRD #SF401472

08/28/2013

Pending

MLSListings #BE40640834

08/23/2013

Pending

RESFAR #415921

08/01/2013

Listed (Active)

RESFAR #415921

$2,449,000
08/01/2013

Listed (Active)

MLSListings #BE40640834

$2,449,000
09/27/2012

Price Change

RESFAR #401472

$2,599,000
09/27/2012

Listed (Active)

RESFAR #401472

$2,449,000
09/27/2012

Listed (Active)

EBRD #SF401472

$2,599,000
09/20/2012

Listed (Active)

MLSListings #BE40590038

$2,599,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 400 Franconia Street

Taxable ValueLand$1,672,607Additions$716,829Total$2,389,436
Tax Record2025$29,067 ($2,422 / month)
Home Facts
Beds9Total Finished SqFt4,950 SqFtAbove Grade Finished SqFt4,950 SqFtStories3Lot Size6,650 SqFtStyleSingle Family ResidenceYear Built1981ZoningRH1CountySAN FRANCISCOAPN5556 -070

Schools near 400 Franconia Street

This home is within San Francisco Unified School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Public - K to 8
Rating
School
Distance
Flynn (Leonard R.) Elementary School
PublicK to 5

Lick (James) Middle School
Public6 to 8

Marshall (Thurgood) High School
Public9 to 12

Revere (Paul) Elementary School
PublicK to 8

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

400 Franconia Street is a single family home for sale in San Francisco, CA 94110. This property was listed for sale on November 6, 2025 by SkyGroup Realty Inc., it's currently listed at $1,100,000. It has been on the market for a total of 47 days and was last sold on July 6, 2017. This listing's school district is San Francisco Unified School District. Nearby schools include Flynn (Leonard R.) Elementary School, Lick (James) Middle School and Marshall (Thurgood) High School. 400 Franconia Street is a 5-bed, 5-bath, 4,845 sqft single family home built in 1981.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of SkyGroup Realty Inc., Anh H Pham, DRE #01432176

Based on information from one of the following Multiple Listing Services: San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.