Toyota, Nissan, Ford, Chevy and GMC all made small pickups that would do the job. Also the Mazda that was a rebadged Ford Ranger. Ignore the automatics and find a stick shift and you'll be good to go. Realize that almost all with have an automatic tranny, but keep looking until you find a stick shifter. 4x2 would be best, but those are are rare too, and 4x4 will do the job. I would look for a Toyota Tacoma, but they will cost you more than the other brands.
Realize you're looking for a pickup that's at least 10 years old, so finding one in good shape will be a challenge. Your best bet would be to go to the Southwest desert country of west Texas, New Mexico and Arizona, or even SoCal, to find what you're looking for that's not a rust bucket. I would NOT
any 10+ year old vehicle, even a Toyota, that had lived for over 10 years in Pennsylvania or nearby states.
None available right now in the Midland/Odessa Craig's List. El Paso has one possibility (if you can read Spanish):
97 TOYOTA TACOMA
Here's one in Phoenix that sounds perfect:
1999 Toyota Tacoma 4X4 XtraCab
And one in SoCal listed today, so it's probably still available:
99 Tacoma truck 5 speed m/t great truck