I stayed in this 1BR for 4 nights and loved its location! It's on a quiet side street and all you hear is birds and nature sounds. However, it's about 15 min walk or a short bus ride to Waikiki beach, 2 min walk to Kapahulu ave with eating places (Ono's Hawaiian Food, Rainbow Drive In), grocery stores, gas stations - anything you might need.
The apartment size was perfect for me alone. It'll be ok for max 2 people to feel comfortably at home:)
Thank you Chifumi and Daniel for a great place to stay!