meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217199' 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 #368, San Francisco, CA, 94107
ffd_mls_id, 421520105
ffd_salesforce_id, a0E1I00000TwJ6VUAV
num_of_fireplaces__c, 0
num_of_rooms__c, 2
of_units__c, 595
address2__c, 250 King Street #368, San Francisco, CA, 94107
pba__address_pb__c, 250 King Street #368, San Francisco, CA, 94107
agent_only_remarks__c, Contact Eric for showings 415 609-8796, [email protected]. Buyer to pay 0.25% of sale price as Mission Bay transfer fee at Close of escrow, and Mission Bay Community enhance fee of $35.37/mo.
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Electric Range
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2004
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-04-01
ffd_createddate, 2021-03-05T12:59:39.000+0000
days_on_market__c, 866
dom__c, 47
ffd_description_pb, Enjoy this bright Jr one-bedroom with an excellent value in the heart of Mission Bay! Residence 368 boasts an efficient and open layout with an abundance of natural light. It also has a well configured and designated sleeping alcove, ample closet space & storage, and higher ceiling. Beacon is a full service building with full amenities including heated pool, fitness center, spa, conference center, dog-walk, concierge, and more. Conveniently located with tons of retail and conveniences: Safeway, Starbucks, banks and more, and is only steps to CalTrain, Embarcadero, Oracle Park, walk score 92! In-unit laundry and one-car parking are included.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
hoa_fee_includes__c, Door Person,Earthquake Insurance,Maintenance Exterior,Maintenance Grounds,Management,Organized Activities,Security,Trash,Water,Other
pba__hoafees__c, 799
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Action Property
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2022-01-25T15:45:09.000+0000
pba__latitude_pb__c, 37.778123
pba__latitude_property__c, 37.778123
listed_date__c, 2021-02-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Li
listing_agent_mls_id__c, 808554
ffd_listingagentname, Eric Li
listing_agent_number__c, 1036714
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 610000
pba__listingtype__c, Sale
pba__listing_website__c, http://250king-368.com
pba__longitude_pb__c, -122.393148
mls_id__c, 421520105
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0O1I000001VhlYUAS
monthly_parking_fees__c, 197.56
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-03-05
original_price__c, 610000
overall_days_on_market__c, 68
parking_access__c, Independent
parking_features__c, Attached,Enclosed
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-04-21
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1030.41
pba__propertytype__c, Condominium
id, a0E1I00000TwJ6VUAV
sale_date__c, 2021-04-27
sale_price__c, 610000
selling_agent_mls_id__c, 802954
selling_agent_number__c, 802954
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 592
size__c, 592
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, King
subdist__c, Mission Bay
ffd_name, 250 King Street #368, San Francisco, CA, 94107
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/530184501-1.jpg
ListingId, a0E1I00000TwJ6VUAV