Not an apex domain
The domain ns2-hosted.74.63.187.in-addr.arpa is not the root of its zone.
Instead, try zone transfer on 74.63.187.in-addr.arpa .
Instead, try zone transfer on 74.63.187.in-addr.arpa .