Analyzing these properties, I knew my only option would be a long term rental.

There are other options you can look into but these ideas should give you a starting point for places to look into for more information about a property. 

Ideally I'd like to buy something with a few acres to build an art studio for multi media work, gallery and perhaps a few small cabins for people to visit with us. 

Hey BP Community, I invest in a smaller market where the properties don't always appraise for 100k and limits my cash out refi loan options when dealing with DSCR.

There are definitely situations where selling to a wholesaler is someone's bets option, but they're the exception, not the rule.

So, they would refinance your current mortgage and then provide the 95% LTV HELOC.In my situation with the option they gave me it doesn't seem to be far off from my current mortgage, I'm currently with rocket mortgage w/ a 2.8% ARM and to refi with Lower (in order to get access to the HELOC) the new interest rate would be 4.1.

Cash out Refi property located in Northern NJ, and hypothetical purchase mixed use or multi family apartment building located in Brooklyn most likely

I did my research on AZ and I’m looking for multi family units with a good or decent cash flow return.

Ultimately, if your CPA is shutting you down on this, without presenting alternative options, it may be time for an upgrade. 

There must be an easier option.