Do a search,there are several posts up on Chiang Mai. I like it, get a Hotel on Loi Kroh Rd. The Ramming Lodge is a reasonable choice in the middle of the action. Foxy Lady is nearby and is the only go go. There are a couple of Soapies near by,nearest one is just past the night market called CelebX,last I checked. I use Thai Airways or Air Asia,not sure about the others. Most things are cheaper there, lots of bargains at the night market. Plenty of options to play but nowhere like Bangkok or Pattaya. I always take the trip up to Doing Suthep,go early to avoid the Crowds. Be ready to see more Chinese travelers, they like Chiang Mai. The Elephant Sanctuary is also a nice day trip into the mountains.