It's in Smyrna, TN. They have their own airport KMQY but do operations out of Nashville. It's about a 30 minute drive to the BNA. On the commercial side they only fly to Tupelo, MS currently, but have an agreement with AA. Depending on the time of day traffic gets crazy. Smyrna is getting up there in price range do to the Nashville boom, but you can still find some good relative housing options.
For those of you looking at colleges. Middle Tennessee State is about a 20 minute drive in Murfreesboro