This gorgeous modern farmhouse, ideally sited at the end of a quiet drive, along the picturesque shores of the Magothy River is a true masterpiece. This home was meticulously rebuilt in 2019 from the foundation up, and every detail has been carefully crafted to create a home that seamlessly blends sophistication with the tranquility of waterfront living.  As you step through the front door, you are greeted by an expansive waterfront view that sets the tone for the entire residence. The open floor plan on the main level boasts luxurious vinyl plank radiant heated floors, a gas fireplace with custom built-in surround, and vaulted ceilings with skylights that fill the space with natural light. Glass doors lead you to a meticulously designed waterfront backyard patio, perfect for enjoying the stunning views and entertaining guests. The gourmet kitchen is a chef's dream, featuring quartz countertops, a subway tile backsplash, and an oversized quartz island with seating. Stainless steel appliances complement the modern aesthetic, while a large butler's pantry provides additional convenience with an additional refrigerator, dishwasher, sink, and ample storage. The kitchen seamlessly opens to a spacious dining area, ideal for entertaining. The main level laundry/mudroom, featuring a dedicated dog washing station and built-in storage solutions, add practicality and ease of use.  The main level also accommodates an office, a guest bedroom/den, and a powder room, offering flexibility and convenience. The primary suite is a true retreat, complete with a waterfront view, glass doors to the backyard patio, a serene ensuite bathroom, and a spacious walk-in closet.  Venture to the upper level, where a second laundry area and three bedrooms with walk-in closets await. Two bedrooms share a connecting ensuite bathroom, while another bedroom boasts its own ensuite bathroom and a captivating waterfront view.  The finished attached garage serves as a versatile recreation room, equipped with built-in sink, custom built-in storage solutions and two split units for AC and heat. The bonus room above the garage offers endless possibilities – whether it be an office, gym, or hobby room, all with a water view.  Step outside to the meticulously landscaped .76-acre waterfront property, featuring a pebble and natural stone patio facing the water. Stone steps lead to the sandy beach, and a private dock with one boat slip awaits your maritime adventures. The property also offers the option to add a boat lift with a 6' mean low water.  With its custom designer finishes, thoughtful layouts, and unparalleled waterfront setting, this modern farmhouse is more than a home – it's a lifestyle. Immerse yourself in the beauty of the Magothy River and make this exquisite property your own.