Any Charleston lovers out there?

Of all the places we could go for a long weekend, the only one on my mind is Charleston.  I've dreamt of visiting this sweet southern spot for many years now..  but since we are living in Houston for the next year(ish), now is as good of time as any!

photo cred

But where to stay?   

photo cred

what to see?

photo cred

Half the fun of planning a vacation is really in the planning stage, isn't it?  

When the possibilities are endless?

photo cred

I see that I am asking alot of questions here.
But what I'd really like to know is~

Have any of you been there?  Where are the best shops, restaurants, etc?

My husband has his sights set on long days spent at the beach.
But I get too antsy.

I want to stroll..
and check out that beautiful historical architecture..
and do some shopping!

Any suggestions?