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] => 2023-03-09 10:09:41
[post_modified_gmt] => 2023-03-09 18:09:41
[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 #403, San Francisco, CA, 94158
ffd_mls_id, 423720337
ffd_salesforce_id, a0E8W00000bDksCUAS
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 332
address2__c, 420 Mission Bay Boulevard #403, San Francisco, CA, 94158
pba__address_pb__c, 420 Mission Bay Boulevard #403, San Francisco, CA, 94158
agent_only_remarks__c, Must see floor plan, not just a one bedroom! Show your two-bedroom buyers! Showing only by appointment per Madrone's rules. Very secure and well-managed building. Please Email Shannon at [email protected] Buyer to pay one-time Mission Bay Community Enhancement Fee of 0.25% of the purchase price. In addition to the monthly HOA dues, there is a $37.45 monthly fee paid to MB Maintenance Corp.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2012
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-09T17:50:45.000+0000
days_on_market__c, 20
dom__c, 12
ffd_description_pb, One Bedroom PLUS Enclosed Den! This unique floor plan at The Madrone is highly coveted offering you an extra room that can serve as your home office, media room, or even a sweet guest space. There is also a bonus half bath located right off the entryway preserving your primary suite with a spa-like full bath as a private retreat. The home is flooded with natural light and features a gracious and open entertainment space with a stylish chef's kitchen with top-of-the-line appliances plus counter seating, and your dining area is adjacent to your own lovely terrace. This fourth-floor location surrounds you with beautiful outlooks of the wonderfully landscaped gardens of the Madrone's private interior courtyard. Your parking space comes with an electric car charger and you have a storage space large enough to store your stand-up paddle board. The Madrone offers a wealth of lifestyle amenities including a resort-style sundeck & swimming pool, clubroom, business center, theatre, gym + more! Discover the special community of The Madrone and all that surrounds it - The Bay breeze, blue skies, convenience, entertainment, and hot spots of Mission Bay's waterfront village. Moments to UCSF, Warrior's Chase Center, Giant's Oracle Ballpark, Freeways, Shuttles & Downtown.
One Bedroom PLUS Enclosed Den! This unique floor plan at The Madrone is highly coveted offering you an extra room that can serve as your home office, media room, or even a sweet guest space. There is also a bonus half bath located right off the entryway preserving your primary suite with a spa-like full bath as a private retreat. The home is flooded with natural light and features a gracious and open entertainment space with a stylish chef's kitchen with top-of-the-line appliances plus counter seating, and your dining area is adjacent to your own lovely terrace. This fourth-floor location surrounds you with beautiful outlooks of the wonderfully landscaped gardens of the Madrone's private interior courtyard. Your parking space comes with an electric car charger and you have a storage space large enough to store your stand-up paddle board. The Madrone offers a wealth of lifestyle amenities including a resort-style sundeck & swimming pool, clubroom, business center, theatre, gym + more! Discover the special community of The Madrone and all that surrounds it - The Bay breeze, blue skies, convenience, entertainment, and hot spots of Mission Bay's waterfront village. Moments to UCSF, Warrior's Chase Center, Giant's Oracle Ballpark, Freeways, Shuttles & Downtown.
