If you're getting a mortgage, then yes, your lender will require an appraisal. The lender needs to order it. The Realtor should not be ordering it. Who's your Realtor and lender? Hopefully you're working with people who know what they are doing. But it sounds like you aren't!