meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='295902' 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] => 2021-12-01 19:38:36
[post_modified_gmt] => 2021-12-02 03:38:36
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E8W00000V0LYEUA3
pba__address_pb__c 1 Twin Peaks Boulevard, San Francisco, CA, 94114
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 4
pba__bedrooms_pb__c 3
days_on_market__c 285
mls_id__c 421593748
pba__totalarea_pb__c 3132
pba__latitude_pb__c 37.7604718
pba__longitude_pb__c -122.4466367
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Twin Peaks
listed_date__c 2021-09-20
sale_date__c 2021-11-18
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 1800000
pba__listingtype__c Sale
sale_price__c 1800000
address2__c 1 Twin Peaks Boulevard, San Francisco, CA, 94114
pba__listing_agent_firstname__c Dena
pba__listing_agent_lastname__c Aslanian-Williams
pba__halfbathrooms_pb__c 0
parkingspaces__c 2
pba__postalcode_pb__c 94114
year_build_text__c 1951
size__c 3132
subdist__c Clarendon Heights
listing_agent_mls_id__c 803162
selling_agent_mls_id__c 809716
listing_co_office_mls_id__c COMP12PUI
listing_co_office_name__c Compass
listing_co_office_number__c 27690
listing_co_agent_mls_id__c 347395
listing_office_number__c 27690
listing_office_name__c Compass
listing_office_mls_id__c COMP12PUI
of_units__c 0
district__c SF District 5
selling_agent_number__c 1042949
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 132
dom__c 33
monthly_parking_fees__c 0
listing_co_agent_number__c 347395
price_per_square_foot__c 574.71
selling_office_name__c Compass
parking_type__c On Site (Single Family Only)
original_price__c 1895000
agent_only_remarks__c Offers as they come. The sellers are three siblings and trustees , please give 48 hours for a response. Pre escrow open with MaryAnn Bunnell at North American Title. Very easy to show, call, text or email Dena Williams at 415 407 4381. Excellent opportunity for your contractor clients. The property used to be two parcels but sometime in the past they were joined and now has one lot block number. Buyer to investigate splitting the lot in to two. Sellers invested in plans to remodel home which will be in disclosures.
pba__yearbuilt_pb__c 1951
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.7604718
listing_agent_number__c 803162
listing_co_agent_name__c Betty A Taisch
on_market_date__c 2021-09-20
pba__listing_website__c https://vimeo.com/623730876
website_property_type__c Single Family Home
media Array
ListingUpdateDate 2022-07-03T02:05:17