Completely rebuilt from the exterior walls inward, this stunning St. Lawrence River view property combines luxury residential living with Highway Commercial zoning, creating a rare opportunity just minutes from Cornwall. This former school house was extensively renovated from top to bottom, including electrical, plumbing, insulation, windows, flooring, fixtures, kitchens, bathrooms, and mechanical systems, offering the peace of mind of modern construction while preserving its timeless character. The heart of the home is the beautifully designed custom kitchen featuring an oversized centre island, quality cabinetry, stone countertops, and an open-concept layout perfect for entertaining. Spacious living areas throughout the main floor provide flexibility for everyday living, working from home, or hosting guests. A large mudroom, laundry room, full bathroom, & versatile den/living room complete the main level. The second floor is highlighted by a remarkable primary suite featuring a walkin closet and spa-inspired ensuite with a double vanity, glass shower, and soaker tub. An additional bedroom and beautifully finished spaces continue the home's blend of comfort and sophistication. The finished loft offers exceptional flexibility and could serve as additional bedrooms, a home office, studio, recreation room, fitness area. Outside, mature trees, covered parking, ample driveway space, and beautiful views of the St. Lawrence River create a setting that feels both peaceful and connected. Adding even more value is the desirable Highway Commercial zoning, opening the door to a variety of permitted uses including professional services, retail, tourism-related ventures, office space, or a live-work arrangement (buyer to verify permitted uses). Whether you're searching for an exceptional family home, a unique live-work opportunity, or an investment in a highly visible location, this remarkable property offers possibilities rarely found in today's market.