For reasonable hope of success , need to know if there are Tv stations that are receivable at your location and yes there are. Your location has many easy to receive Strong LOS = Line Of Sight Digital Tv Stations. The antenna will supply signal to 2 Tv's. Yes you can disconnect the cable from the street where it connects at the house and connect the RG-6 coax that comes from the antenna. For a antenna I recommend a Antennacraft U4000 aimed at about 187 degree magnetic compass. Here is how to aim antennas ,
http://www.kyes.com/antenna/pointing/pointing.html. Mount the antenna above the roof. Here are some antenna mounts ,
http://www.ronard.com/909911.html ,
http://www.ronard.com/34424560.html ,
http://www.ronard.com/ychim.html. Here are places to buy antennas and ect. ,
http://www.amazon.com ,
http://www.solidsignal.com ,
http://www.starkelectronic.com ,
http://www.3starinc.com