Of The Top 4 Foreign Cars The Nissan Altima
IMO has the best lines & is the best looking. But, if you want reliability and LONG life I'd go w/Camry, Accord, or Jetta. All more pricey than the Nissan. MY Camry had 200+k and still was trouble free. Also had an Accord, same thing. But I would not hesitate to get into the Nisan. Great looking and just a tad below the top 3 listed. If you qualify for the "Gas Guzzler" rebate. you can get into a NEW Camry in the TC area for less than 15K!
As far as this car I'd follow Gravey's advice, get the $$ down, get a Carfax, and have someone you trust drive it.