Can a parent-in-law can lend to a SDIRA (non recourse loan secured by a property)?   

Companies like Quicken Loans or Rocket Mortgage have been known for their diverse lending options, and they might work around your requirements.

My understanding about this product is that it is intended for acquiring and renovating, and then I would refinance into a more conventional loan to finance long term as I do hold properties.

I will probably need to refinance to a higher rate mortgage or get another loan to finish.

Went to a mixer last night with a Lender I work with from Park National that I've closed a few "grant loans" with. 

With my equity I could easily get  the down payment for a rental, as well as I qualify for the VA loan, and would like to take advantage of that.I guess my question is should I focus on just one strategy, or should I just do whatever the market throws my way, whether its a rental or a flip.

You can access this equity through a few different methods, such as a Home Equity Line of Credit (HELOC), a cash-out refinance, or a home equity loan on Property A.

I started the process of a portfolio loan with Corevest and ALMOST closed with them, but due to me being a foreign (non-US) national, they were demanding a lot of things like cashflow management (all rent goes to them first, I had to ask for draws to pay for repairs), they wanted monthly reporting, and they wanted me ask my property managers to sign away their right to be paid management fee first (basically Corevest wanted to be paid before everyone else).

You can do this through a Home Equity Line of Credit (HELOC), a cash-out refinance, or a home equity loan on Property A.Tax Deductions: The interest paid on these loans is generally tax-deductible if the funds are used to buy, build, or substantially improve another investment property.

I have emailed a few hard money lenders this morning and will do research into the DSCR loans.