Set on a large, private lot among the pines, this exceptional modern farmhouse offers refined living with resort-style outdoor space and extensive upgrades throughout. Designed for flexibility, the home features 4 spacious upper bedrooms plus main floor den/office with built-in Murphy bed. The open-concept living/dining areas are anchored by a cozy wood insert fireplace, while energy-efficient in-floor heating (with time-of-use savings) and two heat pumps provide year-round comfort. Extra insulation in the slab and walls, along with a radon mitigation system, further enhance efficiency and peace of mind. The stunning kitchen is built for both beauty and function, showcasing a large island with abundant storage, thoughtful built-ins including a printer drawer and kitchen dustpan central vac, and seamless flow for entertaining. A family room, mudroom, 3-pc bath, laundry room with convenient touches like a laundry chute from the bedroom level, complete the main floor. Upstairs, a versatile open nook with built-in offers space for a secondary lounge, reading area, or workspace. The spacious primary suite features a luxurious 5-pc ensuite with heated towel racks, while three additional bedrooms and another 5-pc bath complete the level. Outdoors, the fully fenced backyard is a private retreat with a heated saltwater pool (heat pump), expansive patio spanning the length of the home, interlocking brick surround, extensive hardscaping, and a stunning water feature. A propane hookup for BBQ and a trailer hookup add further convenience. The heated detached double garage with loft space above offers exceptional flexibility for a studio, gym, workshop, or storage. Additional upgrades include fingerprint side-door entry and integrated wireless Sonos ceiling speakers with amp. A rare offering combining luxury finishes, efficiency, privacy, and resort-style living just minutes from city amenities. A full list of premium features is available. (id:31684)