Executive home in highly sought-after Hopkinton, NH! Tucked away on almost 3 acres in a charming cul-de-sac, this stunning residence offers 5 bedrooms, 5 baths, and exceptional amenities. The heart of the home is a dreamy kitchen, complete with high-end Thermador double wall oven and Wolf 5-burner gas cooktop, perfect for culinary enthusiasts. The open-concept family room impresses with a cathedral ceiling, floor-to-ceiling stone fireplace, and elegant moldings, creating a warm and inviting space. The first-floor office provides a quiet workspace, while the private primary suite features trey ceilings, an expansive en-suite bathroom, and walk-in closet. The second floor includes three additional bedrooms and two baths as well as a large open landing. The lower level offers versatile space, perfect for multiple uses including a teen hangout, an au pair suite, or an extended-stay guest area, complete with a bedroom, kitchenette, and 3/4 bathroom. Additional spaces include a gym, craft room/homework room/office, and a home theater. Standout features of this exceptional home include a picturesque farmer's porch, perfect for enjoying a morning coffee or an evening sunset, as well as a charming tree house and fenced-in backyard with a play structure. Don't miss the orchard and blueberry and raspberry patches! Other amenities include first-floor laundry, an attached two-car garage, an additional detached garage with a workshop and storage space and a whole-house generator.