A councillor has told of his shock that an average home in the New Forest cost more than half a million pounds.