meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219003' 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 #1, San Francisco, CA, 94103
ffd_mls_id, 421552186
ffd_salesforce_id, a0E1I00000UTQklUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 5
address2__c, 349 South Van Ness Avenue #1, San Francisco, CA, 94103
pba__address_pb__c, 349 South Van Ness Avenue #1, San Francisco, CA, 94103
agent_only_remarks__c, New TIC subject to Ellis restrictions. Offers must use special contract in disclosure package. Sirkin TICA. Staged and vacant on Supra lockbox on gate. http://www.349SVanNess.com. THANK YOU. Click on Disclosures.io button above or this link for disclosure package: https://app.disclosures.io/link/349-South-Van-Ness-Avenue-1A-dwl8hbmi. Escrow Nick Shanta First American.
appliances__c, Dishwasher;Insulated Water Heater;Gas Water Heater;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Gas Plumbed
architectural_style__c, Edwardian;Modern/High Tech;See Remarks
bath_features__c, Shower Stall(s);Tile;Low-Flow Toilet(s);Dual Flush Toilet;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1917
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-07-06
ffd_createddate, 2021-05-18T19:48:44.000+0000
days_on_market__c, 794
dom__c, 102
ffd_description_pb, Unique chance to own freshly reimagined (modern interior in vintage small building) 2 bedroom TIC home with FANTASTIC SOCIAL DISTANCING OUTDOOR SPACE OVER 550 SQ FEET OF LEVEL DECK/GARDEN EXCLUSIVELY ASSIGNED *****. Private walk-out garden/big deck and private large garage all on one level in boutique building. Steps from exciting Inner Mission, SOMA, Civic Center shopping/ dining/ transportation/ vibrant street life! NOTE: Newly formed HOA monthly actual budget tbd since HOA goes into effect with first sale. Call Mike for more info.
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced;Full
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance,Maintenance Exterior,Sewer,Trash,Water,See Remarks
pba__hoafees__c, 377
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 349 S Van Ness HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric
height_limit__c, Unknown
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:52:48.000+0000
pba__latitude_pb__c, 37.7676631
pba__latitude_property__c, 37.7676631
laundry_features__c, Inside Room;Hookups Only
listed_date__c, 2021-05-15
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, 775000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.417454
mls_id__c, 421552186
master_property__c, a0O8W00000DaE33UAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-05-16
original_price__c, 775000
overall_days_on_market__c, 182
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front,Private
parking_type__c, Other;On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-08-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 980.39
pba__propertytype__c, Tenancy In Common
id, a0E1I00000UTQklUAH
road_surface_type__c, Asphalt,Paved
room_type__c, Laundry;Living Room
sale_date__c, 2021-09-10
sale_price__c, 750000
security_features__c, Smoke Detector;Security Gate;Fire Alarm;Fire Extinguisher;Secured Access;Carbon Mon Detector;Video System;Double Strapped Water Heater
selling_agent_mls_id__c, 809116
selling_agent_number__c, 1040475
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 765
size__c, 765
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 #1, San Francisco, CA, 94103
view__c, Garden/Greenbelt
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/530244359-1.jpg
ListingId, a0E1I00000UTQklUAH