708 Long Bridge Street #909, San Francisco, CA, 94158 - Property Description

_yoast_indexnow_last_ping,1721991441

ffd_listing_title,480 Mission Bay Boulevard #615, San Francisco, CA, 94158

ffd_mls_id,424051737

ffd_salesforce_id,a0EUd000002fkVbMAI

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,332

address2__c,480 Mission Bay Boulevard #615, San Francisco, CA, 94158

pba__address_pb__c,480 Mission Bay Boulevard #615, San Francisco, CA, 94158

agent_only_remarks__c,Showings by appointment only at The Madrone. Text Maureen to schedule this weekend: Saturday 7/27 & Sunday 7/28 from 12:00 - 3:00. Email Maureen for disclosures. Offers: Use SF Purchase Agreement & include pre-approval, proof of funds, & signed disclosure package. Buyer to pay Mission Bay enhancement fee (0.25% of the selling price) at COE. MB is a Master Plan community. There are 2 HOAs: The Madrone and Mission Bay. An additional monthly fee of $39.13 is paid to MB Maintenance Corp. Pets ok; restrictions apply. Recently installed engineered hardwood floors.

appliances__c,Dishwasher;Microwave;Hood Over Range;Ice Maker;Built-In Refrigerator;Gas Cook Top

architectural_style__c,Contemporary;Modern/High Tech

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,2012

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-07-25T21:49:20.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,One Bedroom PLUS Den at The Madrone! This unique, coveted floor plan offers an extra living area that can be your home office, media room, or to welcome an overnight guest. Bright and sunny, this condo features a spacious, open floor plan, private terrace, two walls of floor-to-ceiling windows, and views of the resort-style pool and the Bay. The chef's kitchen boasts top-of-the-line appliances, chic finishes, and abundant counter space and cabinetry. Enjoy meals sitting at the counter, in the dining area or outside on your lovely terrace. A bonus half bath preserves the bedroom suite - complete with full bath - as your private retreat. An in-unit laundry, air-conditioning, 1-car parking, and storage room complete the package. Here, daily living is easy. Residents of The Madrone enjoy resort-style living in a modern, full-service, elevator building with its heated lap pool and sun deck in the beautifully landscaped, private courtyard, fitness center, BBQ areas, clubroom, business center, and more. Enjoy warm, sunny and vibrant Mission Bay - minutes to food trucks, the Warriors' Chase Center, the Giants' Oracle Park, UCSF, public transportation, freeways, shuttles and downtown.

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile;Wood;See Remarks

hoa_fee_includes__c,Common Areas,Door Person,Elevator,Homeowners Insurance,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Sewer,Trash,Water

pba__hoafees__c,1090

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Madrone Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-07-26T10:48:10.000+0000

pba__latitude_pb__c,37.7715936

pba__latitude_property__c,37.7715936

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Stacked Only

listed_date__c,2024-06-14

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Maureen

pba__listing_agent_lastname__c,Terris

listing_agent_mls_id__c,807435

ffd_listingagentname,Maureen O Terris

listing_agent_number__c,1018292

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,1195000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.3885893

mls_id__c,424051737

master_bathroom_features__c,Tub w/Shower Over;Double Sinks

master_property__c,a0O1I000001VhzYUAS

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-07-25

original_price__c,1195000

overall_days_on_market__c,-82020

parking_access__c,Side by Side

parking_features__c,Enclosed,Side-by-Side

parking_type__c,On Site - Assigned (Condo Only)

patio_and_porch_features__c,Covered Deck

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,1095.33

pba__propertytype__c,Condominium

ListingId,a0EUd000002fkVbMAI

road_surface_type__c,Paved

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,1091

size__c,1091

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Mission Bay

subdist__c,Mission Bay

ffd_name,480 Mission Bay Boulevard #615, San Francisco, CA, 94158

view__c,Bay

website_property_type__c,Condominium

window_features__c,Window Coverings

pba__yearbuilt_pb__c,2012

pba__postalcode_pb__c,94158

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530816537-1.jpg

_yoast_indexnow_last_ping,1721991448

ffd_listing_title,260 King Street #263, San Francisco, CA, 94107

ffd_mls_id,424038010

ffd_salesforce_id,a0EUd000002ffPRMAY

num_of_fireplaces__c,0

num_of_rooms__c,3

of_units__c,595

address2__c,260 King Street #263, San Francisco, CA, 94107

pba__address_pb__c,260 King Street #263, San Francisco, CA, 94107

agent_only_remarks__c,Unit comes with the parking license! Easy to Show - Book your tour on Calendly here > https://calendly.com/260king263/tour | 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-263-zmh3za1x | Buyer pays for MB community enhancement fee 0.25% of purchase price at COE and MB monthly dues of $39.13/mo.

