Property Details
Upcoming Open Houses
About this Property
Featured on CNBC, this remarkable residence captured national attention for its elevated design, prime location, and lifestyle appeal. Where design, innovation, and panoramic views converge. Built in 2022, 479 28th Street is a rare modern residence in the heart of Noe Valley, defined by clean architectural lines, premium materials, and elevated living. The most defining feature: the VIEWS, from all levels. From three primary levels, the home enjoys over 270 degrees of sweeping panoramas from the rolling silhouette of Twin Peaks, across the San Francisco skyline and Bay, stretching east toward Mount Diablo on a clear day. Features an in-home elevator, sun-filled terraces or patios on every level, sculptural skylit staircase and a private landscaped garden below. Wide-plank white oak floors, a Yakisugi-treated Japanese Cypress entry, and an Oko Skin slat facade create a refined modern aesthetic. With seven bedrooms and six and half bathrooms, the home features a full-floor primary suite with sweeping views and dual walk-in closets. Main living quarters and a lower unit are integrated into a single-family layout for flexible living. Refined details include Bose surround audio, custom Hafele steel drawer systems, and outdoor decking with a Bison pedestal system for seamless indoor-ou
MLS Listing Information
MLS #
SF426096204
MLS Source
San Francisco Association of Realtors® MLS
Days on Site
15
Interior Features
Appliances
Dishwasher, Oven - Built-In, Oven - Electric, Oven Range - Built-In, Oven Range - Electric
Flooring
Wood
Heating
Central Forced Air, Electric, Heat Pump, Solar
Exterior Features
Roof
Composition
Foundation
Slab
Style
Contemporary
Parking, School, and Other Information
Garage/Parking
Garage, Garage: 0 Car(s)
Sewer
Public Sewer
Water
Public
HOA Fee
$0
Complex Amenities
Community Security Gate
Contact Information
Listing Agent
Zara Rowbotham
Vanguard Properties
License #: 01875543
Phone: (415) 662-8822
Co-Listing Agent
James Rowbotham
Compass
License #: 02240717
Phone: (925) 808-9656
Unit Information
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 2 | 0 | 2 |
| Unit # | Sq Ft | Beds | Baths | Rent |
|---|---|---|---|---|
| 1 | 0 | 4 | 4/1 | – |
| 2 | 0 | 3 | 0/0 | – |
Neighborhood: Around This Home
Neighborhood: Local Demographics
Nearby Homes for Sale
479 28th St is a Duplex in San Francisco, CA 94131. This 4,940 square foot property sits on a 2,848 Sq Ft Lot and features – bedrooms & – full bathrooms. It is currently priced at $5,994,000 and was built in 2022. This address can also be written as 479 28th St, San Francisco, CA 94131.
©2026 San Francisco Association of Realtors® MLS. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from San Francisco Association of Realtors® MLS.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of January 30, 2026. For the most current information, please contact Zara Rowbotham, (415) 662-8822
