His appraisal of 470k comes in at 160sq ft. His lowest comp is 175 sq ft. Am I looking at this all wrong?
Using the $/sf based on the sale price (dividing the sale price by the size-of-the-home) is not the best method for evaluating an appraisal. The $/sf you reference includes all elements in a property. An appraisal (for a HELOC) breaks down those elements into significant components and makes adjustments on a line-item basis (as a rule). So, I wouldn't get hung up on $160 vs. $175/sf.
Where it sounds like you are looking correctly is the comparables that your Realtor friend provided. Based on what you have stated, it sounds like you have some reasonable questions.
There is a formal process called a "Request for Reconsideration". Your loan officer/agent should know how it works, but in general, this process provides a stakeholder with a method of going back to the lender and asking the appraisal to reconsider its original analysis. You have data (sales comparables) which you believe are better indicators of value than those included in the original report. This is what I recommend you do:
1. Provide those sales to your lender.
2. Write a short summary of why you think those sales are better indicators of value than the ones used in the original report.
3. Ask the lender to review your request and then see if they think there is legitimacy in your questions. If they do, they will pass it on to the appraiser. If they don't, they should tell you why that is the case.
4. If the lender believes the data warrants a comment by the appraiser, the lender will send the data to the appraiser and ask him/her to take a look at it and determine if they result in a change in the analysis (the "reconsideration").
5. If the appraiser reviews the data and determines a change is warranted, the appraiser should incorporate the data and make the changes.
6. If the appraiser, upon review, concludes that no change is warranted, the appraiser should let the lender know that is the result and, ideally, give the lender some reason why that is the case. For example, let's just say that all the sales your Realtor friend pulled were in a different school district and that school district had a premium associated with it and all the sales used in the original report were from the same school district as your home, so the appraisal used those same-district sales. You get the picture.
Unfortunately, some appraisers are reluctant to reconsider their original value conclusion; there is a history behind this which I won't get into, but it is a fact. Some believe if they make a change it is an admission of an error (and, they would be in error). Any of us can miss data, and if given the opportunity to evaluate better data than what was originally used, we should take that opportunity and incorporate it into our analysis.
Some things are black and white. I mis-measure your house by 500sf; you provide documentation that shows the correct measurements. That is a factual error that I should correct.
Some things are not so black and white. You think the sales 2-blocks away to the north are better than the sales I chose 2 blocks away to the south. That could be opinion and I may determine there is no change warranted.
So, contact your loan agent/officer and outline the issue as you see it. Ask about the
Reconsideration Process. He or she should be able to help you go from there.
Good luck!