A planning appeal for 475 homes on a green site has been rejected.