He was found in the middle of the lake several hundred yards from both the pier and the far shoreline, Katie Hall, a state parks spokesperson said.
Sgro's body was found in about 12 to 14 feet of water.
Hall said Sgro had removed some articles of clothing, apparently in an effort to swim.
Sgro's family had come down to assist with the search.
RELATED: Search for missing Fayetteville man at state park shifts to recovery effort
Sgro was at the park for a church retreat and went missing last Saturday.
Hall said a group of people went out on the lake in canoes around sunset April 6 when conditions were windy.
Sgro's canoe was found across the lake from his campsite the next morning with his life jacket and cell phone still in the boat.
Hall said the family has been notified.