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.

At a glance

187 Upper Terrace Terrace, San Francisco, CA, 94117

$2,699,000·2 bd·1 ba·SFAR MLS #426156348

Estimated Arrivva buyer rebate$44,000 to $72,000

Every completed rebate is published: see all 249 closings.

Listing data from SFAR MLS. Listing courtesy of Andrew de Vries of Berkshire Hathaway-Franciscan | Agent Phone: (415) 585-5200. Rebate estimate calculated by Arrivva.

Save
Ask
Tour
Hide
Share
$2,699,000
21 Days On Site

187 Upper Terrace Terrace
San Francisco, CA 94117

Single Family Residence|Pending
4
Beds
2
Total Baths
1
Full Bath
1
Partial Bath
2,950
SqFt
$915
/SqFt
1915
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
187 Upper Terrace Terrace187 Upper Terrace Terrace187 Upper Terrace Terrace187 Upper Terrace Terrace
Save
Ask
Tour
Hide
Share

Rarely available near the top of Upper Terrace in Ashbury Heights, this substantial 1915 Edwardian residence with Craftsman influences comes to market for the first time in many years. Approx. 2,950 sq. ft. per public tax records, though the home is likely larger, the residence offers 4BD/1.5BA plus a versatile top-floor bonus room, gracious formal spaces, multiple outdoor areas and a detached 2-car garage. Exceptional original details include hardwood floors, rich wood paneling and millwork, box-beam ceilings, built-in cabinetry, original doors and hardware, and 2 distinctive fireplaces. A period entry vestibule introduces the home's remarkable craftsmanship. The generously proportioned living room features an arched brick fireplace, broad bay window and built-ins, while the dramatic formal dining room showcases a box-beam ceiling, extensive paneling, original cabinetry and tiled fireplace. The character-filled kitchen features a substantial stainless-steel range and hood, antique cast-iron stove, adjoining breakfast/pantry area and nearby half bath, with direct access to the rear garden and a substantial deck above the garage offering downtown SF and Bay views. A spacious lower-level family/recreation room provides flexible additional living space for media, play, exercise or work-from-home uses. The principal bedroom level offers 3BDs, including a spacious primary, a bedroom with private balcony and city views, and another with Twin Peaks/Sutro Tower outlooks and a charming sink/dressing alcove. A traditional split full bath serves this level. Upstairs, the 4th bedroom enjoys broad windows and elevated Twin Peaks/Sutro Tower outlooks, while an additional bonus room offers excellent flexibility for guests, home office, study or creative space. A long side driveway leads to the detached 2-car garage. A large unfinished basement provides laundry, storage, workshop and utility space. Varied outlooks extend toward downtown and the Bay, Twin Peaks and Sutro Tower, and west toward the ocean. Convenient to Cole Valley, Buena Vista and Corona Heights parks, Haight-Ashbury, UCSF, Golden Gate Park and transit. Retaining much of its vintage character and finishes, this distinctive hilltop residence offers an exceptional opportunity to thoughtfully update and personalize a substantial period home while preserving the architectural details that make it so special.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,699,000
Days On Site 
21 Days
Bedrooms 
4
Inside Area (SqFt) 
2,950 sqft
Total Baths 
2
Full Baths 
1
Partial Baths 
1
Lot Size 
0.0562 Acres
Year Built 
1915
MLS® Number 
426156348
Status 
Pending
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
2 days agoListing updated with changes from the MLS®
3 days agoStatus changed to Pending
3 weeks agoListing first seen on site
General Features
Acres 
0.0562
Cross Street 
Clifford Terrace
Direction Faces 
West
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
2
Parking 
DrivewayDetached
Parking Spaces 
4
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
SqFt Total 
2950
Style 
Edwardian
Water Source 
Public
Interior Features
Appliances 
Free-Standing Gas RangeRange HoodDryerWasher
Basement 
Partial
Flooring 
TileWood
Heating 
Central
Interior 
PantryBeamed Ceilings
Laundry Features 
In Basement
Bathroom 1 
Description - Shower Stall(s),Tub
Dining Room 
Level - MainDescription - Formal Room
Family Room 
Level - Lower
Kitchen 
Level - MainDescription - Breakfast Area,Butlers Pantry
Living Room 
Level - MainDescription - Beamed Ceilings,View
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Wood Siding
Roof 
CompositionShingle
View 
BayCityDowntownOcean
Waterview 
BayCityDowntownOcean
Community Features
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-09-10 08:17 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.

Questions about this listing

How much could a buyer get back on 187 Upper Terrace Terrace, San Francisco, CA, 94117?
Arrivva estimates a buyer rebate of $44,000 to $72,000 on this listing. The buyer-broker fee, typically 2 to 3% of the price, goes back to you minus Arrivva's flat $9,750 fee. Every completed rebate is published on the Arrivva results page. See every completed closing
Who is the listing brokerage for 187 Upper Terrace Terrace, San Francisco, CA, 94117?
Listing courtesy of Andrew de Vries of Berkshire Hathaway-Franciscan | Agent Phone: (415) 585-5200, per SFAR MLS listing #426156348. Arrivva is not the listing brokerage: Arrivva is a separate flat-fee brokerage that represents you as the buyer, with your interests first and no dual agency, ever. How Arrivva represents buyers
How do I schedule a tour of 187 Upper Terrace Terrace, San Francisco, CA, 94117?
Set up a quick chat with Arrivva by phone or video. The team confirms showing availability fast, tours the home with you, and walks you through offer strategy and the rebate math before you commit to anything. Set up a time to talk

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.