I have a 1999 Camry with only 107K, but it's been a great car. I bought it a year ago for $4300 off CL which was an excellent deal at the time. The 4 cylinder 5S-FE engine has an outstanding reputation for reliability, as long as you pay particular attention to 2 maintenance items: oil changes and timing belt/water pump. I did a lot of research prior to buying this car, so I can give you a few pieces of advice.
First off, avoid the 6 cylinder engines. They do not have the longevity or reliability of the 4 cylinder ones. This is true for late 90's models, but I cannot speak for newer ones. Second, find out if the timing belt/water pump have been replaced. This is supposed to be done every 90K miles, and costs approx. $800 in this area. If this hasn't been done, be sure to take it into consideration in their asking price. Most late 90's Camrys in good condition around here can go anywhere from $2000-$5500 depending on mileage.
Overall, these are great commuter cars that will last for a very long time if you take care of them. Just be patient and keep watching CL for a good deal to pop up. Good luck and happy hunting!