Tidewater Farm Estates is the setting for this beautifully decorated and updated thirteen room colonial sited in one of Great Bay's finest residential neighborhoods with a kayak/paddle board launch to Great Bay only a half a mile away! Majestically sited on a corner lot with stone circular driveway and mature landscaping, this handsome home has surprising water views of Great Bay from nearly every level in the home. 2015 custom island kitchen with quartz counters, Thermodore appliances including a gas cook-top with griddle and a separate breakfast nook with skylights and views of the bay. Elegant formal entry foyer opens up to the formal dining room and the sunken living room with custom built-ins, a wood-burning FP and glass doors onto a 25'0" x 11'4" deck overlooking the bay, hot tub and inground pool. First floor bedroom suite with walk-in closet, private and new tiled bath and direct deck access. Cozy study with gas FP and additional built-ins completes the first floor. Second floor features a stunning master suite with a wall of windows to the bay and a new and luxurious tiled bath w/clawed-foot soaking tub, walk-in 4'7"x3'3" shower, a custom vanity with double sinks and a walk-in closet. Guest bedroom with tiled en-suite bath and two guest bedrooms sharing a Jack/Jill-styled tiled full bath. Top floor is a welcome retreat and features two new tiled bathrooms, a half bath and 3/4 bath. Finished walk-out lower level features rec room with gas FP. 1st showings 10/04