thats just a regular downstem that you heat with a torch until it bends on its own
here is a video of how to do it...be aware you are gonna wanna get extra downstems as you will break a few most likely....
https://theweedtube.com/video/how-to-bend-glass-downstem-for-custom-bongs-dab-rigs-27019 skip to around 4:30
as to it not being able to be delivered to your place you may wanna look into using the amazon lockers that are in grocery stores and the like
edit. just as a personal opinion I wouldn't bother with bending the downstem I kinda like the straight tube downstem at a 45degree angle it feels more classic(best word i could come up with)