I'm convinced there must be something wrong with it that I'm not seeing for it to be so low and to still be on the market so many days later.

Must occupy for 12 months like 203k.Another loan for Investors on 2 to 4 units is available to add rehab dollars into a 2 to 4 also that does not require owner to ever occupy.

You must study your local markets to determine the answers.

You need to get a good paying job and after saving/working for two years if you have sufficient funds for a DP you then approach a bank for a loan.To be a investor you must have cash, employment and a high credit score.

I am looking for recommendations on the best book, blog, podcast or resource that you would say is a must read/listen for someone considering flipping.

Getting off market deals is a must or take what the known city investors don’t want. 

Properties must cash flow from day 1Overall goal is diversification of income, enough to where rental income could potentially replace W2 income in the far future (we aren't looking to quit our day jobs, and for that reason this will need to be mostly passive in nature). 

The applicant for an ADU must be the current owner-occupant of the property.

You can get by for now with having the tenants supply their own window units, but the municipalities in NC where my rentals are stipulate landlords must provide a heat source. 

Especially due to a 1031 exchange.By the way, if your exchange is not finished yet, you MUST file an extension anyway.