Sorry but 00 buck will fully penetrate house walls. May not get granny in the next house but it could easily get granny two rooms away.
https://www.youtube.com/watch?v=0dbtBWp_beo
Not from 200 yards away. Which is the point and why shotguns are preferred in an urban environment.