Consider a portable air conditioner (
not the same as a window unit) -
dual vented units start from around $400 at Home Depot.
Advantages are: no unsightly outdoor condenser, can be easily moved, and in some instances is more energy efficient.
Condensation water is discharged automatically through the venting hose, so, except in very rare instances, no water to deal with.
"Dual venting" is very important, to avoid a negative pressure situation - is worth spending the extra $100 or so premium; will save money in the long-run in energy savings.
http://www.homedepot.com/Appliances-...z0ze64=1z0ze64