Want Kona Condo for investment

Hi,
I want to buy a small condo in Kona as an investment and possibly be able to use myself in 7 years. I used to own a house in Kihei Maui but moved back to the mainland. I can't afford Maui anymore. I'm looking for a 2 BR, 1-2 bath condo that I could buy for cash and rent out as either a STR or LTR. I'm looking for an investor friendly real estate agent who knows the good buildings and property managers. I will need a property manager to fully manage it. I don't want a leasehold. I'm planning to buy the condo and hold it long term and possibly live in it part-time in 7 years. I plan to give it to my kids when I die. I need a good property manager to manage it. I plan to take money out of my retirement and buy the condo for cash. I'm looking for long term wealth building with the possibility of using it myself in 7 years. I just want to get into the Hawaii market again and can no longer afford Maui.

Thanks,

Anne Donohue