This fabulous farmhouse-style home, one of just two remaining opportunities in this established, upscale neighborhood, is nearing completion! Every inch of this home has been carefully curated to deliver a luxurious, show-stopping living experience. Thoughtfully crafted with flexibility in mind, the layout features dual primary suites, one on the first floor and another on the second, ideal for multi-generational living, aging in place, or hosting guests in comfort. The heart of the home is a stunning kitchen outfitted with upscale features, including Thermador appliances with double ovens, a gas cooktop with pot filler, an oversized refrigerator with cabinet panel overlay, toe-kick lighting, and a striking quartz backsplash. A huge walk-in pantry with a full-size refrigerator offers exceptional storage and convenience, while the mudroom with custom built-ins creates the perfect drop zone to keep everything organized. The spacious living room showcases a gorgeous coffered ceiling and custom built-ins surrounding the gas fireplace, while both primary suites feature an elegant tray ceiling. Spa-like bathrooms include luxurious tiled showers with rain head and hand-wand combos and tiled tub surrounds. With engineered hardwood flooring throughout, abundant recessed lighting with dimmers, crown molding and wainscoting, this home exudes elevated quality at every turn. Additional highlights include an enormous finished bonus room, whole-house standby generator, pre-wiring for an electric vehicle charger, ample storage throughout, and more. Future expansion is easily accommodated with an unfinished basement and a 6-bedroom septic system. Enjoy outdoor living with an oversized front porch, spacious back deck, and a beautifully landscaped yard. Ideally located with easy access to shopping, restaurants, schools, golf courses, Pease International Airport, Portsmouth, and beaches, this home offers the perfect blend of luxury and convenience in a highly sought-after setting.