appliances__c,Dishwasher;Microwave;Disposal;Free Standing Refrigerator;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,2024-07-25T20:48:00.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Indulge in the perfect blend of comfort & style in this beautifully designed & renovated 1Br/1Ba condo. Boasting an open & efficient layout, this home offers a seamless flow between spaces w brand new flooring & carpet. Abundant natural light pours thru expansive windows equipped w functional blinds, illuminating every corner. Spacious bedroom boasts a generous walk-in closet, providing ample storage. Freshly painted walls add to the inviting ambiance, while updated lighting fixtures, including new vanity & ceiling lights, enhance the overall atmosphere. The well-appointed bathroom, complete w spa-like tub, is perfect for unwinding. The combined living & dining area is versatile, whether you're entertaining guests or enjoying a quiet night in. The convenience of in-unit washer/dryer, 1 dedicated parking & earthquake insurance included. The Beacon offers top-notch amenities; 24/7 doorman/security, heated outdoor pool & spas, sauna, clubhouse with kitchen, gym, business ctr, landscaped grounds & dog park. Situated in sought-after Mission Bay neighborhood, w direct access to Safeway & proximity to the Embarcadero Waterfront, Ferry Building, Oracle Park, Chase Center, Michelin-starred restaurants, fitness/yoga studios, Caltrain, Muni, T-Line & EZ freeway access to East Bay/Peninsula

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile;Wood

hoa_fee_includes__c,Common Areas,Door Person,Earthquake Insurance,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Organized Activities,Pool,Recreation Facility,Security,Sewer,Trash,Water

pba__hoafees__c,985

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,2024-07-26T10:48:05.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-06-17

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,619000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.3934181

mls_id__c,424038010

main_level__c,Bedroom(s);Kitchen;Living Room;Primary Bedroom

master_bathroom_features__c,Tub w/Shower Over;Tile;Granite

master_property__c,a0O1I000001VhhZUAS

monthly_parking_fees__c,228

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-07-25

open_house_end__c,2024-07-27T13:00:00.000+0000

open_house_start__c,2024-07-27T11:00:00.000+0000

original_price__c,619000

overall_days_on_market__c,-82020

parking_access__c,Side by Side

parking_features__c,Assigned,Attached,Enclosed,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,894.51

pba__propertytype__c,Condominium

ListingId,a0EUd000002ffPRMAY

room_type__c,Kitchen;Living Room;Primary Bathroom;Primary Bedroom

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,692

size__c,692

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 #263, San Francisco, CA, 94107

view__c,City;Downtown;San Francisco

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/530796175-1.jpg

_yoast_indexnow_last_ping,1721948282

ffd_listing_title,300 Channel Street #56, San Francisco, CA, 94158

ffd_mls_id,423749472

ffd_salesforce_id,a0EUd000002fNPKMA2

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,20

address2__c,300 Channel Street #56, San Francisco, CA, 94158

pba__address_pb__c,300 Channel Street #56, San Francisco, CA, 94158

agent_only_remarks__c,Do NOT contact sellers. Active listing agreement in place. Please contact listing agents for questions/showings.

appliances__c,Dishwasher;Disposal;Built-In Refrigerator

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,0

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Michelle Hunter

pba__contingentdate__c,1800-01-01

cooling__c,Ceiling Fan(s),None

ffd_createddate,2024-07-25T16:47:56.000+0000

days_on_market__c,265

dom__c,222

ffd_description_pb,Located on Mission Creek amongst the abundant wildlife of heron and pelican and anchored at the end of the westward dock, you'll find this once in a lifetime residence at Berth #56 within the exclusive Mission Creek floating homes community. Enter the residence to be greeted by a grand open air foyer, with stairs leading down toward two generous sized bedrooms, an office with built in desk and picture window showcasing the creek outside, and one full spacious bathroom. Head upwards to the open air space of the main living area where you'll discover two walk out view decks, an open concept living/dining/kitchen area, and an additional half bath, all flooded with natural light by an array of windows, vaulted ceilings, and views that invite the nature and scenery of the outside in. Rounded out by a floating dock surrounding two fulls sides of the residence where you'll have plenty of room for outdoor living as well as a place to store your kayaks and/or paddle boards Freshly painted interior, with potential for a rooftop deck, don't miss the chance to make this masterful and unique residence on the water your own. Located in the center of Mission Bay, this home is close to Spark Social, Oracle Park, Gus's Market and many restaurants and areas to walk and bike

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Maintenance Grounds,Trash

pba__hoafees__c,610

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Mission Creek Harbor Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Propane

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-07-25T22:47:49.000+0000

pba__latitude_pb__c,37.771202

pba__latitude_property__c,37.771202

laundry_features__c,Stacked Only

listed_date__c,2023-04-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Daniel

pba__listing_agent_lastname__c,Fernandez

listing_agent_mls_id__c,812821

ffd_listingagentname,Danny A Fernandez

listing_agent_number__c,1058378

listing_co_agent_mls_id__c,809692

listing_co_agent_number__c,1042818

listing_co_office_mls_id__c,COMP90

listing_co_office_name__c,Compass

listing_co_office_number__c,29048

listing_office_mls_id__c,COMP90

