It may use the same connector ("F" type) as a standard 75-ohm cable, so it might just hook right up easily.
BUT... a satellite dish wouldn't make a very good TV aerial, because
 It's designed for higher frequencies than terrestrial (from earth) TV,
 It's extremely directional, and
 It's aimed up at the point in the sky where a specific satellite is in geostationary orbit.
All of these factors would work against getting a decent TV signal from it.
(geostationary orbit = orbiting the same speed as the earth, around the equator, so stays in a fixed position in the sky).
What I was saying is that a satellite dish won't work well at all for terrestrial broadcast TV reception, and you really need an aerial (AKA antenna) intended for that purpose, but that you could hook up that lead if you wanted to (it just won't pick up much).
Since you are not doing business with the satellite provider (you said the dish was not in use), I doubt they would provide a non-customer with a free TV antenna (or a free receiver). But you could start up service with them (and pay them), and then they would provide you with a receiver for the dish, and also provide local stations one way or another (either give you an antenna or if you live in a major market they may provide them on the satellite).