Another circumstance is that they may realize they have ownership, but for some reason or another they don't believe they can sell it, which with rare exceptions generally isn't the case......they can almost always sell.These are absolutely great leads for newer investors because you don't have to have a huge marketing budget to pursue them, they are much easier to negotiate and contract, and much easier to access and show to investors because generally the heirs to the property will tell you to help yourself to viewing the property and inspecting whenever you want without them being present.  

Can anyone suggest a brokerage that would consider working with someone in my circumstance? 

For one, I would not trust Zillow to pay out under any circumstances, so there's that.

It's all about finding the right fit for your circumstances.

Its important that you go with the plan that makes the most sense for your facts and circumstances  

I beleive this is an important distinction because you appear focused solely on apartment buildings that were acquired because of favorable debt or other bad projections. 

Before making any decisions, it's crucial to consult with a legal and financial advisor who can provide personalized guidance based on your specific circumstances.

Do we know the circumstances that may warrant the city needing one?

Not able to edit this post. will duplicate a new one with the right city.No worries: It's a fairly universal distinction across the U.S., including Columbus, OH.An assessor ("auditor" in OH - https://property.franklincountyauditor.com/_web/search/commo...) determines value and enforces the millage rate; the commissioner ("treasurer" in OH - https://treapropsearch.franklincountyohio.gov/) issues the tax bills and collects payments.

You are required to stay in the home for the time of the mortgage and the lien is the way the ensure this, but this can be removed in certain circumstances that would allow for it such as getting a new job that would require you to move, or a death in the family etc.