The body of missing Hartlepool man Malcolm Godfrey has been found in the town's Greatham Street.