Originally Posted by phoenixautumn
a good one with multiple hoses, or one that rotates?
They don't exist. Rotators and multi-hoses are gimmicks and just don't work as well as as a single hose pipe.
Head on over to hookahstore.com and look at a Khalil Mammoon Carnival. Like this one:
They have other colors too.
Use your discount code (Found in the vendors area of the forum) and knock of 20%, which will bring the pricetag down to about $72.
Hookahstore is a well-respected vendor around here with a great reputation. He'll throw in everything you need to start smoking right out of the box (Except the water
Khalil Mammoon is also very highly regarded as one of the best-smoking pipes in the world. And that is a great price for one.