This contemporary Noe Valley residence, redesigned and remodeled by acclaimed architect John Lum,is a true masterpiece. Featuring three bedrooms, three baths, and two additional spacious multi-functional areas, every space unveils a delightful surprise. This sophisticated home showcases meticulous design through strategic interplay of windows, light and texture, delivering spectacular views of the city and the bay. The main level presents an open-concept living space with city views and a sleek gas fireplace, transitioning to an adjacent skylit dining area and a chef's kitchen with premium appliances. A guest suite, which may double as an office, fully completes this floor. Upstairs, discover the primary bedroom enveloped by luscious foliage creating a luxurious natural (treehouse-like) sanctuary. The lavish/chic en-suite features dual vanities, a free standing soaking tub, and waterfall shower. The show stopping fourth level solarium incorporates innovative suspended planters with integrated irrigation for plant lovers, opening to a stunning roof deck with spectacular sunrises and 180 views spanning San Francisco and the Bay. The garden level continues the indoor-outdoor lifestyle with a multi-functional room and a third en-suite bedroom, both accessing a private manicured yard.
Sold for $3,400,000
Street View
$3,400,000
687 28th St, San Francisco, CA 94131
3beds
2,374sqft
Single Family Residence
Built in 1953
2,850 Square Feet Lot
$3,915,900 Zestimate®
$1,432/sqft
$7,959 Estimated rent
Home value
$3,915,900
$3.52M - $4.39M
$7,959/mo
Zestimate® history
Owner options
List your home for rent
$7,959/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$7,959/mo
Rent Zestimate®
Refinance and save
$21,375/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$21,375/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Afisaneh Valizadeh DRE #01239922 415-495-1114,
Compass 415-345-3000,
Caroline Antonacci DRE #02134363 415-990-1258,
Compass
Bought with:
Kelsey Takaha, DRE #02244334
Compass
Jennifer Siem-Oldham, DRE #01325650
Compass
Source: SFAR,MLS#: 425036055
Originating MLS: San Francisco Association of REALTORS
Originating MLS: San Francisco Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Features: Closet
- Area: 0
- Dimensions: 0 x 0
Bedroom 1
- Area: 0
- Dimensions: 0 x 0
Bedroom 2
- Area: 0
- Dimensions: 0 x 0
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Double Vanity
Bathroom
- Features: Double Vanity, Skylight/Solar Tube, Stone, Tub, Window
Dining room
- Features: Skylight(s)
- Level: Main
- Area: 0
- Dimensions: 0 x 0
Family room
- Features: Cathedral/Vaulted
- Level: Lower
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Features: Breakfast Area, Stone Counters
- Level: Main
- Area: 0
- Dimensions: 0 x 0
Living room
- Features: Great Room
- Level: Main
- Area: 0
- Dimensions: 0 x 0
Heating
- Central, Fireplace(s), Natural Gas
Appliances
- Included: Dishwasher, Disposal, Free-Standing Gas Range, Free-Standing Refrigerator, Range Hood, Dryer, Washer/Dryer Stacked
- Laundry: In Garage, Inside, Sink
Features
- Cathedral Ceiling(s)
- Flooring: Concrete, Tile, Wood
- Windows: Skylight(s)
- Number of fireplaces: 1
- Fireplace features: Living Room
Interior area
- Total structure area: 2,374
- Total interior livable area: 2,374 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Covered, Electric Vehicle Charging Station(s), Garage Door Opener, Private, Tandem, On Site (Single Family Only)
- Has attached garage: Yes
Features
- Stories: 3
- Patio & porch: Deck, Uncovered Deck
- Fencing: Wood
- Has view: Yes
- View description: City, City Lights, Downtown, Panoramic, San Francisco, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 2,850 sqft
- Features: Garden
Details
- Parcel number: 7520016
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Modern/High Tech
- Property subtype: Single Family Residence
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1953
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Green energy
- Energy efficient items: Appliances
Community & neighborhood
Location
- Region: San Francisco
HOA & financial
HOA
- Has HOA: No
Other financial information
- Total actual rent: 0
Other
Other facts
- Price range: $3.4M - $3.4M
- Listing terms: Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 6/20/2025 | Sold | $3,400,000-2.7%$1,432/sqft |
Source:  SFAR #425036055 Report a problem | ||
| 6/15/2025 | Pending sale | $3,495,000$1,472/sqft |
Source: SFAR #425036055 Report a problem | ||
| 5/16/2025 | Price change | $3,495,000-0.1%$1,472/sqft |
Source: SFAR #425036055 Report a problem | ||
| 3/21/2025 | Listed for sale | $3,500,000+2.2%$1,474/sqft |
Source: SFAR #425017242 Report a problem | ||
| 9/18/2019 | Sold | $3,425,077+3.9%$1,443/sqft |
Source: SFAR #489452 Report a problem | ||
| 9/11/2019 | Pending sale | $3,295,000$1,388/sqft |
Source: Compass #489452 Report a problem | ||
| 9/6/2019 | Listed for sale | $3,295,000+163.6%$1,388/sqft |
Source: Compass #489452 Report a problem | ||
| 5/25/2011 | Sold | $1,250,000$527/sqft |
Source: Public Record Report a problem | ||
| 3/16/2011 | Listed for sale | $1,250,000+52.4%$527/sqft |
Source: Coldwell Banker Residential Brokerage - San Francisco Market Street #382154 Report a problem | ||
| 2/28/2003 | Sold | $820,000+70.8%$345/sqft |
Source: Public Record Report a problem | ||
| 12/3/1997 | Sold | $480,000$202/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $45,026 +21.6% | $3,745,818 +20.8% |
| 2024 | $37,022 -14.1% | $3,100,000 -13.9% |
| 2023 | $43,085 +1.9% | $3,600,364 +2% |
| 2022 | $42,292 +1.8% | $3,529,770 +2% |
| 2021 | $41,552 -0.4% | $3,460,560 +1% |
| 2020 | $41,705 +49.8% | $3,425,077 +48.5% |
| 2019 | $27,849 +3.5% | $2,305,814 +2% |
| 2018 | $26,908 +2.3% | $2,260,600 +2% |
| 2017 | $26,291 +1.5% | $2,216,276 +2% |
| 2016 | $25,891 +61.6% | $2,172,822 +63.1% |
| 2015 | $16,021 +2.7% | $1,332,502 +2% |
| 2014 | $15,597 | $1,306,402 +0.5% |
| 2013 | -- | $1,300,500 +2% |
| 2012 | -- | $1,275,000 +37.5% |
| 2011 | -- | $926,974 +0.8% |
| 2010 | -- | $920,051 -0.2% |
| 2009 | -- | $922,236 +2% |
| 2008 | -- | $904,156 +2% |
| 2007 | -- | $886,430 +2% |
| 2006 | -- | $869,050 +2% |
| 2005 | -- | $852,010 +61% |
| 2003 | -- | $529,189 +2% |
| 2002 | -- | $518,814 +2% |
| 2001 | -- | $508,644 +2% |
| 2000 | -- | $498,670 |
Find assessor info on the county website
Neighborhood: Diamond Heights
Nearby schools
GreatSchools rating
- 8/10Alvarado Elementary SchoolGrades: K-5Distance: 0.6 mi
- 2/10Lick (James) Middle SchoolGrades: 6-8Distance: 0.5 mi
- 7/10Academy (The)- SF @McateerGrades: 9-12Distance: 0.7 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,915,900
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,915,900
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other San Francisco Topics
