Here are a few options:1)HELOC for repairs and flip it for profit2)HELOC for more rentals and hold current to pay off HELOC3)Seller finance to reduce tax obligation and receive. a large enough initial downpayment from buyer to use FHA for a primary4) Hold and use cashflow with the specific intent to invest all residual income5) Sell and take "Capital Gains" hit but purchase another property to help offset it6) Transfer deed to an LLC to remove it from Grandma's name (this opens another door of possibilities but may trigger tax increase due to transfer of ownership)I can go on, and others with different approaches can add to this list as well.

Do any data providers have code violations, or any other way to find these lots?

But I am a bit of a perfectionist and want all the data in the spreadsheets to flow to the top like the bank has it set up. 

Assuming lender is willing to work with you, you should be able to work out a modification/renewal that would get signed at closing by seller and lender along with the transfer document(s) that would be signed by you and lender.

Some counties in PA have that data on the tax assessors website.

Watch transfer taxes based on PP.

This is fully vested from day 1 and also transferable. 

She advised to us prior to paying for an inspector, that the house is FHA approved, which is why we moved forward to pay for an inspector and put an offer in.We’ve come in 25k lower than asking, based off historical data in the area.

Lets run the timeline2010Grantor: "B" WholesaleGrantee: MaiersSpecial Warranty(signs point to a Foreclosure sale)2009Grantor HendersonGrantee: "B" WholesaleAs Substitute Trustee(Signs point to a foreclosure)2007Grantor HumphreyGrantee HendersonNon Warranty(Humphrey sold share in property to Henderson)      Transfered to Trust in "A" Wholesale2006Grantor AbernethyGrantee Henderson and HumphreyGeneral Warranty DeedSo my question is two part. 1) Why would someone sell their share in investment property through a non warranty deed?

I would spend the money to instll individual on demand electric hot water and transfer the costs to your tenants.