Although I'm confident I can fix and flip it, my plan is to keep it as a rental.My dilemma is... where do I get the rehab funds? 

It sounds like inventory is pretty fixed in the Maui short term rental market, but I'm not sure if that's a safe working assumption for the long term.

If you love your job, make good money from your job, have very little time, and have cash want to park into a secure real estate asset, turnkey is the way to go.If you are opposite of that and want to dive into real estate investing operations, then fixed upper and BRRR.

The Book on Estimating Rehab Costs | Fix-and-Flip Investing Book – BiggerPockets Bookstore

Very few lenders will, especially for 1-4 unit SFR and doing a fix and flip. 

If the entire home is rented out then there can be some incentives to fix things like some big repairs such as roof, windows etc.

Fix it up as quick as possible and then either refi or sell. 

Thought it was a safe first investment, instead of flipping or fixing with no prior experience.

Many investors hesitate to start their next fix-and-flip project due to barriers like limited funding, uncertainty in market conditions, lack of experience in estimating renovation costs, or fear of unexpected delays and expenses.

I also value cash flow with intent to fund a fix and flip as my first primary residence in the next 5 years.I have been analyzing local deals using the BP calculators, all of which leading to me thinking there is not a current future for me in my local market haha!