Bellevue, Crieve Hall, West End, Cool Springs, Mt Juliet.
Avoid Antioch. Brentioch, as previously mentioned, would be ok I guess, but it does attract some riff-raff since it borders Antioch.
I'd also avoid East Nashville, just my opinion. East Nashville may be "coming back", but it's not "there" yet. The other places I mentioned don't have to "come back" because they haven't gone to crap like East Nashville has. Mt Juliet is a very up and coming area but make sure it's Mt Juliet and not East Nashville.
Anywhere in Williamson County will be excellent. Yes it is pricey, but as they say you get what you pay for. There are affordable apartments there, especially if he is getting a job at Vanderbilt. Here's an example of one place:
http://venterraliving.com/thelandingsofbrentwood/rent_pricing_availability and it's right next to the interstate and everything in cool springs.
The county is #1 in the nation for income when adjusted for cost of living, since it is still low but many there make great money. It has the lowest property taxes of the surrounding counties and has the best public schools in the state due to tax revenue from the wealthy that live there. Not to mention I65 between Franklin and Nashville is generally the easiest interstate in the morning for a commute. I65 north of town is a disaster due to Vietnam Vets Blvd, and I40 runs with I24 too long, the latter of which is a parking lot during rush hour.