Now here's an example of a flipper who is honest about his "as is" bike. Hopefully this finds its way to someone who will put the work in that it needs:

http://newyork.craigslist.org/mnh/bik/2551737561.html