meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210363' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 272 Upper Terrace, San Francisco, CA, 94117
ffd_mls_id, 495896
ffd_salesforce_id, a0E1I00000SOx5YUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 272 Upper Terrace, San Francisco, CA, 94117
pba__address_pb__c, 272 Upper Terrace, San Francisco, CA, 94117
agent_only_remarks__c, Please have your clients visit property virtually www.UpperTerraceSF.com. Any live showing options can be discussed on phone, if appropriate. An ideal home affordable for condo buyers. Rare 2 car s/s garage. Hot tub is excluded from sale. Disclosure package available. Please email Claudia Hurtado at [email protected]
bath_features__c, Tub w/Shower Over;Remodeled;Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2020-04-03T20:46:06.000+0000
days_on_market__c, 1761
dom__c, 22
ffd_description_pb, www.UpperTerraceSF.com An Urban Dwellers dream in Ashbury Hts, a quiet, tree-lined street surrounded by some of the city's most treasured natural sites. Close proximity to Cole Valley, Castro, UCSF, conveniences + easy fwy access.This serene home is thoughtfully designed with an open floorplan featuring dramatic up-lit staircase, hdwd flrs, natural sun-light and wonderful outdoor spaces. The naturally bright living room w/wood burning fireplace opens to the dining area + kitchen w/ counter seating. Completing this level is a spacious master bedrm suite w/French doors opening to a private Zen deck.Upper level has two bedrms including a master suite w/dual vanities, double shower, bench seating + skylight makes this an ideal spa retreat. Access to the wonderful decks and lush gardens are from this level opening the home to large patio deck expanding your living area, surrounded by lush garden + a sun deck above. 2 car garage w/ laundry + storage.*Hot tub excluded.
272 Upper Terrace, San Francisco, CA, 94117 - Property Description
www.UpperTerraceSF.com An Urban Dwellers dream in Ashbury Hts, a quiet, tree-lined street surrounded by some of the city's most treasured natural sites. Close proximity to Cole Valley, Castro, UCSF, conveniences + easy fwy access.This serene home is thoughtfully designed with an open floorplan featuring dramatic up-lit staircase, hdwd flrs, natural sun-light and wonderful outdoor spaces. The naturally bright living room w/wood burning fireplace opens to the dining area + kitchen w/ counter seating. Completing this level is a spacious master bedrm suite w/French doors opening to a private Zen deck.Upper level has two bedrms including a master suite w/dual vanities, double shower, bench seating + skylight makes this an ideal spa retreat. Access to the wonderful decks and lush gardens are from this level opening the home to large patio deck expanding your living area, surrounded by lush garden + a sun deck above. 2 car garage w/ laundry + storage.*Hot tub excluded.
