That's an amusing-looking jalopy here, is it possible ones like this existed for real?

I'm four years late, but actually, yes, this was a real vehicle! It's the Piaggio Ape Pentaro Autopompa Antincendio Essentially, an integral trailer of fire-fighting equipment towed by a three-wheel Vespa with an additional engine.