There was an error while loading the video. It could be a temporary error, so please hit refresh to try again.
If it's still not loading we are sorry for the inconvenience and please report the issue as it could be a solvable issue.
There was an error while loading the video. It could be a temporary error, so please hit refresh to try again.
If it's still not loading we are sorry for the inconvenience and please report the issue as it could be a solvable issue.
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 (27247467)
Property Type
Single Family
Annual Property Taxes
$13,454.69 (CAD)
Parking Type
Attached Garage, Garage
Time on REALTOR.ca
80 days
Get a taste for the neighbourhood where this listing is located.
The following neighbourhood demographic information is provided by a third-party supplier based on census data from Statistics Canada.
No demographic information is available for this specific location.
Demographics data is temporarily unavailable
This calculator is for demonstration purposes only. The Canadian Real Estate Association does not guarantee that all calculations are accurate. Always consult a professional financial advisor before making personal financial decisions.