I would appreciate any knowledge share, or tips and advice on where to gather information to properly estimate for such a project. 

Your intermediary must be in place prior to the closing of the sale to provide the proper documentation.

There are going to be three levels of addressing this 1) things you can simply go there and do anytime (pick up pet waste and throw it away) 2) things you can do given proper notice (enter the unit and inspect, repair damage etc) and 3) things you can only do given proper process/procedure (notice to vacate, increase rent etc.)

I appreciate your recommendation to proceed with caution, as investing without proper research indeed carries inherent risks.Thank you and best of luck, as well!

However, they only work if properly used.

But any company that properly creates and maintains a liquidity sleeve like I described above, is going to be able to honor its commitments. 

Renting as a vacation rental might work during hunting season but there really isn't much to do there that would attract vacationers in the winter.

Hello, I am looking for advise on the proper steps to purchase an upcoming foreclosure estate property from the executor. 

Also make sure they have proper license and insurance and name you as additional insured for liability.

Let me guess - you never verified if they are a licensed PMC or if they have proper insurance.Do they even have a website with an Owner's & Tenant's portal?