_yoast_indexnow_last_ping,1736597885
ffd_listing_title,260 King Street #557, San Francisco, CA, 94107
ffd_mls_id,424073986
ffd_salesforce_id,a0EUd000003euZhMAI
num_of_fireplaces__c,0
num_of_rooms__c,3
of_units__c,595
address2__c,260 King Street #557, San Francisco, CA, 94107
pba__address_pb__c,260 King Street #557, San Francisco, CA, 94107
agent_only_remarks__c,Credits to Buyers Considered | Unit comes with the parking license & Air Conditioning (ask agent for more info)! Easy to Show - Book your tour on Calendly here > https://calendly.com/260king557 | Showing needs to be confirmed in separate email/text and Pls follow showing instructions you receive via email for the key access at 260 King front desk. Call/text Mia 415.728.2596 | [email protected] for more info. Offers to be on most recent SFAR contract. Escrow opened with Michael Yip at Chicago Title. Pls follow offer instructions on the disclosure.io > https://app.disclosures.io/link/260-King-Street-557-39r9lbpg | Buyer pays for MB community enhancement fee 0.25% of purchase price at COE and MB monthly dues of $40.54/mo.
appliances__c,Dishwasher;Microwave;Disposal;Free Standing Refrigerator;Ice Maker;Free Standing Electric Range
architectural_style__c,Contemporary;Modern/High Tech
bath_features__c,Tub w/Shower Over;Tile;Radiant Heat;Quartz
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
cooling__c,Central
ffd_createddate,2024-11-20T23:25:01.000+0000
days_on_market__c,57
dom__c,57
ffd_description_pb,Experience the pinnacle of luxury living in this impeccably renovated corner home in Mission Bay, offering breathtaking views frm Twin Peaks to Oracle Park. Spanning 1,104 SF, this expansive 1BR + Office/1.5BA home feat. over $100,000 in high-end upgrades. The open-concept living are feat. wrap-around floor-to-ceiling windows that showcase stunning city vistas. The chef's kitchen is a masterpiece, featuring custom cabinetry by Gao Cabinets, high-end SS appliances, quartz countertops, and a custom backsplash, all set against sleek porcelain flooring. The master suite is a serene retreat with panoramic city views, a walk-in closet with custom organizers, and a luxurious spa-like bathroom with radiant heated floors, custom cabinetry, and a walk-in shower with seating. Add'l highlights include a dedicated home office, AC, custom lighting, wood flooring, ample storage, in-unit laundry & a convenient guest half-bath. Enjoy five-star amenities at Beacon; heated outdoor pool, fitness center, spas, sauna, business center, clubhouse, dog park, and 24/7 concierge & security. W parking included & EZ access to Caltrain, Muni, BART & major freeways, this home offers the perfect blend of modern luxury & urban convenience, just steps frm SF's waterfront, best dining, shopping & entertainment!
district__c,SF District 9
driveway_sidewalks__c,Gated
entry_level__c,0
external_listing__c,1
pba__floortype_pb__c,Tile;Wood
hoa_fee_includes__c,Door Person,Earthquake Insurance,Elevator,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Organized Activities,Pool,Roof,Security,Sewer,Trash,Water
pba__hoafees__c,1069
pba__hoafrequency_pb__c,Monthly
hoa_name__c,The Beacon Homeowners association
hoa__c,Yes
pba__halfbathrooms_pb__c,0
has_monthly_parking_fees__c,1
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2025-01-11T11:47:59.000+0000
pba__latitude_pb__c,37.7776422
pba__latitude_property__c,37.7776422
laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included
listed_date__c,2024-11-15
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Miyuki Mia
pba__listing_agent_lastname__c,Takami
listing_agent_mls_id__c,806485
ffd_listingagentname,Miyuki Mia Takami
listing_agent_number__c,166017050
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,EXPRE
listing_office_name__c,eXp Realty of California, Inc
listing_office_number__c,26334
pba__listingprice_pb__c,858000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.3934181
mls_id__c,424073986
main_level__c,Full Bath(s);Bedroom(s)
master_bathroom_features__c,Quartz;Radiant Heat;Stone
master_property__c,a0O1I000001VhhZUAS
monthly_parking_fees__c,228
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2024-11-15
open_house_end__c,2025-01-11T13:00:00.000+0000
open_house_start__c,2025-01-11T11:00:00.000+0000
original_price__c,858000
overall_days_on_market__c,-82133
parking_access__c,Side by Side
parking_features__c,Assigned,Garage Door Opener,Interior Access,Private,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,777.17
pba__propertytype__c,Condominium
ListingId,a0EUd000003euZhMAI
sale_date__c,1800-01-01
sale_price__c,0
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,1104
size__c,1104
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 #557, San Francisco, CA, 94107
view__c,City;Panoramic;City Lights;San Francisco;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/530896220-1.jpg