What I'm looking for is a godsend!!! Or to put it more frankly I need major help from you guys as I really am out of my depth here

. What I'm probably asking is the impossible but I am looking to buy a digital camcorder for no more than €800.
I want to try and get a camcorder with a high optical zoom (20x or higher), a high CCD size (no less than 1.3), DV-in/out, AV-in/out, USB, a memory card and to be small and light.
The camcorder should be able to take digital shots (hence the reason why I want a high CCD and the memory card), good sound quality, have steadycam and night shot mode. I don't care too much about special effects as I hope to do that later with software.
What format do people reckon? I hear that DVD still has a few glitches so I had thought MiniDV but if anyone thinks different then let me know. Is there anything else I should be looking for in a camcorder that I have forgotton?
So anyone there have any suggestions? Also does anyone know of a good place to buy online for a camcorder at a good price or one that allows you to buy now and pay later which provides 0% APR over a time period and that also delivers to Ireland.
Tall order

? I thought so but if you can help it would be much appreciated. Thanks

.