The location is perfect 10 min walk from train station and you really do not need to take public transport from the apartment to see Naples. You can walk to most of the tourist stuff. Giuliano is a great host who speaks very good English and knows the city well.
He recommended two pizza places that were amazing. Nice stay in a perfect location.