meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211697' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 260 Upper Terrace, San Francisco, CA, 94117
ffd_mls_id, 490446
ffd_salesforce_id, a0E1I00000H1Jp8UAF
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 260 Upper Terrace, San Francisco, CA, 94117
pba__address_pb__c, 260 Upper Terrace, San Francisco, CA, 94117
agent_only_remarks__c, Contact Susan for showings (415) 793-3340 [email protected] Offer date to be Monday, October 14th by 10:00 a.m. Please use SFAR PA. Owner is a licensed CA real estate agent. This is a trust sale. Buyer to cooperate with seller 1031 Exchange. Please do not block neighbors driveway.
appliances__c, Dishwasher;Gas Range;Disposal;Hood Over Range;Double Oven
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1950
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2019-09-26T10:46:04.000+0000
days_on_market__c, 1392
dom__c, 18
ffd_description_pb, Set on an exclusive block of Buena Vista/Ashbury Heights, this sophisticated property offers unparalleled elegance and modernity. Ascend to the main level fit with an open floor plan informed by the smart living room with fireplace and dining room, bar area, kitchen with cozy seating for an informal meal, half bath, and large media room. Upstairs, the master bedroom with en suite bath and walk-in closet seamlessly opens to the outdoors with an inviting deck and garden greenery. A coveted layout, this level includes two additional bedrooms with partial views of the SF Bay and a second bathroom. An abundance of Mid-Century windows and skylights imbue the home with natural light. The garage has SBS parking for 2 cars, washer/dryer, and storage. Several parks - Mt. Olympus, Buena Vista, Tank Hill and Corona Hts. - are nearby, as are tree-lined streets, Cole Valley, Castro, and Haight-Ashbury. With easy access to muni, freeways and downtown San Francisco this is a very special property
260 Upper Terrace, San Francisco, CA, 94117 - Property Description
Set on an exclusive block of Buena Vista/Ashbury Heights, this sophisticated property offers unparalleled elegance and modernity. Ascend to the main level fit with an open floor plan informed by the smart living room with fireplace and dining room, bar area, kitchen with cozy seating for an informal meal, half bath, and large media room. Upstairs, the master bedroom with en suite bath and walk-in closet seamlessly opens to the outdoors with an inviting deck and garden greenery. A coveted layout, this level includes two additional bedrooms with partial views of the SF Bay and a second bathroom. An abundance of Mid-Century windows and skylights imbue the home with natural light. The garage has SBS parking for 2 cars, washer/dryer, and storage. Several parks - Mt. Olympus, Buena Vista, Tank Hill and Corona Hts. - are nearby, as are tree-lined streets, Cole Valley, Castro, and Haight-Ashbury. With easy access to muni, freeways and downtown San Francisco this is a very special property
