Matt - My brother-in-law had a pistol range in his basement years ago, and it was great fun during the cold winter months. He only shot .38 and smaller, and had a fan fitted in a window to blow out the lead and powder smoke. The window was facing the side yard, and was shielded by shrubbery, so any noise that escaped was muffled a bit more. He also had very understanding neighbors.
It all came to a screeching halt one night when he was trying out some rubber tipped training rounds, and one caught the bullet trap kind of funny, came back and hit my nephew. No injury, no blood or anything, but a scared, screaming little boy who thought he had been shot brought my sister in a hurry, and that was the end of the inddor pistol shooting.
I used to work with a guy years back, whose wife was an international air pistol shooter. They searched for a long time when looking for a house, before they found one that had enough length in the hallway and other rooms, that she could practice at Olympic distances. Hard to argue with his rifle and pistol addiction, when she bought a house specifically for an indoor range.