i have visited chaing mai a few times on my exploring in se asia the last few years. chaing mai is my chill out town and this is my chill out neighborhood pub when i'm there. the pub has the best western food when the urge hits (at reasonable prices but be sure to be really hungry as the servings are large). thai food is good but you can usually get it a bit cheaper at the numerous small family joints nearby sitting on plastic chairs with the locals.
atmosphere attracted me the first time. great location in the old city. staff really friendly and helpful when you're a lost traveler (and most have become friends over the subsequent trips). the rooms are clean, comfortable, basic and functional and budget priced. lots of exploring options within walking distance. nice inclusive set of clientele usually. locals, expats, tourists, backpackers, lbgt community, solo travelers etc all having a good time in a local pub atmosphere.
highly recommend stopping there.