Dualing Piano Bar
One really fun place is Howl At The Moon. It is not to bar-scene-esque but it is not a total tourist trap.
Something that makes this unique is that there is a full band backing up the pianos which really adds to the energy. In addition- by city standards, the drinks are not too expensive. Which in a city when $9 dollars for a beer is not unheard of really helps my pocket book.
My one significant complaint is that it gets a little bachelorette crazy at times- it seems like so many parties go there.