I used to live in the property and are in very good terms with the previous neighbors, and don't want to risk anything given the shady past/current behavior from the tenants. 

Instead of getting the typical FHA (203b) loan, get the FHA (203k) loan.  

I personally love Columbus in terms of doing value add.

On a DSCR refinance, you can hold title in an LLC, however a person will need to be on the loan (not an entity). 

Based just on your DSCR calculations, it appears this property is significantly under-performing, or if it is operating well, then it is significantly over-priced.If your plan is to reposition the property, then you need a bridge loan or private loan to acquire and manage the property. 

Mortgage, Taxes, Insurance, HOA: $3040.37Estimated rent: $2475Total Expenses: $3660.12Vacancy (5%): $123.75Repairs (5%): $123.75Capital Expenditures: $100Property Management (11%): $272.25Information when I bought the house in 2022, new constructions Purchase Price: $373000Purchase Closing costs: $4662Current home value: 400k-420kCash Flow: $2475-$3660.12= -$1185.12; -$71107.2 at 5 yearsCash on Cash Return on Investment (CoCROI): 0%Appretiation per year (6%); $535,290.23 at 5 yearsEquity: Loan value $345,089.53 at 5 years; $190,200.47 in equity at 5 yearsLoan Value today 6/2024: $368,201.59Total ROI in 5 years= (Total profit/Total Invested capital)/ Time (in years); Total profit: $190,200.47Total Invested: $71107.2 (neg cash flow) + $42757 (closing sale costs)= $113,864.20Total ROI (5 years)= ROI 67%, annualized ROI 10.8%My biggest concern is that I am relying solely on appreciation and assuming will appreciate at 6% per year. 

Depending on the loan amount and LTV there are even some automatic issuances with no appraisal requirements. 

If there is a credit, then that will be handled in escrow.Yes, make sure that you try and use all the money from the sale of the first home and if there was a loan on the property it also needs to be replaced on the up leg. 

Are you asking about a loan for your emd?

Have you used your owner occupant loan on a house yet, and if not I would try to find somewhere to house hack.