8243 CONCORD Boulevard E Rare riverfront property on the Trout River offering incredible water views and endless potential. This solid 3-bedroom, 2-bath brick home features 1, 826 sq ft and sits on a spacious half-acre lot with direct river access. Highlights include a circular driveway, in-ground pool, dock, boat lift, boat house, 1-car attached garage, and a 2-car detached garage. The home has strong bones with key updates already completed: HVAC (2020), PVC plumbing, re-wired in 2003, original hardwood floors, and an updated primary bathroom located on the second floor. Ideal layout for a long-term residence or renovation project. Property will need a new roof, pool replastering, and cosmetic updates, making this a perfect value-add opportunity. With its prime riverfront location and generous lot size, this home has the potential to be a true forever home or an exceptional investment. Waterfront opportunities like this don't come around often. Bring your vision and unlock the value.