meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213790' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 455 Upper Terrace #5, San Francisco, CA, 94117
ffd_mls_id, 503024
ffd_salesforce_id, a0E1I00000S123MUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 5
address2__c, 455 Upper Terrace #5, San Francisco, CA, 94117
pba__address_pb__c, 455 Upper Terrace #5, San Francisco, CA, 94117
agent_only_remarks__c, For showings contact Walter Johnson, 415-298-5332, [email protected] Escrow open with Michelle Patterson, First American Title Co.
appliances__c, Dishwasher;Microwave;Disposal;Refrigerator;Hood Over Range;Cooktop Stove;Built-In Oven
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1970
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-25
ffd_createddate, 2020-08-12T16:50:07.000+0000
days_on_market__c, 1604
dom__c, 60
ffd_description_pb, Set at the top of Upper Terrace, this spectacular contemporary home boasts the city's best views, spanning three bridges and multiple counties, a panorama of the SF Bay, city landmarks and our exciting architectural skyline! Complete with 2 bedrooms, each with terrace, two full baths and a new stainless kitchen. The expansive terrace encourages indoor/outdoor living. Floor to ceiling glass doors open to stunning outlooks in each room. The open living and dining space features built-in theater surround sound and a hidden entertainment center. Located at the intersection of Ashbury Heights, Cole Valley & Corona Heights, you are in the epicenter of the city. Steps away from parks, public transportation & the city's best shopping & dining.
455 Upper Terrace #5, San Francisco, CA, 94117 - Property Description
Set at the top of Upper Terrace, this spectacular contemporary home boasts the city's best views, spanning three bridges and multiple counties, a panorama of the SF Bay, city landmarks and our exciting architectural skyline! Complete with 2 bedrooms, each with terrace, two full baths and a new stainless kitchen. The expansive terrace encourages indoor/outdoor living. Floor to ceiling glass doors open to stunning outlooks in each room. The open living and dining space features built-in theater surround sound and a hidden entertainment center. Located at the intersection of Ashbury Heights, Cole Valley & Corona Heights, you are in the epicenter of the city. Steps away from parks, public transportation & the city's best shopping & dining.
