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, 480 Mission Bay North Boulevard #611, San Francisco, CA, 94158
ffd_mls_id, 423900121
ffd_salesforce_id, a0E8W00000cpesBUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 48
address2__c, 480 Mission Bay North Boulevard #611, San Francisco, CA, 94158
pba__address_pb__c, 480 Mission Bay North Boulevard #611, San Francisco, CA, 94158
agent_only_remarks__c, Open houses are not allowed at the Madrone. Private showings with 24-hour notice. Buyers to pay Mission Bay Community Transfer Tax of .25% of the purchase price. In addition to the $1,052/month HOA fee, there is a $39/month fee paid to MB Maintenance Corp. Escrow opened with First American Title/Liz Paglinawan at [email protected]. Please use the SFAR Purchase Contract with pre-approval along with proof of funds.
appliances__c, Dishwasher;Hood Over Range;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
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-08-26T02:50:49.000+0000
days_on_market__c, 5
dom__c, 3
ffd_description_pb, Experience the best of San Francisco living at this remarkable condo with a large deeded deck in the Madrone. Show off your home and entertain in style on the huge terrace that takes up the full length of the condo. You can also make use of the outdoor patio as your own personal haven to read and relax in the sun. This luxurious two-bedroom, two-bath condo is fitted with floor-to-ceiling windows and a top-notch kitchen, providing you with the ultimate lifestyle and flexibility. Plus, you get one car parking, a walk-in closet, in-unit laundry, and extra storage to top it off. Enjoy a convenient location in the city, just minutes away from shops, eateries, and Warriors & Giants stadiums. The Madrone boasts an attended Lobby, a Fitness Center with Steam and Sauna, a Pool and BBQ patio, a Residence Lounge, a Theatre, a Business Center, and a Meeting room in its amenities.
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 1091
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Madrone Owners' Association & MB Maintenance Corp.
Experience the best of San Francisco living at this remarkable condo with a large deeded deck in the Madrone. Show off your home and entertain in style on the huge terrace that takes up the full length of the condo. You can also make use of the outdoor patio as your own personal haven to read and relax in the sun. This luxurious two-bedroom, two-bath condo is fitted with floor-to-ceiling windows and a top-notch kitchen, providing you with the ultimate lifestyle and flexibility. Plus, you get one car parking, a walk-in closet, in-unit laundry, and extra storage to top it off. Enjoy a convenient location in the city, just minutes away from shops, eateries, and Warriors & Giants stadiums. The Madrone boasts an attended Lobby, a Fitness Center with Steam and Sauna, a Pool and BBQ patio, a Residence Lounge, a Theatre, a Business Center, and a Meeting room in its amenities.
