$1,570,000
SOLD JUL 23, 2025
3 Beds
1.5 Baths
1,844 Sq Ft
$497/mo HOA Fee

Recently Sold

$851 Per Sq Ft

19% Below List Price

119 Days on Market

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 2025

Welcome 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.

Last Agent to Sell the Property

Michelle Harris

Compass License #02091863 Listed on: 03/21/2025

Compass

Co-Listed By

Val Steele

Compass License #00838961

Last Buyer's Agent

Kevin Delmore

Sotheby's International Realty License #01842104

Sotheby's International Realty

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

Property Details

Home Type

Condominium

Est. Annual Taxes

$22,740

Year Built

Built in 1906

Lot Details

0

HOA Fees

$497 per month

Listing Details

  • Property Type: Residential
  • Property Sub Type: Condominium
  • Subtype Description: Flat
  • Year Built: 1906
  • Special Features: None
  • Stories: 0

Interior Features

  • Bedrooms: 3
  • Bathrooms: 2
  • Half Bathrooms: 1
  • Full Bathrooms: 1
  • Number Of Rooms: 6
  • Appliances: Built-in Electric Oven, Built-in Gas Oven, Dishwasher, Free Standing Electric Oven, Free Standing Gas Oven, Gas Cook Top, Hood Over Range
  • Flooring: Wood
  • Interior Amenities: Skylight(s)
  • Kitchen Features: Breakfast Area, Island
  • Laundry Features: Dryer Included, Inside Area, Inside Room, Washer Included, Washer/Dryer Stacked Included
  • Price Per Square Foot: 851.41
  • Square Footage: 1844.00

Exterior Features

  • View: City

Utilities

  • Security Features: Smoke Detector

Condo/Co-op/Association

  • Association Fee: 497
  • Association Fee Frequency: Monthly

Lot Info

  • Assessor Parcel Number: 1248-042
  • Lot Size Acres: 0.0486
  • Lot Size Sq Ft: 2119.00
  • Lot Size Units: SqFt
  • Price Per Acre: 32304526.75

Multi Family

  • Number Of Units: 3

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
Source: Public Records

