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, 1746875953
ffd_listing_title, 420 Mission Bay Boulevard #1504, San Francisco, CA, 94158
ffd_mls_id, 425023426
ffd_salesforce_id, a0EUd000004pW3bMAE
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 332
pba__address_pb__c, 420 Mission Bay Boulevard #1504, San Francisco, CA, 94158
address2__c, 420 Mission Bay Boulevard #1504, San Francisco, CA, 94158
agent_only_remarks__c, Sellers accepted a pre-market offer from the tenant. Photos are from before 2020 and show the owner's furniture. Property is currently tenant occupied, lease ends at the end of May 2025. Please provide at least 24 hours for showings. Please keep escrow with Joanne Kung, Chicago Title Co. due to prepared documentation for the sellers for closing. Buyer to pay Mission Bay transfer fee totaling 0.25% of the sale price at close of escrow. Mission Bay is a Master Plan community. There is an additional Mission Bay Maintenance Corporation fee of approximately $40.27/month.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Built-In Refrigerator
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s);Quartz
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, 2025-04-23T21:46:53.000+0000
days_on_market__c, 17
dom__c, 0
ffd_description_pb, Welcome to Madrone 1504, an exceedingly rare high floor home with views of the Bay Bridge, city and bay. The split floorplan maximizes the views from the living room leading to the private balcony. An open chef's kitchen with space for dining creates an ideal space for entertaining. The primary suite features an en-suite bathroom with great closet space. The second bedroom is ideal for family members, guests or an office. Air conditioning and heat, in-unit laundry, one car parking, and storage complete this incredible offering. Madrone exemplifies luxurious Mission Bay living. Amenities include 24-hour door persons, on-site management, a state-of-the art fitness center, outdoor pool and jacuzzi, owner's lounge, and a business center. With its incredible location and spectacular views, Madrone 1504 should not be missed.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, BBQ Built-In
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Roof,Security,Sewer,Trash,Water
420 Mission Bay Boulevard #1504, San Francisco, CA, 94158 - Property Description
Welcome to Madrone 1504, an exceedingly rare high floor home with views of the Bay Bridge, city and bay. The split floorplan maximizes the views from the living room leading to the private balcony. An open chef's kitchen with space for dining creates an ideal space for entertaining. The primary suite features an en-suite bathroom with great closet space. The second bedroom is ideal for family members, guests or an office. Air conditioning and heat, in-unit laundry, one car parking, and storage complete this incredible offering. Madrone exemplifies luxurious Mission Bay living. Amenities include 24-hour door persons, on-site management, a state-of-the art fitness center, outdoor pool and jacuzzi, owner's lounge, and a business center. With its incredible location and spectacular views, Madrone 1504 should not be missed.
* Disclaimer: MLS listing information is deemed reliable but is not guaranteed by the service.
* Listing Agent: Marcell Neri
Listing Details for 420 Mission Bay Boulevard #1504
HOA Information
HOA Information
Association: Yes
Association Fee: $1347
Association Fee Frequency: Monthly
Association Fee Includes: Common Areas,Door Person,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Roof,Security,Sewer,Trash,Water
# of Units (Total): 332
Parking & Garage Information
Parking & Garage Information
Parking Total: 1
Parking Type: On Site - Assigned (Condo Only)
Parking Access: Side by Side
Parking Features: Assigned,Covered,Enclosed,Garage Door Opener,Interior Access,Restrictions,Side-by-Side
