
San Francisco, CA 94107
This Edwardian Duplex is a High-Potential Investment Opportunity listed at $2,500,000, representing a stable entry point at its $2,500,000 Fair Market Value. Featuring two massive 1,500+ sqft flats and an unpermitted studio, the property boasts panoramic city views and a Fair Condition Rating due to deferred exterior maintenance. Located in prime Potrero Hill near Whole Foods and elite schools like Lowell High School, it offers a rare 2026 owner-occupancy window. This is a strategic acquisition for Buy-and-Hold Investors or Owner-Occupants seeking a value-add "house hack."
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 954 De Haro Street Subject | $2,500,000* List Price | 6 | 2 | 3,074 | $813 | - |
A 481-483 Mississippi Street Sold | $2,300,000 | 7 | 3 | 2,324 | $990 | 0.4 mi |
B 121 Arkansas Street Active | $1,800,000 List Price | 7 | 4 | 2,350 | $766 | 0.5 mi |
* Subject property listed price vs sold prices of comps.
Property is moderate renovation needed.
This 1926 Edwardian duplex is in fair condition, showing signs of age and deferred maintenance consistent with a property held by the same owner for over 50 years. While the kitchen has been partially updated with granite countertops, shaker-style cabinetry, and some stainless steel appliances, the original hardwood floors show significant wear and the interior paint is dated. The listing description explicitly notes that the exterior requires repainting and the rear staircase needs structural reworking, placing it firmly in the 'fair' category as it requires minor to moderate updates and repairs.
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 in a highly desirable neighborhood, the property is less than a block from the Potrero Hill Community Center and within close proximity to Whole Foods, Chase Center, and Oracle Park.
Each flat offers over 1,500 square feet of living space with flexible 2-3 bedroom layouts, providing a rare scale and Edwardian architectural character that is highly sought after in San Francisco.
The property requires immediate capital investment for exterior repainting and structural reworking of the rear staircase, as noted in the listing details.
The presence of an unpermitted studio on the ground level may pose legal compliance risks and could complicate financing or future permitting processes with the city.
First time on the market in over fifty years for this Southwest Potrero Hill Edwardian that features 2 large flats with over 1500 square feet per flat with 2-3 bedrooms and one bathroom per flat. There is one unpermitted studio on the ground level. On May 1st, 2026 one of the full flats will be available for owner occupancy in this prime location. This property is in close proximity to all things Potrero Hill including the dazzling Potrero Hill Community center less than one block away and Whole Foods just a short jaunt over the hill, Thrive City and Chase Center and Oracle sports venues are very close as well. Maintenance expense has been historically minimal for this property but the exterior does require repainting as well as reworking some of the components of the rear staircase. Disclosures are available upon request. Inspection reports forthcoming.
No exterior & parking available.
Grades K-5 • 0.3 mi
Grades K-5 • 0.4 mi
Grades K-5 • 0.5 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 6.0 | 5.5 | 50% |
| Baths | 2.0 | 2.0 | 50% |
| Square foot | 3,074 | 2,916 | 50% |
| Lot Size | 2,500.34 | 2,498.165 | 50% |
| Price | $2.50M | $2.02M | 67% |
| Price per sq ft | $813 | $643 | 67% |
| Built year | 1926 | 1914 | 83% |
| HOA | $0 | $0 | 50% |
| Days on market | 122 | 189 | 17% |
Dec 21, 2025
$2,500,000
Initial Listing