meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211880' 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] => 2022-01-05 13:04:38
[post_modified_gmt] => 2022-01-05 21:04:38
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E1I00000H0te3UAB
pba__address_pb__c 480 Mission Bay Boulevard #711, San Francisco, CA, 94158
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 2
days_on_market__c 1022
mls_id__c 489533
pba__totalarea_pb__c 1252
pba__latitude_pb__c 37.7715936
pba__longitude_pb__c -122.3885893
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Mission Bay
listed_date__c 2019-09-06
sale_date__c 2019-11-08
pba__propertytype__c Condominium
pba__listingprice_pb__c 1685000
pba__listingtype__c Sale
sale_price__c 1635000
pba__lotsize_pb__c 0
address2__c 480 Mission Bay Boulevard #711, San Francisco, CA, 94158
pba__listing_agent_firstname__c Michael
pba__listing_agent_lastname__c Ackerman
pba__floor__c 0
parkingspaces__c 1
pba__postalcode_pb__c 94158
year_build_text__c 2012
size__c 1252
subdist__c Mission Bay
listing_agent_mls_id__c 803645
hoa_dues__c 806.34
listing_co_office_mls_id__c ZEPH01
listing_co_office_name__c Zephyr Real Estate
listing_co_office_number__c 2264
listing_co_agent_mls_id__c 804143
listing_office_number__c 2264
listing_office_name__c Zephyr Real Estate
listing_office_mls_id__c ZEPH01
unit_number__c 711
district__c SF District 9
selling_agent_number__c 1022637
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1022
dom__c 47
laundry_appliances__c Washer/Dryer,In Closet
monthly_parking_fees__c 0
listing_co_agent_number__c 166013610
price_per_square_foot__c 1305.91
selling_office_name__c Compass
parking_type__c Designated On Site
transportation__c 2 Blocks
original_price__c 1685000
agent_only_remarks__c The Madrone is a beautiful and exclusive luxury residential development by BOSA in Mission Bay. Private Showings Only with RSVP - Concierge Service. Call 415-244-5846 or email [email protected] for showings and disclosures. ** Buyers to pay Mission Bay Community Transfer Tax Fee of .25% of the purchase price. Included in HOA is an additional approx. $32.50 monthly fee paid to MB Maintenance Corporation. **
pba__yearbuilt_pb__c 2012
external_listing__c 1
pba__latitude_property__c 37.7715936
listing_agent_number__c 803645
on_market_date__c 2019-09-06
master_property__c a0O1I000001VhzYUAS
has_3d_tour__c 1
pba__listing_website__c https://my.matterport.com/show/?m=fjC7HD77TxJ
website_property_type__c Condominium
media Array
ListingUpdateDate 2022-06-25T03:36:56
