I have one golden retriever, who of course loves being outside! I have a lot of sand in my area. I have carpet in the bedrooms and hardwood throughout the rest of the house. Can anyone recommend a vacuum for both carpet and hardwood? We have had every Shark Vacuum they make, also the robot wouldn’t work in my house. Has anyone had any luck with a Hoover or Eureka?