
San Francisco, CA 94107
This Turnkey Luxury Duplex is listed at $3,995,000, representing a premium asset positioned near its $3,836,309 Fair Market Value. Featuring an Excellent Condition Rating, the property showcases a comprehensive designer renovation with chef's kitchens, city skyline views, and private outdoor decks. Situated near Top-Rated Schools including Lowell High (10/10) and Lilienthal Elementary (9/10), this residence blends sophisticated design with functional versatility. It is an elite selection for Owner-Occupants seeking a high-end lifestyle or Luxury Real Estate Investors.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 704 18th Street Subject | $3,995,000* List Price | 7 | 5 | 3,579 | $1,072 | - |
A 801 Wisconsin Street Sold | $2,925,000 | 5 | 2 | 2,758 | $1,061 | 0.6 mi |
B 1390-1392 Rhode Island Street Active | $2,800,000 List Price | 7 | 7 | 3,386 | $827 | 1.0 mi |
* Subject property listed price vs sold prices of comps.
Property is new construction or fully renovated.
The property has undergone a comprehensive, design-led renovation where every major component—including electrical, plumbing, flooring, and lighting—has been fully replaced or upgraded. It features a modern chef's kitchen with premium appliances, designer bathrooms, and high-end finishes throughout, meeting the criteria for a newly renovated, turnkey luxury residence with no deferred maintenance.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
The property has undergone an extensive, design-led renovation featuring all-new systems, premium chef's kitchens, and high-end finishes, offering a turnkey luxury experience.
With seven total bedrooms across two units, including a dedicated office and a large bonus family room, the floor plan provides rare flexibility for multi-generational living or high-yield rental income.
Living area discrepancy between mls listing and other public or private record. mls listing living area = 3579, other record living area = 2800.
The property is offered as Tenancy in Common (TIC) units, which typically involves more complex financing options and legal arrangements compared to traditional fee-simple or condo ownership.
While some nearby schools are highly rated, several assigned public schools in the immediate area have low ratings, which may impact the property's appeal to families.
Offered individually or as a 2 unit building. Two units (TIC's) thoughtfully reimagined through an extensive, design-led renovation. Led by a respected local designer, the two renovated units showcase the highest level of craftsmanship and finish, with all systems, surfaces, and details completely new. 694 Tennessee Street | Lower Residence The lower unit at 694 Tennessee Street is a spacious and light-filled four-bedroom, three-bath home designed for both everyday living and entertaining. The main level features an open-concept kitchen, living, and dining area, anchored by a chef's kitchen with premium appliances and designer finishes. Two bedrooms and two bathrooms are located on this level, including a serene primary suite. The lower level offers exceptional flexibility with a large bonus family room, dedicated laundry, a generous office, and two additional bedrooms with a full bathroom. This level opens directly to a bright outdoor space, creating an ideal indoor-outdoor flow rarely found in city homes. 704 18th Street | Upper Residence With its own separate address, the upper residence at 704 18th Street features three bedrooms and two bathrooms, highlighted by soaring ceilings, rich architectural detail, and a fireplace that anchors the living space. A private deck off the bedrooms adds a quiet outdoor retreat. The layout is elegant yet functional, blending classic character with a fully modernized interior. Design and Finishes Across both residences, every element has been fully replaced or upgraded, including floors, doors, bathrooms, electrical, plumbing, lighting, and kitchens. The result is a seamless blend of refined design, modern comfort, and long-term reliability. Each unit includes one-car parking.
No exterior & parking available.
Grades K-5 • 0.4 mi
Grades K-5 • 0.9 mi
Grades K-5 • 2.1 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 7.0 | 6.0 | 50% |
| Baths | 5.0 | 3.0 | 67% |
| Square foot | 3,579 | 3,168.5 | 50% |
| Lot Size | 2,500.34 | 2,498.165 | 50% |
| Price | $4.00M | $2.02M | 83% |
| Price per sq ft | $1.1K | $643 | 83% |
| Built year | 1950 | 1914 | 83% |
| HOA | $0 | $0 | 50% |
| Days on market | 111 | 189 | 17% |
Jan 1, 2026
$3,995,000
Initial Listing
Sep 22, 2015
$3,250,000
Public Record