meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214507' 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, 555 4th Street #403, San Francisco, CA, 94107
ffd_mls_id, 505306
ffd_salesforce_id, a0E1I00000THmOrUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 302
address2__c, 555 4th Street #403, San Francisco, CA, 94107
pba__address_pb__c, 555 4th Street #403, San Francisco, CA, 94107
agent_only_remarks__c, Please send PEAD. Easy showing at the same day. Email listing agent for showing instructions. Virtual staged photos. Offers to be reviewed as it comes. Email offers to [email protected]. Text listing agent Steven Tam at 415-300-0238. Escrow opened at First American Title with Aileen Michael.
appliances__c, Electric Range;Refrigerator;Hood Over Range;Cooktop Stove;Built-In Oven;Self/Cont Clean Oven
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2006
building_name__c, The Palms San Francisco
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-22T00:56:47.000+0000
days_on_market__c, 1031
dom__c, 4
ffd_description_pb, The Palms San Francisco - Full Service Building - Includes 24 hour door person, Social Lounge, Fitness Center, Yoga Studio, 24 hrs Business Center and 20 Seat Theatre. This beautiful 2 bedroom 2 bathroom residence is ideal for entertaining, has plenty of natural light, and a balcony. Kitchen has all stainless appliances and Quartz Countertops. Master bedroom includes an in-suite bath and closets with built-in custom organizers. Washer/Dryer in closet. 1-Car Parking. Low HOA dues and a great location for commuters - walking distance to Caltrain station. Virtual Tour Link: https://www.asteroommls.com/pviewer?token=o13YCFKj5UmA0daOVNl63w
district__c, SF District 9
entry_level__c, 9
external_listing__c, 1
pba__floor__c, 9
pba__floortype_pb__c, Wood
hoa_dues__c, 674.92
hoa_fee_includes__c, Door Person,Maintenance Exterior,Trash,Maintenance Grounds,Water
pba__hoafees__c, 674
pba__hoafrequency_pb__c, Monthly
hoa_name__c, The Palms Homeowner Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:33:13.000+0000
pba__latitude_pb__c, 37.779431
pba__latitude_property__c, 37.779431
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Steven
pba__listing_agent_lastname__c, Tam
listing_agent_mls_id__c, 812620
ffd_listingagentname, Steven Tam
listing_agent_number__c, 1057399
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REGO10
listing_office_name__c, RE/MAX Gold Daly City
listing_office_number__c, 27468
pba__listingprice_pb__c, 1050000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.asteroommls.com/pviewer?token=o13YCFKj5UmA0daOVNl63w
pba__longitude_pb__c, -122.396905
pba__lotsize_pb__c, 0
mls_id__c, 505306
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001VhjeUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-21
original_price__c, 1050000
overall_days_on_market__c, 346
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-09-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1088.69
pba__propertytype__c, Condominium
id, a0E1I00000THmOrUAL
sale_date__c, 2020-10-23
sale_price__c, 1068000
selling_agent_mls_id__c, 805965
selling_agent_name__c, Tim M. Heffernan
selling_agent_number__c, 166016071
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Real Estate Advisor Group
pba__status__c, Closed
pba__totalarea_pb__c, 981
size__c, 981
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 4th
subdist__c, South Beach
ffd_name, 555 4th Street #403, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, 403
view__c, City Lights
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2006
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369618-1.jpg
ListingId, a0E1I00000THmOrUAL