Be sure and see this thread if you haven't already:
http://texags.com/main/forum.reply.asp?topic_id=1217907&forum_id=55Your question is quite generic... it's kind of like saying, "Hey, I need to buy a car...it needs to get decent gas mileage... anyone got any good pointers on what I should get?"
The good news about Denver is that there is a neighborhood within striking distance of the city to fit just about any taste/desire/requirements. Also, remember that Denver is not nearly as spread out as say Houston or Dallas, but of course, the real estate is more expensive. A lot more expensive. This is compensated for somewhat by smaller lots and other ways of building houses for less money(like multi level houses).
I agree with just about everything said above. I can't really speak to the quality of schools as I don't have kids but I always hear great things about the Cherry Creek School district. Parts of southern Aurora (generally considered the nicer part of Aurora) are in that district.
The southern suburbs that my Aggie friends tend to move to are the ones mentioned above.
The northern suburb that my friends tend to like is Broomfield, though I'm less familiar with that area.
The person who's probably best qualified to answer this question (and assess your detailed needs)is a real estate agent up here. I mention Matt Sadler on the other thread, and I think he'd be a good place to start. Even if you're planning on renting, he'd still be a good place to start and I'm sure he would not mind at all giving you the lay of the land. You can also pm me if you like.
[This message has been edited by qqchuck (edited 12/30/2008 2:21p).]