When Viewing This Property on Realtor.ca Please Click on the Multimedia or Virtual Tour Link for More Property Info. Waterfront Lifestyle at its best! Swimming, boating, fishing, skating, waterskiing, kayaking, all in your own backyard! Over 295ft of Breathtaking waterfront on the St John River (Mactaquac Headpond). 180-degree unobstructed water views from every room in the house! This modern home was custom built with every attention to detail. A chef's dream kitchen with stone countertops and a custom-built island to look like an exquisite piece of furniture. Cook while you look a the endless views out the oversized windows. Mingle with your guest's open layout or eat outside on the Balcony overlooking the water. Spice Pantry/Butler's Kitchen with sink and a 2nd fridge. Formal living room with propane fireplace to relax. Mud room, Oversized Master with dreamy views, ensuite bath and walk-in closet, 2 more bedrooms and second full bath complete this level. Lower Level to watch some tv, play a game of pool, grab a drink at the bar. A playroom/storage room, an oversized 4th bedroom with walk-in closet and 3rd full bath. This property is truly a magical masterpiece! This rare Waterfront offering is the dream. (id:60457) Location - Take TCH exit 258 or Hwy 102 past the weigh scales in Longs Creek. Longs Creek Road left on Sandcastle Lane.