It is 23-5/8 inches long, not counting the insert, about 1 inch and tapers to 1" wide and 3/4  inch thick. 

It is finished, with a hole drilled through.

The wood is rosewood spruce.

This is a solid one-piece stem with insert. It is not two halves glued together.

 This stem will enhance the beauty of any pipe you are crafting.