This is a small, 1-story condo on the bottom floor of a 3-story building. We didn't have any issues with inside noise coming from above, which was great. I'm not sure if the unit above us was occupied or not. You can hear people outside and have to have the windows/doors open at all times, but everyone was respectful, especially early in the morning and at night. We traveled in early Oct - I'm not sure how cool it actually gets in the winter. There is 1 window A/C unit in the bedroom, but none in the living room area and the layout of the space does not allow the cool air to circulate to other rooms. The A/C s also quite loud. If anyone in your party is heat and/or noise sensitive I don't recommend this place. We are not used to heat and humidity and my husband, who runs hot, was quite uncomfortable. The bedroom is also in the front of the unit, which borders the parking lot and the Paia Highway so with the small windows open there is a degree of noise.
The renovation is very nice and appears to be quite new - everything was in good working order and very clean. The access to Mama's Beach is great! It's a small, but special spot with a lot of history. The location in general is also very good - very close to town by car or by foot. The road to town is pretty busy with traffic so driving is probably better than walking, especially at night or with small children. But the distance is certainly walkable if need be.