I bought an air mattress under the same parameters that you are asking. Occasional use for guests, great option for an emergency, queen sized, and built-in pump. I landed on getting one from Costco because of their lifetime warranty. Costco previously replaced an old air mattress that had the seams wear out, so I can vouch that they stand behind their word. They currently have two models for sale at Costco. The brand I bought was Aerobed. It doesn’t look like they currently sell that brand at Costco anymore, and I can’t find the exact model that I bought there being sold on Amazon or at Bed Bath and Beyond, the other sellers of Aerobed. Unfortunately I won’t be able to tell you an exact model to buy, but I’ve enjoyed Aerobed’s quality.