Extended Stay America just across the bridge in Mt P. Red Roof over there also if you are going frugal.
I lived in Mt P for a while and Im partial to it.
West Ashley and North Chucktown is dumpy. Downtown is pricey.
Chucktown is really nice. I miss it almost daily.
Be sure to get some BBQ from Melvins and Sticky Fingers when your there. The Marketplace downtown is a cool place for food and drinks. Wet Willys is also a mandatory stop. Check out Pat Point, catch a Stingrays game, and walk around the battery and downtown and you'll have it covered.