This Sherlock is about 6 inches long. Lays down perfectly without tipping over, due to flat surface on bottom of bowl. Tip of the mouth end is flat. Gorgeous color changing piece is sure to please. Each pipe is fumed for a color changing experience. Your pipes look will change colors after every smoking session. You will see it evolve into a new piece slowly over time. Cleaning your Sherlock pipe will reset it back to the way it was when you first got it, allowing you to color change it all over again! Because each pipe is individually handmade by glass artists, the pipe you receive will be one-of-a-kind. The exact shape or color artwork may vary from the pipe in the photo.