Below I'll do my best to paint a picture of the place itself and the neighborhood in order to help you make your decision based on your needs for your trip, but let me get a few things out of the way:
1. My wife and I loved our stay and thought the place was in perfect location both getting around and enjoying some break from the hustle and bustle.
2. Andreas was very helpful and the entire trip was completely incident free. We wanted to be at the airport for our return flight at 5am Sunday morning, and at 11pm Saturday night decided to take a shot in the dark and see if Andreas could find us a ride rather than us having to take a taxi all the way or take public transportation to Termini to the airport. He did and within 10 minutes at that.
3. We stayed here the first week in March 2020 as the COVID-19 craziness was breaking. Rome was absolutely business-as-usual albeit with smaller-than-normal crowds which was great for us.
Now, on to the apartment and neighborhood:
The apartment is located on a wonderfully cavernous, narrow, ancient road just off the Campo de' Fiori in a 15th century building. You open heavy wooden doors to enter a tunnel walkway which opens into a small picturesque courtyard. You then enter the building and walk up two flights of stairs. The building features high, wooden beam ceilings and the hallways are breezy due to open windows and arches. On the first landing there's even Latin inscribed over one of the doorways going back who knows how long.
The apartment is a studio, so it's essentially a hotel room, with a bed, TV and TV stand, small table and two chairs, all in one room. There is a small kitchen in its own little room and a full bathroom. High, wooden beam ceilings. The window has shutters and catches the late morning sun. From it you can peer down onto the street but also into other people's apartments (and they yours) if you're not careful. The bed is super comfy, and the TV is a smart TV in case you want to sign into your Netflix.
When natural light is flooding in as well as a soft breeze and the sounds of life coming from the daily Campo de' Fiori market, it can be the most relaxing place on Earth.
A small nearby church bell tower announces the time every 15 minutes during the day, which we loved.
The Campo de' Fiori is actually a pretty popular bar spot, with the Drunken Ship occupying the corner closest to the apartment, and a lot of those revelers stumble down the little street outside the window and make a lot of noise. Most of the languages I heard being spoken were not Italian so it makes me think that if they were Roman/Italian, they'd appreciate a little more how well sound carries in the canyon and keep it down, but for a light sleeper like me, I woke up every time (my wife slept soundly). Thankfully Andreas anticipated this and provided ear plugs. Also, in addition to shutters there are also storm windows and they actually do a great job shutting out noise, too.
The bathroom is nice, and the shower has an overhead ceiling mount, chromatherapy blue lighting optional.
Overall, the little apartment was perfectly cozy for us.
The location is neither the most nor the least touristy place in Rome. It is a 15-17 minute walk to the Vatican, a 7 minute walk south to trendy Tratevere and its restaurants and bars, a 7 minute walk up the Piazza Navona, and another 5 minute walk to the Pantheon. The car/motorcycle traffic is not nonexistent, but minimal because I think they charge an extra toll for cars to to be driving through there.
It is a three minute walk to a bus stop which takes your either towards St. Peter's or East more towards a lot of the sites. The closest tram (the 8) is about a 12 minute walk away, and the Metro is a little far for walking to it to be the most preferred option. This means that for some sites, you do have to budge a little more time and string together a few more transit options, but given that we walked through MANY better connected neighborhoods which were super busy/bustle-y/hectic we always enjoyed coming back to our much more tranquil neighborhood.
The square itself is like many in Rome in that each restaurant sends its hawks out there to try to pull you in as you walk through, which is annoying, and the market has their stall hawks too trying to get your taste things or try things.
The Market is there every day, and there is some noise as it sets up and takes down and people push or drive crates through the streets. We went to other markets for fresh or farmer's goods, but it's still nice to walk through there every day. Every single morning we walked an extra minute past the square to Roscioli's, which is a famous bakery, and got some pizza bianca with mortadella for breakfast. We then would walk back to the smaller square where St. Barbara dei Librai is, order some coffee, sit in the square, and people watch. There's also a great fish place called Dar Filletaro (although the sign, instead of advertising the business name, advertises what it sells and says Fillete di Baccala, or fried cod). Emma's is a great, inexpensive little dinner place around the corner, and ZUM Tiramisu is close too. Man, so many good places to eat in this little area. Trappezino is right over the river in Trastevere, so 7 minutes away, too.
Another thing to note is that the cobblestone gets slick when it rains to keep that in mind when choosing footwear.
I know no one asked for a book but the trip is fresh