As someone who has lived in Larkfield since the summer of 1999 (we were the sixth family to move in), I'd just like to give my tuppence worth...
First of all, the 'asbestos' story is completely new to me. Guessed there was something wrong as they have being lying idle for nearly 4 years now (slight exaggeration GA001). It does make the entrance to the estate look very untidy indeed.
Our estate is a quiet one, thankfully, with relatively little crime or unsocial behaviour. The council estate is/was a big concern. It was actively fought against at the time but to no avail, much like the Drugs Treatment Centre which unfortunately is now being built opposite St Edmunds. Although the council estate is an eyesore, I have not heard of any direct trouble from it.
The houses were built, by Fitzgibbon Brothers, to a very high standard. I've absolutely no problem with the houses themselves. Most folk within the estate keep to themselves. It's ideally located for shops, buses, M50, Liffey Valley etc etc
In summary, Larkfield is a beautiful estate in the wrong area. I know this might sound a bit snobbish, but when you're surrounded by filthy council estates, Drug treatment centres, halting sites, it's only natural to think this way. Basically, if you decided you want to live in Lucan, then Larkfield is as good as you're going to get. That said, if Lucan is not the be-all, then another area might be better advised...