Sounds like quite a driveway. Do friends and family ever visit?
The best match could be a Toyota 4Runner. To get one for your price you might have to be flexible on age and/or miles, but they are among the most reliable models in our survey.
No manual transmission in recent years, unfortunately.
You could get a manual transmission in the related FJ Cruiser, which would also be less expensive, so that might be an option if you don't mind limited rearward visibility and a small, hard to access rear seat.