Something similar to this one: http://www.coranix.com/sherlock/sh_pipe.jpg I smoked out of this guy's on 4/20 this year and I just remembered how good it was. How much do these puppies run for?
My friend used to have a sherlock but now he just uses his signature corn-cob pipe... man that thing is crazy... Home made! (in wood shop class) Just take dowel and drill it out on a lathe and thread it... get a corn-cob and do the same, but drill a hole in the side and dont hollow the entire cob out. Then just use a tapping tool to make threads and screw in the dowel! DONE
Wait, are you talking about an actual tobacoo pipe, or a glass pipe with the same shape? Either way the price range is very broad, with glass you could spend $10-$300 on one. I'm sure tobacco pipes get pretty spendy too.