meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331290' 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, 540 Delancey Street #401, San Francisco, CA, 94107
ffd_mls_id, 423715615
ffd_salesforce_id, a0E8W00000a72qRUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 16
address2__c, 540 Delancey Street #401, San Francisco, CA, 94107
pba__address_pb__c, 540 Delancey Street #401, San Francisco, CA, 94107
agent_only_remarks__c, Please submit any offer on SFAR contract with pre-approval/VOF, signed Disclosures Summary, and note that fully signed disclosure package to be returned within 24 hours of ratification.
architectural_style__c, Modern/High Tech;Conversion;Vintage
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 1
year_build_text__c, 1892
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-04-10
ffd_createddate, 2023-01-14T20:46:12.000+0000
days_on_market__c, 186
dom__c, 105
ffd_description_pb, The South End Warehouse, originally built in 1892, was converted to brick-and-timber lofts in 1997, using reclaimed gymnasium wood floors, shoji-style walls, glass barn slider doors, and custom cabinetry. This top floor corner unit retains industrial design elements, like exposed wood beams, pipes, concrete, and high ceilings in all their glory. Spanning two open levels connected via a dramatic staircase, the loft features a generous entertaining "great room" with outstanding light, tree top views, and large industrial & transom windows opening to a large private patio. The entertaining Bulthaup kitchen has a sizeable island, tremendous storage with built-ins, stone counters, and Miele/Sub-Zero appliances -- including a wine fridge. There is room for an office area, and a full guest bath with laundry complete this level. The reclaimed wood floors continue to the upper level and into the bedroom suite, which offers a custom walk-in closet, a luxe bathroom, and large windows to the outdoor terrace with peek-a-boo Bay and East Bay hills views. One car garage parking, secure lobby, elevator, courtyard, located on a secluded historic brick block just seconds to the Embarcadero, Michelin-starred restaurants, major league ball parks, and transit lines.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 1041
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Cape Horn Lofts managed by Bohan
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-07-13T18:15:06.000+0000
pba__latitude_pb__c, 37.784352
pba__latitude_property__c, 37.784352
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-12-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Paul
pba__listing_agent_lastname__c, Ybarbo
listing_agent_mls_id__c, 802800
ffd_listingagentname, Paul Ybarbo
listing_agent_number__c, 802800
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/BcJn1SYMNe4
pba__longitude_pb__c, -122.391236
mls_id__c, 423715615
master_property__c, a0O1I000001ViliUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-14
original_price__c, 1295000
overall_days_on_market__c, -81462
parking_access__c, Side by Side
parking_features__c, Covered,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck;Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2023-04-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 862.52
pba__propertytype__c, Condominium
ListingId, a0E8W00000a72qRUAQ
sale_date__c, 2023-05-09
sale_price__c, 1123000
security_features__c, Security Gate
selling_agent_mls_id__c, 800745
selling_agent_number__c, 800745
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, 1302
size__c, 1302
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Delancey
subdist__c, South Beach
ffd_name, 540 Delancey Street #401, San Francisco, CA, 94107
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1892
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530568969-1.jpg