Unmatched quality and attention to detail best describes this executive 2 storey with triple garage. Located in one of NB’s premier neighbourhoods on large private waterfront lot, featuring panoramic water views and access to St. John River. Walking trail close to Fredericton Golf Course, Garden Creek School and all downtown amenities. Featuring 5 bdrm and 6 bathrooms with approximately 5500 sqft of living space, plus large waterfront terrace. Enter to great room w/ floor to ceiling windows to second level and large linear gas fireplace. Dream kitchen features massive island, large chefs’ fridge/freezer, double wall oven, quartz counters and walk-in pantry. Office space, spacious main floor bdrm w/ separate bath, mudroom off garage, laundry complete this level. Wired elevator shaft for easy access to second level if desired (just add lift). Top level has luxurious master suite w/ waterfront balcony, includes hot tub. Ensuite has quartz double vanity, full tile dual shower, walk-in closet w/ lots of storage. Second laundry room, spacious den/gym area has dual head water fountain, bdrm plus storage room complete this side. Catwalk to 2 more bdrms each with own bathroom. Extras include whole home auto start propane generator, whole home sound system, camera system, concrete floors with in floor heat on both levels, upgraded spray foam insulation and recirculation hot water pump. Don’t miss your chance to own this custom-built home located in one of the best locations in the province!