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-03-07 14:08:53
[post_modified_gmt] => 2024-03-07 22:08:53
[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, 480 Mission Bay Boulevard #513, San Francisco, CA, 94158
ffd_mls_id, 422699845
ffd_salesforce_id, a0E8W00000a6zwPUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 323
address2__c, 480 Mission Bay Boulevard #513, San Francisco, CA, 94158
pba__address_pb__c, 480 Mission Bay Boulevard #513, San Francisco, CA, 94158
agent_only_remarks__c, Call listing agent for showings, disclosures & offer instructions. Buyer to pay 0.25% Mission Bay transfer fee.
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Ice Maker;Built-In Refrigerator
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2012
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-01-13T11:48:31.000+0000
days_on_market__c, 187
dom__c, 32
ffd_description_pb, Premier Mission Bay luxury condo at Madrone by Bosa. Stylish & sleek ultra-modern 5th floor unit w/ beautiful resort-style courtyard views. Grand floor-to-ceiling windows overlook the landscaped amenity level & flood the home w/ natural light. 2 private balconies create indoor outdoor living flow. Open concept floor plan w/ gorgeous new hardwood floors, top-of-the-line appliances & in-unit laundry. Built-in closet organizers, parking & additional storage included. Steps to Spark Social SF, Starbucks, Mission Bay Commons Park & the waterfront. World-class employers, medical centers, entertainment & activities abound. Near the San Francisco Giants baseball stadium & Chase Arena, home to the world-champion Golden State Warriors. Amenity suite includes heated swimming pool, hot tub, gym, steam room, dry sauna, club lounge, community room, movie theater, BBQs, meeting room, billiards, terrace & 24/7 attended lobbies. Welcome home!
district__c, SF District 9
entry_level__c, 1
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Gas,Maintenance Grounds,Management,Pool,Security,Sewer,Trash,Water
480 Mission Bay Boulevard #513, San Francisco, CA, 94158 - Property Description
Premier Mission Bay luxury condo at Madrone by Bosa. Stylish & sleek ultra-modern 5th floor unit w/ beautiful resort-style courtyard views. Grand floor-to-ceiling windows overlook the landscaped amenity level & flood the home w/ natural light. 2 private balconies create indoor outdoor living flow. Open concept floor plan w/ gorgeous new hardwood floors, top-of-the-line appliances & in-unit laundry. Built-in closet organizers, parking & additional storage included. Steps to Spark Social SF, Starbucks, Mission Bay Commons Park & the waterfront. World-class employers, medical centers, entertainment & activities abound. Near the San Francisco Giants baseball stadium & Chase Arena, home to the world-champion Golden State Warriors. Amenity suite includes heated swimming pool, hot tub, gym, steam room, dry sauna, club lounge, community room, movie theater, BBQs, meeting room, billiards, terrace & 24/7 attended lobbies. Welcome home!
