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] => 2023-06-23 10:34:13
[post_modified_gmt] => 2023-06-23 17:34:13
[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, 207 King Street #501, San Francisco, CA, 94107
ffd_mls_id, 423900297
ffd_salesforce_id, a0E8W00000cqNq1UAE
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 36
address2__c, 207 King Street #501, San Francisco, CA, 94107
pba__address_pb__c, 207 King Street #501, San Francisco, CA, 94107
agent_only_remarks__c, Over $116K in upgrades! Easy to Show - Book your tour on Calendly here > https://calendly.com/207king501/tour | Showing needs to be confirmed in separate email/text and shown by agent. Pls follow showing instructions you receive via email for the access. Call/text Mia 415.728.2596 | [email protected] for more info. Offers to be on SFAR contract. Escrow opened with Mijael Schmidt at First American Title. Pls follow offer instructions on the disclosure.io >https://app.disclosures.io/link/207-King-Street-501-85i416mq 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;Hood Over Range;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Free Standing Electric Oven;Free Standing Electric Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Split Bath;Tile;Low-Flow Toilet(s);Stone
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2003
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-09-06T22:46:50.000+0000
days_on_market__c, 8
dom__c, 8
ffd_description_pb, Dramatic & Rarely Avail. 2-level 2BR residence w soaring ceilings & walls of expansive windows at iconic Glassworks. Step inside this meticulously renovated residence ($116K+ in upgrades!) that epitomizes modern living perfection, adorned w beautiful French Oak flrs, luxurious new baths, designer wallpapers & mirrored walls. The kitchen boasts gorgeous granite countertops, sleek cabinets, top-of-the-line SS appliances. Spacious living/dining area features extra high ceilings & captivating SF views, making it an ideal setting for hosting gatherings. Exquisitely remodeled half bath, embellished w elegant marble countertops & Kohler smart toilet. Upstairs, are the generously sized bedrooms that offer Twin Peaks & City views & spacious walk-in closets. Master bath boasts double sinks, marble countertops, designer walk-in shower & custom cabinets, ensuring a dream-like spa experience. This one-of-a-kind Waterfront residence offers AC, CA Closet systems in all closets & beneath the stairs, new W/D, electronic blinds, custom stairs w runner, Barn door, onsite parking & extra LG storage unit. Located in heart of vibrant Mission Bay, steps frm Embarcadero/playground/dog parks, Giants Park/Warriors Chase Ctr, Michelin restaurants, finest fitness studios + Caltrains, Muni, T-Line/freeway
district__c, SF District 9
driveway_sidewalks__c, Gated
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood;Stone
hoa_fee_includes__c, Door Person,Electricity,Gas,Maintenance Exterior,Maintenance Grounds,Management,Security,Trash,Water
Dramatic & Rarely Avail. 2-level 2BR residence w soaring ceilings & walls of expansive windows at iconic Glassworks. Step inside this meticulously renovated residence ($116K+ in upgrades!) that epitomizes modern living perfection, adorned w beautiful French Oak flrs, luxurious new baths, designer wallpapers & mirrored walls. The kitchen boasts gorgeous granite countertops, sleek cabinets, top-of-the-line SS appliances. Spacious living/dining area features extra high ceilings & captivating SF views, making it an ideal setting for hosting gatherings. Exquisitely remodeled half bath, embellished w elegant marble countertops & Kohler smart toilet. Upstairs, are the generously sized bedrooms that offer Twin Peaks & City views & spacious walk-in closets. Master bath boasts double sinks, marble countertops, designer walk-in shower & custom cabinets, ensuring a dream-like spa experience. This one-of-a-kind Waterfront residence offers AC, CA Closet systems in all closets & beneath the stairs, new W/D, electronic blinds, custom stairs w runner, Barn door, onsite parking & extra LG storage unit. Located in heart of vibrant Mission Bay, steps frm Embarcadero/playground/dog parks, Giants Park/Warriors Chase Ctr, Michelin restaurants, finest fitness studios + Caltrains, Muni, T-Line/freeway
Main Level: Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room
Pool: Yes
Interior Features
Interior Features
Heating: Central;Electric
Appliances: Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Free Standing Electric Oven;Free Standing Electric Range
Laundry Features: Laundry Closet;Washer/Dryer Stacked Included
Spa: Yes
Bath Features: Tub w/Shower Over;Split Bath;Tile;Low-Flow Toilet(s);Stone
Cooling: Central
Flooring: Tile;Wood;Stone
Primary Bathroom Features: Tub w/Shower Over;Shower Stall(s);Tile;Stone
