I’ve never used them, but I had found these once upon a time. I ended up in an apartment that had a wall vent for me to use so I never needed this. The free standing units aren’t great but definitely better than nothing. To my mind they put out a lot of heat so you’ll want to keep the exhaust hose as short as possible. If you can insulate the exhaust hose so it doesn’t radiate it’s heat inside the very room it’s trying to cool, it should work better. At least there’ll be one room that’s a bit more comfortable than the others.
TL;DR: A free standing unit with a hose to one of these is an option.