Best neighborhoods of Charleston?/

I'm in my late 20s and looking to move down to Charleston from the northeast. I've just started apartment hunting and would love some suggestions on areas to live. I'll probably be working in North Charleston (which I've been told is not great to live in) and would love to live close to downtown. Any and all suggestions are appreciated!!!