Where to stay in Dublin?

Stay in the Temple Bar area. This is the city center. Then all bars, clubs, restaurants and the main sights are on a short walking distance.
Dublin is a very popular weekend destination. Hotel prices are relatively high, as you can see on the graph below.
Hotel map