Not an apex domain
The domain 83.74.97.host.secureserver.net is not the root of its zone.
Instead, try zone transfer on 74.97.host.secureserver.net .
Instead, try zone transfer on 74.97.host.secureserver.net .