For a local dive bar, Sweaty Betty's does the job. Went there last night for a last minute pint with a friend, and managed to find a couple of stools at the bar. The bartender seemed friendly enough, and even offered up a bowl of nuts which I don't think is usually the norm. The music was chilled out 60's and 70's rock which totally suited the vibe.
One thing, just be sure to watch your step on the way down to the restrooms after you've had a couple of pints.