Anyone from Charlestown SC?

Hello Everyone . . .I'm needing some help on planning a vacation to Charlestown, SC. I know this is silly but the reason I want to go to Charelstown is based on a show called Flip this House - the homes and sites on the show make me have to visit. Please let me know where we should stay and go when visiting Charleston, SC. Your help is APPRECIATED!!