A 450-home development has been granted at appeal despite the inspector admitting there would be harm to the local environment.