meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340069' 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] => Brilliantly-planned triumph or mid-rise suburban-esque modern stucco nightmare? Welcome to San Francisco's nearly newest neighborhood (the newest is Yerba Buena Island and that is a different page). Mission Bay is redeveloped former railroad land and is anchored by UCSF's Mission Bay campus.
Sunny weather, new to newer construction, 47 acres of parks and recreation areas, and an arena for our Golden State Warriors. A wonderful neighborhood for families with kids and pets. Retail shops for every need are within easy access, also cafes, restaurants, and entertainment are close.
On the east side of San Francisco, you will find 303 acres that is now Mission Bay. Before it was a railroad yard and industrial area in the 20th century, Mission Bay was hundreds of acres of marshland with year-round tidal waters.
[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-10-31 11:06:24
[post_modified_gmt] => 2023-10-31 18:06:24
[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
(
)
)
_yoast_indexnow_last_ping, 1701472395
ffd_listing_title, 250 King Street #1410, San Francisco, CA, 94107
ffd_mls_id, 423912326
ffd_salesforce_id, a0E8W00000dUSdUUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 595
address2__c, 250 King Street #1410, San Francisco, CA, 94107
pba__address_pb__c, 250 King Street #1410, San Francisco, CA, 94107
agent_only_remarks__c, Escrow has been opened with Chicago Title Co., Michael Yip, escrow #3552300612. Please visit www.250King1410.com
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Refrigerator;Ice Maker;Self/Cont Clean Oven;Free Standing Electric Oven;Free Standing Electric Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2004
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-13T01:48:33.000+0000
days_on_market__c, 50
dom__c, 50
ffd_description_pb, Price Reduced! Welcome home to breathtaking panoramic city views and world-class amenities in this stunning & sophisticated rare to find north facing VIEW residence. The condominium boasts an expansive great room drenched in ambient sunlight, brand new wide-planked engineered flooring throughout, and a Chef's Kitchen including stainless steel appliances, granite countertops, ample newly painted cabinetry, and under cabinet lighting. With a wall of sleek windows, the living space capitalizes on sensational urban views of the entire downtown skyline, city lights, and peek-a-boo views of Twin Peaks, Sutro Tower, and the Bay Bridge! One luxurious bedroom with dramatic city views & an expansive outfitted walk-in closet, one sumptuous spa-like bath, multiple storage closets, in-unit laundry, and a prime parking space too. Additional features include: new paint, new engineered flooring, new light fixtures & recessed lighting, new cabinet hardware, and built-in window seating. Enjoy the vibrant Mission Bay neighborhood, Oracle Park, Chase Center, Ferry Plaza building, and first-class amenities: 24-hour door attendant, heated pool & spas, fitness & business centers, dog park, lush courtyard, and more!
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Uncovered Courtyard;Dog Run;Kitchen
external_listing__c, 1
pba__floortype_pb__c, Simulated Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Insurance,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Sewer,Trash,Water
pba__hoafees__c, 826
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Beacon Residential Community Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Electric;MultiZone
ffd_lastmodifieddate, 2023-12-01T22:47:10.000+0000
pba__latitude_pb__c, 37.778333
pba__latitude_property__c, 37.778333
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-09-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marla
pba__listing_agent_lastname__c, Moresi-Valdes
listing_agent_mls_id__c, 802988
ffd_listingagentname, Marla Moresi-Valdes
listing_agent_number__c, 802988
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 750000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/873733763
pba__longitude_pb__c, -122.393047
mls_id__c, 423912326
main_level__c, Full Bath(s);Kitchen;Living Room;Retreat;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Closet;Granite
master_property__c, a0O1I000001VhlYUAS
monthly_parking_fees__c, 218
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-10-12
open_house_end__c, 2023-12-03T16:00:00.000+0000
open_house_start__c, 2023-12-03T14:00:00.000+0000
original_price__c, 819000
overall_days_on_market__c, -81733
parking_access__c, Independent
parking_features__c, Assigned,Attached,Covered,Interior Access,Side-by-Side
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, 912.41
pba__propertytype__c, Condominium
ListingId, a0E8W00000dUSdUUAW
room_type__c, Kitchen;Living Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Fire Alarm;Secured Access;Carbon Mon Detector
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, 822
size__c, 822
spa__c, 1
pba__state_pb__c, CA
stories__c, 16
pba__street_pb__c, King
subdist__c, Mission Bay
ffd_name, 250 King Street #1410, San Francisco, CA, 94107
view__c, City;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Twin Peaks;Hills;Sutro Tower
website_property_type__c, Condominium
window_features__c, Dual Pane Full
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/530691855-1.jpg