meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='296689' 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 a0E8W00000V1lmnUAB
pba__address_pb__c 517 Capp 1/2 Street, San Francisco, CA, 94110
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 1
pba__bedrooms_pb__c 3
days_on_market__c 227
mls_id__c 421610958
pba__totalarea_pb__c 1292
pba__latitude_pb__c 37.757979
pba__longitude_pb__c -122.417844
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Capp
listed_date__c 2021-11-12
sale_date__c 2021-12-27
pba__propertytype__c Tenancy In Common
pba__listingprice_pb__c 559000
pba__listingtype__c Sale
sale_price__c 750000
address2__c 517 Capp 1/2 Street, San Francisco, CA, 94110
pba__listing_agent_firstname__c Jeffrey
pba__listing_agent_lastname__c Salgado
view__c City Lights
pba__halfbathrooms_pb__c 1
parkingspaces__c 0
pba__postalcode_pb__c 94110
year_build_text__c 1900
size__c 1292
subdist__c The Mission
listing_agent_mls_id__c 805001
selling_agent_mls_id__c 808971
listing_co_office_number__c 0
listing_office_number__c 28751
listing_office_name__c Compass
listing_office_mls_id__c COMP7
of_units__c 2
district__c SF District 9
selling_co_office_name__c Compass
selling_co_agent_mls_id__c 808937
selling_co_office_mls_id__c COMP
selling_agent_number__c 1038794
selling_co_agent_number__c 1038623
selling_co_office_number__c 26293
overall_days_on_market__c 38
dom__c 10
hoa_name__c 517-517 1/2 Capp Street
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 580.5
selling_office_name__c Compass
original_price__c 559000
agent_only_remarks__c The disclosure packet is available on homelight/IO and here is the link: https://app.disclosures.io/link/517-Capp-Street-12-srmz00w3 Please email the listing agent to schedule appointments and follow advised health safety protocols. The deck nor the back stairs are not currently safe to walk on. The HOA does not collect monthly dues and the monthly amount stated includes water, trash, Insurance, and property taxes. The square footage is from a previous appraisal and includes the back porch. Buyer to verify square footage.---OFFER DATE MONDAY 11/22/21 BY 3:00PM---
pba__yearbuilt_pb__c 1900
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.757979
listing_agent_number__c 166014760
on_market_date__c 2021-11-12
master_property__c a0O8W00000DaE75UAF
architectural_style__c Edwardian;Victorian;Traditional
website_property_type__c Tenancy In Common
media Array
ListingUpdateDate 2022-06-28T03:25:27