meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332310' posts_per_page=4 post_type=property
bool(false)
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-03-09 10:09:41
[post_modified_gmt] => 2023-03-09 18:09:41
[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 #618, San Francisco, CA, 94158
ffd_mls_id, 423744987
ffd_salesforce_id, a0E8W00000awhtzUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 329
address2__c, 480 Mission Bay Boulevard #618, San Francisco, CA, 94158
pba__address_pb__c, 480 Mission Bay Boulevard #618, San Francisco, CA, 94158
agent_only_remarks__c, No open houses allowed at The Madrone, text listing agents for an appointment to view. Unit also comes with a storage cage. Please write all offers on SFAR contract and include pre-approval letter, and proof of funds. Buyers to pay Mission Bay Community Transfer Tax Fee of .25% of purchase price. In addition to Madrone HOA, there is an additional approx. $39 monthly fee paid to MB Maintenance Corp. Escrow opened with Karen Tam at Old Republic Title Company [email protected]
appliances__c, Disposal;Hood Over Range;Gas Cook Top;Built-In Electric Oven
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
listing_co_agent_name__c, Terrence Chan
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-05-26T19:48:39.000+0000
days_on_market__c, 9
dom__c, 9
ffd_description_pb, Welcome to Residence 618 at The Madrone, where sun-drenched luxury meets panoramic views. This spacious 2BD/2BA south facing corner unit captivates you with floor-to-ceiling windows that fill the space with natural light. The picturesque vista encompasses a lush park, the Bay, majestic Twin Peaks, and Sutro Tower. Prepare gourmet meals in the well-appointed kitchen featuring sleek Caesarstone counters and top-of-the-line SS appliances. Custom closets offer ample storage, ensuring that your belongings are neatly organized. Step outside onto the inviting deck, an extension of your space, where you can unwind and soak in the breathtaking views. Embrace the vibrance of Mission Bay, where renowned institutions like UCSF, Kaiser, Uber, and The Warriors thrive. From social spots to mini golf, parks, coffee shops, and restaurants, the neighborhood offers a myriad of activities. Enjoy easy access to public transit, Highway 280/101, and the Bay Bridge. The Madrone, is a premier building boasting impressive amenities such as a lap pool, jacuzzi, sauna, steam room, movie theater, fitness center, resident lounge with a full kitchen and billiards, BBQ area, landscaped courtyard, and a dedicated 24/7 staff. Experience the best of Mission Bay's vibrant lifestyle at The Madrone!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 1106
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Action Life
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-06-04T10:48:25.000+0000
pba__latitude_pb__c, 37.77074264
pba__latitude_property__c, 37.77074264
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-05-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Crystal
pba__listing_agent_lastname__c, Injo
listing_agent_mls_id__c, 808900
ffd_listingagentname, Crystal C Injo
listing_agent_number__c, 1038416
listing_co_agent_mls_id__c, 810812
listing_co_agent_number__c, 1048237
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1689500
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3889459
mls_id__c, 423744987
master_bathroom_features__c, Shower Stall(s);Double Sinks
master_property__c, a0O1I000001VhzYUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-05-26
original_price__c, 1689500
overall_days_on_market__c, -81594
parking_access__c, Side by Side
parking_features__c, Attached,Covered
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1231.41
pba__propertytype__c, Condominium
ListingId, a0E8W00000awhtzUAA
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1372
size__c, 1372
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission Bay
subdist__c, Mission Bay
ffd_name, 480 Mission Bay Boulevard #618, San Francisco, CA, 94158
view__c, Park;Bay;Water;Twin Peaks;Sutro Tower
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 2012
pba__postalcode_pb__c, 94158
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530624577-1.jpg
