Our goals: Obtain another investment property while not having to pay anything for a down payment.I envision that my in-laws would use $250k (equity in current house) as a down payment to get into a new smaller location.

The primary purpose is to assist eligible veterans in purchasing, building, repairing, retaining, or adapting a home for personal occupancy.Asset Protection Strategies: If your goal is to protect your assets, there are other strategies you might consider:Insurance: Obtaining adequate insurance coverage, like homeowner's insurance and umbrella policies (as @Greg Scott mentioned), can provide a layer of protection against liabilities.Homestead Exemption: Some states offer a homestead exemption that can protect a portion of your home's value from creditors.Trusts: In some cases, placing the property in a trust can provide asset protection, although this can be complex and requires legal expertise.Legal and Financial Advice: It's crucial to seek advice from legal and financial experts.

A large, deep and qualified network of "intermediaries" to provide deal flow OR the ability to spend $5 -10K PER MONTH on obtaining that deal flow. 5.

Any suggestion on how to obtain mortgage?

It's easy to obtain, costs very little, and doesn't require extra, on-going effort to maintain.

I intend to sell one my single family homes (which I can avoid taxes on with the 2/5 primary residence clause) to obtain the needed capital. 

I'd like to obtain pure cash flow and cash on cash.

But if I could actually cashflow and be profitable, I'd certainly be willing to entertain other areas of Hawaii. 

That is certainly worth entertaining.

Build a Financial FoundationImprove Your Credit Score: A good credit score helps in obtaining favorable financing terms.Save for a Down Payment: Start saving for a down payment on your first property.