---
listing_id: SF426156348
status: Active
price: 2699000
beds: 4
baths_full: 1
baths_half: 1
sqft_living: 2950
sqft_lot: 2448
lot_acres: 
year_built: 1915
property_type: Residential
property_subtype: Single Family Residence
address: "187 Upper Terrace Ter"
city: San Francisco
state: CA
zip: 94117
county: "San Francisco County"
lat: 37.7642303
lng: -122.4441267
days_on_market: 2
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Andrew de Vries"
list_office: "Berkshire Hathaway-Franciscan"
list_agent_phone: "(415) 585-5200"
list_agent_license: 01368031
mls_source: RESFAR
modified: 2026-08-21
transaction_type: buy
---

Home | San Francisco County | San Francisco | 94117 | 187 Upper Terrace Ter

187 Upper Terrace Ter, San Francisco, CA 94117

MLS: SF426156348 | Status: Active | Price: $2,699,000
Beds/Baths: 4 / 1 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4 1 /1 2,950 2,448 1915

Upcoming Open Houses

Date Time Hosted By
Sunday, August 23 2:00 pm - 4:00 pm

Remarks

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 w

MLS Listing Information

Field Value
MLS # SF426156348
MLS Source San Francisco Association of Realtors® MLS
Days on Site 2

Features

Interior Features

Feature Details
Bathrooms Other, Stall Shower, Tub
Kitchen Breakfast Nook, Other, Pantry
Appliances Hood Over Range, Other, Oven Range - Gas, Dryer, Washer
Dining Room Formal Dining Room, Other
Family Room Other
Flooring Tile, Wood
Laundry In Basement
Heating Central Forced Air

Exterior Features

Feature Details
Roof Composition, Shingle
Foundation Concrete Perimeter
Style Edwardian

Parking, School, and Other Information

Feature Details
Garage/Parking Detached, Other, Parking - Independent, Garage: 2 Car(s)
Sewer Public Sewer
Water Public

Contact Information

Andrew de Vries
Berkshire Hathaway-Franciscan
License #: 01368031
Phone: (415) 585-5200

Property Units

# Buildings # Leased Units # Total Units
0

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Grattan Elementary School public K-5 0.35 mi 9
Chinese Immersion School At Deavila public K-5 0.39 mi 10
McKinley Elementary School public K-5 0.50 mi 9
Milk (Harvey) Civil Rights Elementary School public K-5 0.55 mi 6
Rooftop Elementary School public K-8 0.66 mi 8
Sanchez Elementary School public K-5 0.74 mi 2
New Traditions Elementary School public K-5 0.75 mi 8
Alvarado Elementary School public K-5 0.82 mi 8
Everett Middle School public 6-8 0.82 mi 1
Wells (Ida B.) High School public 9-12 0.93 mi 2
Mission High School public 9-12 0.94 mi 3
Clarendon Alternative Elementary School public K-5 0.97 mi 9
Muir (John) Elementary School public K-5 1.07 mi 6
Independence High School public 9-12 1.08 mi 5
Mahler (Theresa S.) Children Center public KG 1.08 mi N/A
Wallenberg (Raoul) Traditional High School public 9-12 1.12 mi 7
Lick (James) Middle School public 6-8 1.20 mi 2
Academy (The)- SF @Mcateer public 9-12 1.34 mi 7
Asawa (Ruth) San Francisco School Of The Arts, A Public School. public 9-12 1.34 mi 10
Frank McCoppin Elementary School public K-5 1.38 mi 8

Nearby Homes

Address Price Beds Baths Sq Ft Status
1620 Pacheco St $2,295,000 5 4 2,609 Active
2366 20th Ave $2,295,000 4 4 3,000 PendingDoNotShow
44 Rockaway Ave $2,395,000 3 2 2,273 PendingDoNotShow
66 Joost Ave $2,595,000 4 1/1 2,350 Active
1046 Anza St $2,795,000 4 3/1 2,490 Active

Disclosures

©2026 San Francisco Association of Realtors® MLS. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from San Francisco Association of Realtors® MLS.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of August 21, 2026. For the most current information, please contact Andrew de Vries, (415) 585-5200.