Bought 4 light fixtures and 2 had glasses broken. grrrr.

In light of that then any option espoused by someone that involves you immediately incurring a potential $250,000 tax bill like selling and cashing out or selling without a tax mitigator like a 1031 or the establishment of a primary residence is not doing you any favors.The world seems to have forgotten but I still see a lot of people everyday working in Publix who were once paper millionaires who kept putting 20% down. 

Our realtor warned us they were difficult to deal with, and when the appraisal came back low there was nothing they would do to help us besides tell us to put more down. 

I'm curious if someone can shed some light for me.

I had some vacation rentals that were EXTREMELY profitable near a large corporation in a 1 street light town.

The low hanging fruit deals with light rehab and low margins are for the weak ;) Did you work with any real estate professionals (agents, lenders, etc.) that you'd recommend to others?

So hopefully the Bigger Pockets community could shed some light on this. 

The topic of agents is a topic that will keep in the lime light they will be lees less need for them . 

If you buy a Moen faucet at HomeDepot its feather light and made entirly out of plastic; you can get the exact same Moen at a plumbing supply house made of metal.I am usually over $3 per SF for top quality material.

I can see why you are annoyed, but the amount of time you will spend on trying to get this appraiser a light reprimand (which is all he would get because he will have an explanation like above) will not be worth it.