I purchased a property in Missouri June 2023. I am questioning the appraisal as it was a $100K discrepancy from previous appraisal. My question is, are appraisers allowed to include comps that are still active and not sold yet on the appraisal? Thx!