Array
(
[ID] => 16083
[post_author] => 4
[post_date] => 2018-11-06 17:57:53
[post_date_gmt] => 2018-11-06 17:57:53
[post_content] => Clarendon Heights is what it would look like if you re-built Pacific Heights at the top of Twin Peaks in the 1960s. Large, sloping lots that assume you have at least two cars. Bridge to bridge views. The land of former mayors and current moguls.
[post_title] => Clarendon Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => clarendon-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:53:08
[post_modified_gmt] => 2024-04-09 17:53:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=16083
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 29 Villa Terrace, San Francisco, CA, 94114
ffd_mls_id, 422670878
ffd_salesforce_id, a0E8W00000Xj46fUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 29 Villa Terrace, San Francisco, CA, 94114
pba__address_pb__c, 29 Villa Terrace, San Francisco, CA, 94114
agent_only_remarks__c, This place is so cool, great for buyers wanting BIG VIEWS!!! Very easy to show by appointment. Property website: www.29villaterrace.com. (Note, while the home's physical location & mailing address is 29 Villa Terrace, it's referred to as 1363 Clayton St in the SF tax records.)
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator;Gas Cook Top;Built-In Freezer
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 2001
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Room Air,Wall Unit(s)
ffd_createddate, 2022-06-19T01:46:17.000+0000
days_on_market__c, 397
dom__c, 21
ffd_description_pb, Don't miss this spectacular, updated contemporary home w/sweeping views toward Downtown/Salesforce Tower, East Bay & Mt Diablo. A grand yet comfortable 2-story living/dining area features dramatic floor-to-ceiling windows, as well as a professional grade chef's kitchen & walkout terrace. Spread out comfortably among four large bedrooms, including two primary suites with walk-in closets. One of the bedrooms doubles as a cosy library/media room with built-in bookcases & surround sound speakers, while a big, separate family room comes with two built-in work stations, plus one of SF's coolest wine cellars holding 900 bottles! Additional amenities include hardwood floors throughout, extensive storage, skylights, solar panels, electric car charging & air conditioning in two bedrooms. Two-car garage with interior access. Centrally-located just uphill from both the Cole Valley & Castro shopping & dining districts. UCSF Hospital, nature trails & freeways south are easily accessed nearby.
29 Villa Terrace, San Francisco, CA, 94114 - Property Description
Don't miss this spectacular, updated contemporary home w/sweeping views toward Downtown/Salesforce Tower, East Bay & Mt Diablo. A grand yet comfortable 2-story living/dining area features dramatic floor-to-ceiling windows, as well as a professional grade chef's kitchen & walkout terrace. Spread out comfortably among four large bedrooms, including two primary suites with walk-in closets. One of the bedrooms doubles as a cosy library/media room with built-in bookcases & surround sound speakers, while a big, separate family room comes with two built-in work stations, plus one of SF's coolest wine cellars holding 900 bottles! Additional amenities include hardwood floors throughout, extensive storage, skylights, solar panels, electric car charging & air conditioning in two bedrooms. Two-car garage with interior access. Centrally-located just uphill from both the Cole Valley & Castro shopping & dining districts. UCSF Hospital, nature trails & freeways south are easily accessed nearby.
