An "as is" property can mean lots of things to different people. Probably the most common meaning is that the seller wants an offer without a list of items to fix. They may know of the items or the items may come out in a inspection that buyer completes. Sometimes fixer-uppers are sold "as-is" and the price reflective of the repairs needed.
Here is another thread previously posted on Trulia on the same topic.