For what it's worth, it isn't a spiggot. That's for an outside line. It is a sillcock. There are a lot of names for the long sillcocks but something like freeze-proof or frost-proof sillcocks are often used. A sillcock will be close to the sillplate of your house.