---
listing_id: SF426096204
status: Closed
price: 5710000
beds: 0
baths_full: 0
baths_half: 0
sqft_living: 4940
sqft_lot: 2848
lot_acres: 
year_built: 2022
property_type: Residential Income
property_subtype: Duplex
address: "479 28th St"
city: San Francisco
state: CA
zip: 94131
county: "San Francisco County"
lat: 37.7447523
lng: -122.432938
days_on_market: 117
hoa_fee: 
hoa_frequency: 
garage_spaces: 0
list_agent: "Zara Rowbotham"
list_office: "Vanguard Properties"
list_agent_phone: "(415) 662-8822"
list_agent_license: 01875543
mls_source: RESFAR
modified: 2026-03-23
transaction_type: recentlySold
---

Home | San Francisco County | San Francisco | 94131 | 479 28th St

479 28th St, San Francisco, CA 94131

MLS: SF426096204 | Status: Sold | Price: $5,710,000
Beds/Baths: – / –
Property Type: Residential Income

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4,940 2,848 2022

Remarks

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

Field Value
MLS # SF426096204
MLS Source San Francisco Association of Realtors® MLS

Features

Interior Features

Feature Details
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

Feature Details
Roof Composition
Foundation Slab
Style Contemporary

Parking, School, and Other Information

Feature Details
Garage/Parking Garage, Garage: 0 Car(s)
Sewer Public Sewer
Water Public
HOA Fee $0
Complex Amenities Community Security Gate

Contact Information

Listing Agent Co-Listing Agent
Zara Rowbotham James Rowbotham
Vanguard Properties Compass
License #: 01875543 License #: 02240717
Phone: (415) 662-8822 Phone: (925) 808-9656

Property Units

# Buildings # Leased Units # Total Units
2 0 2

Unit Details

Unit # Sq Ft Beds Baths Rent
1 0 4 4/1
2 0 3 0/0

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Mission Education Center public K-5 0.20 mi 1
Lick (James) Middle School public 6-8 0.34 mi 2
Fairmount Elementary School public K-5 0.52 mi 7
Alvarado Elementary School public K-5 0.66 mi 8
Mahler (Theresa S.) Children Center public KG 0.77 mi N/A
Glen Park Elementary School public K-5 0.82 mi 6
Serra (Junipero) Elementary School public K-5 0.82 mi 2
Academy (The)- SF @Mcateer public 9-12 0.86 mi 7
Asawa (Ruth) San Francisco School Of The Arts, A Public School. public 9-12 0.86 mi 10
Rooftop Elementary School public K-8 0.87 mi 8
Buena Vista/ Horace Mann K-8 public K-8 0.92 mi 3
Milk (Harvey) Civil Rights Elementary School public K-5 1.00 mi 6
Miraloma Elementary School public K-5 1.03 mi 6
Flynn (Leonard R.) Elementary School public K-5 1.17 mi 4
Revere (Paul) Elementary School public K-8 1.20 mi 2
Chavez (Cesar) Elementary School public K-5 1.20 mi 3
Mission High School public 9-12 1.22 mi 3
San Francisco Community Alternative School public K-8 1.29 mi 5
Sanchez Elementary School public K-5 1.30 mi 2
Sunnyside Elementary School public K-5 1.32 mi 8

Disclosures

©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 March 23, 2026. For the most current information, please contact Zara Rowbotham, (415) 662-8822.