Well, if anyone else is shopping in his price range, with schools, a pool, and great commutes I'd recommend Nolensville in Williamson Co. zoned for Ravenwood schools. Some neighborhoods to try would be Bent Creek, Silver Stream and Stonebrook. Since Flyboy was planning a move for at least 10 years, then I think it's okay to go in a new construction neighborhood. I'd be more cautious if the move were for a short period of time. Ask around these days and a lot of people are stuck in their brand new homes right now.
I'm not knocking new construction. I had my home built, but did so knowing how long I would keep the home.
Good Luck with your search and I would be happy to show you and your family around.
We're actually selling ours to build new and I've included a link to give you an idea of the neighborhood. Let me know if you have specific questions.
You will certainly find the best value in Rutherford County (Murfreesboro, Smyrna, LaVergne). Finding homes in Williamson County (Franklin, Brentwood, et. Al.) in the $200-$250K price point may be challenging. In Murfreesboro, Garrison Cove was my home a few years ago; however, the prices there have escalated about that point. I would take a serious look at Indian Hills. While Murfreesboro pushes the 30 minute airport time, Indian Hills is easily accessible to I-24 and will put you right at 30 minutes. Rutherford County schools have a strong reputation for quality.
Recent studies show that college towns (like Murfreesboro) are seeing interesting potential for appreciation thanks to the correlation between active lifestyles for retiring baby boomers.