This is a large community and someone might give you some insights on the lender or the loan officer.  

Both Conventional loans and DSCR loans can offer this flexibility, depending on the specific scenario and borrower qualifications.

A better option if you can swing it is to purchase with your own funds, gain access, then refi into a loan.

FHA loans require living in the home as your primary residence for 1 year after purchase.

And in terms of the unit - we own 4 others in a 3 mile radius and are very familiar with comps.

Whatever you do, leverage smartly—DSCR loans can help you buy more without draining your cash, and depreciation will handle your tax burden for 2024.

Will I be able to overcome it's reputation in getting mid term renters?

Low appreciation may make the RoI from these assets low over long term, though they will cash flow on day 1.

@Scott Trench - have you considered investing in short term rentals, materially participating, and having the average stay be less than 7 days?

Metro Atlanta, generally speaking, respective markets 30 to 45 minutes from the City, will be tight on cash flow unless you implement a creative investment strategy, such as short-term rentals, medium-term rentals, or rent-by-the-room properties, or allocate at least 30% to 35% towards your downpayment if you intend to hold the property as a long-term rental.