meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212229' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2022-01-10 13:43:03
[post_modified_gmt] => 2022-01-10 21:43:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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 a0E1I000001JZXhUAO
pba__address_pb__c 859 South Van Ness 861 Avenue, San Francisco, CA, 94110
pba__city_pb__c San Francisco
days_on_market__c 1716
mls_id__c 464209
pba__totalarea_pb__c 3390
pba__latitude_pb__c 37.759453
pba__longitude_pb__c -122.416580
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c South Van Ness
listed_date__c 2017-10-20
sale_date__c 2018-02-26
pba__propertytype__c 3 Unit
pba__listingprice_pb__c 1898000
pba__listingtype__c Sale
sale_price__c 1960000
pba__lotsize_pb__c 0.06
address2__c 859 South Van Ness 861 Avenue, San Francisco, CA, 94110
pba__listing_agent_firstname__c David
pba__listing_agent_lastname__c Anderson
parkingspaces__c 5
pba__postalcode_pb__c 94110
year_build_text__c 1900
size__c 3390
subdist__c The Mission
listing_agent_mls_id__c 981832
selling_agent_mls_id__c 804550
listing_co_office_number__c 0
listing_office_number__c 1668
listing_office_name__c I Star Properties, Inc.
listing_office_mls_id__c PCMT
of_units__c 3
vacant__c 3
district__c SF District 9
selling_agent_number__c 166014145
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1716
dom__c 58
parking__c Attached,Garage
listing_co_agent_number__c 0
price_per_square_foot__c 578.17
selling_office_name__c Compass SF
original_price__c 2099000
agent_only_remarks__c Vacant, show anytime, Supra lock box, email offers to [email protected], email disclosure requests to [email protected], escrow is open with Georgine Lonero at North American and seller kindly requests it's kept there, Seller reserves the right to accept, counter and reject any and all offers. Buyer to verify bedroom count, room count and square footage.
pba__yearbuilt_pb__c 1900
style__c Traditional
type__c 3 Story
gross_annual_income__c 0
est_total_expenses__c 0
external_listing__c 1
pba__latitude_property__c 37.759453
listing_agent_number__c 1031830
on_market_date__c 2017-10-20
selling_agent_name__c Bob Wheeler
website_property_type__c 3 Unit
media Array
ListingUpdateDate 2022-07-03T03:31:35