meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329584' 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, 401 Harrison Street #25B, San Francisco, CA, 94105
ffd_mls_id, 423715119
ffd_salesforce_id, a0E8W00000a6xLkUAI
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 298
address2__c, 401 Harrison Street #25B, San Francisco, CA, 94105
pba__address_pb__c, 401 Harrison Street #25B, San Francisco, CA, 94105
agent_only_remarks__c, Best floor plan in the Harrison! Vacant, easy to show with a little advanced notice. Please contact Derek (415.244.3000) or Tea (415.702.7028), by appointment only. Furniture is negotiable and can be included in the sale except for the bar cart which is excluded.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2014
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Scott E Morton
pba__contingentdate__c, 2023-03-08
ffd_createddate, 2023-01-12T01:46:29.000+0000
days_on_market__c, 189
dom__c, 65
ffd_description_pb, This 2 bed / 2 bath condominium on the 25th floor offers stunning views of Downtown San Francisco and the Bay, as well as the sleek design and convenience for 21st century modern living. Clean lines throughout are accentuated with wide plank white oak flooring, floor to ceiling windows, and deco reminiscent fixtures that coalesce to create a style and warmth unparalleled in SF. The designer kitchen with Bertazzoni cooking appliances and Sub Zero refrigerator will bring a refined culinary intention to your cooking and entertaining as your guests enjoy sweeping views from every room. The Building: 21st century modern amenity meets Gatsby-like style and service in San Francisco's premier downtown high-rise. The Harrison brings to life the Art Deco design aesthetic that is missing in so many sterile new construction projects, and offers world class concierge service and amenities. Whether you need help getting reservations at that new restaurant, finding someone to babysit, walk the dog while you are on vacation, or basic handyman services, the 24 hour staff is here to help. Amenities such as Uncle Harry's penthouse lounge with panoramic city and bay views, heated outdoor pool, and top of the line workout facility.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
hoa_fee_includes__c, Gas,Insurance,Management,Trash,Water
pba__hoafees__c, 1418
pba__hoafrequency_pb__c, Monthly
hoa_name__c, ONE RINCON HILL TOWER II ASSOCIATION
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-07-13T18:14:06.000+0000
pba__latitude_pb__c, 37.786063
pba__latitude_property__c, 37.786063
listed_date__c, 2023-01-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Derek
pba__listing_agent_lastname__c, Jackson
listing_agent_mls_id__c, 810859
ffd_listingagentname, Derek M Jackson
listing_agent_number__c, 1048512
listing_co_agent_mls_id__c, 804736
listing_co_agent_number__c, 166014407
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.theharrison25b.com/mls/86221706
pba__longitude_pb__c, -122.392176
mls_id__c, 423715119
master_property__c, a0O1I000001VhhCUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-11
original_price__c, 1795000
overall_days_on_market__c, -81459
parking_access__c, Independent
parking_features__c, Valet
parking_type__c, On Site - Unassigned (Condo Only)
pba__pendingdate__c, 2023-03-17
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1296.72
pba__propertytype__c, Condominium
ListingId, a0E8W00000a6xLkUAI
sale_date__c, 2023-04-07
sale_price__c, 1700000
selling_agent_mls_id__c, 817253
selling_agent_number__c, 1076147
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Leading Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1311
size__c, 1311
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Harrison
subdist__c, South Beach
ffd_name, 401 Harrison Street #25B, San Francisco, CA, 94105
view__c, City;Bay;Downtown;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2014
pba__postalcode_pb__c, 94105
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530568052-1.jpg