What pipe style is this?

I was just curious about the style of it, mainly. I liked the look of it, yet at the same time, I didn't. Strange I know...oh well, that's what being too lazy to change the channel gets me.

Thanks to you both, I'll poke around a bit more.
Kegan