Chiang Mai Hotels near the Night Bazaar
Seems like this is the subject of most interest right now.
D2 is the best hotel in the area (other than The Chedi I suppose) -- but a little pricey at 3,600+ baht per night on average.
The Central Duangtawan Hotel is without a doubt the best quality for your money at about 1,200-1,600 per night during this time of the year. The nicest pool and weightroom for a hotel in Chiang Mai. And its right across the street from the night bazaar.
Slightly higher in price is the Imperial Mae Ping or the Royal Princess Hotel -- very nice, and right in the middle of the night bazaar.
Slightly lower in price and quality but right dab in the middle of the night bazaar is the Suriwongse hotel (old hotel) and the Royal Lanna Hotel.
But yeah, if you can afford it, go for the D2 hotel -- it's new, sleek and right there in the night market.