'Pent-up demand is just about running its course': August was another record month for Canadian real estate