Waterfront Condos For Sale Charleston SC | Condos for sale in Charleston SC on Waterfront | Riverfront The Charleston SC area has hundreds of waterfront condos for sale, beachfront condos, and riverfront condos for sale, and many even with marinas. Areas such as Downtown Charleston SC has more than 5 waterfront condos buildings to choose from, Folly Beach, Mount Pleasant, Daniel Island, Kiawah, and Wild Dunes all have condos for sale with water or beach views. Prices range from $250’s for small one or two bedroom condos on Folly Beach, to well over $1.5 Million for condos in town on the water, or condos on Kiawah, and Wild Dunes. Unfortunately, Sullivan’s Island doesn’t really have many condos at all, much less any on water.