S&N sold the land to Newcastle city council in 2004 I think. The deal meant 14.4 acres of the site have now passed from Scottish & Newcastle Breweries to Newcastle City Council, One NorthEast and Newcastle University who have pledged to use Science City status to enhance the region’s growing reputation for pioneering scientific research and as a key location for knowledge based business.
Here is an old article about the closure. S&N to close Newcastle brewery
Here is what remains of the site some 2 years later in January 2006.
Demolition photos May 2007
Demolition Photos July 2007
Inside The Breweries August 2007
Demolition Photos October and November 2007
Demolition Photos January 2008
Demolition Photos March 2008
Demolition Photos May 2008
Demolition Photos 7th June 2008
Controlled Explosion 22nd June 2008
The last remaning part of the breweries to be knocked down was done with a controlled explosion. Here's a few before and after photos and a video of the explosion as well.
Video of the detonation taken from St James Metro car park
Video from the Evening Chronicle features Sir Bobby Robson pressing the detonate button.
Here is a few ironic pictures sent in by Rowland Barker an ex-Heaton boy now living in the States. Thanks Rowland.