Quoted From crandall:
Well, can’t go wrong with a Honda Civic or Accord. Gas mileage is excellent, reliability is good, and there are a ton of aftermarket and OEM parts available. I have owned two Accords and one Civic (all from the 90s) and was very happy with them. I eventually sold the Civic but the two Accords are still in the family. Both are well over 200K on the mileage.
I think the only thing that could really stop them at this point is rust. Of course, with older cars, you will still have to make repairs, doesn’t matter what model, so there is always a tradeoff between less money up front to buy vs. putting $ into it because it is older. If you like to do a little wrenching though, the Hondas are fairly easy for a DIY person to work on. Plus, ETCG has a lot of videos on fixing Hondas as well.
My dad had a 93 Honda Accord and he eventually gave it to me when I was 15. BUT when he gave it to me it had well over 300K miles on and it ran strong till he parked it. He did however, go through two transmissions on it because of the way he would drive it. That and the job he had required him to drive it up and down the east coast and he put about 50K miles on it a year. Needless to say he only had the job for two years. When he parked it it needed a battery, a front brake job, and a tune up. It sat there for about a year and when I got it, it ended up sitting in my back yard for a couple years. By the time I was ready to fix it it needed a windshield, four tires, all new bearings, new gaskets, the front brake job, probably a rear brake job, and it was held together by rust, that and my dad lost the title to it. Unfortunately I ended up selling it for about $175 to a guy for parts as I didn’t have a job or any tools or know-how. Now I’ve had some education in auto and done all the work on my car including a timing belt, thermostat, brakes etc…. But I’d love another Honda as I know they’re easy to work on. My Dad changed the transmission out on his in a day. I’d love a standard Accord or Civic as I believe they probably get better gas mileage than the autos. And I was unaware of the Mazda issue thank you for the tip!