We have the AeroBed Raised Quick-Inflate Bed (queen size) in our guest room. It has a built-in pump which is VERY fast. I paid $140 plus $10 shipping from
smartbargains.com - received very quickly. I don't believe they have queen size currently, but twin & full. There are a bunch of reviews on their site.
Very comfy, somewhat firm, not like a waterbed IMO as referenced by previous post. I haven't slept a whole night on it myself, but family who have stayed over really like it.