what is there and rough prices,,, fed up of this fucking stupid fan that does fuck all

wanna get ice cold air and stay cool,,, cant have a big arse unit though as im not allowed to place things outside on the wall due to satalite bollox rules

what do you all use and where from/ price ect