It would really depend on what road you are buying on. Alpine Heights has always been a private Estate, accessed via "Bawnogue", which is where any trouble would have traditionally come from. Though parts of Bawnogue have quietened down an awful lot, there is still an element of anti-social behaviour, more so from the Kilmahudrick side of the area.
I know there are two Estates there on that side of the road, Alpine and Ashwood, but I dont know if Alpine is the one nearer the front, or nearer the canal.
I would say for that type of Budget, you could do an awful lot worse. I know somebody who has lived there for 10 years and has no problems. You would also do well getting it for €325K, I would think.
If you are looking around that area and price bracket, look at Dunawley, though perhaps they might be more expensive now.
I grew up near that area, so if you have any further queries, let me know.