meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213844' 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] => 2024-03-07 14:08:53
[post_modified_gmt] => 2024-03-07 22:08:53
[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, 250 King Street #912, San Francisco, CA, 94107
ffd_mls_id, 503100
ffd_salesforce_id, a0E1I00000S1243UAB
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 595
address2__c, 250 King Street #912, San Francisco, CA, 94107
pba__address_pb__c, 250 King Street #912, San Francisco, CA, 94107
agent_only_remarks__c, Visit: https://tours.tourspace.net/public/vtour/display/1660773 Buyer shall pay Mission Bay community enhancement fee of .25% of the purchase price and the Mission Bay maintenance corporation fee of $35.37 monthly.
appliances__c, Dishwasher;Microwave;Disposal
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub;Granite
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2004
building_name__c, Beacon
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-04-08
ffd_createddate, 2020-08-12T16:50:54.000+0000
days_on_market__c, 1080
dom__c, 273
ffd_description_pb, Ideal for entertaining, this stunning and spacious home boasts a superior open floor plan with custom built-ins throughout. The modern kitchen features granite countertops and stainless steel appliances. The oversized master bedroom offers a tremendous light-filled space with a sizable walk-in closet and a spacious master bathroom with a soaking tub and in-unit washer/dryer. The Beacon's luxury amenities include heated pool and spa, 24-hour doorman, well maintained and equipped fitness center, clubhouse, conference center, concierge, dog run, and 24-hour security. Location is a commuter's dream, a block from Muni/CalTrain, Oracle Park, Safeway, close to Bay Bridge, 101/280 onramps, Walk to major tech companies, free Mission Bay shuttle to Financial District & BART. Walk Score of 95; Bike Score of 94; Transit Score of 97. Live in vibrant & convenient Mission Bay! Priced to sell.
district__c, SF District 9
entry_level__c, 9
external_listing__c, 1
pba__floor__c, 9
hoa_dues__c, 850.37
pba__hoafees__c, 850
hoa_name__c, Beacon RCA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:30:11.000+0000
pba__latitude_pb__c, 37.77802583
pba__latitude_property__c, 37.77802583
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet
listed_date__c, 2020-08-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Masoumeh
pba__listing_agent_lastname__c, Pahlbod
listing_agent_mls_id__c, 404560
ffd_listingagentname, Masti M Pahlbod
listing_agent_number__c, 404560
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SANF
listing_office_name__c, Engel & Voelkers San Francisco
listing_office_number__c, 25914
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__listing_website__c, https://tours.tourspace.net/public/vtour/display/1660773
pba__longitude_pb__c, -122.391244
pba__lotsize_pb__c, 0
mls_id__c, 503100
master_property__c, a0O1I000001VhlYUAS
monthly_parking_fees__c, 197.56
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-03
original_price__c, 895000
overall_days_on_market__c, 301
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-05-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 878.38
pba__propertytype__c, Condominium
id, a0E1I00000S1243UAB
sale_date__c, 2021-05-03
sale_price__c, 780000
selling_agent_mls_id__c, 815097
selling_agent_number__c, 1070733
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Berri Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 888
size__c, 888
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, King
subdist__c, Mission Bay
ffd_name, 250 King Street #912, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, 912
view__c, City Lights;Garden/Greenbelt
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2004
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/367757-1.jpg
ListingId, a0E1I00000S1243UAB