Seller's Agent in 2025
Michelle Harris
Compass
(415) 712-4600
1 in this area
34 Total Sales
647 Cole St San Francisco, CA 94117
Haight-Ashbury Neighborhood
3
Beds
1.5
Baths
1,844
Sq Ft
$497/mo
HOA Fee
Highlights
- City View
- 4-minute walk to Carl And Cole
- Breakfast Area or Nook
- Grattan Elementary Rated A
- Wood Flooring
- 5-minute walk to Richard Gamble Memorial Park
About This Home
As of July 2025Welcome to 647 Cole Street a sunlit, top-floor Edwardian flat in the heart of San Francisco's most iconic and walkable neighborhoods. Nestled just steps from Golden Gate Park, boutique shops, and beloved local cafes, this spacious residence blends timeless charm with modern urban convenience. Featuring tall ceilings, period details, and abundant natural light, the home offers a flexible layout perfect for remote work, entertaining, or city living. Enjoy a recently updated kitchen, generous bedrooms, and serene outlooks from every room. Skip the hassle of driving-this location is a dream for commuters and culture-seekers alike. With a Walk Score of 97 and Transit Score of 90+, you're a short walk to tech shuttles, MUNI lines, UCSF, and everything the Haight, Cole Valley, and the Inner Sunset have to offer. Parking? No problem. You're surrounded by car-sharing options, secure bike storage, and easily rentable garages nearby. Embrace a low-maintenance, eco-friendly lifestyle in a vibrant, community-oriente neighborhood.Whether you're a first-time buyer,UCSF affiliate, investor, or pied--terre seeker, 647 Cole is your gateway to classic San Francisco living-without compromise.
Property Details
Home Type
- Condominium
Est. Annual Taxes
- $22,740
Year Built
- Built in 1906
HOA Fees
- $497 Monthly HOA Fees
Interior Spaces
- 1,844 Sq Ft Home
- Skylights
- Wood Flooring
- City Views
- Stacked Washer and Dryer
Kitchen
- Breakfast Area or Nook
- Built-In Gas Oven
- Free-Standing Electric Oven
- Gas Cooktop
- Range Hood
- Dishwasher
- Kitchen Island
Home Security
Listing and Financial Details
- Assessor Parcel Number 1248-042
Community Details
Overview
- 3 Units
Security
- Fire and Smoke Detector
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Mar 21, 2025
Closed on
Jul 21, 2025
Sold by
Mamacita Cha Cha Cha Living Trust and Marenbach Christian Dieter
Bought by
Utton Olivia and Utton James
Seller's Agent
Michelle Harris
Compass
Buyer's Agent
Gregg Lynn
Sotheby's International Realty
List Price
$1,950,000
Sold Price
$1,570,000
Premium/Discount to List
-$380,000
-19.49%
Views
47
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-1.05%
Original Mortgage
$1,256,000
Outstanding Balance
$1,256,000
Interest Rate
6.84%
Mortgage Type
New Conventional
Estimated Equity
$311,361
Purchase Details
Closed on
Aug 20, 2020
Sold by
Marenbach Christian Dieter and Casper Caroline Louise
Bought by
Marenbach Christian Dieter and Casper Caroline Louise
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$985,000
Interest Rate
2.8%
Mortgage Type
New Conventional
Purchase Details
Listed on
May 9, 2019
Closed on
Jun 8, 2019
Sold by
Camp John and Camp Michelle N
Bought by
Marenbach Christian Dieter and Casper Caroline Louise
Seller's Agent
Brendon Kearney
Compass
Buyer's Agent
Gillian Toboni
Compass
List Price
$1,700,000
Sold Price
$1,700,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-1.29%
Original Mortgage
$100,000
Interest Rate
4.1%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jul 1, 2017
Sold by
Camp John
Bought by
Camp John and Camp Michelle N
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$878,800
Interest Rate
3.94%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 16, 2017
Sold by
Cantu Alberto and Witherspoon Thomas
Bought by
Camp John
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$880,000
Interest Rate
4.17%
Mortgage Type
New Conventional
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | -- | First American Title | |
| Interfamily Deed Transfer | -- | None Available | |
| Grant Deed | $1,700,000 | Chicago Title Co Concord | |
| Interfamily Deed Transfer | -- | Boston Natl Title Agency Llc | |
| Interfamily Deed Transfer | -- | Chicago Title Company |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,256,000 | New Conventional | |
| Previous Owner | $985,000 | New Conventional | |
| Previous Owner | $100,000 | New Conventional | |
| Previous Owner | $878,800 | New Conventional | |
| Previous Owner | $880,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 07/23/2025 07/23/25 | Sold | $1,570,000 | 0.0% | $851 / Sq Ft |
| 07/18/2025 07/18/25 | Pending | -- | -- | -- |
| 06/05/2025 06/05/25 | Price Changed | $1,570,000 | -11.5% | $851 / Sq Ft |
| 04/28/2025 04/28/25 | Price Changed | $1,775,000 | -9.0% | $963 / Sq Ft |
| 03/21/2025 03/21/25 | For Sale | $1,950,000 | +14.7% | $1,057 / Sq Ft |
| 06/12/2019 06/12/19 | Sold | $1,700,000 | 0.0% | $922 / Sq Ft |
| 05/24/2019 05/24/19 | Pending | -- | -- | -- |
| 05/09/2019 05/09/19 | For Sale | $1,700,000 | -- | $922 / Sq Ft |
Source: San Francisco Association of REALTORS® MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $22,740 | $1,896,377 | $1,137,827 | $758,550 |
| 2024 | $22,740 | $1,859,194 | $1,115,517 | $743,677 |
| 2023 | $22,232 | $1,822,741 | $1,093,645 | $729,096 |
| 2022 | $21,815 | $1,787,001 | $1,072,201 | $714,800 |
| 2021 | $21,430 | $1,751,963 | $1,051,178 | $700,785 |
| 2020 | $21,522 | $1,734,000 | $1,040,400 | $693,600 |
| 2019 | $8,721 | $677,942 | $338,971 | $338,971 |
| 2018 | $8,428 | $664,650 | $332,325 | $332,325 |
Source: Public Records
Agents Affiliated with this Home
-
Michelle Harris
-
Val Steele
Seller Co-Listing Agent in 2025
Val Steele
Compass
(415) 810-5234
1 in this area
29 Total Sales
-
Gregg Lynn
Buyer's Agent in 2025
Gregg Lynn
Sotheby's International Realty
(415) 595-4734
2 in this area
279 Total Sales
-
Brendon Kearney
Seller's Agent in 2019
Brendon Kearney
Compass
(415) 640-4757
1 in this area
87 Total Sales
-
Gillian Toboni
Buyer's Agent in 2019
Gillian Toboni
Compass
(415) 297-5572
38 Total Sales
Map
Source: San Francisco Association of REALTORS® MLS
MLS Number: 425022395
APN: 1248-042
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Nearby Homes
- 764 Cole St Unit 1
- 1742 Page St
- 1736 Page St
- 1662 Page St
- 1664 Page St
- 135 Carl St Unit 4
- 1010 Stanyan St Unit 2
- 1330 Waller St
- 1006 Cole St
- 2267 Hayes St
- 516 Stanyan St
- 1818 Fell St
- 1127 Shrader St
- 2137 Grove St
- 1960 Hayes St Unit 7
- 1960 Hayes St Unit 2
- 1024 Masonic Ave
- 683 Frederick St
- 655 Frederick St
- 978 Clayton St