Welcome to this gorgeous waterfront property tucked away in Wexford Terrace on a 1/2 acre lot. The neighborhood is just minutes from military bases, hospitals, and all of your shopping and entertainment needs. The property boasts a flowing layout with new flooring throughout. There are many windows that flood the home with natural light and provide exquisite views of the Lafayette River! The first level features an open living area with a wood burning fireplace, a formal dining and sitting area, a wet bar, a huge updated chef's kitchen with granite countertops and stainless steel appliances, and two first floor bedrooms both with ensuite. The second level features the remaining bedrooms; the primary suite includes his and her closets an ensuite and a nursery/office. There is also a mother-in-law suite with an ensuite and small kitchenette. Enjoy relaxing and entertaining in the oasis backyard on the back deck with a beautiful garden, a cabana and a large koi pond. This one won't last!