We lived there for a long time before moving closer to home when kids arrived. Its a nice town with a lot of "ex-pats" living there - people who have moved there to be out of dublin or to be close to dublin. 45mins to the M50 roundabout by car, and great rail services to Dublin and Sligo.
Primary schools are choc a bloc though, and you might have difficutly getting into a town school, so may have to go to the outskirts.
Depending on your budget, the Ardmore Road and old Dublin road are priciest side of town - Ardmore Hills, Gleann Petit, etc.
Lakepoint is a nice estate, its big though, and has been seeing some anti social behaviour of late, but you'll get a nice 4/5 bed semi for c. 350k there.
The other side of town (the hospital side) tends to be cheaper house prices and the estates are v claustrophobic. Wouldnt be my preference.
But the people are lovely, and the town is great. If we had family closer we'd have stayed. Football clubs in the town are great also. Lomans and Shamrocks have great underage set ups - I'd be biased to Lomans!
Hope this helps, good luck with your move.