I've asked him about it several times, he said it is perfectly fine for me to access MLS and to even show houses that he is selling.

careful with that approach. lets say you scheduled for 2pm. your rental is in C-. 3 ghetto queens with their baby daddies came over to check out the crib. standing there complaining about everything ...they will soon start arguing with each other...while ..there is another couple back there that just entered. they are looking at you, looking at them making 180 and leaving without a word. u know that couple would make perfect tenants ...but after what they saw they want as far away from this place as possible. screen first over the phone before you do group showings ....they always lie over the phone ...so what to do ?  

You have a tenant complaining about perfectly reasonable things, and everyone in here jumps on "raise her rent!"

How is a security interest perfected to secure your mortgage?

In my opinion if you try to create the perfect house to get the absolute most money you can, you are asking for trouble.

"Good is better than Perfect" I've been quoting that one all week!

looks like you found the perfect PM or I am looking at the wrong ones.

Still wouldn't happen right away.Try to approach the situation diplomatically with him - you'll cooperate with showing the place, you'll leave it in perfect condition, but you cannot stay with that level of noise.Hopefully, he'll work with you and release you from your lease, and not keep your security deposit.

Of course, that is over a year from now and I might start working with the perfect agent and decide I don't need to waste my time.

A sheriff sale is when a lien is perfected against a property, and a judgement is entered ordering a sale to the highest bidder by a law enforcement agency, usually the sheriffs dept.