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-06-23 10:34:13
[post_modified_gmt] => 2023-06-23 17:34:13
[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, 435 China Basin Street #118, San Francisco, CA, 94158
ffd_mls_id, 423759646
ffd_salesforce_id, a0E8W00000dSGS7UAO
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 329
address2__c, 435 China Basin Street #118, San Francisco, CA, 94158
pba__address_pb__c, 435 China Basin Street #118, San Francisco, CA, 94158
agent_only_remarks__c, No Open Houses allowed at Madrone. Contact Nini at [email protected] or 650-291-4409 for private showings. FOR ALL SHOWINGS: Meet showing agent at 420 Mission Bay Blvd lobby. OFFERS: Please use SFAR Purchase Agreement, provide pre-approval/POF and signed disclosures with any offer. Pre-escrow opened with Mijael Mike Schmidt at First American. *Buyer to pay MB transfer fee (0.25% of the selling price) at COE. MB is a Master Plan community. In addition to HOA, there is an additional approx. $39.13 monthly fee paid to MB Maintenance Corporation.
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator;Built-In Freezer
bath_features__c, Tub w/Shower Over;Dual Flush Toilet;Quartz
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2012
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Charlene T Gueco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-09-09T01:48:14.000+0000
days_on_market__c, 20
dom__c, 20
ffd_description_pb, Welcome to Madrone #118, a captivating 1-bedroom, 1-bathroom residence in San Francisco's thriving Mission Bay neighborhood. Step into this northeast-facing gem and be greeted by an inviting living room adorned with beautiful hardwood flooring and customized window treatments. With two walk-in closets, you'll find ample storage space for all your needs, ensuring a clutter-free oasis. The chef's kitchen is a culinary dream, boasting Caesarstone countertops, sleek European-inspired cabinetry, a stylish tiled backsplash, and top-of-the-line stainless steel Bosch appliances, perfect for creating culinary masterpieces. Indulge in individually controlled heat and air conditioning for year-round comfort. In-unit amenities continue with a full-sized washer and dryer, making laundry day a breeze. This condo offers generous room to relax and entertain with 900 sq. ft. of living space. The bedroom boasts plush carpeting, creating a cozy retreat to unwind after a day in the city. The icing on the cake is the private balcony, where you can sip your morning coffee while soaking in the neighborhood's dynamic energy. Don't miss your chance to immerse yourself in Mission Bay living at Madrone #118. Schedule your private tour today and make this extraordinary property your new home!
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, Door Person,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Security,Trash,Water
Welcome to Madrone #118, a captivating 1-bedroom, 1-bathroom residence in San Francisco's thriving Mission Bay neighborhood. Step into this northeast-facing gem and be greeted by an inviting living room adorned with beautiful hardwood flooring and customized window treatments. With two walk-in closets, you'll find ample storage space for all your needs, ensuring a clutter-free oasis. The chef's kitchen is a culinary dream, boasting Caesarstone countertops, sleek European-inspired cabinetry, a stylish tiled backsplash, and top-of-the-line stainless steel Bosch appliances, perfect for creating culinary masterpieces. Indulge in individually controlled heat and air conditioning for year-round comfort. In-unit amenities continue with a full-sized washer and dryer, making laundry day a breeze. This condo offers generous room to relax and entertain with 900 sq. ft. of living space. The bedroom boasts plush carpeting, creating a cozy retreat to unwind after a day in the city. The icing on the cake is the private balcony, where you can sip your morning coffee while soaking in the neighborhood's dynamic energy. Don't miss your chance to immerse yourself in Mission Bay living at Madrone #118. Schedule your private tour today and make this extraordinary property your new home!
