I would plan to long-term rent the property from day one and would never reside in the property before renting.  

Excited to see where you put that equity next—what’s the plan for reinvesting? 

Still, I think you'd find it difficult to find one that would be a good long-term investment unless you had another ~20-30 years to go, it's at least cash neutral, and you don't plan to hold it too long (to avoid too much investment loss and before you get to the point where it's unsellable because of too few years left); that's another way of saying that maybe it suits your cash needs in the near-term or is at least less of a pill to swallow than other options until you find something that's more of a sensible long-term play

We plan on living in the house and doing most of the fixes and renovations ourselves.

I recall reading about it in CNBC...The quest for solid returns in our current market might feel daunting with interest rates where they are, but the good news is.. if you find the right deal and set clear criteria.. like a minimum cash flow target, or a plan for eventual refinancing.. your numbers can still work out.

Also ask, when you submit the plans does the city give a hard time on all the stuff or just a couple things. 

Maintenance and potential repairs will also require a long-term financial plan and setting aside a contingency fund for such expenses.The steady cash flow, appreciation over time, and tax benefits can make a meaningful difference to your wealth in the long term, especially with the principal paydown on the mortgage.However, if managing the property from a distance feels too burdensome, or if you’d prefer the certainty and flexibility that comes with having less debt (especially given the high mortgage rates), selling and using the $100,000 in equity to reduce your loan for your next home may be the smarter move.

I'm planning to use that money for a downpayment  to buy a multifamily where I would live in one side and rent out the other side. 

Planning for property management, scaling strategically in one market, and being conservative with financing can also help avoid costly mistakes.If you're considering out-of-state investing and need insights on markets, property management, or financing, DM me and I’ll point you in the right direction!

I plan to hodl for the long term