Yes, you will get it back after court. Once the Judge senteces you, he will then ask if you would like to have your pipe back so that you can continue on your path to becoming an even more dumbass than you already are.
No your not getting it back, it is now considered states evidence against your butt.