Hi,
To find good housing in Charlottesville, look at http://www.brac.com. It'll show you most of the best rental options. If you want to stay away from drunken undergrads, DO NOT live near "the Corner" (aka. Rugby Road, Grady, etc). Also, don't live too close to the stadium, since traffic is impossible on game days and there will be plenty of noise. Lots of people live in U Heights (but they're getting rid of the shuttle, so it may not be a good idea) and U Gardens. Downtown is nice if you don't mind being further away and can afford it. Another option is living near JPA (Jefferson Park Ave). I also know people who are happy in College Park, Eagles Landing, and Lakeside. In general, I've also heard good things about msc rentals. I hope this helps!