I'm not sure I have ever been to a real headshop. Living in the bible belt has it's disadvantages. A local shop was even closed due to George W's recent assault on glass art. We have a few hippy-esque establishments but none that sell legal enthogens or anything like that.

Natural Vibrations in downtown Columbia, SC is where I've bought all my hand-pipes and bubblers. They usually have two large cases full of pipes and a case full of bubblers as well as a case full of misc. stuff (papers, cleaners, etc...) and usually a case full of hand-blown stash jars. The whole inventory changes like every two weeks! The staff is quite friendly and obviously supports our cause. The prices are also very kind. Highly recommended. Just ask to see upstairs if you want to see the pipes.