Body of 40-year-old found inside house after neighbours alerted police over foul smell