I've name changed for this as I live in Longstanton and I don't want to totally out myself!
Longstanton is nice, not as pretty as other villages but we have found it friendly. Floods not really a problem though there have been issues with drains in some places on Station Road, mostly due to people flushing inappropriate things...
The primary school has been struggling, but think things are looking up. I know they were doing a consultation into turning into an academy.
Can't say there's any particular issues with anti-social behaviour, quite the opposite, I'd say, it's pretty quiet! There is a reasonable amount going on, there's not a bad community spirit but surrounding villages seem to have more going on and more involvement by people. Not quite sure why Longstanton isn't the same, could be to do with the legacy of the old MOD housing, I don't know.
But the thing you must consider very, very carefully, is the building of Northstowe. This is going to affect Longstanton hugely - we were a bit naive about it and I don't think we properly considered the effect. This will not necessarily be a bad thing - but it's a big thing. Look into it, think about it.
I like the village a lot but we are dithering about whether to stay or not.
Feel free to message me if you want to chat about anything.