This single bend rose sherlock glass pipe can be made in transparent Red, Purple or Blue (Blue comes with sparkly edged petals) at this time. It features 2 formed opaque greenleaves that function as a stand, so the pipe will stand up for you. This rose pipe measures about 5 inches "long", though about 7 inches when stretched out (accumulative length).