meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='311918' 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 a0E8W00000WiAqKUAV
pba__address_pb__c 33 Mountain Spring Avenue, San Francisco, CA, 94114
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 5
pba__bedrooms_pb__c 5
days_on_market__c 92
mls_id__c 422652406
pba__totalarea_pb__c 5928
pba__latitude_pb__c 37.757969
pba__longitude_pb__c -122.449384
pba__state_pb__c CA
pba__status__c Active
pba__street_pb__c Mountain Spring
listed_date__c 2022-04-02
sale_date__c 1800-01-01
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 4500000
pba__listingtype__c Sale
sale_price__c 0
address2__c 33 Mountain Spring Avenue, San Francisco, CA, 94114
pba__listing_agent_firstname__c Steven
pba__listing_agent_lastname__c Gallagher
view__c City;Bay;Downtown;San Francisco
pba__halfbathrooms_pb__c 1
parkingspaces__c 2
pba__postalcode_pb__c 94114
year_build_text__c 1932
size__c 5928
subdist__c Clarendon Heights
listing_agent_mls_id__c 398474
listing_co_office_number__c 0
listing_office_number__c 2128
listing_office_name__c Coldwell Banker Realty
listing_office_mls_id__c CBLUXURY
of_units__c 0
district__c SF District 5
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c -81202
dom__c 91
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 759.11
parking_type__c On Site (Single Family Only)
original_price__c 9500000
agent_only_remarks__c Harcourts Luxury New Live Auction Date - Bidding to start from $4,500,000 - Auction Date: 12:00pm August 4, 2022. Seller has nominated a reserve that must be met in order for the sale to take place. All buyers and financing options welcome. Contingencies and variations to terms considered. No buyer premium or additional fees. All disclosures and reports available. Submit pre-emptive offer to stop auction. Contact for further information. Here is the link for information about the auction and for disclosures: https://liveauction.link/33Mountain. Contact Jonathan Bass at (949) 632-6350 with questions about the auction. The home is owner occupied and it is easy to show but strictly shown by appointment outside of any scheduled open houses. Escrow has been opened with Heather Shiffer at First American Title.
pba__yearbuilt_pb__c 1932
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.757969
listing_agent_number__c 398474
on_market_date__c 2022-04-29
open_house_start__c 2022-07-31T14:00:00.000+0000
open_house_end__c 2022-07-31T16:00:00.000+0000
architectural_style__c Spanish;Mediterranean
has_3d_tour__c 1
pba__listing_website__c https://my.matterport.com/show/?m=T1vPHmxAJop
website_property_type__c Single Family Home
media Array
ListingUpdateDate 2022-07-30T20:11:02