I have a midea U a/c unit for sale. Probably the best unit you can get. Super quiet and eco friendly.
They recently had a recall on this unit so I bought a different one. You still may be able to get midea to service it for you. I think they put some kind of drainage hole on the outside.
This unit comes as is. I can show that it works by plugging it on for you. All you will need the window installation kit which is why it’s soo cheap but, I don’t think the kit is very expensive.
Also, it’s heavy so you may need help bring it down.