The Pineapple Fountain is located at Waterfront Park downtown Charleston, SC. It is common to see kids of all ages playing on the fountain during the heat fo the Summer. Bordered by Charleston Harbor, the area is loaded with benches and palmetto trees offering great views and relaxing are for tourists and locals alike.