A North Wales warehouse site which fell into disrepair and became a haven for anti-social behaviour has been transformed into ...