meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214626' 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, 260 King Street #649, San Francisco, CA, 94107
ffd_mls_id, 502971
ffd_salesforce_id, a0E1I00000THi37UAD
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 595
address2__c, 260 King Street #649, San Francisco, CA, 94107
pba__address_pb__c, 260 King Street #649, San Francisco, CA, 94107
agent_only_remarks__c, Submitting proof of funds or loan pre-approval and the SFAR Purchase Agreement is recommended. Buyer will pay the Mission Bay Community Enhancement Fee of .25% of the purchase price and the Mission Bay Maintenance Corporation Fee of $34.97/month. Pre-escrow is opened with Sylvia Wong at Fidelity National Title Company. Please call or text Justin for all COVID-compliant showings. Please visit www.260King649.com for video and virtual tours.
appliances__c, Dishwasher;Electric Range;Microwave;Disposal;Refrigerator;Hood Over Range;Ice Maker;Freezer;Self/Cont Clean Oven
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2004
building_name__c, The Beacon
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-30
ffd_createddate, 2020-09-12T19:47:04.000+0000
days_on_market__c, 1040
dom__c, 28
ffd_description_pb, Spread out in this open-flow condo with 2 BRs, 2 full BAs, and a den for home working. Watch the fog roll in over Twin Peaks from either BR or the spacious living/dining area. The kitchen features granite countertops, Bosch s/s range and range hood/microwave, a dual Fisher & Paykel dishwasher, and GE s/s fridge. The primary BR has a renovated en suite BA, WIC with an Elfa custom closet system, and motorized window shades. Ample storage throughout (the second BR also has a huge WIC). The Beacon lifestyle includes access to a heated lap pool, hot tubs, sauna, gym, business center, private dog run, clubhouse, and even a security robot! HOA fees include 24-hour doorman and earthquake insurance. While Safeway, Tender Greens, Umami Burger are right in the building, Gus's Market, Whole Foods, and Mission Bay Wine and Cheese are also nearby. Convenient Mission Bay location provides easy assess to the Peninsula, South Bay, and East Bay via CalTrain, the future Muni Central Subway, and the 280.
district__c, SF District 9
electric__c, 220 Volts in Laundry
entry_level__c, 6
external_listing__c, 1
pba__floor__c, 6
hoa_dues__c, 932.57
hoa_fee_includes__c, Management,Door Person,Earthquake Insurance,Maintenance Exterior,Trash,Maintenance Grounds,Homeowners Insurance,Organized Activities,Security,Water
pba__hoafees__c, 932
pba__hoafrequency_pb__c, Monthly
hoa_name__c, The Beacon Residential HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Electric;Wall Furnace
ffd_lastmodifieddate, 2022-01-25T15:33:41.000+0000
pba__latitude_pb__c, 37.778014
pba__latitude_property__c, 37.778014
laundry_appliances__c, 220 Volt Wiring,Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-08-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Justin
pba__listing_agent_lastname__c, Welch
listing_agent_mls_id__c, 812198
ffd_listingagentname, Justin Welch
listing_agent_number__c, 1055448
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1050000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=FoBiHwFhXqq&mls=1
pba__longitude_pb__c, -122.39151483
pba__lotsize_pb__c, 0
mls_id__c, 502971
master_property__c, a0O1I000001VhhZUAS
monthly_parking_fees__c, 188.15
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-12
original_price__c, 1050000
overall_days_on_market__c, 142
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-10-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 828.59
pba__propertytype__c, Condominium
id, a0E1I00000THi37UAD
room_type__c, Den
sale_date__c, 2020-11-12
sale_price__c, 1020000
selling_agent_mls_id__c, 806899
selling_agent_name__c, Sergio R. Giannoni
selling_agent_number__c, 166017824
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1231
size__c, 1231
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, King
subdist__c, Mission Bay
ffd_name, 260 King Street #649, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, 649
view__c, Twin Peaks
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/369912-1.jpg
ListingId, a0E1I00000THi37UAD