I’d not sleep on a blow up mattress beyond few nights, I don’t find them comfortable at all. IKEA has fold up sofa beds that look like love seats when folded, they take very little place as they aren’t like sleeper sofas, they unfold differently: part where you sit on when folded is not length, it’s width of the bed. When unfolded they are full size beds, fit two people if not too big lol.
They are very inexpensive and we’ve been happy with it for a guest room. Although I see if you don’t have out of town guests, it will be a waste later. I just can’t imagine sleeping on air mattress much