I vote Spartan Mansion as well based the side view but definitely not a Spartanette. It may never roll again but what a nice vacation spot (though I wonder why it says waterfront yet doesn't show the view or list the water frontage.
The trailer may not be as abused as it first looks. The roof may be just an unattached covering and the bland walled "living room" pictures are the clapboard sided addition with the furnace and chimney which probably attach through the second side door.
I don't know the area but Mass property is very expensive so I'm guessing the price is not outrageous for almost an acre. [WOOPS, THAT'S .08!!! ]
Pushing it as an Airstream is a travesty!
I'd go look at it for fun if I was closer
Steve