Problem with random glass you find on the internet is that it could be a one-off custom piece from an artist. That being said you can go on etsy or google or something like that and search "glass rose pipe".
https://www.etsy.com/listing/127803428/rose-sherlock-glass-pipe?ref=cat_gallery_3&ga_search_query=rose+pipe&ga_order=most_relevant&ga_view_type=gallery&ga_ship_to=US&ga_search_type=all $45 on etsy. Comes in red, blue or purple.