Anywhere in Georgetown or Adams Morgan is good. The former is considerably more upscale than the latter, but you can have a good time in both areas. BPT spend $8-10 on a drink though, you're not in college anymore.
As for Fredericksburg, I think the bar is called "On the Water," and its...