If you truly believe your tenant won't destroy the house then there's hope.

I have thought about off campus property but dont want them to destroy it

At least she destroyed her grill in the process.....

But I think you will probably find a few that are fine with them as long as the HOA costs don't destroy the cash flow potential.

There will always be new tenants, so don't worry about the turnover, there won't be any turnover if your rental is destroyed beyond repair. 

I’d do cash for keys in this case :Tell them that you are supposed to give them 60 day notice ..and if they don’t destroy the building and agree to vacate before lease is up ..you’ll give them their full deposit back plus additional 100 bucks ( or whatever you’d want to add to entice them ) if they are making things really bad for your good tenant then the good tenant probably won’t be there much longer either if you don’t do something

I like to look at the "Top 10" Airbnb's in my city and look at their stats.As far as people destroying property, it definitely can happen.

Punched holes in the vinyl, broke windows, destroyed the crappy plastic gutters.

I have personally owned over 500 doors over a few decades and have KNock on wood never been sued by a tenant expect for deposit squabbles.. if anything we sue the tenant for destroying our units.. .

If not, I would just be nice as you can to the tenant and make regular property inspections to make sure the tenant is not destroying the property.