meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331882' 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] => 2023-06-01 11:17:15
[post_modified_gmt] => 2023-06-01 18:17:15
[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, 170 King Street #711, San Francisco, CA, 94107
ffd_mls_id, 423733339
ffd_salesforce_id, a0E8W00000awJTlUAM
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 198
address2__c, 170 King Street #711, San Francisco, CA, 94107
pba__address_pb__c, 170 King Street #711, San Francisco, CA, 94107
agent_only_remarks__c, Easy to Show w 24 hr notice (temporary occupant prefers showings during 9-4pm on weekdays) - Book your tour on Calendly here >https://calendly.com/170king711/tour | Showing needs to be confirmed in separate email/text and 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 7 page contract. Escrow opened with Mijael Schmidt at First American Title. Pls follow offer instructions on the disclosure.io > https://app.disclosures.io/link/170-King-Street-711-4cuwy3kj
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2007
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-19T00:49:01.000+0000
days_on_market__c, 21
dom__c, 20
ffd_description_pb, Thoughtfully & stylishly upgraded 2BR residence w fresh paint features an open floor plan with expansive windows that offer breathtaking views of Oracle Park, Willie Mays Plaza, Potrero Hill, and San Francisco Bay. Boasting oak hardwood floors, perfect office area with a window and a modern Chef's kitchen with gas appliances, an island, and granite countertops. Primary bedroom w walk-through closet and en-suite bathroom with dual sink vanity. The second Bedroom makes for a great guest rm or spacious office with ample closet space & natural light. Custom closet organizers, in-unit washer/dryer, gas & secured parking space, included in HOA. 5-star full amenity building; a movie theater, fitness center, 40 ft heated lap pool, hot tub, art-filled courtyard w bbq area, clubhouse/lounge with kitchen + fireplace, and panoramic roof deck w expansive city views. Experience city life at its finest with this exceptional condo just steps away from Caltrain, Muni, and the future Central Subway. Walkable to Safeway, Oracle Park & some of SF's best Michelin Star restaurants + finest fitness/yoga studios. Enjoy a short walk to the Ferry Building/Farmer's Market, Embarcadero Waterfront, Chase Center, Salesforce Transit Center featuring an amenity-rich public 5.4-acre rooftop park and Union Square
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Elevator,Gas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Security,Sewer,Trash,Water
pba__hoafees__c, 845
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 170 Thrid Off HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-06-08T00:49:52.000+0000
pba__latitude_pb__c, 37.778695
pba__latitude_property__c, 37.778695
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-04-11
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, 1025000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.391619
mls_id__c, 423733339
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Primary Bedroom
master_property__c, a0O1I000001VhnuUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-05-18
open_house_end__c, 2023-06-10T15:00:00.000+0000
open_house_start__c, 2023-06-10T13:00:00.000+0000
original_price__c, 1025000
overall_days_on_market__c, -81586
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener,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, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000awJTlUAM
room_type__c, Kitchen;Living Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
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, 0
size__c, 0
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, King
subdist__c, South Beach
ffd_name, 170 King Street #711, San Francisco, CA, 94107
view__c, City;City Lights;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2007
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530608618-1.jpg
