NO mattress included.
I have a queen size MALM Ikea bed for sale that is disassembled.
Some photos of it assembled as I don't have the original instructions but you can always look online to find a video on how to assemble. Not that difficult anyways.
Some damage to the foot board but once you get a mattress on it you won't see it.
Comes with a couple of storage doors that tuck in under the bed.
You will need a Pickup truck or an SUV to move the pieces.