meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217587' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 224 Upper Terrace, San Francisco, CA, 94117
ffd_mls_id, 421526609
ffd_salesforce_id, a0E1I00000TwgNWUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 224 Upper Terrace, San Francisco, CA, 94117
pba__address_pb__c, 224 Upper Terrace, San Francisco, CA, 94117
agent_only_remarks__c, More at www.224UpperTer.com. For showings, please call or text Ron Abta: 415-595-7661. Escrow opened with Steve Salviejo, (415) 346-0122, from North American Title. Showings by appointment only. *In-person showings permitted after the PEAD is signed and returned. PLEASE NOTE: The seller has NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and must enter at their own risk. Buyers should investigate to their satisfaction.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Wine Refrigerator
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-03-16T01:01:53.000+0000
days_on_market__c, 859
dom__c, 33
ffd_description_pb, This 4 bedroom / 3.5 bath view home will impress you with its contemporary aesthetic, great floor plan, and incredible craftsman woodwork. Enjoy the breathtaking views from Downtown to Bernal Heights while being located on one of San Francisco's rare cul-de-sacs. The gourmet kitchen with island and Viking stove conveniently opens to the breakfast & family areas, while also enjoying direct access to the landscaped patio and backyard making for great indoor / outdoor living. An inviting entry, spacious formal dining room, and 1/2 bath completes the main living level. 3 large bedrooms, media area, deck, and laundry room are upstairs, while the primary suite on the top floor features a walk-in closet, bath with double sink vanity and separate shower & tub. Just steps to Buena Vista & Corona Heights Parks, playgrounds, and the Randall Museum. Culinary marvels such as Zazie are all nearby. A storage room with ample space for a gym, garage parking and solar panels complete this amazing home.
224 Upper Terrace, San Francisco, CA, 94117 - Property Description
This 4 bedroom / 3.5 bath view home will impress you with its contemporary aesthetic, great floor plan, and incredible craftsman woodwork. Enjoy the breathtaking views from Downtown to Bernal Heights while being located on one of San Francisco's rare cul-de-sacs. The gourmet kitchen with island and Viking stove conveniently opens to the breakfast & family areas, while also enjoying direct access to the landscaped patio and backyard making for great indoor / outdoor living. An inviting entry, spacious formal dining room, and 1/2 bath completes the main living level. 3 large bedrooms, media area, deck, and laundry room are upstairs, while the primary suite on the top floor features a walk-in closet, bath with double sink vanity and separate shower & tub. Just steps to Buena Vista & Corona Heights Parks, playgrounds, and the Randall Museum. Culinary marvels such as Zazie are all nearby. A storage room with ample space for a gym, garage parking and solar panels complete this amazing home.
