meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212160' 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 a0E1I000001Ja1vUAC
pba__address_pb__c 2926 Cesar Chavez, San Francisco, CA, 94110
pba__city_pb__c San Francisco
days_on_market__c 2052
mls_id__c 452331
pba__totalarea_pb__c 2664
pba__latitude_pb__c 37.748508
pba__longitude_pb__c -122.408325
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c Cesar Chavez
listed_date__c 2016-11-03
sale_date__c 2017-08-24
pba__propertytype__c 2 Unit
pba__listingprice_pb__c 1169000
pba__listingtype__c Sale
sale_price__c 1210000
pba__lotsize_pb__c 0.03
address2__c 2926 Cesar Chavez, San Francisco, CA, 94110
pba__listing_agent_firstname__c Alex
pba__listing_agent_lastname__c Castillo
parkingspaces__c 0
pba__postalcode_pb__c 94110
year_build_text__c 1915
size__c 2664
subdist__c The Mission
listing_agent_mls_id__c 808391
selling_agent_mls_id__c 171004
listing_co_office_mls_id__c RMWE
listing_co_office_name__c RE/MAX Westlake Investments
listing_co_office_number__c 1868
listing_co_agent_mls_id__c 802833
listing_office_number__c 1868
listing_office_name__c RE/MAX Westlake Investments
listing_office_mls_id__c RMWE
of_units__c 2
vacant__c 0
district__c SF District 9
selling_agent_number__c 171004
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 2052
dom__c 154
listing_co_agent_number__c 802833
price_per_square_foot__c 454.2
selling_office_name__c Coldwell Banker Res. R.E. Svcs
original_price__c 989000
agent_only_remarks__c Property is now back on the market and the commercial unit is vacant and it looks great. Bring in your serious and approved buyers that have been looking for an investment property or to move in. Call, email,or text Alex or Joel for any questions. Proof of funds and pre-approval letter is requested with signed disclosure package with your offers.
pba__yearbuilt_pb__c 1915
style__c Victorian
type__c Duplex
gross_annual_income__c 76200
est_total_expenses__c 0
external_listing__c 1
pba__latitude_property__c 37.748508
listing_agent_number__c 1034357
on_market_date__c 2016-11-17
selling_agent_name__c Christina C. Chung
pba__listing_website__c http://pro.walkintour.com/35124/
website_property_type__c 2 Unit
media Array
ListingUpdateDate 2022-07-01T11:17:55