Welcome to TRS
Used Ranger buyers guide here:
https://www.therangerstation.com/ford-rangers-buyers-guide/
1997 was last year of 2nd generation, 1993-1997, or 3rd generation depending on who you ask, lol
It had 3 engine options, 2.3l 4cyl, 3.0l Vulcan V6 or 4.0l OHV V6
All were good reliable engines
If automatic trans the 2.3l and 3.0l would have 4R44E model, 4.0l OHV could have 4R55E or 5R55E, but same thing, lol
Same basic automatic was used in Rangers from 1985 to 2011, just more solenoids added in 1995, 26 year run, so good reliable transmission, but like ALL automatics expensive to repair if not serviced
If manual then its an M5OD-R1, used from 1988 to 2011, also reliable, uses ATF not Gear oil
4x4 transfer case is a BW1354, also reliable, came in Manual or electric shift, if electric then the GEM module controlled the shifting of transfer case
It came with Automatic hubs to lock and unlock front wheels in 4WD and 2WD, they worked fine if serviced and not over greased, but many owners switched to manual hubs if there were issues in locking and unlocking
Because of the low miles you will start to have lots of small leaks if you change it to a daily driver, just one of the drawbacks with "low milers", sitting causes seals and gaskets to dry out
Just have to fix the leaks as they come up
If automatic I would have trans serviced ASAP, and oil change for engine, if you buy it
You can pay Ford about $150 to do an inspection(on any used Ford) before or after buying and they will tell you whats OK and want needs attention