thinking of getting rid of my dog?

I love him a lot but he just doesn't listen at ALL. He's a year old and we've had him since 8 weeks old but he doesn't listen and we're going to be temporarily living with my in laws and he's even worse there. When were home he's good for the most part. He mostly just plays and sleeps. But when we're at my in laws he doesn't sleep. Maybe a hour or two. He pees on everything, constantly tries playing with the other dogs who hate him and snap at him, he wakes us up at 3 am crying for no reason and trying to go upstairs (we separate the dogs at night and he stays downstairs with us). He doesn't come when he's called, he cannot be walked, he pulls no matter what we do. My husband trained many dogs and said he's never had this much of a problem with any dog. And his parents don't like this dog either. We tried everything, and work hard with this dog but he won't learn anything. He's horrible with kids and we'd like to have one soon...