meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214578' 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] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[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
(
)
)
ffd_listing_title, 349 South Van Ness Avenue #3, San Francisco, CA, 94103
ffd_mls_id, 505424
ffd_salesforce_id, a0E1I00000THdyCUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 5
address2__c, 349 South Van Ness Avenue #3, San Francisco, CA, 94103
pba__address_pb__c, 349 South Van Ness Avenue #3, San Francisco, CA, 94103
agent_only_remarks__c, ***NEW PRICE***. NEW TICA by Sirkin, new HOA. Text/call Mike Gallin for more info and disclosures/ offer instructions. Vacant and staged. Supra lockbox (no code required), submit PEAD first. http://www.349SVanNess.com. For disclosure package click on Disclosures.IO button above or this link: https://app.disclosures.io/link/349-South-Van-Ness-Avenue-3A-agvxi3og. Nick Shanta/First American escrow
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1917
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2020-09-06T21:46:04.000+0000
days_on_market__c, 1046
dom__c, 381
ffd_description_pb, Freshly reimagined 2/1 TIC unit, nice open floor plan, new French Oak wide plank floors, kitchen, bath, lots of natural light. 2nd floor rear unit over-looks peaceful outlook. Walk to Inner Mission/SOMA/Civic Center shopping. Easy 101/280/BART/MUNI access plus high walk score. h HOA to be formed newly upon first sale and actual/estimated HOA budget to be determined. Call Mike for more information.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 2
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2022-01-25T15:33:33.000+0000
pba__latitude_pb__c, 37.7676631
pba__latitude_property__c, 37.7676631
laundry_features__c, Hookups Only;Inside Area;Stacked Only
listed_date__c, 2020-09-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Gallin
listing_agent_mls_id__c, 391396
ffd_listingagentname, Michael A Gallin
listing_agent_number__c, 391396
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AVNU
listing_office_name__c, Avenue 8 Inc.
listing_office_number__c, 28244
pba__listingprice_pb__c, 625000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=T4BsuvwznPN
pba__longitude_pb__c, -122.417454
pba__lotsize_pb__c, 0
mls_id__c, 505424
master_property__c, a0O8W00000DaE33UAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2020-09-06
original_price__c, 829000
overall_days_on_market__c, 420
parking_features__c, No Garage
parking_type__c, None
pba__pendingdate__c, 2021-10-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 762.39
pba__propertytype__c, Tenancy In Common
id, a0E1I00000THdyCUAT
sale_date__c, 2021-11-24
sale_price__c, 600000
selling_agent_mls_id__c, EB283818
selling_agent_number__c, 981313703
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 787
size__c, 787
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, South Van Ness
subdist__c, The Mission
ffd_name, 349 South Van Ness Avenue #3, San Francisco, CA, 94103
transportation__c, 1 Block
unit_number__c, 3
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369745-1.jpg
ListingId, a0E1I00000THdyCUAT