I have an older model of Dyson upright vacuum. It works in upright position and sometimes does work with a hose. With a handy support I'm sure it is fixable. It is pretty heavy so unless you like it or use it for parts/training I don't know why else you'd want it.
Nonetheless, pick up at Edmonds station if you are up for a challenge.