Can you install a window AC? I don't know what your financial situation is, but around here you can buy one for less than $100.
I actually have one in storage that I'm not using; if you lived closer, you'd be welcome to it.
(Okay, so I'm being a man, suggesting solutions instead of being sympathetic... sorry! Consider yourself duly sympathized with. )