WATERFRONT with views from every room! Vast, well-treed private backyard oasis. Custom-built classic 2 storey executive home with fully finished lower level, beautifully situated on the well-sought after scenic Niagara River Parkway. Over 7,200 sq ft of finished space for you to enjoy! Private driveway leading to 1,500 sq ft insulated 4 car garage with workshop! Impressive courtyard & fountain. Outside firepit with professional landscaping. Grand entrance features a beautiful covered porch. Inside, you will discover 9 ft ceilings & a large hallway leading to several rooms & formal living room. When you look up, a huge crystal chandelier will light up the hallway and staircase to the second floor. Formal sunken dining room features massive wood fireplace. Kitchen features large island with second sink, built-in dishwasher & top of the line appliances incl commercial quality gas range & 2 ovens. Corner sink with stunning window views. Magma Gold Brazilian granite countertops. Entertainment area off of the kitchen is awe-inspiring with picturesque views of the river & yard. Large family room with patio door leading to a roof-covered concrete back porch overlooking the 20' X 40' in-ground, heated saltwater pool. Main level guest bedroom has 3 pc ensuite. 3 pc guest powder room features a urinal. Upstairs, you will find a magnificent primary bedroom with romantic gas fireplace & a balcony with heavenly views of the River. Through a sizable walk-in closet with washer/dryer, you arrive into a spa inspired ensuite bath with multiple showers, jacuzzi tub, double sinks, toilet, bidet & lots of closet space. Second shared 5pc bathroom. Lower level is fully finished, open concept, has interior windows for extra light & walkup to the garage. Kitchenette offers perfect in-law set up. Party room, wine cellar, sitting area, zen/relaxation area (can be used as a bedroom) & workout area with 2nd laundry. Owned, state of the art water treatment system offers unlimited water supply.