We are two retired couples that had driven from BC to start our extended summer holiday with a two-week stay in Fredericton. John's place was great for a place to settle down for those two weeks. We had everything we needed: a fully stocked kitchen, three bathrooms, comfortable beds and linens, outside seating on a mostly private deck, access to laundry in the basement (and a great drying rack that could be moved outside for air-dried clothes), a wine fridge (with drinks in it when we arrived; thanks John!), lots of parking for our two vehicles in the driveway, and a comfy living room so we could watch Netflix movies at the end of our busy days.
There is a gravel trail directly across the street along the Saint John River and we walked it most days/nights. The paved bike/walk trail into town was great for biking as well. We walked to downtown a couple of times (40ish minutes) - there are a couple of trail ways and the sidewalk on the main road too.
Along the river trail there are lots of birds (Eagles, Ospreys, Redstarts, Yellow Warblers, Song Sparrows, Kingfishers...) and a beaver. On the back deck of the house the birding was amazing too. On top of those other birds, there was also a pair of Downy Woodpeckers, Cardinals, Hummingbirds, Chickadees, (a) Nuthatch, and Grackles. A cheeky Red Squirrel and a Chipmunk also kept us entertained.
John was great to deal with, as everyone has said. He was quick to reply when we enquired about recycling and we had a blue bin delivered to the front porch that afternoon. John even put in a window A/C before we arrived because he knew we were going to get some hot days while we were there (again, thanks!).
John's place was perfect for our needs! It would be a good house for a family too. The yard has no grassy play space (big wooden deck only), but the park across the street would be great for running around with a ball or frisbee. It's also a short trip down to the waterpark (on the same road heading into town).