Introducing a stunning luxurious Custom Built Mini-Estate Colonial nestled in the picturesque Hudson Rivertown of Stony Point, NY with its majestic Hudson River, marinas and waterfront restaurants! This exquisite property boasts soaring 12-foot ceilings, Mezzanine balcony Grand Foyer and a charming circular driveway framed by a durable wrought iron fence with two automatic entry gates. The home features radiant heating on all three levels and is adorned with Italian porcelain tiles and elegant Italian marble fireplaces with remote controls, while the Mercier Canadian Hardwood floors enhance its warm, inviting atmosphere. Custom-designed, the signature kitchen seamlessly combines style and functionality with spacious kitchen island, dual sinks, high-end appliances, double ovens, custom selected backsplash and granite countertops with an additional eat-in dining area. This open floor plan kitchen flows into the family room with its two-story ceilings and Italian marble fireplace. The well-appointed formal dining room and living room with the eye-catching Italian marble fireplace make entertaining your guests a pleasure. Nicely tucked on the first floor is the detailed home office completed with its custom built-in oak bookcases, two sets of self-closing beautiful wood French doors with privacy glass. State of the art security surveillance system with 12 cameras gives you peace of mind at all times. Further complementing this remarkable estate are solid wood 1 3/4 doors, energy-efficient Anderson windows and doors, six heat zones and central air conditioning units for year-round comfort. As you make your way up the stylish staircase you will be welcomed by the cozy loft space overlooking the first floor. The 13 ft tray ceiling in the primary bedroom brings a feeling of spaciousness as you make your way into the en-suite Spa bathroom with it's double sinks, luxurious custom tiled shower and relaxing soaking tub. Making your way around the second floor, you will find three more bedrooms, one with an en-suite bathroom and the other two sharing a Jack and Jill style bathroom. The lower level boasts 2,400 sq ft of space for entertaining in the rec room, exercise area, gaming area and roomy full bathroom with sitting area. Stepping outside to the Resort-style backyard you will be in awe of its beauty! Enjoy the luxury of a 20 x 40 heated saltwater pool, complete with an automatic cover, Pentair heater with cellphone control, situated amid meticulously landscaped grounds. The Cabana, outdoor kitchen, pizza oven, spacious patio with Pergola and privacy complete this oasis. For the car enthusiast, there is a heated 3 car garage with 13 ft ceilings making your vehicle storage comfortable. This property is truly a homeowner's dream sanctuary in a location that defines privacy, beauty and sophistication!