They almost flooded the entire ceiling the first day because they couldn't even figure out how to turn the water all the way off.I am looking for an answer on how I can deal with this.

You can try to research to make sure the utilities are there for sewer, water, electric, etc. 

Insurance companies often pay for temporary housing for families displaced by things like fires or floods, and they usually cover full rent!

You could tear out everything and spray the lumber with Monterey Consan 20 (I used it in Louisiana after the flood of 2016).

No to very little crime no worries with water or food borne illness's  etc etc.  

And yes, I can still achieve this mark but I also have no interest in marketing that fact with a treasure map to flood my "honey-holes" with _-holes to just ruin it all....  

Haven’t discussed pricing yet but probably won’t get as great of a deal on this one but it is a beautiful log cabin with big windows and fireplace overlooking the water.

I already owned a home not on the water.

I'm considering making this property into more of a mid term rental as an interim spot for people that may have experienced a flood, fire or are moving or renovating and need an interim space. 

Where I’m at, if you list on Zillow, and you are priced right, you should be flooded with applicants for an affordable property… but the ‘flood’ decreases as your price point moves up.