If one sale exemplifies Charlestonians thirst for waterfront properties, this might be it. A house on Cove Avenue on Sullivan’s Island sold not so long ago for $2.5 million. As part of the arrangement, the home will be torn down and a new dwelling built in its place.