Buy
  • Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (744)
    Mexico Listings (332)
    Central America Listings (633)
    Caribbean Islands Listings (45)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7745460
MLS #426143793
Listing photo

Rarely does a Cole Valley Victorian combine this much scale

482 Frederick St, San Francisco, California, 94117
$2,695,000
8Beds
4Baths
2,371Sqft
0.079Acres

About this property

Rarely does a Cole Valley Victorian combine this much scale, architectural character, flexibility, and opportunity in one remarkable property. Located near Cole Valley, Golden Gate Park, UCSF, and Haight-Ashbury, this substantial turn-of-the-century 5-6BD/3BA Victorian home offers approximately 3670 sq. ft. of measured living space per floor plan provider, including an approximately 1080 sq. ft. separate legal 2BR/1BA lower-level residence. Together, the property offers up to 8BDs and 4 full BAs, creating exceptional flexibility for multigenerational living, extended family, guests, home offices, or income potential. Rich in period character, the main residence features high ceilings, hardwood floors, decorative fireplace mantels, bay windows, period moldings, vintage millwork, pocket doors, and a central staircase that anchors the home's interior. Formal living rm and adjoining parlor provide gracious entertaining spaces, while the spacious formal dining rm, located adjacent to a full BA, may continue as a traditional dining rm or function as a main-level BR or primary suite alternative. Large eat-in kitchen, separate laundry rm, and direct access to the rear garden complete the main level. Upper levels include generous BRs, abundant natural light, and multiple BAs arranged to support changing household needs. The separate legal lower-level residence features its own private entrance, spacious living rm, eat-in kitchen, 2BRs, full BA, bonus office/study alcove, and direct access to the rear garden. Ideal for aging parents, adult children returning home, live-in caregivers, au pairs, guests, a private home office, or rental income. The rear garden offers generous outdoor space with mature trees, established plantings, patio areas, pathways, and a detached garden shed. Conveniently located near neighborhood cafes, restaurants, boutiques, N Judah Muni, Golden Gate Park, the Panhandle, and Kezar Stadium. A rare opportunity to own a substantial Cole Valley Victorian offering classic San Francisco character, remarkable flexibility, and long-term potential. Broker's Note: Buyers to verify all square footage and warranted bedroom and bath counts for themselves.

Property Features

8 Beds
4 Baths
2,371 Sqft
Built in 1900
0.079 Acres
4 Stories
Siding: Wood
Composition Roof
Central
San Francisco County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Andrew de Vries

Berkshire Hathaway Franciscan Properties

415-585-5200

Location

Map
Listing Agent: Andrew de Vries 415-585-5200
Broker: Berkshire Hathaway Franciscan Properties 415-664-9400 Listing Site
Copyright © 2026 San Francisco Association of REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Jul 15, 2026

Photo Gallery

