You can't go wrong with the River Lee in Cork. It is perfectly located, just outside of the husslin' and buzzlin' in Cork, while you can still walk easily into town.
An advantage is also the included NRG Gym, which one has access to.
Would I stay here again? I certainly would!