Thank you Woolleyworm for your reply.
I did consider a shotgun, but i am hesitating for 3 reasons:
1. I am afraid it will damage the house if I shoot it a couple of times inside..
2. big and difficult to handle inside a small hose like mine
3. with a handgun, i can take it to the range and have some fun shooting targets/practicing
it seems that i will have to have both.....
am I making sense?