I can't help much with what type of MH to purchase for your needs, but with respect to your budget and location (the rust belt), you may want to decide what works best for you and then search in areas more popular for RV's.
I spent a couple years in AZ and every spring there was a glut of used RV's for sale by all the snowbirds who had taken their last trip (literally and figuratively) or decided to relocate permanently.
Rust was not an issue because they all wintered in AZ and were only in the snowy regions spring through fall.
Mileage was typically low becasue they were mostly desination vehicles, 1 annual trip N to S and back.
Perhaps the only downside is that they all had alot of "use" of living quarters.
Not an issue for you since you dont really plan on long term use of the lq.
Florida is similar.
Just watch the used market in the snowbird areas in the spring. I'd bet it would be worth the trip.
