@Jeremy Hunter The 0% down VA loan limit is $721,050, anything over that amount will require a small downpayment. However, you still need to qualify for that much with a lender. I work with many military buyers who don't necessarily qualify up to that amount although at most grades above E6+ it's possible.
I've also used my VA loan to purchase and operate a vacation rental on the North Shore. I use VRBO (Vacation Rental By Owner) as guests on that platform are a bit more high end.
In Ewa Beach and Kapolei we've seen values increase dramatically over the past few years. I've seen new 4BR 2.5BA 1600sqft homes in Hoakalei start in the low 600s last year and now that same new home starts in the high 600s-low 700s at the start of this year. These homes and area are ideal for long term rentals for military. Airbnb vacation rentals would be tough unless you had one of the homes lining a golf course with views.
Get in the market while you still can. Prices are not getting any cheaper.