Schools in Frome and surrounding areas

[TraciTrickett]

Hi there
I am looking to move to Frome with my twin 8 year old boys.I believe that that they would be going to a middle school.Could someone please tell me which is the best one,or are they all pretty much the same?Are there any schools to be avoided and are there limited spaces?
I was also wondering if there are any areas to avoid renting in or is everywhere quite nice and friendly and flood free:)?
Thanks