I plan on living in one side and renting the other side out. 

Super cool apartment style living, but all one story. 

Preferably out of state near Charlotte NC where our daughter lives.  

My wife and I have done all the terms (short, mid, long term rentals) and have done some live in flips.

Having a long-term rental while living abroad is do-able.Flipping houses while abroad, in my opinion, more difficult, especially if its your first go around with real estate.I would recommend taking a flight and staying in the area for a week and inspect the neighborhoods and make connections.You can reach out to @Elenis Camargo who has a PM company in Jacksonville.Best of luck though.

Built in 1905, this property features a total of 2,832 square feet of living space, divided into two units.

You have multiple people living in each others spaces.

Consult someone who actually knows what they are talking about/does this for a living, but most of your tax savings are only going to offset the earnings of the partnership rather than one of you individually.

A lot of people go in expecting these programs to completely change their lives. 

Unless you want to live in that district, I would avoid any and all purchases in an area like that.