@Jack Mi: my first impression is anyone that is buying a deal at a 4.5% going-in cap rate with 7% interest rate is anything by conservative.Now, there are so many details missing that it is impossible to give any true thoughts.The things I like:No up front fees, so less motivation to simply transact10% Co-invest is pretty good80/20 (assuming there is no second hurdle) is fairly good.Things that give me pause, based on what is actually presented:Going-in cap rate is very slim.  

Mainly those that have seen sharp price increases without incomes keeping up.

I know Florida, Texas, and North Carolina are seeing huge growth but I don't really see myself moving to any of those states mainly because of the hurricanes/floods/and the heat in Texas.I'm assuming the problem I'm having is a result of the high insterest rates, housing shortage and affordability, but I'm wondering if it's like this everywhere right now?

A few hurdles will be how much will you net from the sale of your current home.  

Are there any hurdles I should anticipate with zoning or permits?

Apparently double taxation is one of the biggest hurdles for cross border investing.I would really appreciate some sound advice about this, and if anyone knows someone who specializes in US-CAN cross border tax laws, please let me know.A big big thanks in advance.

The main reason for this is to avoid Proprty Management.  

Columbus ohio is our main market and Miami Florida let me know if either are of interest.

A couple other tips;you can’t use the renovation loan to finance renovations to the commercial space. only exception is if you need to do repairs to the core structure or mechanicals that are integral to the building (ie, structural work, sewer lines, water mains)Make sure you work with a lender that knows how to do these.

As noted above they're only in 18 feet which is not going to get you to the main unless your house sits right on the street or similar.