Ideally, an agent and/or property manager experienced with out-of-state investors (I'm in NY), actively investing themselves, and capable of sourcing off-market deals for BRRRR opportunities.Thanks!

You always have the deposit to use when they move out, but that is not ideal because if there is that much damage you can see now, what other damage will you find once they are out.

Provide specific details about your ideal rehab process and your expectations.

The only caveat I would add is that you should be able to make the payment out of your day job salary, ideally with a bit of principal on top of that. 

While appraisers may resort to adjusted single-family comps as a less-than-ideal solution, considering factors like size, location, and amenities, it provides a starting point.

Everything is highly individualistic and there isn’t a “right or wrong”, but what works best for you and your situation. 1) what is your ultimate goal for your ideal investment property?

Ideally you buy with some cash flow, if necessary with more downpayment to get to a 1.2 DSCR.

My initial goal is to house hack, purchasing a small multi-family property within the next year, ideally the next 6 months.I am between Atlanta and Athens and have relatively little savings so unless I find a partner I will likely be using an FHA or USDA loan for my first property.

You get a DBA for your LLC and make a creative moniker to host AirBnBs, but ideally  you hire a STR property management company and pass most liability to them. 

Ideally if one of your flips does not go exactly according to plan, you can always refinance it and hold it as a cash-flowing rental.