I live about 10 minutes from there. Im in there about 3 times a week the manager is and his fellow employees are friendly, the website does not do them justice in the pipe department, they have a pretty wide selection of tobacco, a good collection of new and estate pipes, and some from a local artisan who does a very good job. The manager is quite knowledgeable on all forms of tobaccos, but is an avid pipe smoker himself. I would recommend it to anyone around. Also, it should be noted that they hold a pipe club there once every month.
Now in regards to your hookah question, I have no idea, haven't tried any of there stuff but Eric (the manager) would be happy to answer any questions you have.