A CV (constant velocity) joint is the joint on each end of the axle shaft (halfshaft). This is naturally on the front, and connects the transmission to the hubs. There is a rubber boot over the joints. Once the boot tears, grease comes out, water comes in, and the joint starts to go. I've had to replace one of mine twice in 120K miles on my 95. The second time I learned to do it myself.
I strongly advise against the automatic unless you know for a fact that it's had its fluid changed very regularly.
Check naturally for oil in the plug holes (I just replaced the rear valve cover gasket on my 95...trust me it's not a fun job!)
Generally these cars hold up pretty well. Everything on mine works after 120K miles, and the engine is in wonderful shape. The manual transmissions are also bulletproof.
Check for 60K and 120K timing belt replacements, if applicable. If over 100K, check for water pump replacement too. It's about a $300 job at the dealer to replace said belt, and it's common to do the water pump at the 120K replacement. Water pump adds some labor and $70-100 in parts.
Tyson