Oreste's flat is located in the bustling old part of the town, it's a great place located a short distance from various restaurants and numerous little shops.
The views from the terrace and balcony are spectacular (especially at sunset, with a beer and pizza) and have a great view over the town and across the bay to Mt Vesuvius. We used it as a base to explore the area such as Sorrento and Pompeii. We'd recommend getting the Campania regional artecard as it's not badly priced as gives you access to most public transport and attractions (first two included, others discounted) It lasts for 3 calendar days so you can make the most of it.
Other than using the artecards we walked most places (except for taxis to/from the airport). Watch out for the scooters darting about as they come from everywhere! Naples is pretty hilly and the flat is located on the fifth floor so you can definitely burn off all the great food.
The flat itself was well equipped and clean. Sadly we didn't get to meet Oreste but he was great at giving suggestions /advice via email and WhatsApp. Would definitely stay again if visiting the area. Thanks again!