I live approx. 3 km from Skerries town, so know a little about it. Overall, it's considered a very desirable place to live, certainly in this part of North Dublin.
Within Skerries the South Strand area is very much sought after - due to it's proximity to the sea. There is a good mix of older 1920's and 1930's housing there as well as some new apts.
It's not desirable in the conventional sense ie wide tree lined avenues, with large period redbricks. However, it is very close to the sea and has nice bars and restaurants, which give it a very nice feel. Even though there was some building done in that part of the town during the Celtic Tiger it wasn't ruined by it.
If I could afford it, I would love a home there. The only downside is that during the summer, especially on the weekends when the weather is nice, a lot of day trippers come out to Skerries and parking can be an issue.
I have never heard of flooding being an issue in the 4 years that I have been here, that's not the say it won't happen.