HopStop (hopstop.com) .

You enter your start point and destination and you get the best public transportation routes - by bus or train (subway etc...)
(it even re-routes based on track construction)

I have used it quit a bit but it exists in it's own island , it does not have image views etc.. of what the place should look like after I get off the train. etc...