647 Cole St San Francisco, CA 94117
Haight-Ashbury Neighborhood
3
Beds
1.5
Baths
1,844
Sq Ft
$398/mo
HOA Fee
Highlights
- Unit is on the top floor
- 4-minute walk to Carl And Cole
- Edwardian Architecture
- Grattan Elementary Rated A
- Dining Room with Fireplace
- 5-minute walk to Richard Gamble Memorial Park
About This Home
As of July 2025This beautifully maintained top-floor Edwardian flat features 3 bedrooms + a home office and 1 1/2 bathrooms with over 1800 square feet of flexible living space. This expansive residence combines classic architectural details with modern design. Featuring a thoughtful floor plan with generously proportioned rooms, a spacious kitchen and formal dining room. Showcasing artisan craftsmanship, 647 Cole features gleaming hardwood floors with walnut inlays, high ceilings, contemporary lighting, period molding and trim details, and is flooded with natural light. Exclusive use for this home is a 1,000 sq. ft. attic with potential development into additional living space. Located on the border of the Cole Valley and Haight Ashbury neighborhoods, this home is convenient to fine and casual dining, parks and recreation, freeway access and has access to public and private transportation.
Property Details
Home Type
- Condominium
Est. Annual Taxes
- $22,740
Year Built
- Built in 1904
HOA Fees
- $398 Monthly HOA Fees
Home Design
- Edwardian Architecture
- Wood Siding
- Concrete Perimeter Foundation
Interior Spaces
- 1,844 Sq Ft Home
- Decorative Fireplace
- Living Room with Fireplace
- Dining Room with Fireplace
- 2 Fireplaces
- Formal Dining Room
- Home Office
- Storage Room
- Wood Flooring
Kitchen
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- Main Floor Bedroom
- Bathtub with Shower
Laundry
- 220 Volts In Laundry
- Washer and Dryer Hookup
Parking
- Side by Side Parking
- Parking Fee
- $198 Parking Fee
Additional Features
- Unit is on the top floor
- Central Heating
Listing and Financial Details
- Assessor Parcel Number 1248-042
Community Details
Overview
- Association fees include maintenance exterior, trash, homeowners insurance, water
- 3 Units
- 643 647 Cole Street HOA
- Low-Rise Condominium
- Greenbelt
Recreation
- Community Spa
Ownership History
Date
Name
Owned For
Owner Type
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
Outstanding Balance
$880,500
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$686,861
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.32%
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
Similar Homes in San Francisco, CA
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 |
|---|---|---|---|
| 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 | $985,000 | New Conventional | |
| Closed | $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
Seller's Agent in 2025
Michelle Harris
Compass
(415) 712-4600
1 in this area
34 Total Sales
-
Val Steele
Seller Co-Listing Agent in 2025
Val Steele
Compass
(415) 810-5234
26 Total Sales
-
K
Buyer's Agent in 2025
Kevin Delmore
Sotheby's International Realty
-
Brendon Kearney
Seller's Agent in 2019
Brendon Kearney
Compass
(415) 640-4757
1 in this area
88 Total Sales
-
Gillian Toboni
Buyer's Agent in 2019
Gillian Toboni
Compass
(415) 297-5572
40 Total Sales
Map
Source: San Francisco Association of REALTORS® MLS
MLS Number: 484614
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
- 1708 Waller St
- 1742 Page St
- 1736 Page St
- 55 Downey St
- 839 Cole St
- 535 Frederick St
- 720 Ashbury St
- 1976 Fell St
- 23A Delmar St Unit 23A
- 1932 Fell St Unit 1
- 516 Stanyan St
- 1818 Fell St
- 126 Cole St
- 1024 Masonic Ave
- 683 Frederick St
- 655 Frederick St
- 1015 Ashbury St Unit 4
- 1015 Ashbury St Unit 3
- 333 Parnassus Ave
- 450 Carl St