Celebrating 10 years: fixed fees, full service, fast responses

Property search · The Consumer Protection Brokerage

Every listing shows your estimated rebate.

The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.

Save
Ask
Tour
Hide
Share
$2,695,000
24 Days On Site

482 Frederick Street
San Francisco, CA 94117

Duplex|Pending
8
Beds
4
Total Baths
4
Full Baths
2,371
SqFt
$1,137
/SqFt
1900
Built
County:
San Francisco
Listing courtesy of Andrew de Vries of Berkshire Hathaway-Franciscan | Agent Phone: (415) 585-5200
Call Now: (408) 868-2620
Is this the listing for you? We can help make it yours.
(408) 868-2620
482 Frederick Street482 Frederick Street482 Frederick Street482 Frederick Street
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,695,000
Days On Site 
24 Days
Bedrooms 
8
Inside Area (SqFt) 
2,371 sqft
Total Baths 
4
Full Baths 
4
Partial Baths 
N/A
Lot Size 
0.0789 Acres
Year Built 
1900
MLS® Number 
426143793
Status 
Pending
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
a week agoListing updated with changes from the MLS®
2 weeks agoStatus changed to Pending
3 weeks agoListing first seen on site
General Features
Acres 
0.0789
Cross Street 
Shrader
Foundation 
Concrete Perimeter
Number Of Stories 
4
Property Sub Type 
Duplex
Security 
Security Gate
Sewer 
Public Sewer
SqFt Total 
2371
Style 
Victorian
Utilities 
Electricity Available
Water Source 
Public
Interior Features
Appliances 
Free-Standing Gas RangeFree-Standing Refrigerator
Basement 
Apartment
Flooring 
CarpetTileVinylWood
Furnished? 
None
Heating 
Central
Laundry Features 
In Unit
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Wood Siding
Exterior 
Garden
Lot Features 
GardenSecluded
Roof 
Composition
View 
City
Waterview 
City
Community Features
Financing Terms Available 
CashConventional
MLS Area 
SF District 5
School District 
SF School District
Schools
School District
SF School District
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Andrew de Vries of Berkshire Hathaway-Franciscan | Agent Phone: (415) 585-5200



Listing information is provided by Participants of the San Francisco Association of Realtors MLS. 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. Copyright 2026, San Francisco Association of Realtors MLS.
Last checked: 2026-07-27 03:45 AM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.

Found a home you love?

Schedule a free consultation to lock in your rebate before you offer.

Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.