Discover the beauty of waterfront living in this newly built six-bedroom, four-bathroom home, perfectly positioned on the scenic shores of the Hillsborough River. Located just 10 minutes from downtown Charlottetown in the charming community of Mermaid, this property offers breathtaking water views and stunning sunsets. The spacious open-concept main floor is flooded with natural light from large windows, creating a warm and inviting atmosphere. Relax in the living room, where a cozy propane stove enhances the picturesque setting. The kitchen is designed for both style and function, featuring custom cabinetry, a 10-foot quartz island, and seamless access to the dining area. Triple patio doors lead to a covered deck, extending your living space outdoors. The main level includes a luxurious primary suite with a walk-in closet, plus two additional good sized bedrooms and a full bathroom. The walk-out lower level offers incredible versatility, with three more bedrooms, two full bathrooms, and a generous family room. A private external entrance, along with pre-installed plumbing and electrical connections, makes this space ideal for a secondary suite - simply add kitchen fixtures to complete the setup. Outside, enjoy a beautifully maintained lot in a quiet, family-friendly neighbourhood. There is lots of parking and storage, thanks to an attached two-car garage, a detached single-car garage, a storage shed, and a spacious concrete driveway. Laundry connections are roughed in upstairs should you wish to move them up. Don't miss the chance to own this stunning waterfront property! All measurements are approximate and should be verified by the Buyer(s). The listing agent is the seller's brother. (id:63267)