I bought a unit from a French DIY place about 10 years ago, Mr Bricolage I think, as the temps are regularly around 40'c when we go to our little place in Provence.
Think it was around 200 euros back then. Its been brilliant, cools down to 17'c which is fine for sleeping. Only drawback is its a little on the heavy side and you need to vent with the curly pipe thing outside, which we do through an open window, stuffed with blankets to make a seal.
Much better choice out there I would suggest