Lots of pros and cons here. I recommend trying the commute from each location if you are on Oahu. That will give you some idea as to the desirability of the area(s). Check Craigslist for rental rates and compare it to sales values.
I would be happy to send you the sale values for any/all neighborhoods you have in mind.
(RA) MBA, e-PRO, REALTORÂ®
East Oahu Realty