I just closed on a house literally 1 house away from a grade school in Albertson and the new home owners are really enjoying it. He does not have to get on long lines to drop his child off at school because the child can just walk right in and he can watch from his window. I would imagine that there is some noise when children are being dropped off /picked up from school and during lunch time, but otherwise I can't imagine it being too noisey. Why not take a day off from work and sit in your car during a school day to hear how much noise there is?
By the way, this home had multiple offers and was in contract in 9 days from the day it was listed.
I live behind a school and i actually like the sounds of kids playing sports and the traffic is not to bad. I am in Georgia so I do not know your area, but you can research traffic and physically visiting is the most important thing.
Heather Murphy Real Estate Group
Keller Williams Coastal Area Partners