Rarely does a Cole Valley Victorian combine this much scale - photo 1
Rarely does a Cole Valley Victorian combine this much scale - photo 2
Rarely does a Cole Valley Victorian combine this much scale - photo 3
Rarely does a Cole Valley Victorian combine this much scale - photo 4
Rarely does a Cole Valley Victorian combine this much scale - photo 5
Rarely does a Cole Valley Victorian combine this much scale - photo 6
Rarely does a Cole Valley Victorian combine this much scale - photo 7
Rarely does a Cole Valley Victorian combine this much scale - photo 8
Rarely does a Cole Valley Victorian combine this much scale - photo 9
Rarely does a Cole Valley Victorian combine this much scale - photo 10
Rarely does a Cole Valley Victorian combine this much scale - photo 11
Rarely does a Cole Valley Victorian combine this much scale - photo 12
Rarely does a Cole Valley Victorian combine this much scale - photo 13
Rarely does a Cole Valley Victorian combine this much scale - photo 14
Rarely does a Cole Valley Victorian combine this much scale - photo 15
Rarely does a Cole Valley Victorian combine this much scale - photo 16
Rarely does a Cole Valley Victorian combine this much scale - photo 17
Rarely does a Cole Valley Victorian combine this much scale - photo 18
Rarely does a Cole Valley Victorian combine this much scale - photo 19
Rarely does a Cole Valley Victorian combine this much scale - photo 20
Rarely does a Cole Valley Victorian combine this much scale - photo 21
Rarely does a Cole Valley Victorian combine this much scale - photo 22
Rarely does a Cole Valley Victorian combine this much scale - photo 23
Rarely does a Cole Valley Victorian combine this much scale - photo 24
Rarely does a Cole Valley Victorian combine this much scale - photo 25
Rarely does a Cole Valley Victorian combine this much scale - photo 26
Rarely does a Cole Valley Victorian combine this much scale - photo 27
Rarely does a Cole Valley Victorian combine this much scale - photo 28
Rarely does a Cole Valley Victorian combine this much scale - photo 29
Rarely does a Cole Valley Victorian combine this much scale - photo 30
Rarely does a Cole Valley Victorian combine this much scale - photo 31
Rarely does a Cole Valley Victorian combine this much scale - photo 32
Rarely does a Cole Valley Victorian combine this much scale - photo 33
Rarely does a Cole Valley Victorian combine this much scale - photo 34
Rarely does a Cole Valley Victorian combine this much scale - photo 35
Rarely does a Cole Valley Victorian combine this much scale - photo 36
Rarely does a Cole Valley Victorian combine this much scale - photo 37
Rarely does a Cole Valley Victorian combine this much scale - photo 38
Rarely does a Cole Valley Victorian combine this much scale - photo 39
Rarely does a Cole Valley Victorian combine this much scale - photo 40
Rarely does a Cole Valley Victorian combine this much scale - photo 41
Rarely does a Cole Valley Victorian combine this much scale - photo 42
Rarely does a Cole Valley Victorian combine this much scale - photo 43
Rarely does a Cole Valley Victorian combine this much scale - photo 44
Rarely does a Cole Valley Victorian combine this much scale - photo 45
Rarely does a Cole Valley Victorian combine this much scale - photo 46
Rarely does a Cole Valley Victorian combine this much scale - photo 47
Rarely does a Cole Valley Victorian combine this much scale - photo 48
Rarely does a Cole Valley Victorian combine this much scale - photo 49
Rarely does a Cole Valley Victorian combine this much scale - photo 50

$2,695,000

8
Beds
4
Baths
2,371
Sqft

482 Frederick St, San Francisco, California, 94117

By contacting this agent you agree to these Terms and Conditions.
Home California San Francisco
Rarely does a Cole Valley Victorian combine this much scale - photo 1
Rarely does a Cole Valley Victorian combine this much scale - photo 2
Rarely does a Cole Valley Victorian combine this much scale - photo 3
Rarely does a Cole Valley Victorian combine this much scale - photo 4
Rarely does a Cole Valley Victorian combine this much scale - photo 5
MLS# 426143793
Home For Sale

Rarely does a Cole Valley Victorian combine this much scale

$2,695,000

482 Frederick St, San Francisco, California, 94117

8
Beds
4
Baths
2,371
Sqft
0.079
Acres
$2,695,000
482 Frederick St, San Francisco, California, 94117
8 Beds
4 Baths
2,371 Sqft
0.079 Acres
Rarely does a Cole Valley Victorian combine this much scale, architectural character, flexibility, and opportunity in one remarkable property. Located near Cole Valley, Golden Gate Park, UCSF, and Haight-Ashbury, this substantial turn-of-the-century 5-6BD/3BA Victorian home offers approximately 3670 sq. ft. of measured living space per floor plan provider, including an approximately 1080 sq. ft. separate legal 2BR/1BA lower-level residence. Together, the property offers up to 8BDs and 4 full BAs, creating exceptional flexibility for multigenerational living, extended family, guests, home offices, or income potential. Rich in period character, the main residence features high ceilings, hardwood floors, decorative fireplace mantels, bay windows, period moldings, vintage millwork, pocket doors, and a central staircase that anchors the home's interior. Formal living rm and adjoining parlor provide gracious entertaining spaces, while the spacious formal dining rm, located adjacent to a full BA, may continue as a traditional dining rm or function as a main-level BR or primary suite alternative. Large eat-in kitchen, separate laundry rm, and direct access to the rear garden complete the main level. Upper levels include generous BRs, abundant natural light, and multiple BAs arranged to support changing household needs. The separate legal lower-level residence features its own private entrance, spacious living rm, eat-in kitchen, 2BRs, full BA, bonus office/study alcove, and direct access to the rear garden. Ideal for aging parents, adult children returning home, live-in caregivers, au pairs, guests, a private home office, or rental income. The rear garden offers generous outdoor space with mature trees, established plantings, patio areas, pathways, and a detached garden shed. Conveniently located near neighborhood cafes, restaurants, boutiques, N Judah Muni, Golden Gate Park, the Panhandle, and Kezar Stadium. A rare opportunity to own a substantial Cole Valley Victorian offering classic San Francisco character, remarkable flexibility, and long-term potential. Broker's Note: Buyers to verify all square footage and warranted bedroom and bath counts for themselves.
6 days
on BeachHouse.com
10
views
0
saves

