My lender needs an appraisal and by extension the appraisal company will do a thorough examination to provide an ARV for the lender to use.

It seems there are accountants/advisors that know a lot but I would like one to examine my portfolio and make suggestions.

Of those that I have dealt with, they do something called “asset-based” lending, which means they will examine the veracity of your deal and the numbers to ensure it’s good and limits some of their risk exposure.

It will be adjusted under audit or examination with substantial understatement penalties (because it's a frivolous tax position), and the courts will agree with the Service here.Third, if your LLC taxed as an S Corp owns the property, you ruin your Sec 121 exclusion, and probably your homestead status for property taxes.Please consult a competent tax advisor.

I’ve been examining a property in my market for a while that was on pre-foreclosure for 2 months and due to local county law they couldnt accept a lesser offer than their minimum of 77.5k.The home needs 120-130k worth of renovation and had 60k worth of judgments against it with previous liens.Now the home is listed with a realtor and the county is willing to accept lesser offers, but I don’t know if the judgments and liens previously against the property are wiped clean now or not?

You're really just rolling the dice on an audit/examination and hoping they don't look under the rug.Tax preparation and tax advice are not commodity services. 

Fitch also examined which states had the most overvalued housing markets.

@Shannon KiefhaberYour question cannot be answered without a thorough hour-long (at least) discussion of your business and your family's overall financial situation, current and future, as well as examining your tax returns and financials. 

If you have many comps that are different configurations, the Comp analysis will still allow you to examine Price/SqFt.3.

Again, others might feel differently here.3) property level due diligence: (takes seconds to weeks per deal): here is where I drill in with the low-level details.a) pro forma popping: I examine all the assumptions, and see if they are overoptimistic or not.