Average prices dropped by 0.3% in August, says Rightmove, as demand for bigger houses shrinks.