I had the same problem, it turned out that the release mechanism inside the shift knob was broken. Sometimes it would work, sometimes it would not. My wife called it "the worst getaway car ever". The shift knob is easy to replace, just grab it and smack your wrist with your other hand upwa...

I would echo the solenoid check. When you depress the brake pedal you should feel it click. Isn’t a common failure with a small plastic gear tooth inside the shifter boot? If you get no click make sure your brake lights are activating and the solenoid is clean. Lots of coffee spills in that area!

I would put the front wheels up and see how the steering feels engine off , make sure the rack isn’t binding.

fix the scratches, get some quality seat covers.
but whats the mileage.?
maybe 4 to 6K

In my country it could easily fetch $10k or more maybe less because of the age, but a 2007 will surely get this much at least.