Can anyone walk me through how they handle care for their dog while away? Family is too far and we don't have friends who can take him because of their own dogs.

My dog is high energy, likes his space (so doggy day care places overwhelm him) and he loooves people. Any suggestions? How does your dog do with either option? I feel so mean leaving him here overnight alone but I am not sure he would prefer a kennel because of all the barking. Also, I am pregnant, hormonal and behaving like a crazy over protective person so any anxiety here is not actually indicative of how my dog will handle things!