I did the same in our last house, bought a small rca antenna from amazon based on some antenna guru's design. Works great, about 42 channels easy to mount in attic. My new house has a metal roof so i am expecting issues inside however i will try inside before i punch a hole to the outside.

As far as connecting to the tvs, it is coax so just unscrew the old cable/sat feed and screw in the antenna. Worked like a champ.