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
(
)
)
_yoast_indexnow_last_ping, 1746841160
ffd_listing_title, 420 Mission Bay Boulevard #708, San Francisco, CA, 94158
ffd_mls_id, 425030612
ffd_salesforce_id, a0EUd000004qYUrMAM
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 329
pba__address_pb__c, 420 Mission Bay Boulevard #708, San Francisco, CA, 94158
address2__c, 420 Mission Bay Boulevard #708, San Francisco, CA, 94158
agent_only_remarks__c, No open houses are allowed, contact listing agents for a private appointment. Please write all offers on SFAR contract and include pre-approval letter, and proof of funds. Buyers to pay Mission Bay Community Transfer Tax Fee of 0.25% of purchase price. In addition to the Madrone HOA dues, there is an additional approx. $41 monthly fee paid to MB Maintenance Corp. Escrow opened with Karen Tam at Old Republic Title Company [email protected]
appliances__c, Microwave;Disposal;Hood Over Range;Gas Cook Top;Built-In Electric Oven
bath_features__c, Tub w/Shower Over;Dual Flush Toilet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2012
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Terrence Chan
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2025-04-25T18:47:18.000+0000
days_on_market__c, 14
dom__c, 14
ffd_description_pb, No open houses are allowed at The Madrone. Please contact for appointment. Expansive floor-to-ceiling windows bathe this spacious 2bed/2bath south-facing home with sunlight while offering spectacular water views of the Bay and lush greenery from the park below. This spacious condo combines living+dedicated dining, a generous open-floor-plan, abundant closet space and two sizable balconies. This entertainer's dream features an open kitchen with sleek European style cabinetry, tiled backsplash, Ceasarstone countertops, stainless steel Bosch appliances, and built-in Thermador fridge. There is 1 car parking and storage (large private room versus a standard cage in a common space). Building amenities include attended lobbies, heated outdoor pool, spa, sauna, BBQ/dining areas, state-of-the-art fitness center, theater, and community lounge/game room. Enjoy easy access to parks, public transit, highways, restaurants, Spark Social, plus entertainment at the Chase Center and Oracle Park! This is luxury living at its finest!
420 Mission Bay Boulevard #708, San Francisco, CA, 94158 - Property Description
No open houses are allowed at The Madrone. Please contact for appointment. Expansive floor-to-ceiling windows bathe this spacious 2bed/2bath south-facing home with sunlight while offering spectacular water views of the Bay and lush greenery from the park below. This spacious condo combines living+dedicated dining, a generous open-floor-plan, abundant closet space and two sizable balconies. This entertainer's dream features an open kitchen with sleek European style cabinetry, tiled backsplash, Ceasarstone countertops, stainless steel Bosch appliances, and built-in Thermador fridge. There is 1 car parking and storage (large private room versus a standard cage in a common space). Building amenities include attended lobbies, heated outdoor pool, spa, sauna, BBQ/dining areas, state-of-the-art fitness center, theater, and community lounge/game room. Enjoy easy access to parks, public transit, highways, restaurants, Spark Social, plus entertainment at the Chase Center and Oracle Park! This is luxury living at its finest!
