Hi there I'm basically looking for a Digital Camera, with the following features:

1) A good Optical Zoom (More than 2-3X).
2) media preffered is CompactFlash.
3) would like its price to be less than $250.

Thanking you in Advance.