- and finally once you do this, realize it will never even be close to how it actually plays out in real life, but it can serve as a guide for what sort of money you may need to save up to try and actually accomplish something like this.

They are not motivated.

I would like to be able to occupy the property for 1 week every 4-6 months, which they agree to (with enough notice on dates) as they have to travel for work at times and could easily vacate during these periods.Has anyone written this sort of agreement into a lease?

They will take anyone that is "motivated" just like how they target "off market deals".

., hopefully they will sort things out.

Jackson MS 80% of your rental pool is on some sort of subsistence Portland maybe 15%Jackson life long renters ..

I believe part of their motivation is that they would have to cancel reservations to get the remaining work done. 

I have an entire podcast dedicated to passive investor fears and almost everyone i've talked to had some sort of fear that they had to educate away.

To my knowledge there isn’t a BP page for Columbus overall; you need to do your own research or use the resources of motivated investor-friendly realtors like ReafCo.

Getting everything sorted early on will save a lot of headaches later