This Northumberland town has been named the most popular affordable location for families in the North East, according to new Zoopla data.