Not an apex domain
The domain c-174-171-88-49.hsd1.tx.comcast.net is not the root of its zone.
Instead, try zone transfer on hsd1.tx.comcast.net .
Instead, try zone transfer on hsd1.tx.comcast.net .