A mammoth 1,000-home development has been given the green light on appeal - seven years after plans for the controversial estate were first revealed.