The place is just as described (make sure to read the description fully!!!)! It's very clean and the bed is comfortable - but I like a soft mattress! The kichenette has all items you'd need for easy to prepare meals. Also check-in was so simple as there's a keypad to get into the house, so didn't even need to bother anyone (coming in at 1 a.m.!). But, just as described - it's on the 3rd floor, so prepare yourself to walk up those stairs with your luggage - this wasn't a big deal for me in any way......
The location is also convenient as it's within downtown and walking distance to the water. We stayed for 3 full days and did a lot of walking.
Would definitely stay here again if I'm ever in Fredericton.