Tour
#425017391, Carol Koffel, Listing Office: Compass
$3,500,000 List price
687 28th St San Francisco, CA 94131
3 beds
3 full
2,374 sqft
0.07 acres
$1,474 / sqft
House
Property details
About 687 28th St
Contemporary Noe Valley residence redesigned and remodeled in 2014 by acclaimed architect John Lum, featuring strategic interplay of windows, light, and texture, with spectacular city and bay views. 3 bedrooms and 3 baths. The main level presents an open-concept living space with city views and a sleek gas fireplace, transitioning to a skylit dining area and chefs kitchen with premium appliances. A guest suite completes this floor. Upstairs, discover the primary bedroom with view of mature foliage creating a natural sanctuary, and served by a luxurious en-suite featuring dual vanities, a free standing soaking tub, and waterfall shower. The show stopping roof-level solarium incorporates innovative suspended planters with integrated irrigation, opening to a stunning roof deck with 180 degree views spanning downtown SF, the Bay, and the East Bay hills. The garden level continues the indoor-outdoor lifestyle with a multi-functional room and third en-suite bedroom, both accessing a private manicured garden through expansive sliding glass doors. 2 car tandem parking and extensive storage space in the garage. This residence masterfully balances architectural innovation with functional luxury for discerning urban dwellers seeking both sophisticated design and tranquil living.
Highlights
Home typeSingle Family Residence
HeatingCentral, Natural Gas, Heat Pump
StatusActive
Size2,374 sqft
Lot size0.07 Acres
Year built1953
ParkingAttached, Enclosed, Electric Vehicle Charging Station(s), Garage Door Opener, Garage Faces Front, Inside Entrance, Private, Tandem, On Site (Single Family Only)
MLS #425017242
Attached garageYes
FireplaceGas Starter, Living Room
ViewBay, City, City Lights, Downtown, Hills
Virtual tour
Summary
- MLS Number: 425017242
- MLS Name: San Francisco
- Office Name: Christies Intl R.E. San Francisco
- Office Phone: (415) 312-2555
- Listing Agent: Afi Valizadeh
Listings on this page identified as belonging to another listing firm are based upon data obtained from the SFAR MLS, which data is copyrighted by the San Francisco Association of REALTORS©, but is not warranted. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listing Broker has attempted to offer accurate data, but buyers are advised to confirm all data provided. 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.
© 2025 San Francisco Association of Realtors. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 4/12/2025, 4:20:55 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$3,500,000
687 28th St
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Sep 18, 2019 | Home Sold | $3,425,500 |
| May 25, 2011 | Home Sold | $1,250,000 |
| Feb 28, 2003 | Home Sold | $820,000 |
| Dec 03, 1997 | Home Sold | $480,000 |
| Dec 09, 1992 | Home Sold | $315,000 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $3,100,000 | $37,021 |
| 2023 | $3,600,364 | $43,084 |
| 2022 | $3,529,770 | $42,292 |
| 2021 | $3,460,560 | $41,551 |
| 2020 | $3,425,077 | $27,848 |
| 2019 | $2,305,814 | $26,907 |
| 2018 | $2,260,600 | $26,907 |
| 2017 | $2,216,276 | $25,891 |
History based on county public records data.
Nearby schools
2
Mission Education Center
Public District KG-5
0.4 mi
•1670 Noe St
6
Alvarado Elementary School
Public District KG-5
0.6 mi
•625 Douglass St
4
Huerta (Dolores) Elementary School
Public District KG-5
0.7 mi
•65 Chenery St
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $82,572. The majority of San Francisco, CA residents have income between $35k-100k annually. Most families are single, no kids. Most residents in this area have post secondary degree education.
How much money do the neighbors make?
23%
<35k
40%
35k-100k
27%
100k-200k
10%
200k+
What level of education do the neighbors have?
No High School
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
69%
Single, No Kids
5%
Single, with Kids
18%
Married, No Kids
8%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
7%
<11 yrs old
2%
12-17 yrs old
19%
18-34 yrs old
54%
35-64 yrs old
18%
65+ yrs old
What do the neighbors do for fun?
Live Theatre
Hiking/backpacking
Art Museums
Where do the neighbors shop?
Bloomingdales
Banana Republic
H&M
Where do the neighbors go to eat?
Boston Market
Starbucks
Jack In The Box
What do the neighbors drive?
Mercedes
Audi
Toyota
What do the neighbors listen to?
News
Alternative
Jazz
All data provided by Home Junction and Claritas
Similar homes for sale
1 day on Rocket
#425028576, Frank A Nolan, Andrew J Warren, Listing Office: Vanguard Properties
1 day on RocketTour
$10,000 Closing Credit¹
#425029172, Sherri Howe, Savinie Lam, Listing Office: Compass
$10,000 Closing Credit¹
#425017988, Deniz Kahramaner, Listing Office: ATLASA
Tour
#425021291, Kevin K Zhou, Listing Office: Compass
$10,000 Closing Credit¹
#425026682, Kelsey Stratton, Priya Agrawal, Listing Office: Rivet Real Estate
Tour
#425025121, Cassie Kim, Listing Office: Vanguard Properties
5 days on Rocket
$10,000 Closing Credit¹
#425025921, Nina Hatvany, Paul Hatvany Kitchen, Listing Office: Compass
Tour
$10,000 Closing Credit¹
#425011187, Yulia I Mitchell, Michael J Plotkowski, Listing Office: Compass
$10,000 Closing Credit¹
#425016068, Anh H Pham, Listing Office: SkyGroup Realty Inc.
Frequently asked questions
About 687 28th St
This home is located at 687 28th St in San Francisco, CA and zip code 94131 in the Noe Valley neighborhood. This 2,374 square foot home, which was built in 1953, sits on a 0.07 acre lot. Features: 3 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since March 21, 2025 and is currently priced at $3,500,000.
In March 2025, from all listings sold in San Francisco, CA there were more than 210 sold above asking price, over 108 sold below and more than 29 were sold right at the asked price. The inventory of homes for sale in San Francisco, CA between February and March 2025 increased by 4.9%. While the average time on the market in March 2025 was 35 days, the median list price was $1,450,000.
From Rocket Homes Real Estate and based on county public records data.