Imagine waking up to this breathtaking waterfront view. Custom designed & built by Holland Homes; Frederictons premiere luxury home builder in their flagship subdivision. Unprecedented city waterfront on 1.2 acres of land; on a street of stately & quality homes. Striking w/ black board & batten wood siding & 3-bay garage w/ paver parking. Inside youll be immediately struck by the timeless modern aesthetic. Quality of construction & materials evident from the European tilt & turn triple pane windows, to the meticulous millwork thru-out. Den w/ wooden french doors off the foyer, leading to the soaring cathedral Great Room w/ oak ceiling & stone gas FP. Queenstown kitchen w/ soapstone counters & dining overlooking the covered exterior living space & South West view. Main floor owners suite w/ marble shower, walk-in closet w/ custom cabinets & direct access to mudroom & laundry. Guest suite on this level with its own full ensuite bath. Fully finished lower level walks out directly to the inground pool. Gorgeous family room w/ built-in entertainment center & wet bar, a home office or den w/ built-in library, home gym, a soundproofed music room PLUS a 2 bedroom 1 bath guest wing w/ walkout patio doors. Frederictons walking trail accessed steps away, and a path leading directly to the waters edge where your future boat will dock right at your back door. 4868 total sqft thoughtfully considered & planned; A dream home for most & a rare opportunity for it to be a reality for one (id:47421)