This product was mentioned in 5 comments, with an average of 1.00 upvotes
Get this mattress: [link]
Amazon also has a bunch of frames for not a lot of money. I'd go with a wood one over the metal ones personally
What size mattress? If by chance it’s a full sized mattress, you could look at futon mattresses. That’s what I’m using for now on my adjustable base and it works well enough. My mattress is something like this one, but a 6”. It has the independent coils like this one:
Otherwise I’d look for a foam mattress. Check CostCo. I don’t think you need a membership to buy online. They have a good return policy and some cheap foam mattresses. Amazon does too but I’ve seen some questionable reviews of some of the cheaper ones, like trouble with the glass fire retardant layer (don’t ever unzip the cover!). So make sure you do your research on the mattress first. Some hybrid mattresses work on adjustable bases too. You don’t want the kind that have wire frames to hold the coils (inner springs). You want pocket coils.
Buy this. I use this one and NO ONE has complained at all. Anyone who ever sat or laid on it loves it. My parents have this for their spare bedroom, I have one in the living room and I have one in my bedroom (with some added foam). I have a buddy who crashes at my place who sleeps on the living room one. No issues from him either.
We all have the 8 inch.
You can get a pretty cheap futon with a REALLY good mattress for under 300$ if thats within your price range.
I did the mattress on the floor bit for 3 years after moving out to wyoming and it fucking sucked. Killed my back, never wanted to have anyone over and even less entertained the idea of having a woman over.
Suuuuper comfy and doesn't give out easily. I've had mine for.... shit over 4 years now and its almost as good as it was day one. Not the easiest set up to have sex on lol but it'll work. And i guess the frame they recommend is also the one i bought, it can be slightly noisy but nothing terrible. And the price for both of them is about 200$ thanks to the frame being on sale!
Hopefully you can get something like this. Just something as simple as being able to put your feet down when you wake up out of bed is a game changer.
Futon's the way to go for a bed-like mattress while saving space - this one seems popular.
For the ultimate in space-saving, have you considered a hammock?