meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237008' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 389 Upper Terrace, San Francisco, CA, 94117
ffd_mls_id, 422671392
ffd_salesforce_id, a0E8W00000XjQfvUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 389 Upper Terrace, San Francisco, CA, 94117
pba__address_pb__c, 389 Upper Terrace, San Francisco, CA, 94117
agent_only_remarks__c, Disclosures: https://app.disclosures.io/link/389-Upper-Terrace-dklq82s0 Seller will review offers as they come.
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-23T10:48:38.000+0000
days_on_market__c, 391
dom__c, 12
ffd_description_pb, Perched atop Ashbury Heights this architectural home looks over San Francisco's Golden Gate park towards and onto the Pacific Ocean and Marin headlands, a unique view that is only captured by a handful of homes. Soaring ceilings with dramatic, floor to ceiling Bonelli windows and Fleetwood doors bring the views into every level of this open floor plan. Impeccably finished with marble counters, Heath tile, custom cabinetry, and Italian-designed lighting this home has been meticulously crafted for sleek modern living. The primary suite features a cleverly hidden wet bar behind suede paneled custom cabinets and automated closet lighting. A professionally designed landscape incorporates elements of corten steel, a bocce court and multiple planting beds. Technologically forward, the home is controlled by smart systems and made comfortable by a central A/C system. A private 1 bedroom guest quarters with a private entrance and panoramic views elevate the flexibility of the home.
389 Upper Terrace, San Francisco, CA, 94117 - Property Description
Perched atop Ashbury Heights this architectural home looks over San Francisco's Golden Gate park towards and onto the Pacific Ocean and Marin headlands, a unique view that is only captured by a handful of homes. Soaring ceilings with dramatic, floor to ceiling Bonelli windows and Fleetwood doors bring the views into every level of this open floor plan. Impeccably finished with marble counters, Heath tile, custom cabinetry, and Italian-designed lighting this home has been meticulously crafted for sleek modern living. The primary suite features a cleverly hidden wet bar behind suede paneled custom cabinets and automated closet lighting. A professionally designed landscape incorporates elements of corten steel, a bocce court and multiple planting beds. Technologically forward, the home is controlled by smart systems and made comfortable by a central A/C system. A private 1 bedroom guest quarters with a private entrance and panoramic views elevate the flexibility of the home.
