A note on appraisal waivers as it was mentioned above, assuming you are looking for a conventional loan which a loan under 417k that is not a FHA or VA is almost guaranteed to be, appraisal waivers are granted by automated underwriting systems that both Fannie Mae an Freddie Mac both use.
These waivers, called property inspection waivers (PIW) are based on your property and your credit file. In other words, to get one you likely have a pretty good amount of equity and likely have pretty good credit/debt to income/reserves. Again, these are determined by the automated system that all lenders, big and small, use. So, if you get a PIW with lender A you should get one with lender B as well.
Its a great money and time saving advantage but when in comes to conventional loans, it is not really up to the originating lender.