meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212206' 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 a0E1I000001JaFjUAK
pba__address_pb__c 2824 21st 2828 Street, San Francisco, CA, 94110
pba__city_pb__c San Francisco
days_on_market__c 1747
mls_id__c 462620
pba__totalarea_pb__c 3726
pba__latitude_pb__c 37.757736
pba__longitude_pb__c -122.411041
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c 21st
listed_date__c 2017-09-14
sale_date__c 2017-11-08
pba__propertytype__c 3 Unit
pba__listingprice_pb__c 1979000
pba__listingtype__c Sale
sale_price__c 1825000
pba__lotsize_pb__c 0.06
address2__c 2824 21st 2828 Street, San Francisco, CA, 94110
pba__listing_agent_firstname__c Gary
pba__listing_agent_lastname__c Tribulato
parkingspaces__c 0
pba__postalcode_pb__c 94110
year_build_text__c 1910
size__c 3726
subdist__c The Mission
listing_agent_mls_id__c 800067
selling_agent_mls_id__c 808933
listing_co_office_mls_id__c ZEPH06
listing_co_office_name__c Zephyr Real Estate
listing_co_office_number__c 166014343
listing_co_agent_mls_id__c 808574
listing_office_number__c 166014343
listing_office_name__c Zephyr Real Estate
listing_office_mls_id__c ZEPH06
of_units__c 3
vacant__c 3
district__c SF District 9
selling_agent_number__c 1038611
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1747
dom__c 36
listing_co_agent_number__c 1036952
price_per_square_foot__c 489.8
selling_office_name__c Zephyr Real Estate
original_price__c 2495000
agent_only_remarks__c Showing by appointment only. Please call Greg Tribulato at 415.235.6717, Michael Price at 415.652.4576, or Gary Tribulato at 415.828.7814 to arrange a showing. Tuesday Brokers Tour: 10/03 2:30 pm-4:00pm
pba__yearbuilt_pb__c 1910
style__c Victorian
type__c Flats,Triplex,3 Story
gross_annual_income__c 0
est_total_expenses__c 0
external_listing__c 1
pba__latitude_property__c 37.757736
listing_agent_number__c 800067
on_market_date__c 2017-09-14
selling_agent_name__c Lucinda J. Otto
pba__listing_website__c http://www.2824-21st.com/
website_property_type__c 3 Unit
media Array
ListingUpdateDate 2022-06-28T04:07:34