On the premier Zebulon Pike Lake - a part of the Mississippi River sought after with 178' of frontage and almost 1 Acre lot, this stately, spacious yet modern 2 story has plenty of room for fun or rest inside & out! Enjoy the horseshoe driveway and the oversized 1 car detached garage, the insulated & heated attached garage leading to a large practical mudroom with 2 sets of built ins plus closet! Main floor laundry and half bathroom off back hallway too! Overlooking the river just feet away is the beautiful new kitchen with Quartz counter-tops & custom cabinetry, walk in pantry and coffee bar plus spacious island and patio door leading to paver patio for grilling & entertaining. The large formal dining room off the foyer as well as the formal living room or flex room (19x13.5) leads to the even larger living room overlooking the river & backyard deck, brick fireplace, cofferred ceiling and hardwood floors accenting it's warmth. Upstairs are 4 bedrooms, the huge primary suite just renovated with 2 walk in closets, stunning river view and walk-in shower. Another full bathroom down the hall near the other 3 bedrooms is practical! Basement has a massive rec/family room plus storage/utility room! Double retaining wall at water's edge, deck and dock (included) many other upgrades such as flooring, lighting, paint, Hvac/ BRAND NEW AC Summer 2026 & much more!