meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='297168' 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 a0E1I00000TwgOWUAZ
pba__address_pb__c 808 South Van Ness Avenue, San Francisco, CA, 94110
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 3
days_on_market__c 471
mls_id__c 421527929
pba__totalarea_pb__c 2180
pba__latitude_pb__c 37.760106
pba__longitude_pb__c -122.41727
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c South Van Ness
listed_date__c 2021-01-24
sale_date__c 2021-04-19
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 1895000
pba__listingtype__c Sale
sale_price__c 1915000
address2__c 808 South Van Ness Avenue, San Francisco, CA, 94110
pba__listing_agent_firstname__c John
pba__listing_agent_lastname__c Solaegui
pba__halfbathrooms_pb__c 1
parkingspaces__c 1
pba__postalcode_pb__c 94110
year_build_text__c 1900
size__c 2180
subdist__c The Mission
listing_agent_mls_id__c 803722
selling_agent_mls_id__c 803117
listing_co_office_number__c 0
listing_office_number__c 27677
listing_office_name__c Compass SF
listing_office_mls_id__c COMP7PAR
of_units__c 0
district__c SF District 9
selling_co_office_name__c Compass
selling_co_agent_mls_id__c 809927
selling_co_office_mls_id__c COMP2
selling_agent_number__c 803117
selling_co_agent_number__c 1044191
selling_co_office_number__c 27341
overall_days_on_market__c 133
dom__c 7
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 878.44
selling_office_name__c Compass
parking_type__c On Site (Single Family Only)
original_price__c 1895000
agent_only_remarks__c Call John at 415-999-0673 to schedule a showing appointment. Please do not use ShowingTime. Prior to requesting a showing, please review disclosures at https://app.disclosures.io/link/808-South-Van-Ness-Avenue-75cvm2w3 , online photos and 3D video tour at 808southvanness.com. Check with the listing agent regarding a possible offer date. Send John the signed PEAD-V at [email protected] Escrow is opened with Gerrie Brindley at Chicago Title, [email protected] Offers will be submitted on most current 7-page SFAR contract (12/2020 edition). Prospective purchasers are advised to independently verify accuracy of square footage and to review any disclosure information before submitting offers.
pba__yearbuilt_pb__c 1900
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.760106
listing_agent_number__c 803722
on_market_date__c 2021-03-13
architectural_style__c Victorian
pba__listing_website__c http://808southvanness.com
website_property_type__c Single Family Home
media Array
ListingUpdateDate 2022-06-28T03:48:48