meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216210' 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 #305, San Francisco, CA, 94107
ffd_mls_id, 510650
ffd_salesforce_id, a0E1I00000Tl6EJUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 16
address2__c, 540 Delancey Street #305, San Francisco, CA, 94107
pba__address_pb__c, 540 Delancey Street #305, San Francisco, CA, 94107
agent_only_remarks__c, This is one of the best and most unique condo's in the area. For showings txt or call Joost 415.431.3131 with your name showing request. Supra Lockbox is installed on the front lobby gate but you need to request the 7 digit CBM code to enter on your app. Code will be txted to you after you submit your signed Pead. Txt Joost to request code. You can also use the ShowingTime App to schedule appointments. Disclosure package is in Disclosures IO for you to download and review.
appliances__c, Dishwasher;Electric Range;Disposal;Refrigerator;Hood Over Range;Ice Maker;Freezer
architectural_style__c, Modern/High Tech;Conversion;Craftsman
bath_features__c, Tub w/Shower Over;Remodeled
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1892
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-02-02
ffd_createddate, 2020-12-03T23:46:43.000+0000
days_on_market__c, 958
dom__c, 81
ffd_description_pb, Transparent Pricing. First time available in over 20 years. This brick and timber loft style condo is truly unique for San Francisco and unlike anything else you see in the area. Built in 1892 as the South End Warehouse, along what used to be the city's original waterfront. The building was extensively remodeled and converted to an upscale boutique building with only 16 units. The conversion was completed in the late 1990's. The condo has an open floor plan and brick walls on two sides. Large exposed beams and big warehouse windows make this condo truly special. The unit has in unit Miele washer dryer and reclaimed wood floors from a high school gymnasium. Updated kitchen with brand new appliances. Updated bathroom and lots of closet space. Located steps away from the Embarcadero as well as all the great restaurants or walking distance to the ballpark. My client loved it for 20 years and so will you.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Reclaimed;Parquet
hoa_dues__c, 612.37
hoa_fee_includes__c, Management,Maintenance Exterior,Trash,Maintenance Grounds,Internet,Water
pba__hoafees__c, 612
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2022-01-25T15:40:47.000+0000
pba__latitude_pb__c, 37.784352
pba__latitude_property__c, 37.784352
laundry_appliances__c, Washer/Dryer,In Closet,In Kitchen
laundry_features__c, Laundry Closet;In Kitchen;Washer/Dryer Included
listed_date__c, 2020-12-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joost
pba__listing_agent_lastname__c, Van de Water
listing_agent_mls_id__c, 802477
ffd_listingagentname, Joost A Van de Water
listing_agent_number__c, 802477
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 798888
pba__listingtype__c, Sale
pba__listing_website__c, http://www.540Delancey305.com
pba__longitude_pb__c, -122.391236
pba__lotsize_pb__c, 0
mls_id__c, 510650
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001ViliUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-12-03
original_price__c, 798888
overall_days_on_market__c, 90
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2021-02-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000Tl6EJUAZ
roof__c, Bitumen
sale_date__c, 2021-03-10
sale_price__c, 780000
selling_agent_mls_id__c, 811613
selling_agent_number__c, 1052666
selling_co_agent_mls_id__c, 981678
selling_co_agent_number__c, 1017282
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Delancey
subdist__c, South Beach
ffd_name, 540 Delancey Street #305, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, 305
view__c, Partial;Downtown;San Francisco;Woods
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/374413-1.jpg
ListingId, a0E1I00000Tl6EJUAZ
