Waterfront real estate for sale James Island SC | Homes on deep water on James Island SC | Riverfront properties listings James Island SC in Charleston SC. Properties for sale in Charleston SC on James Island on water: such as creek front, intracoastal, deep water homes with docks, riverfront and harbor front houses for sale. There are essentially three kinds of waterfront homes here in the Charleston area, and James Island is no different: deep waterfront (harbor or river), riverfront, creek front (tidal or shallow), and lakefront. Honestly, we really only have a couple “lakes”, unless you go to Santee SC for large lakes. View all properties for sale by price, size, neighborhood, street, and type (condo, townhouse, luxury home, land lots).