'As-is': what does it really mean in a real estate transaction?

When Billy Joel wrote the song Just the Way You Are, it wasn't about buying a house...