Bummer on the automatic.
But $500 is hard to beat.
If you didn't already have other plans to change it, I'd say sell the Accent (with the relative's blessing... making a profit) and find something with a stick.
Mirage CVT, eh? You've probably seen this already:
Gas mileage/MPG test: 2014 Mirage CVT vs. 5-speed (sub/urban Ottawa route)