Array
(
[ID] => 15715
[post_author] => 4
[post_date] => 2018-11-02 19:54:29
[post_date_gmt] => 2018-11-02 19:54:29
[post_content] => Master-planned masterpiece or mid-rise suburban-esque stucco nightmare? Welcome to San Francisco's newest neighborhood, redeveloped from former railroad land and anchored by UCSF's Mission Bay campus. Sunny weather, new to newer construction, 47 acres of parks, and an arena for the Warriors.
[post_title] => Mission Bay
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-bay
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-04 10:46:27
[post_modified_gmt] => 2024-11-04 18:46:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15715
[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, 420 Mission Bay Boulevard #1201, San Francisco, CA, 94158
ffd_mls_id, 506579
ffd_salesforce_id, a0E1I00000Tvv49UAB
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 329
address2__c, 420 Mission Bay Boulevard #1201, San Francisco, CA, 94158
pba__address_pb__c, 420 Mission Bay Boulevard #1201, San Francisco, CA, 94158
agent_only_remarks__c, Private In-person Showings Available. Contact Kevin AND Marcell for showings: [email protected] AND [email protected]. FOR ALL SHOWINGS: Buyers & agents must provide PEAD forms. Buyers & agents must follow COVID-19 safety protocols. OFFERS: Please use SFAR Purchase Agreement and provide pre-approval/POF and signed disclosures with any offer. Pre-escrow opened with Mijael Mike Schmidt at First American. **Buyer to pay MB transfer fee (0.25% of the selling price) at COE. MB is a Master Plan community. In addition to HOA, there is an additional approx. $32.50 monthly fee paid to MB Maintenance Corporation
appliances__c, Dishwasher;Hood Over Range;Self/Cont Clean Oven
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2012
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Marcell P Neri
pba__contingentdate__c, 2021-01-30
cooling__c, Central
ffd_createddate, 2021-02-16T01:49:28.000+0000
days_on_market__c, 1432
dom__c, 1
ffd_description_pb, A highly sought-after 3BD/2BA in Mission Bay's most coveted building. Facing northeast, the residence features views of the city skyline, the San Francisco Bay, Bay Bridge & beyond. Floor-to-ceiling windows in every room ensure natural light & views from every room. The kitchen is complete w/ Caesarstone countertops, Thermador fridge & gas oven which flows seamlessly into the open living & dining space. Take a break on your private balcony & revel in your own oasis in the sky. In-unit washer/dryer, 1-car parking w/ & a private storage closet complete this home. Madrone's amenities include an open-air sun deck, heated lap pool, jacuzzi spa, steam room & sauna, outdoor grills & terrace, catering kitchen, game room, a private movie theater & fitness studio. Madrone is in the epicenter of Mission Bay, surrounded by parks & open space. Close to Oracle Park, UCSF's renowned medical campus & the Chase Center as well as Caltrain, Muni, 280/101 freeways & corporate shuttles!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Door Person,Maintenance Exterior,Maintenance Grounds,Trash,Water
420 Mission Bay Boulevard #1201, San Francisco, CA, 94158 - Property Description
A highly sought-after 3BD/2BA in Mission Bay's most coveted building. Facing northeast, the residence features views of the city skyline, the San Francisco Bay, Bay Bridge & beyond. Floor-to-ceiling windows in every room ensure natural light & views from every room. The kitchen is complete w/ Caesarstone countertops, Thermador fridge & gas oven which flows seamlessly into the open living & dining space. Take a break on your private balcony & revel in your own oasis in the sky. In-unit washer/dryer, 1-car parking w/ & a private storage closet complete this home. Madrone's amenities include an open-air sun deck, heated lap pool, jacuzzi spa, steam room & sauna, outdoor grills & terrace, catering kitchen, game room, a private movie theater & fitness studio. Madrone is in the epicenter of Mission Bay, surrounded by parks & open space. Close to Oracle Park, UCSF's renowned medical campus & the Chase Center as well as Caltrain, Muni, 280/101 freeways & corporate shuttles!
