We have a big 3 room tent, similar to
This One.
Ours is the same maker, different style. We love it. We can fit a queen size air mattress in it and still have one room available for other things (kids, clothing, etc). We can stand up in the center room, and almost stand in the side rooms.
If you have to carry stuff anywhere, carrying this tent is not so much different than carrying any other tent. They are big, ya know? If you're gonna have a tent big enough for kids and all, it's gonna be big, but they fold down into an easy carry bag, we pack this thing in all the time!
oh, and they sell this type of tent at Costco.