You have a calculated field in your query which we can't see all of. It looks like it involves starting price and may be the cause of duplication. You could try using the Unique Rows and Unique Values property (see query property sheet when in design view) but you can use only one or the other. If neither helps, suggest you copy this query and in the copy, start with 1 or 2 simple fields and build from there. When you get duplicates again, you will know which field is causing the issue. That's not always 100% the culprit as it could be working in tandem with some other field, meaning that if you remove prior added fields, the issue could go away again.
EDIT
it could be that the right outer join is creating multiple combinations because of duplicates of the HostId.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.