meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212330' 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 a0E1I000001JaFtUAK
pba__address_pb__c 1227 San Bruno 1231 Avenue, San Francisco, CA, 94110
pba__city_pb__c San Francisco
days_on_market__c 1744
mls_id__c 462788
pba__totalarea_pb__c 4772
pba__latitude_pb__c 37.753544
pba__longitude_pb__c -122.404190
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c San Bruno
listed_date__c 2017-09-15
sale_date__c 2017-10-30
pba__propertytype__c 3 Unit
pba__listingprice_pb__c 2749000
pba__listingtype__c Sale
sale_price__c 2850000
pba__lotsize_pb__c 0.06
address2__c 1227 San Bruno 1231 Avenue, San Francisco, CA, 94110
pba__listing_agent_firstname__c Michael
pba__listing_agent_lastname__c Minson
parkingspaces__c 0
pba__postalcode_pb__c 94110
year_build_text__c 1906
size__c 4772
subdist__c The Mission
listing_agent_mls_id__c 808482
selling_agent_mls_id__c 091779
listing_co_office_number__c 0
listing_office_number__c 26158
listing_office_name__c Keller Williams San Francisco
listing_office_mls_id__c KWRSF
of_units__c 3
vacant__c 0
district__c SF District 9
selling_agent_number__c 91779
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1744
dom__c 12
listing_co_agent_number__c 0
price_per_square_foot__c 597.23
selling_office_name__c Citiland Investment Corp.
original_price__c 2749000
agent_only_remarks__c We're back - this time with a $250k price reduction! Must ratify by 1-Oct so bring your best offer. Offers due Weds, 27-Sept by 10a. Weekday showings only to not to disturb tenants - please call to schedule. No tenants claim protected status. Two leases run thru May/June 2017; one thru May 2018. Full financials available. Former BK rescinded - still short sale. Buyer to cooperate in seller's 1031 at no cost to buyer.
pba__yearbuilt_pb__c 1906
style__c Edwardian
type__c Apartments,Triplex,3 Story
gross_annual_income__c 175000
est_total_expenses__c 42778
external_listing__c 1
pba__latitude_property__c 37.753544
listing_agent_number__c 1035858
on_market_date__c 2017-09-16
selling_agent_name__c Floyd R. Turnquist
website_property_type__c 3 Unit
media Array
ListingUpdateDate 2022-06-26T18:02:53