There a lot of excellent restaurants and bars located on the water at Shem Creek in Mount Pleasant, SC.

Charleston City Market is a stable to go when you are visiting. They are open everyday from 9:30am till 5pm with all local vendors.

Waterfront park is a great location to see multiple Charleston sites close by including: The Battery, Rainbow Row, and the pier.