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:47423)
Interested in obtaining the full price history for this property? Contact us!Contact us! Our real estate professionals would be happy to provide a complete listing history with historical sold prices and dates.
Detailed Information
Bedrooms
2+2
Bathrooms
4
Equipment
Water Heater
Features
Cul-de-sac
Municipal ID
75545293
Ownership Type
Freehold
Pool
Inground pool
Property Type
Single Family
Rental Equipment
Water Heater
Transaction Type
For sale
Waterfront Type
Waterfront on river
Building
Architectural Style
Bungalow
Constructed Date
2023
Cooling Type
Central air conditioning, Heat Pump
Exterior Finish
Wood siding
Flooring Type
Vinyl, Stone, Wood
# of Half Bathrooms
1
Heating Fuel
Natural gas
Heating Type
Forced air, Heat Pump, Stove
Roof Material
Asphalt shingle
Roof Style
Unknown
Stories Total
1
Total Finished Area
4868 sqft
Type
House
Utility Water
Municipal water
Rooms
Room
Level
Dimensions
Notes
Bonus Room
Basement
19'1'' x 15'5''
Other
Basement
17'10'' x 14'2''
Bath (# pieces 1-6)
Basement
9'10'' x 4'11''
Bedroom
Basement
14'2'' x 12'5''
Bedroom
Basement
14'5'' x 14'4''
Office
Basement
21'11'' x 13'11''
Living room
Basement
17'1'' x 13'10''
Other
Main level
6'5'' x 6'10''
Bath (# pieces 1-6)
Main level
4'5'' x 4'6''
Laundry room
Main level
13'5'' x 10'7''
Bath (# pieces 1-6)
Main level
7' x 7'4''
Bedroom
Main level
16'8'' x 11'9''
Bedroom
Main level
14'11'' x 14'1''
Ensuite
Main level
12'3'' x 11'6''
Primary Bedroom
Main level
20'4'' x 15'
Dining room
Main level
8'5'' x 12'6''
Living room
Main level
23'3'' x 15'5''
Kitchen
Main level
11'9'' x 16'
Parking Spaces
Name
Spaces
Attached Garage
Garage
Land
Total Size
1.21 acres
Access Type
Year-round access
Acreage
Yes
Landscape Features
Landscaped
Sewer
Municipal sewage system
Size of Irregular Land
1.21
Terms of Use
Please review and agree to the following terms of use to access the listing content:
REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA's By-Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA;
The information contained on this site is based in whole or in part on information that is provided by members of CREA, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy;
This website is operated by a brokerage or salesperson who is a member of CREA;
The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, "screen scraping", "database scraping", and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.
The information contained on this site is based in whole or in part on information that is provided under copyright by the Toronto Regional Real Estate Board (TRREB) or by members of The Canadian Real Estate Association (CREA), who are responsible for its accuracy. TRREB and CREA reproduce and distribute this information as a service for their members and assume no responsibility for its accuracy. All information displayed is believed to be accurate but is not guaranteed and should be independently verified. No warranties or representations of any kind are made with respect to the accuracy of such information. The information provided herein must only be used by consumers that have a bona fide interest in the purchase, sale, or lease of real estate and may not be used for any commercial purpose or any other purpose.