There is always the internet if you have a debit or gift card of some sort. If not you would have to find out the location of a head/smoke shop in your area, or a flee market. Some ghetto booth-type gas stations may also sell paraphenelia. Ask someone you know with a bowl/pipe where they got it. These options are probably void if you are underage and don't know a single person 18 or older, just hang in there.
If you can find a shop or website to order from triple-blown glass pieces look nice, smoke nice, and require some effort to break. They usually go for $15-$30.

CVS stores and the like usually sell cob pipes for tobacco use. They cost about $5 if you can find someone willing to contribute to the delinquency of a minor.

Lastly you could find someone with a pipe who is willing to sell it. You've got to know other smokers and one of them either has a pipe or knows where to get one.