Marianne and Satoshi's Surf Lodge is a strategic location away from the busy part of Waikiki but close enough for a walk to the beach when you feel like it. This is a converted garage as stated by the listing, pretty cozy, and has a lot of ventilation.
Located close to tons of food options Rainbow drive-in is across the street which has a lot of options for affordable and delicious comfort foods. Safeway is less than a mile walk, a bonus to this across the street is Leonards malasadas, you gotta try this at least one if you are visiting this area.
I had a great time working remotely from the Surf Lodge for a month :)