Just to be more precise about where they are, here's a Google streetview:
View Larger Map
There's also a series of Quicktime panoramas here (with further links on the right of this page). There's also a gritty/disturbing 2006 film of the same name which is set there. There are hundreds of other potential links, but the final one here is from a short BBC film of the area. The schedule for demolition is a little unclear, but the first block is supposed to be toppled in spring 2010.
Finally, I edited one of my very own Red Road photos (taken in 2005) to see what the skyline will look like from Petershill Road once they are all gone (the picture below is a small animated gif).
