Rte 94 or Hebron Ave is a major road that runs the entire town. I would recommend that you look at all the home in Glastonbury. Glastonbury has some of the best neighborhoods in the state and it is very a desirable place to live and raise kids. Also, it is a very commuter friendly town due to its proximity to the highways and Hartford. This was one of the main reason why I chose to live in Glastonbury.
When it comes to resales the basic colonial house wins out over a contemporary. While that old home on Main street may look charming also consider that parts of Main St are also Rte 17 and is a busy noisy road. Also, how far out do you want to live? Rte 2 backs up quite a bit if you are a commuter.
The good homes in Glastonbury are snapped up. Also, make the realtors work for you . Consider working with an agent from each of the big realtors. They usually steer their clients to showings of new homes that are just listed before releasing to the other agencies. They will deny this but I have seen it done.