Trash it - the thing is no good. The very best way to utterly kill a battery is to just let it discharge and then let it set. From your description that is exactly what someone did to this one.
To answer your question though, a battery that gets any sort of decent treatment will last 3 years and if you don't over heat it, keep it charged and full of electrolyte, and don't store the bike with it partially discharged it should last five years or more.