A 40-year-old home in the northern suburbs has sold for $1 million, the highest price ever achieved in a suburb known for its affordability.