The median cost of a home in the city is now $1.7m, a record high, according to the latest figures.