An ecobeater is a car that isn't popular, pretty or even clean but gets you from point a to point b using the least fuel as possible.
The list in no particular order:
Chevrolet Prizm: First branded a Geo, the Chevrolet Prizm came out of the same factory as the Toyota Corolla. The Prizm offers Toyota reliability and fuel efficiency with the resale value of an American car.