In my city the police did a recent round up for people who had outstanding warrants.

There was someone (illegally I think) living there for a month or so since there is an outstanding water bill.

It has a $60k LoE loan outstanding on it and is assessed for $190k.  

Then when that process reaches the point of auction, or auctioning off the property - the outstanding balance of the mortgage loan, plus Chase's legal and admin fees/expenses associated with their filing of foreclosure comprise that $342,096 dollar amount.

We let the tenants know well in advance and ask if they have any outstanding maintenance items that need attention.

Roseville is an outstanding place but prices are higher relatively speaking so your cash on cash return may not be as good.

Also, how can I make sure it's a clean buy as in there are no other outstanding loans, HOA fees, liens, ECT on the house?  

To me a personal guaranty just means that if your LLC defaults on payments that you would then be personally liable for the amount owed such that they could come after you for the outstanding debt.

I was also extremely fortunate to have an outstanding realtor.

Also check if there are any outstanding violations on the house.