listing_office_name__c,Compass

listing_office_number__c,29048

pba__listingprice_pb__c,1049000

pba__listingtype__c,Sale

pba__listing_website__c,https://300channel56.com/mls

pba__longitude_pb__c,-122.3965096

lower_level__c,Bedroom(s),Full Bath(s)

mls_id__c,423749472

main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room

master_bathroom_features__c,Bidet;Jetted Tub

master_property__c,a0O1I00000BBvfWUAT

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-11-03

open_house_end__c,2024-07-27T15:00:00.000+0000

open_house_start__c,2024-07-27T13:00:00.000+0000

original_price__c,1249000

overall_days_on_market__c,-81755

parking_access__c,Side by Side

parking_features__c,Unassigned

parking_type__c,On Site - Unassigned (Condo Only)

patio_and_porch_features__c,Roof Deck;Uncovered Deck;Covered Deck

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,2024-07-25T09:38:37.000+0000

price_per_square_foot__c,668.15

pba__propertytype__c,Condominium

ListingId,a0EUd000002fNPKMA2

room_type__c,Office;Kitchen;Living Room;Game Room

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,1570

size__c,1570

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Channel

subdist__c,Mission Bay

ffd_name,300 Channel Street #56, San Francisco, CA, 94158

view__c,Water

website_property_type__c,Condominium

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94158

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530633405-1.jpg

_yoast_indexnow_last_ping,1721869970

ffd_listing_title,250 King Street #1612, San Francisco, CA, 94107

ffd_mls_id,424051382

ffd_salesforce_id,a0EUd000002dQazMAE

num_of_fireplaces__c,0

num_of_rooms__c,3

of_units__c,595

address2__c,250 King Street #1612, San Francisco, CA, 94107

pba__address_pb__c,250 King Street #1612, San Francisco, CA, 94107

agent_only_remarks__c,Easy to show, call or text Jeff at 415.218.6130 to schedule. Keys available for pick up at 260 King St lobby. A few hours lead time is needed to confirm with front desk. Pre-escrow opened with WFG Title - Kathie Ng. Offers to be written on SFAR. There are 2 HOA associations: Beacon Homeowners Association and Mission Bay Maintenance Corp which is $39 a month. Assigned parking fee is $228 per month. Buyers to pay the Mission Bay transfer fee of.25% of Purchase Price at closing. 90 Minutes validated parking available at Safeway with $5 purchase.

appliances__c,Dishwasher;Microwave;Hood Over Range;Free Standing Refrigerator;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,2024-07-23T10:47:42.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Discover penthouse living in this stunning luxury suite on the 16th floor. Enjoy breathtaking views of the Bay and Oracle Park, with abundant natural light streaming through expansive windows. The open, spacious floor plan features recessed lighting and fresh paint throughout. This complex is rich with amenities, including 24-hour security, a fully equipped gym, a heated pool, two spas, sauna, private dog park, clubhouse, and more. Conveniently located, you'll have easy access to Caltrain, Muni, and highways 101 & 280, making transportation a breeze. Plus, you'll be close to a variety of entertainment options such as restaurants, Starbucks, Safeway, and the world famous Embarcadero. Experience the best in comfort and convenience with this exceptional penthouse suite.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Maintenance Grounds,Pool,Recreation Facility,Roof,Security,Sewer,Trash,Water

pba__hoafees__c,1028

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Beacon Residential Community

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Electric

interior_features__c,Elevator

ffd_lastmodifieddate,2024-07-25T00:48:35.000+0000

pba__latitude_pb__c,37.7775963

pba__latitude_property__c,37.7775963

laundry_features__c,Washer/Dryer Stacked Included

listed_date__c,2024-07-22

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jeffrey Gwan

pba__listing_agent_lastname__c,Sie

listing_agent_mls_id__c,809883

ffd_listingagentname,Jeffrey Sie

listing_agent_number__c,1044001

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,MOSAIK

listing_office_name__c,Mosaik Real Estate

listing_office_number__c,27803

pba__listingprice_pb__c,789000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.3930734

mls_id__c,424051382

master_bathroom_features__c,Tub;Walk-In Closet

master_property__c,a0O1I000001VhlYUAS

monthly_parking_fees__c,228

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-07-22

open_house_end__c,2024-07-27T16:00:00.000+0000

open_house_start__c,2024-07-27T13:30:00.000+0000

original_price__c,789000

overall_days_on_market__c,-82017

parking_access__c,Side by Side

parking_features__c,Assigned,Covered,Enclosed,EV Charging,Garage Door Opener,Side-by-Side

parking_type__c,On Site - Assigned (Condo Only);On Site ' Monthly Fee (Condo Only)

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,849.3

pba__propertytype__c,Condominium

ListingId,a0EUd000002dQazMAE

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;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,929

size__c,929

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,King

subdist__c,Mission Bay

ffd_name,250 King Street #1612, San Francisco, CA, 94107

view__c,City;City Lights;Bay;Downtown

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/530815006-1.jpg