Oh yeah, any time you see "AS-IS not tested" you can be assured it is definately bad.
I agree. As-is = broken. A while ago I was looking for a good deal on a digital camera and I stayed away from any as-is's because I didn't want to spend money on anything that didn't work.