You do not have children who are lovely at home, lovely at school and revert to feral/anti-social behaviour when on pavements or on the bus - because they have been brought up to behave appropriately
You do however have children who are (reasonably) polite in public, know how to toe the line at school and revert to prima donnas at home - because they can manipulate their parents.
Any child that exhibits anti-social behaviour in public, generally exhibits that at school and is often the norm at home.
Perceived poorly performing schools (by results) often have the best pastoral care, hence poor results because parents will flock for mile to avail them selves of a well functioning SEN dept.
Most people when looking at league tables only look at A8-C grades - but if you have a core of SEN pupils who have over achieved, but still only get D or E grades, to outsiders that looks like "failure". The fact those children went to a school and were predicted G or F goes largely over looked.
I learned my lesson the hard way - never discount a school by reputation. Look at all schools. Look outside as well, go to the precinct, ride a bus with them, talk to the teachers if you must but seek out the TAs and support staff who aren't always primed with the jargon and sound bites.
Personal perspective - never trust a school that doesnt let you lose with the pupils!!! If they throw the pupils as guides with staff dotted around, that is much better - you will get a brilliant picture from the children.