You should inspect the unit to ensure it is safe, clean, and functional.

They are functionally dead from a  tourist point of view. 

Part of what the government funds is an indirect investment in an affordable and functioning US real estate market. 

Any deposit of money, the function of which is to secure the performance of a residential rental agreement or any part of such an agreement, other than a deposit which is exclusively an advance payment of rent, shall be governed by the provisions of this section.Subd. 2.Interest.

Then you won't have any problems with advertising. . . though if you do this without a license you might run into issues of functioning as a seller's agent without a license but. . . yea.

I nicely pointed out that state law only required that at least 1 bathroom continued to function and I made reasonable efforts to repair the other, which I did.

You really want to focus on making the house completely functional and livable.

When we sell the home, the door will be opened and it can be a functional single family home with a mother-in-law suite.

In Excel, use either a Goal Seek function or a Data Table. 

It's functioning but how concerned should I be?