If you're looking to stay in a great location in Dublin and not spend a fortune, the Harding Hotel is the way to go. This hotel is close to Temple Bar, but not so close that you're listening to yelling drunks at all hours. Nearly all Dublin tourist sites are easily walkable from this hotel. Also, the airlink bus to the airport is just on the corner.
The rooms are spacious and clean. The only problem I noticed is that there is really no lip on the shower, so it means water, water everywhere. The bar and restaurant attached to the hotel are both nice. I would absolutely recommend a stay at the Harding Hotel while you're in Dublin.More