Try Shade Acres on Catawba Island. They rent cottages, mobile homes, camping spots, pretty reasonable.
http://www.shadeacres.com/