The major transformation included popping out the living room ceiling, to create a loft space instead of an attic.

That's an example of creative financing, using existing assets to transform a deal.So, to get into any creative issues with you, you'd need to provide alot of information about the parties involved, and I suggest you not do that in any forum, BTW!

Intel is a great example, who is building the largest chip manufacturing plant in the US right here, and it will be a $20 billion dollar investment that brings a few new thousand jobs.https://www.dispatch.com/story/business/2022/01/21/intel-ohio-building-computer-chip-factories-licking-county-jersey-township/9173472002/ Another example of economic growth is the upcoming Ohio State University Wexner Medical Center Inpatient Hospital which is a 1.9million square foot hospital that will bring over 800 new beds and a thousand new jobs. https://abc6onyourside.com/news/local/new-osu-hospital-expected-to-transform-health-careHere are a few more recent investments https://www.10tv.com/article/money/business/hydrogen-power-company-hyperion-bringing-700-jobs-to-columbus/530-25907aab-5517-4661-a9f3-d2ed2d5be6b0 https://news.wosu.org/news/2022-02-08/rumpke-to-build-50-million-recycling-facility-in-columbus Check out The Complete Guide to the Columbus, Ohio Real Estate Market which goes through the Columbus, Ohio market in depth and will give you a better scope of where the highest levels of growth are taking place and where to look to invest.

As a bonus, if I improve the property values of a neighborhood it helps to transform the community. 

Remember that the biggest profit is in transforming an ugly, not-mortgagable property to one they can get a mortgage on.

@Gaston BaruaHi Gaston,Make it your "Massively Transformative Purpose" (Peter Diamandis).  

Any advice on transforming all,or some of this property into an income producing asset? 

Let me know your frustrations and how are you dealing to manage with these obstacle's.Don't get me wrong it is rewarding to transform a house or real estate property into something beautiful and sale it.

And if you are running electric from a pole, it needs to have a transformer on it (add ~9k for a transformer).

It's been permitted to partly because of term transformation and rate refinancing over years - all monetary expansion.