
Recycling Centres in Newcastle upon Tyne, Tyne and Wear
Finding a reliable local Recycling Centres is often worth the effort. Here at Second Hand Bargains we try to make it as easy as possible to locate the Recycling Centres closest to you in Newcastle upon Tyne.
We would always recommend contacting the Recycling Centres first to ensure that they are open and have not moved out of the area.
We also provide links to some Recycling Centres that are not in Newcastle upon Tyne but have premises near by.
Instead of visiting a local Recycling Centres you may want to see what is available on ebay and better still you can register free.
(
)
SELECT
sqrt((abs(p.x - t2.x) * abs(p.x - t2.x)) + (abs(p.y-t2.y) * abs(p.y-t2.y))) as distance,
b.*, bt.*, t.nameTown, t.sefTown, c.sefCounty, c.nameCounty, p.* from business_shb b
join towns t on b.idTown = t.idTown
join counties c on t.idCounty = c.idCounty
join postcodes p on b.shortPostCode = p.postcode
join towns t2
join businesstypes bt on b.idBusinessType = bt.idBusinessType
where
b.idBusinessType = 170069 and
t.idTown <> 3921 and
t2.idTown = 3921
order by (abs(p.x - t2.x) * abs(p.x - t2.x)) + (abs(p.y-t2.y) * abs(p.y-t2.y))
limit 8BIGINT UNSIGNED value is out of range in '(`shb_shb`.`p`.`x` - `shb_shb`.`t2`.`x`)'