Do you have Freecycle in your area? Everything there is free, and you can post what you need, too. It'd be worth the google search.
I too, have a big son that visits - 6'2", 250 lb body builder
vegetarian! We bought a standard twin bed and it's waaay too short for him. We didn't know they have longer mattresses in twin size. Anyway, it didn't take too long and he said that it hurt his back, it just wasn't strong
enough to hold up to his size (and too cheap to begin with).
Neighbors made bed frames w/ 4x4 posts, and then scrounged 2x material for sides, plywood for the headboard. It turned out pretty good. They did some
wood burning on the plywood and stained everything.
I have seen some amazing things built using pallet material. including kitchen cabinets. We had access to oak pallets for a brief period. There was no way to get the nails out, so we cut that part off and burned it in our
wood stove. Sigh, I wish we could still get them.
I just did a search 'make a bed frame using pallets' - pulled up several results that look promising. You
should be able to find some helpful tips/ inspiring ideas there. Good luck!