Similar Homes in San Francisco, CA

  • 317 Douglass St Unit 317, San Francisco, CA 94114

    $1,175,989

    • 3 Beds
    • 1 Bath
    • 1,309 Sq Ft
    • 317 Douglass St
    • Unit 317
    • San Francisco, CA

    Remarkable Price!!! 317 Douglass Street is a condo in an intimate three unit Edwardian building. Full floor flat with San Francisco charm and character. Coved ceilings, period built-ins, *hardwood flooring throughout lays under wall to wall carpeting. Two decorative fireplaces are just a few of the highlights. Beautiful, rich wood paneling adorns our southern exposed family/dining area. The floor

    Paul Andreini Nest Real Estate Services

    Section Image
  • 813 Union St, San Francisco, CA 94133

    $1,695,000

    • 2 Beds
    • 1.5 Baths
    • 1,609 Sq Ft
    • 813 Union St
    • San Francisco, CA

    Charming Victorian Penthouse in Iconic Russian Hill just steps from vibrant North Beach & Washington Square Park, this top-floor Victorian flat is a dream come true for city dwellers. Featuring 2 car tandem parking and extra storage and exclusive roof rights for a deck. Nestled in a quintessential San Francisco location, this 5-room condo blends classic period details with modern updates for

    John Woodruff Aethos Real Estate

    Section Image
  • 718 Long Bridge St Unit 1002, San Francisco, CA 94158

    $1,799,999

    • 2 Beds
    • 2 Baths
    • 1,417 Sq Ft
    • 718 Long Bridge St
    • Unit 1002
    • San Francisco, CA

    Enjoy bay views and abundant natural light from this highly desirable southeast-facing corner residence at Arden. Featuring 2 bedroom plus a den, an XL walk-out balcony, and floor-to-ceiling windows throughout. The open-concept layout includes a gourmet chef's kitchen with premium Sozo cabinetry, XL Caesarstone kitchen island, and premium Bosch and Thermador appliances, spacious separated

    Milan Jezdimirovic Compass

    Section Image
  • 333 1st St Unit 1507, San Francisco, CA 94105

    $1,150,000

    • 2 Beds
    • 2 Baths
    • 950 Sq Ft
    • 333 1st St
    • Unit 1507
    • San Francisco, CA

    Step into this stunning east-facing condo and be captivated by its breathtaking Bay Bridge and cityscape views, dazzling day or night. Thoughtfully designed with two spacious bedrooms and bathrooms on opposite sides, it's perfect for shared living, a peaceful home office setup, or simply spreading out in style. The interior boasts hardwood floors throughout, custom window treatments, and a

    Michael Annunziata North Point Real Estate

    Section Image
  • 1015 Ashbury St Unit 4, San Francisco, CA 94117

    $1,208,000

    • 1 Bed
    • 1 Bath
    • 974 Sq Ft
    • 1015 Ashbury St
    • Unit 4
    • San Francisco, CA

    List price is Probate Court Minimum Overbid amount. This penthouse unit, located in a boutique 4-unit Edwardian building, offers stunning views! From the living room, bedroom, and functional study, enjoy panoramic views that stretch from Mt. Sutro to the Marin Headlands, including the Ocean, Bay, and Golden Gate Bridge. With an elegant formal entry that features a large skylight, this home has an

    Kathleen Tostanoski Park North Real Estate

    Section Image
  • 85 Uranus Terrace, San Francisco, CA 94114

    $1,695,000

    • 3 Beds
    • 1.5 Baths
    • 1,461 Sq Ft
    • 85 Uranus Terrace
    • San Francisco, CA

    Perched on a serene block above the city and yet steps from all that Cole Valley has to offer, this two-level 3BR/1.5BA Corona Heights condo offers rare privacy, outdoor space, and breathtaking panoramic views. From the moment you arrive, you're welcomed by sweeping vistas of the skyline and Bay. Inside, period charm meets modern updates in a warm, inviting space that feels like home. Built in

    Shane Ray Compass

    Section Image
  • 10 Lower Terrace, San Francisco, CA 94114

    $1,295,000

    • 2 Beds
    • 1.5 Baths
    • 919 Sq Ft
    • 10 Lower Terrace
    • San Francisco, CA

    Spacious Condo That Lives Like a House in Coveted Corona Heights Discover the perfect blend of privacy, space, and convenience in this charming, tenant-occupied condo nestled in a duplex-style HOA in sought-after Corona Heights. Offering the feel of a single-family home, this residence boasts 2 bedrooms, 1.5 bathrooms, a private garage, and exclusive outdoor space. Step inside to a bright

    Jeff Appenrodt Laurel Realty & Investment

    Section Image
  • 527 Baker St Unit 527, San Francisco, CA 94117

    $1,695,000

    • 3 Beds
    • 2.5 Baths
    • 1,810 Sq Ft
    • 527 Baker St
    • Unit 527
    • San Francisco, CA

    Experience elevated urban living in this beautifully renovated 3-bed, 2.5 bath Condo located in the vibrant NOPA neighborhood. Thoughtfully redesigned with a contemporary floor plan providing a seamless flow between living and dining spaces. The updated kitchen is outfitted with stainless steel appliances, porcelain countertops, and an island overlooking the large living area. Retreat to the

    Kevin McCollom Compass

    Section Image
  • 12 Beaver St, San Francisco, CA 94114

    $1,495,000

    • 4 Beds
    • 2 Baths
    • 1,626 Sq Ft
    • 12 Beaver St
    • San Francisco, CA

    Classic Victorian in Prime San Francisco Location. Welcome to 12 Beaver Street, a beautiful Victorian home tucked away on a quiet street in San Francisco’s desirable Duboce Triangle neighborhood. Rich in period detail, this classic residence showcases decorative moldings, bay windows, high ceilings, and original hardwood floors—seamlessly blending historic charm with modern comfort. Located

    JACOB ADAMS

    Section Image

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

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

Source: Public Records

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

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: San Francisco Association of REALTORS® MLS

MLS Number: 425022395

San Francisco Association of REALTORS® MLS

APN: 1248-042