Also, for us, our MLS system plugs into the public records through a system called Realist.

I gather that someone can write a note and lein a property, but T would like my generous high-LTV lender to gain the benefits of tax shelter. 

You can also get a PayPal credit card scanner gadget for next to nothing that you can plug into your phone and scan people's credit cards.

Once I find one that looks good on  Clik2Flip , I usually plug it into this Excel sheet and research each line item to make sure it's as accurate as possible. 

I have that as well as a few other common sense rules - like don't throw cigarette butts on the ground, grills/BBQs can't be used inside, etc -- the lease is a bit lengthy, but I feel having some of these stated is required. 

Management stepped in and worked their butts off to make it right though.

Doesn't have to be fancy, just want to plug in how the market value of a property can change at various cap rates, change in rents and occupancy.

That's hard to say, because a butt-joint wall like that can have some of its own slight movement. 

As an investor I hope you are trying to buy properties from someone at X minus 40% (getting a discount (plug any %)).

Do the work and know your stuff, and kick their butts to the curb man!