Cheap housing plan rejected in village with ‘astronomical property prices’