meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='297505' 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 a0E1I000001w5SpUAI
pba__address_pb__c 1232 Treat A Avenue, San Francisco, CA, 94110
pba__city_pb__c San Francisco
days_on_market__c 1536
mls_id__c 469417
pba__totalarea_pb__c 2395
pba__latitude_pb__c 37.750385
pba__longitude_pb__c -122.413078
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c Treat
listed_date__c 2018-04-13
sale_date__c 2018-05-31
pba__propertytype__c 2 Unit
pba__listingprice_pb__c 1459000
pba__listingtype__c Sale
sale_price__c 1900000
pba__lotsize_pb__c 0.13
address2__c 1232 Treat A Avenue, San Francisco, CA, 94110
pba__listing_agent_firstname__c Jeffrey
pba__listing_agent_lastname__c Salgado
parkingspaces__c 1
pba__postalcode_pb__c 94110
year_build_text__c 1900
size__c 2395
subdist__c The Mission
listing_agent_mls_id__c 805001
selling_agent_mls_id__c 807863
listing_co_office_number__c 0
listing_office_number__c 2865
listing_office_name__c Compass SF
listing_office_mls_id__c PARA
of_units__c 3
vacant__c 3
district__c SF District 9
selling_agent_number__c 1027872
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1536
dom__c 14
parking__c Attached,Garage,Auto Door,Interior Access
listing_co_agent_number__c 0
price_per_square_foot__c 793.32
selling_office_name__c Zephyr Real Estate
original_price__c 1459000
agent_only_remarks__c Please contact the listing agent for further details and showings. The property is part of a TIC and can only be sold as the full 37.5% share with fractional financing. The property is currently being used a a 2-unit building. The current TIC agreement is being amended and should be available on Monday. Disclosure packet available on disclosure IO.---OFFER DATE THURSDAY 4/26/18 BY 12:00PM---
pba__yearbuilt_pb__c 1900
style__c Contemporary,Traditional,Rustic,Modern/High Tech,Conversion
type__c Apartments
gross_annual_income__c 0
est_total_expenses__c 0
external_listing__c 1
pba__latitude_property__c 37.750385
listing_agent_number__c 166014760
on_market_date__c 2018-04-13
selling_agent_name__c Isabelle Grotte
pba__listing_website__c https://vimeo.com/264042996
website_property_type__c 2 Unit
media Array
ListingUpdateDate 2022-06-28T04:35:59
