No, wouldn't buy opposite a school.
Apart from all the other reasons already outlined I feel you could also suffer vandalism particularly seeing its older kids. You know the thing, sitting on the fence, horse playing etc.
Having said that I have a townhouse which is right next to the oval of a...