Hi there, I'm new to this site and was amazed to find reference to Castlerock, Castleconnell here. My wife and I bought a four bed semi here in 2006 and moved in in July 2007. So far we have absolutely no complaints. We love the area and our neighbours on either side are really sound, professional people with very young kids that spend their time playing together in the green area to the front which is nice to see. The quality of our house is good but some cracks have emerged in the plasterwork over the skirting boards that might have been avoided with more careful wood/plaster work. Noise from next door is absolutely not an issue and the house retains heat well though on the minus side the radiator in the living room is under the window which means full length curtains do block the heat. This is the second new house that we have purchased and the quality of this one is way better (the first was in a development in Rochestown, Cork called Silverbirch - anybody know it?)
Location wise, we are near the back of the estate beside the pedestian walkway to the village which means a five minute walk to Guerin's pub and few minutes more to the church, school, railway station and SuperValu which is fantastic. We also like the fact that you can go for a decent walk/jog in a loop from the back of the estate via the village and the river Shannon walkway up through the back of the Castleoaks and back in via the Belmount Road to the front of the estate.
We were initially very worried about the size of the estate but so far so good. There is absolutely no problem getting out of the place at rush hour in the morning though this may change once the entire development is finished. My wife works in Limerick City and I work in Nenagh so close access to the N7 was important. I make work in 25 minutes and depending on the time of the morning she leaves it can take my wife a little longer than that to get into the city centre. The right turn onto the N7 is not ideal for her but she tells me that she rarely has to wait longer than a few minutes to benefit from a gap in the traffic. The junction isn't very well lit at night and I think eventually that a roundabout may be needed though when the new motorway finishes next year traffic should be a lot lighter. For the less fainthearted, however, you can always go the back way to the city via O'Brien's Bridge and Parteen though this will take you about 30 minutes on a good day. It's a good way to access the southside of the city though particularly if you're going to Thomond Park or the Gaelic Grounds.
Finally, two of the five bed detached houses to the front are occupied by Munster rugby players so it does the reputation of the estate no harm at all. However, I'm a bit concerned that my Missus is a bit obssessed with the fact that Marcus Horan lives in the neighbourhood!
Castleconnell itself has a lot to recommend itself though to be honest we haven't really had a chance to get to know it properly yet. There's a local historial society that holds talks once a month in the village community centre (the ACM). I went to this month's talk and while the age profile was a bit on the old side the people at it seemed really sound and easygoing but very very proud of their village and locality at the same time which is heartening to see. The locals are particularly proud of their local GAA club, Ahane. We've also been to All Saints Church opposite the Castle Oaks Hotel to hear two Schubert recitals which were well attended and happen on an annual basis over the Autumn (each year they concentrate on a different composer) which was something different to do of a September evening. Apart from that we haven't really had much cause to mix with the local community. There are two local primary schools, one in the village and one in Lisnagry, both mixed. Apparently both are fine though I've heard on the grapevine that Lisnagry may be posher if you're into that sort of thing (though admittedly this was from somebody who went to the school themself so they would say that wouldn't they!
All in all, I'd definitely recommend the place but having said that I haven't really looked into the other new developments in the village so I can't really compare and contrast. We have friends currently renting in Clonlara who have looked at some of the show houses (three bedders) in the other new developments in the village and apparently Castlerock isn't the cheapest so it would be worth looking more into this if you are thinking of buying. There's seems to be a lot of new empty houses both in Castlerock itself and especially in the smaller newer estates so there should be lots of room for negotiation. Best of luck!