well there is ones like this but you gotta vent hot air and you gotta drain the bucket or run a hose to a floor drain. I had one in an apartment with tiny old 1900's windows. just vented the air and a water hose out the window on the second floor.
SPLIT AC is the one with the guts outside and the rad with fan inside. Still need to drain condensation away and have it installed up on the wall. pretty similar to having ducted ac in the furnace installed for plumbing.
you can also have 2 indoor condensers on one outdoor unit if its big enough.
