What would be a good telescope to purchase? I have seen those telescopes on sale at places like Wal-Mart, but people told me those are "trash-scopes".

Then I looked on the Internet, the price varies from a few hundred bucks to five grand. For a casual amatuer city-dwelling cosmo sightseer, what would be a good and affordable telescope to get?

Thanks in advance.