D.C.
Howdy!
Most of College Station is a mixture of students housed in neighborhoods with families. Like behind the CS Target, Glade Street (though that is a very busy street to live on when you have small kids. There are culdesacs and such, like near Village and Holik.
The Southwood and Beecreek Dr areas are nice too. Check out www.csisd.org for info about the public school district and what the zoning areas are.
Living out, south, like in Pebble Creek subdivision is distant enough that you will want to make sure that your location more than makes up for paying more for gas to get to/from the campus.
The endearing greeting around here (in CS) is "Howdy!"
Good luck finding a place!
P.S. An option many people look for is TAMU bus stops. Ask your realtor about that or look at http://transportation.tamu.edu for more info.