meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330231' 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] => 2023-06-23 10:52:55
[post_modified_gmt] => 2023-06-23 17:52:55
[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, 140 South Van Ness Avenue #419, San Francisco, CA, 94103
ffd_mls_id, 423729584
ffd_salesforce_id, a0E8W00000bGGW4UAO
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 212
address2__c, 140 South Van Ness Avenue #419, San Francisco, CA, 94103
pba__address_pb__c, 140 South Van Ness Avenue #419, San Francisco, CA, 94103
agent_only_remarks__c, Easy to show by appointment. Prelim courtesy of Gerrie Brindley at Chicago Title. Option for leased parking in the building. No maximum number of spaces but is subject to availability. Parking pricing is estimated to be: Full spot= $250, Compact spot =$240, Full tandem = $400, Compact Tandem =$350.
appliances__c, Dishwasher;Disposal;Hood Over Range;Ice Maker;Built-In Refrigerator;Built-In Electric Range;Plumbed For Ice Maker
bath_features__c, Tub w/Shower Over;Granite;Stone;Closet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2002
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-03-29
cooling__c, None
ffd_createddate, 2023-03-25T10:49:11.000+0000
days_on_market__c, 131
dom__c, 20
ffd_description_pb, Plentiful light courtesy of three glass windows. Smashing views of San Francisco's skyline, and points south, brought closer by stepping out onto the terrace. A rooftop courtyard with barbecue for gatherings with friends. At 140 South Van Ness No. 419, you'll find new perspective courtesy of this rare corner unit in the burgeoning Van Mission corridor. Here are two split ensuite bedrooms in one of the city's most dynamic areas steps away from restaurants, shopping, and San Francisco's performing arts district, with theatre, opera, and the symphony practically at your door. In-unit amenities include designer lighting, engineered floors, remodeled kitchen with new appliances and granite countertops, and limestone and marble bathrooms, while building amenities include a 24/7 gym, available parking, and deeded storage. With tech shuttles stopping regularly at the building's front door and public transit an easy stroll away, you'll love the convenience too!
district__c, SF District 9
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood;Simulated Wood
hoa_fee_includes__c, Common Areas,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Roof,Security,Trash,Water
pba__hoafees__c, 711
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 140 South HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Electric;MultiZone
ffd_lastmodifieddate, 2023-08-02T10:48:48.000+0000
pba__latitude_pb__c, 37.68478498
pba__latitude_property__c, 37.68478498
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-09-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brendon
pba__listing_agent_lastname__c, Kearney
listing_agent_mls_id__c, 802979
ffd_listingagentname, Brendon Kearney
listing_agent_number__c, 802979
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 965000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/811441191
pba__longitude_pb__c, -122.40042388
mls_id__c, 423729584
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I00000AMq4DUAT
monthly_parking_fees__c, 240
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-24
original_price__c, 965000
overall_days_on_market__c, -81531
parking_access__c, Independent
parking_features__c, Assigned,Enclosed,Garage Door Opener
parking_type__c, On Site - Lease Available (Condo Only)
pba__pendingdate__c, 2023-04-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 897.67
pba__propertytype__c, Condominium
ListingId, a0E8W00000bGGW4UAO
room_type__c, Storage
sale_date__c, 2023-04-21
sale_price__c, 965000
security_features__c, Smoke Detector;Fire Alarm;Secured Access;Carbon Mon Detector;Video System
selling_agent_mls_id__c, EB283165
selling_agent_number__c, 981313641
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Excel Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1075
size__c, 1075
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, South Van Ness
subdist__c, The Mission
ffd_name, 140 South Van Ness Avenue #419, San Francisco, CA, 94103
view__c, City;City Lights;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2002
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530595203_c9985917-fae8-4552-ab04-018c75967df4.jpg
_wp_old_slug, 140-van-ness-south-avenue-419-san-francisco-ca-94103
