meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221482' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15713
[post_author] => 4
[post_date] => 2018-11-02 19:54:26
[post_date_gmt] => 2018-11-02 19:54:26
[post_content] => San Francisco's South Beach of today is a far cry from the South Beach of 25 years ago. Once South Beach was storage yards, warehouses, and crumbling piers. Today, gleaming glass towers and soulful conversion lofts have transformed it into one of the most desired destinations in San Francisco.
[post_title] => South Beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => south-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-05 12:56:49
[post_modified_gmt] => 2024-04-05 19:56:49
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15713
[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, 88 King Street #304, San Francisco, CA, 94107
ffd_mls_id, 421601104
ffd_salesforce_id, a0E8W00000V0g3BUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 235
address2__c, 88 King Street #304, San Francisco, CA, 94107
pba__address_pb__c, 88 King Street #304, San Francisco, CA, 94107
agent_only_remarks__c, Please call or text Jamie Ennis to show (415) 290-7282. Built as a 2-bedroom, legally remains a 2-bedroom while functions as a 1-bedroom (wall to 2nd bedroom was removed to provide an open, gracious living area) but could be added back. Custom-built cabinet opens to second bed for guests. More info at SouthBeachLuxeLiving.com. Will update weekend open house times for October 16 and 17th. This is a very special residence, different than the rest in the complex due to its custom finishes and features originally designed to set the tone for the entire complex. Resort like living with fantastic amenities offerings, this unit is on the same level as the majority of the amenities. Great for Giants fans with an incredible view of the ballpark but amazing and beautiful residence even for those non-baseball fans. In unit laundry, parking and deeded storage across the hall from the unit included.
appliances__c, Dishwasher;Microwave;Disposal;Electric Cook Top;Built-In Refrigerator;Built-In Freezer;Built-In Electric Oven
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2000
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-10-07T22:50:02.000+0000
days_on_market__c, 650
dom__c, 47
ffd_description_pb, Rare opportunity. Expansive open living/dining/entertainment area provides floor-to-ceiling bay windows with abundance of natural light, wet bar and west-facing deck with spectacular view of the entire SF Giants ballpark and city architecture. Built as a 2-bedroom, legally remains a 2-bedroom while functions as a 1-bedroom (wall to 2nd bedroom was removed to provide an open, gracious living area). Custom-built cabinet opens to second bed for guests. This stunning residence was a model unit and contains specially appointed features not found in others including wall-to-wall built-ins, unique bathroom finishes, removable window bench, and stained wood floors.Chef's kitchen with Sub-Zero refrigerator/freezer, Gaggenau cooktop, oven and dishwasher. Large bedroom, room for king bed, seating with built-in cabinetry, wall fireplace. Two full bathrooms. Same floor as pool, spa, barbecue, fireplace, sauna. Overnight valet. Home office space options. 1 car parking, storage unit, in-unit laundry
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood;Painted/Stained
hoa_fee_includes__c, Common Areas,Door Person,Insurance,Internet,Maintenance Exterior,Maintenance Grounds,Management,Organized Activities,Pool,Recreation Facility,Security,Trash,Water
pba__hoafees__c, 1125
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2022-01-25T16:04:00.000+0000
pba__latitude_pb__c, 37.78063
pba__latitude_property__c, 37.78063
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-10-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jamie
pba__listing_agent_lastname__c, Ennis
listing_agent_mls_id__c, 815382
ffd_listingagentname, Jamie Ennis
listing_agent_number__c, 1072670
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1325000
pba__listingtype__c, Sale
pba__listing_website__c, http://southbeachluxeliving.com
pba__longitude_pb__c, -122.389625
mls_id__c, 421601104
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Tile;Soaking Tub
master_property__c, a0O1I000001VhiIUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-10-07
original_price__c, 1325000
overall_days_on_market__c, 85
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,EV Charging,Garage Door Opener,Garage Facing Front,Interior Access,Valet
parking_type__c, On Site - Unassigned (Condo Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 2021-11-23
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1157.21
pba__propertytype__c, Condominium
id, a0E8W00000V0g3BUAR
room_type__c, Storage;Kitchen;Master Bathroom;Master Bedroom;Possible Guest;Great Room
sale_date__c, 2021-12-07
sale_price__c, 1325000
security_features__c, Security Fence;Secured Access;Video System;Guarded Gate;Security Patrol
selling_agent_mls_id__c, 814864
selling_agent_number__c, 1068736
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1145
size__c, 1145
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, King
subdist__c, South Beach
ffd_name, 88 King Street #304, San Francisco, CA, 94107
view__c, City;Panoramic;City Lights;Bay;Water;Downtown;San Francisco;Other
website_property_type__c, Condominium
window_features__c, Window Coverings;Bay Window(s)
pba__yearbuilt_pb__c, 2000
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530337099-1.jpg
ListingId, a0E8W00000V0g3BUAR