Pippi's Paradise was a great stay and exceeded expectations. The place looks even better than the pictures. The air conditioning has been upgraded since then. The location is fantastic if you are not looking for the Mission Beach party experience. Two beaches and tons of small shops within easy walking distance. It's a short drive or bike ride to just about anything else you could want in San Diego.
A couple of things to expect:
It's pretty tough to find street parking. There is a garage, which is great, but it's in a narrow alley, and it was a very tight squeeze to park a new model Nissan Pathfinder. We ended up parking in the garage at the beginning of the stay and walking, or using scooters, or ride-sharing for the whole time, which worked out fine.
As others have mentioned, the location does have airport noise, but you don't notice it most of the time. They stop flights late in the evening and start them again early in the morning. The stream of backed-up flights taking off one after another at 6:30 could be annoying for late risers.
Overall, I would definitely stay there again if I make my way back to SD.