Charleston SC waterfront condominiums for sale. Waterfront means different things to different people, but here in Charleston most everyone is referring to condominiums that are overlooking one of the three rivers we have, the intracoastal, harbor views, and of course beachfront. Most waterfront condos in Mount Pleasant, Isle of Palms, Daniel Island, Folly Beach, Downtown Charleston, James Island or the other more popular communities of the tri-county area will start at $350,000 for a small condo to well over $3 Million for the luxury condos in downtown’s French Quarter. Condominiums like The Tides and The Renaissance in Mt Pleasant are luxury mid-rise condos that have views of the Charleston Harbor and Wando river whereas The Reverie on The Ashley is as the name says on the Ashley Cooper river. On Daniel Island you have The Oaks at Riverside which also are on the Wando river but have their own marina which is only one of only a handful of waterfront condos with their own marina.