The TCL 5,000 BTU Mini Mechanical Window Air Conditioner is a unit that fits into your window.  It takes a bit to set up and is very loud when it runs, but it does provide cooler air for a smaller room.  It is a fairly energy efficient model.