Property Details

HOME DETAILS

8 Beds
4 Baths
2,371 Sqft
Built in 1900
0.079 Acres
4 Stories

EXTERIOR

Siding: Wood
Composition Roof

INTERIOR

Central

FINANCIAL & COMMUNITY

San Francisco County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7745460
Viewed
10 times
Listing Status
Active
Added
Jul 08, 2026
Last Refresh
Jul 15, 2026 12:57:22 PM

Listing Information

Data Source
San Francisco Association of REALTORS
Source Property ID
426143793
Listing Agent: Andrew de Vries 415-585-5200
Broker: Berkshire Hathaway Franciscan Properties 415-664-9400 Listing Site
Copyright © 2026 San Francisco Association of REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Substantial vacant Richmond District two-family dwelling with - photo 1
Substantial vacant Richmond District two-family dwelling with - photo 2
Substantial vacant Richmond District two-family dwelling with - photo 3
Substantial vacant Richmond District two-family dwelling with - photo 4
Substantial vacant Richmond District two-family dwelling with - photo 5
Substantial vacant Richmond District two-family dwelling with - photo 6
Substantial vacant Richmond District two-family dwelling with - photo 7
Substantial vacant Richmond District two-family dwelling with - photo 8
Substantial vacant Richmond District two-family dwelling with - photo 9
Substantial vacant Richmond District two-family dwelling with - photo 10
Substantial vacant Richmond District two-family dwelling with - photo 11
Substantial vacant Richmond District two-family dwelling with - photo 12
Substantial vacant Richmond District two-family dwelling with - photo 13
Substantial vacant Richmond District two-family dwelling with - photo 14
Substantial vacant Richmond District two-family dwelling with - photo 15
Substantial vacant Richmond District two-family dwelling with - photo 16
Substantial vacant Richmond District two-family dwelling with - photo 17
Substantial vacant Richmond District two-family dwelling with - photo 18
Substantial vacant Richmond District two-family dwelling with - photo 19
Substantial vacant Richmond District two-family dwelling with - photo 20
Substantial vacant Richmond District two-family dwelling with - photo 21
Substantial vacant Richmond District two-family dwelling with - photo 22
Substantial vacant Richmond District two-family dwelling with - photo 23
Substantial vacant Richmond District two-family dwelling with - photo 24
Substantial vacant Richmond District two-family dwelling with - photo 25
Substantial vacant Richmond District two-family dwelling with - photo 26
Substantial vacant Richmond District two-family dwelling with - photo 27
Substantial vacant Richmond District two-family dwelling with - photo 28
Substantial vacant Richmond District two-family dwelling with - photo 29
Substantial vacant Richmond District two-family dwelling with - photo 30
Substantial vacant Richmond District two-family dwelling with - photo 31
Substantial vacant Richmond District two-family dwelling with - photo 32
Substantial vacant Richmond District two-family dwelling with - photo 33
Substantial vacant Richmond District two-family dwelling with - photo 34
Substantial vacant Richmond District two-family dwelling with - photo 35
Substantial vacant Richmond District two-family dwelling with - photo 36
Substantial vacant Richmond District two-family dwelling with - photo 37
Substantial vacant Richmond District two-family dwelling with - photo 38
Substantial vacant Richmond District two-family dwelling with - photo 39
Substantial vacant Richmond District two-family dwelling with - photo 40
Substantial vacant Richmond District two-family dwelling with - photo 41
Substantial vacant Richmond District two-family dwelling with - photo 42
Substantial vacant Richmond District two-family dwelling with - photo 43
Substantial vacant Richmond District two-family dwelling with - photo 44
Substantial vacant Richmond District two-family dwelling with - photo 45
Substantial vacant Richmond District two-family dwelling with - photo 46
Substantial vacant Richmond District two-family dwelling with - photo 47
Substantial vacant Richmond District two-family dwelling with - photo 48
Substantial vacant Richmond District two-family dwelling with - photo 49
Substantial vacant Richmond District two-family dwelling with - photo 50

