We spent couple nights at Giampiero's place in July. The weather was hot and we used air conditioning to cool the place down. Air conditioning is present in two bedrooms and kitchen, one bedroom is missing it. It was still okay to sleep in. We used terrace for eating our breakfast in the sun and it was great! You can see the mount Vesuvius directly from the terrace.
Couple things about the location. The roads are quite rough and narrow, you really have to keep your focus when driving there, the locals also tend to drive way over the speed limit ;) There's one private parking spot but the entrance and yard are very small. We had an SUV (Merc GLC) and managed to drive it there with another person being a spotter outside the car. After we got car parked we didn't move it until we left :D You can walk around the area but I wouldn't recommend it with small children because of the narrow streets, lots of traffic and almost non-existent walk ways. The bus stop is right in front of the house so I'd recommend taking the bus to the city center and walking there. There is one grocery store across the street but the selection is very limited. If you walk towards the pizza place Giampiero recommends then there are separate fruit and grocery stores which have more selection.
Also pay attention that the place is very close to the airport. The planes descent right over the house from morning to evening, the traffic stops for the night. It didn't bother us and we got great pictures from the planes!
Overall there are lots of sights within walking distance or by bus so it's a great place to stay if you want to check Naples out!