The property is equipped with modern amenities including forced air heating and central air conditioning, ensuring year-round comfort for tenants.

For example, I can get up-to-date pictures of a property (with time stamp on it) for as low as 10$ in 24 hours, most of the time it is more expensive to grab your car and go there in person if you also count your time invested. there is a great book called "long-distance real estate investing" by David Green (you can find it in BP book store or on Amazon) which goes over a lot of those services and find solutions to long distancing investing.

You may have some luck finding some creative solutions there https://www.biggerpockets.com/forums/50

They are now looking at retrofitting a guest access solution. 

Has anyone had a solution to this issue? 

Did you find a solution you’re happy with?  

We added significant value by investing $30,000 in renovations, focusing on modernizing the property's interior and enhancing its curb appeal.

@Tom Hall there is no magical solution that's going to bail you out of this:(

We invested $18,000 in renovations to modernize the property and increase its appeal.

There are some attractive financing solutions available to investors with options available up to 85% loan to value.