Neighbours have expressed their shock after a body was found in the search for a missing woman - with a murder investigation ongoing