Not an apex domain
The domain c-174-56-188-253.hsd1.ga.comcast.net is not the root of its zone.
Instead, try zone transfer on hsd1.ga.comcast.net .
Instead, try zone transfer on hsd1.ga.comcast.net .