While sales in affluent suburbs are lacklustre, sales at the lower end of the property market are starting to sparkle