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, 420 Mission Bay Boulevard #104, San Francisco, CA, 94158
ffd_mls_id, 421541836
ffd_salesforce_id, a0E1I00000USDCcUAP
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 329
address2__c, 420 Mission Bay Boulevard #104, San Francisco, CA, 94158
pba__address_pb__c, 420 Mission Bay Boulevard #104, San Francisco, CA, 94158
agent_only_remarks__c, A must-see. Text Kara for showings and disclosures. 650- 918-2039. Offer date TBD. Buyer pays Mission Bay transfer fee .25% of purchase price. Monthly dues of ~$35/mo for Mission Bay Maintenance Corp, includes landscaping, community patrol, MB shuttle service. Agent/buyer to verify sq ft, permits, nearby development to buyer's satisfaction.
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Ice Maker;Built-In Refrigerator
architectural_style__c, Modern/High Tech
bath_features__c, Low-Flow Shower(s);Closet
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, Kara W Lee
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-04-23T20:47:20.000+0000
days_on_market__c, 817
dom__c, 47
ffd_description_pb, One of only five walk-up townhome collections at Mission Bay's highly desirable luxury building, Madrone. 2bd/2.5ba + den two-level condo. Residence 104 overlooks the lush green open park w blossoming trees. Two patio spaces w its own private entry. This home showcases 12' ceilings on the second level w floor-to-ceiling windows, chef's kitchen w contemporary finishes, Thermador fridge, Bosch gas stove, tri-level dishwasher, Caesarstone counters, central heat & A/C, washer/dryer, EV charging parking, in-unit & additional storage. Upgrades incl dimmable LEDs in kitchen, spotlights for artwork, wide-plank wood flooring, California Closets in primary bedroom. Resort-like amenities: open air sundeck w heated pool & hot tub, 24hr fitness studio, steam room & sauna, lounge w pool table, theater, Viking BBQs & alfresco dining, 24hr lobby attendants. Conveniently located near Chase Center, Oracle Park, MUNI, Caltrain, I280, UCSF, Sparks Social, Gus's Community Market & dog & kid parks & trail.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Door Person,Gas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Security,Sewer,Trash,Water
420 Mission Bay Boulevard #104, San Francisco, CA, 94158 - Property Description
One of only five walk-up townhome collections at Mission Bay's highly desirable luxury building, Madrone. 2bd/2.5ba + den two-level condo. Residence 104 overlooks the lush green open park w blossoming trees. Two patio spaces w its own private entry. This home showcases 12' ceilings on the second level w floor-to-ceiling windows, chef's kitchen w contemporary finishes, Thermador fridge, Bosch gas stove, tri-level dishwasher, Caesarstone counters, central heat & A/C, washer/dryer, EV charging parking, in-unit & additional storage. Upgrades incl dimmable LEDs in kitchen, spotlights for artwork, wide-plank wood flooring, California Closets in primary bedroom. Resort-like amenities: open air sundeck w heated pool & hot tub, 24hr fitness studio, steam room & sauna, lounge w pool table, theater, Viking BBQs & alfresco dining, 24hr lobby attendants. Conveniently located near Chase Center, Oracle Park, MUNI, Caltrain, I280, UCSF, Sparks Social, Gus's Community Market & dog & kid parks & trail.
* Disclaimer: MLS listing information is deemed reliable but is not guaranteed by the service.
* Listing Agent: Trevor Leung, Co-listing Agent: Kara W Lee
Virtual Tour
Listing Details for 420 Mission Bay Boulevard #104
HOA Information
HOA Information
Association: Yes
Association Fee: $938
Association Fee Frequency: Monthly
Association Fee Includes: Common Areas,Door Person,Gas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Security,Sewer,Trash,Water
# of Units (Total): 329
Parking & Garage Information
Parking & Garage Information
Parking Total: 1
Parking Type: On Site - Assigned (Condo Only)
Parking Access: Independent
Parking Features: EV Charging,Interior Access,Side-by-Side
Exterior Features
Exterior Features
Main Level: Partial Bath(s);Garage;Living Room;Dining Room;Street Entrance
Exterior Features: Balcony
Security Features: Fire Alarm;Carbon Mon Detector
Pool: Yes
Interior Features
Interior Features
Interior Features: Storage Area(s)
Heating: Central
Appliances: Dishwasher;Microwave;Disposal;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Ice Maker;Built-In Refrigerator
