I bought a property thinking it was gold, but I was all over the place

So here's the thing: I was eyeing a duplex in the city core, thought it was a slam dunk for rental income, and I signed on the dotted line after a quick zoning check that turned out to be a misread I was convinced the area was booming, the school district was top notch, and the property was undervalued, but it turned out the zoning maps had a hidden commercial overlay that capped the units I could legally rent out. I basically got a two-unit shell with a legal ceiling that limited my revenue potential.

I tried to justify the move by pointing to the low purchase price and the fact that I could flip it when the market recovered. I even tried to convince myself that the zoning change was a temporary glitch that would be corrected in the next council meeting. Spoiler: it wasn’t. The council stuck to the overlay and the duplex stuck to its new, restrictive status. Now I’m stuck with a property that can’t generate the cash flow I promised to my partners, and I have to scramble to find a way to make it work.

Anyone out here has had a similar real estate snafu? I’d love to hear your stories or any advice on turning this mess into something profitable. Maybe a little DevOps mindset could help me automate the rent collection and find a niche tenant market? If you’ve seen this happen or know how to fight zoning overreach, I’m all ears. Also, if you have any constructive criticism about my approach, I’m ready to take it.

PS: I’m not trying to brag – I’m just confessing that I got my own lesson in market research, and I’d rather hear your take than just sit here with the paperwork.