Mr. Natural closed, I believe. If they have a location somewhere please let us know here.
Infinity's End in Charlotte is good. Just bought a nice glass-on-glass bong there. It has nice notches and everything very sweet. They also have dry pipes and a good selection of bubblers. Also some hard-to-find things like ash-catchers for bongs.
Where are those local shrooms, man? :)