The city's housing landscape is cooling off as prices, along with the number of sales and new listings, tumbled in August