Generally, I hate air mattresses, but I make an exception and can vouch for the queen-size Aero Bed. I slept on one for 8 months on the carpeted concrete floor of a duplex patio home in 2005.
I've got a broken back and I'm very fussy about what I can sleep on, but the Aero Bed did the trick...