Three dogs were found living in conditions an RSPCA officer likened to a "cesspit" at a property in Nelson.