$2,500,000

8 Beds | 6.0 Baths | 4,624 Sqft

471 31st Ave, San Francisco, CA, 94121

Substantial vacant Richmond District two-family dwelling with

Added: 07/08/2026 • Updated: 07/08/2026
For Sale
Outstanding 3-unit view building. Top unit penthouse features - photo 1
Outstanding 3-unit view building. Top unit penthouse features - photo 2
Outstanding 3-unit view building. Top unit penthouse features - photo 3
Outstanding 3-unit view building. Top unit penthouse features - photo 4
Outstanding 3-unit view building. Top unit penthouse features - photo 5
Outstanding 3-unit view building. Top unit penthouse features - photo 6
Outstanding 3-unit view building. Top unit penthouse features - photo 7
Outstanding 3-unit view building. Top unit penthouse features - photo 8
Outstanding 3-unit view building. Top unit penthouse features - photo 9
Outstanding 3-unit view building. Top unit penthouse features - photo 10
Outstanding 3-unit view building. Top unit penthouse features - photo 11
Outstanding 3-unit view building. Top unit penthouse features - photo 12
Outstanding 3-unit view building. Top unit penthouse features - photo 13
Outstanding 3-unit view building. Top unit penthouse features - photo 14
Outstanding 3-unit view building. Top unit penthouse features - photo 15
Outstanding 3-unit view building. Top unit penthouse features - photo 16
Outstanding 3-unit view building. Top unit penthouse features - photo 17
Outstanding 3-unit view building. Top unit penthouse features - photo 18
Outstanding 3-unit view building. Top unit penthouse features - photo 19
Outstanding 3-unit view building. Top unit penthouse features - photo 20
Outstanding 3-unit view building. Top unit penthouse features - photo 21
Outstanding 3-unit view building. Top unit penthouse features - photo 22
Outstanding 3-unit view building. Top unit penthouse features - photo 23
Outstanding 3-unit view building. Top unit penthouse features - photo 24
Outstanding 3-unit view building. Top unit penthouse features - photo 25
Outstanding 3-unit view building. Top unit penthouse features - photo 26
Outstanding 3-unit view building. Top unit penthouse features - photo 27
Outstanding 3-unit view building. Top unit penthouse features - photo 28
Outstanding 3-unit view building. Top unit penthouse features - photo 29
Outstanding 3-unit view building. Top unit penthouse features - photo 30
Outstanding 3-unit view building. Top unit penthouse features - photo 31
Outstanding 3-unit view building. Top unit penthouse features - photo 32
Outstanding 3-unit view building. Top unit penthouse features - photo 33
Outstanding 3-unit view building. Top unit penthouse features - photo 34
Outstanding 3-unit view building. Top unit penthouse features - photo 35
Outstanding 3-unit view building. Top unit penthouse features - photo 36
Outstanding 3-unit view building. Top unit penthouse features - photo 37
Outstanding 3-unit view building. Top unit penthouse features - photo 38

$2,400,000

7 Beds | 5.0 Baths | 3,540 Sqft

915 Burnett Ave, San Francisco, CA, 94131

Outstanding 3-unit view building. Top unit penthouse features

Added: 07/07/2026 • Updated: 07/07/2026
View More in San Francisco View More in San Francisco
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.15
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

San Francisco

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

San Francisco Real Estate Agent Info

About San Francisco

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.15
Terms & Policy