I got a small room in the loft with a mobile air conditioner. Because of the heat wave when we left the room in the morning, had it ran all day on lowest temperature settings. When we arrived at 23pm, the room temperature was very high. My 6 year old son woke up 4 times during the night - and I could only sleep a few hours laying on the colder tiles on the floor.
After I complained at the front desk the next morning, I got two bottle of wines as present. So if you can bear heat and love drinking, there's no problem at all. :)