I love Charleston but, like Punki, Bay Area-ites are weather wimps too, and so summer for me is definitely out (it's not the heat, per se, but that gosh-awful humidity y'all have down there).
I vote for springtime. As PDX_Roy says, the flowers are in bloom and it is really lovely at that time of year (Middleton Place, Magnolia Plantation). My second choice would be around Christmastime.
So, we are very possibly interested, depending on the date.