meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='297645' 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 a0E1I0000085NSnUAM
pba__address_pb__c 1875 Mission Street #407, San Francisco, CA, 94103
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 1
pba__bedrooms_pb__c 0
days_on_market__c 1136
mls_id__c 485425
pba__totalarea_pb__c 645
pba__latitude_pb__c 37.767072
pba__longitude_pb__c -122.419728
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Mission
listed_date__c 2019-05-17
sale_date__c 2019-05-17
pba__propertytype__c Condominium
pba__listingprice_pb__c 735000
pba__listingtype__c Sale
sale_price__c 735000
pba__lotsize_pb__c 0
address2__c 1875 Mission Street #407, San Francisco, CA, 94103
pba__listing_agent_firstname__c Eric
pba__listing_agent_lastname__c Li
pba__floor__c 0
parkingspaces__c 0
pba__postalcode_pb__c 94103
year_build_text__c 2014
size__c 645
subdist__c The Mission
listing_agent_mls_id__c 808554
selling_agent_mls_id__c 809151
hoa_dues__c 470
listing_co_office_mls_id__c CLMB
listing_co_office_name__c Climb Real Estate
listing_co_office_number__c 15688
listing_co_agent_mls_id__c 808865
listing_office_number__c 15688
listing_office_name__c Climb Real Estate
listing_office_mls_id__c CLMB
unit_number__c 407
district__c SF District 9
selling_agent_number__c 1040801
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1136
dom__c 0
monthly_parking_fees__c 0
listing_co_agent_number__c 1039225
price_per_square_foot__c 1139.53
selling_office_name__c Zephyr Real Estate
parking_type__c None
original_price__c 735000
agent_only_remarks__c Please use 7 page SFAR contract & include pre-approval letter, proof of funds, and completed disclosure package. Pre-escrow opened with Elisabeth Davis / Fidelity National Title [email protected] For showings and more information, please contact Eric Li at [email protected] or via text at 415.609.8796 or Liz at [email protected] or text to 415.518.7966.
pba__yearbuilt_pb__c 2014
external_listing__c 1
pba__latitude_property__c 37.767072
listing_agent_number__c 1036714
on_market_date__c 2019-05-17
selling_agent_name__c Cynthia M. Pagan
master_property__c a0O1I000001VhmLUAS
website_property_type__c Condominium
media Array
ListingUpdateDate 2022-06-26T18:31:51