My review is mixed.
Pros: David's place is in a great location, at the quiet end of Thames Street, one of the main streets in Newport. Everything in town is very walkable and convenient. So that's a big plus. The apartment itself is as advertised---the top loft of an older building, which has ceilings that are very sloped, so you just have to watch your head when walking around. The kitchen and the bathroom were both clean and well-equipped. The air conditioners were quiet and worked very well.
Cons: There were several small issues that could be easily fixed or upgraded to make a stay at this apartment so much nicer. Several light bulbs were burned out, for instance and the rug had lots of stains. The handle on the bathroom door fell off and so we were unable to close the door during our stay; the toilet was difficult to flush and I had to wrestle with the chain in the tank to make it work. The closets all contained miscellaneous stuff inside that left no space for guests to use. The walls could use a coat of paint and maybe a few pictures. The wifi wasn't working and so therefore we couldn't get Netflix to work either.
Overall, if you just want a place to shower and sleep in a convenient area of Newport and don't have high expectations for "creature comforts", this would be a good place for you. If you're seeking a place that's a bit nicer and better-equipped, I'd look elsewhere.