We are planning our first trip to Charleston. We do not know where to stay. Is the Charleston waterfront any better than North Charleston. Any good hotels. We read there is a new Residence Inn in North Charleston but it looks really far out. Any good hints or hotel deals are really appreciated. Also what are must see things and what should we do in 2 or 3 days?