When do they appraise the house? Before the loan is approved or after?

Before. The loan approval is based, in part, on the value of the property. The appraisal certifies that value.