You've unfortunately unlocked the centipede effect by saying Columbus.

What's the most effective means of dealing with this issue?

Its much more cost effective to outsource things like skiptracing and direct mail.

Read: The millionaire real estate agent; Hyper Local Hyper Fast AgentWhat are some effective ways to network with individuals at all levels?

The 1st position heloc has nothing to worry about because it will still be attached to the property after the 2nd position heloc forecloses....death of the borrower has no effect on it.Likely not time to make a deal with the “owners” since that would likely involve probate, and time.  

So I would say to continue to develop yourself at work and learn how to invest effectively on the side.

It reduces the “bouncing ball” effect of tasks being passed between departments. 

It's just a single family home so the rents don't effect the appraised value.

Effective  12/1/2024 @ 12:01a the Louisville rental registry requires the 16 page Lead Hazard Evaluation form in addition to the Affidavit of Compliance.

If that is what you are looking for.You have seen it now:It takes a good second to understand what's plotted in the scatter plot, but this is my version of that.