meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215233' posts_per_page=4 post_type=property
bool(false)
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] => 2023-10-31 09:53:54
[post_modified_gmt] => 2023-10-31 16:53:54
[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, 20 Palo Alto Avenue, San Francisco, CA, 94114
ffd_mls_id, 507244
ffd_salesforce_id, a0E1I00000TvIsXUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 20 Palo Alto Avenue, San Francisco, CA, 94114
pba__address_pb__c, 20 Palo Alto Avenue, San Francisco, CA, 94114
agent_only_remarks__c, Website: 20PaloAlto.com Built in 1991. Contemporary 4 level home with attached 2 car garage + additional parking in driveway. ADU on lower level is in the process of being legalized. Plans & drawings have been submitted to the city. Property last sold in March 2010 for $2,840,000 (tax records incorrectly show sales price of $2,240,000). Main Level: living room/dining/kitchen/breakfast nook/powder room/garage/entry patio. Upper Level: 3 bedrooms including main BD suite, 2 full baths, laundry room. Roof level: access to view roof deck. Lower Level (ADU): 2 bedroom suites, home theater, 3 full baths, kitchen, family room/dining, laundry room/ storage. Artist studio and/or storage room (approx. 500 sf) located on the garden level.
appliances__c, Dishwasher;Disposal
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 5
year_build_text__c, 1991
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-02-12
ffd_createddate, 2021-01-02T03:45:58.000+0000
days_on_market__c, 929
dom__c, 61
ffd_description_pb, Located along the ultra-private and quiet cul-de-sac section of Palo Alto Avenue in Clarendon Heights, this contemporary home offers spectacular 270 degree views from every single room. Oversized street-to-street lot (two addresses: 20 Palo Alto Ave / 314 Twin Peaks Blvd). 5 bedrooms, 5.5 baths on 4 levels which includes ADU with home theater on the lower floor. This is an updated and detached home with floor-to-ceiling windows on all sides with a corner lot feel. Expansive views everywhere you look. Multiple decks including a panoramic view roof deck, newly constructed IPE deck with built-in seating in the garden below. Amazing privacy in this enclave of multi-million dollar homes. The new billionaires' row! Expansion potential. 20 Palo Alto Ave presents a rare opportunity to enjoy city living with easy access to open green spaces, Twin Peaks, and arguably the best views in all of SF!
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-01-25T15:36:23.000+0000
pba__latitude_pb__c, 37.7568987
pba__latitude_property__c, 37.7568987
laundry_features__c, Inside Room
listed_date__c, 2020-10-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Christiane
pba__listing_agent_lastname__c, Gigas
listing_agent_mls_id__c, 804817
ffd_listingagentname, Christiane Gigas
listing_agent_number__c, 166014506
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 5495000
pba__listingtype__c, Sale
pba__listing_website__c, https://20paloalto.com/
pba__longitude_pb__c, -122.4490395
pba__lotsize_pb__c, 0.1
lower_level__c, Bedroom(s),Family Room,Kitchen,Living Room
mls_id__c, 507244
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2021-01-01
original_price__c, 5495000
overall_days_on_market__c, 364
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio
pba__pendingdate__c, 2021-03-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1178.93
pba__propertytype__c, Single Family Residence
id, a0E1I00000TvIsXUAV
room_type__c, Storage;Office;Laundry;Den;Studio
sale_date__c, 2021-03-22
sale_price__c, 5350000
selling_agent_mls_id__c, 812840
selling_agent_number__c, 1058406
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 4538
size__c, 4538
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Palo Alto
subdist__c, Clarendon Heights
ffd_name, 20 Palo Alto Avenue, San Francisco, CA, 94114
view__c, Ocean;Panoramic;City Lights;Bay;Water;Downtown;Bay Bridge;San Francisco;Golden Gate Bridge;Twin Peaks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1991
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371474-1.jpg
ListingId, a0E1I00000TvIsXUAV