I'm not certain how large tanning bed lamps are, but I'm guessing they are 72" or less (stardard 48"?). If so, then those will fit inside a Fit, Yaris, Matrix, Focus, Prius, Subaru or just about any other hatchback/wagon out there with the seats down.
You don't seem to like the minivan option, and for you that's probably not the most efficient choice.
I'd sell the ranger and buy any of the used vehicles above (or search for cars that get 35+mpg highway). All of those listed above fit that bill (except the Subaru impreza wagon, which i believe gets just under 35mpg.