I'm going to exclude my personal residence from this because I don't view this as an investment, I need a place to live.Excluding my primary residence my current breakdown is 47% real estate 53% stocks/cash. 

It might make the most sense to just sell your primary residence and use it as 40% to 50% down payment on your future home. 

I reside in FL, so I would like to purchase in neighboring states if possible, but I heard Ohio is a great market.   

Quote from @Lamier Guzman: @Jaycee Greene I was thinking Hampton or Virginia Beach, leaning more into Hampton honestly for the duplex's but after my military contract and my 1 year of residing in the duplex is complete I plan on renting both units and moving to Florida or Texas to purchase SFH's and BRRRR them.

Quote from @Rory Darcy: Hi guys my name is rory, pretty new to this im an out of state investor residing in new york, looking to invest in wisconsin and illinois, currently looking to build my portfolio around multi family duplexes or single family residencies, would be great to connect with like minded investors or agents who can lend a hand.Rookie investors should not invest out of state.

That would not qualify for a 1031 exchange. 

I am pretty sure you can not do a 1031 and use the proceeds to do anything to a primary residence.

Interest rates and cap rates change, competition changes, your PM ends up being horrible, lots of variables.Just to throw you a monkey wrench, in your killer spreadsheet does it include the credit score, income, and employer of every resident? 

I was looking for some advice (viable target areas in Cleveland or Ohio in general, financing options and credible PM/realtor contacts) from the experts here though especially if you are in a similar boat as mine (reside in Canada/Ontario area and invest in US). 

Looking to find duplex or something along those lines to reside in and then eventually move upward.