A mixed use zone can be a good transition between residential and commercial.Impact - My wife used to live in a dorm with a high speed train going by every couple hours.

It has been a great LTR, but it is transitioning to a MTR.  

Trying to avoid having too many transitions in carpet to hardwood/vinyl flooring and plan on doing LVP throughout the entire unit, bedrooms and bathroom included.

Best of luck in your big decision and life transition! 

Currently transitioning my focus to finding an affordable buildable lot to purchase outright then going the Private Money lender route for our first build.

I also believe better transition information is being provided to newly separated, so they hopefully take advantage of everything available to them.

Since you'd be looking to hold this property long term, look at what the property's cash flow and appreciation would potentially be 5-10 years down the road to help inform your decision.All that being said, if you feel confident that you can cover the maintenance, capex, vacancy loss, turn expenses, and leasing costs for a few years while you wait for the cash flow to improve, and you have enough risk tolerance to handle a potentially difficult tenant in the first few months which could lead to zero rent coming in during that transition to getting a new tenant in place, then it sounds like a solid deal to get into with $0 down.Lastly, I'll also caveat all of my statements above by mentioning that this all requires you to self-manage the property. 

For my Minneapolis duplex unit, the ROI potential on transitioning the apartment from a 1BR which would rent for ~$1,200/month up to a 2BR that could rent for ~$1,550/month makes a ton of sense.  

Getting a bit tired of my current job (first out of college) given the demanding hours and really motivated to transition into making Real Estate investing a full-time occupation for me.

Hence, I plan on transitioning to Commercial Real Estate as soon as I have enough knowledge on this field.