Some of these pictures and descriptions may give away plot details that you might not want to know before watching the film.
This is a drama or mystery that is part horror movie, and it has a couple of snake scenes, including a long one that might be one of the most unintentionally funny snake scenes in a movie. Sharon Stone and Dennis Quaid get tired of living in New York City so they buy a large old house in the country that they get cheap because the former owner (Stephen Dorff) didn't pay his mortgage because he was in jail. Dorff gets out of jail and visits them soon after they move in and asks for a job helping them fix up the house. We can see from the beginning he'll be trouble, and does turn out to be a psycopathic murderer, but at least he knows his snakes. When several kids are in the pool (including 12-year-old Kristen Stewart) they find a snake in the water and run screaming. Dorff walks into the pool and picks up the snake telling them it's harmless, then he takes it to them and tries to teach them how to recognize a venomous snake. He says to be careful of snakes with triangle heads - they're poisonous, then he takes the snake somewhere to let it go. That sequence was believable and even commendable for Dorff's actions. But the next snake scene is absurd, as most of them are.
We see a milk snake crawling under some plastic sheeting on a ceiling being repaired. Then we see a Gray-band Kingsnake crawling next to a boy's bed. Then there's a Boa Constrictor under Sharon Stone's covers and a snake under the refrigeratior and before we know it the whole house is full of snakes and everybody is running around screaming and making over-the-top scared-of-a-snakes faces. There's a Western Diamond-backed Rattlesnake in one room, a striking Boa Constrictor in another (that is probably CGI) then the milk snake falls on Dennis Quaid who completely freaks out. Besides the rattlesnake, all the snakes are totally harmless, so it's funny to watch the family panic if you know that, but probably not so much fun if you're afraid of snakes. They all somehow find their way to the roof locking the door thinking they'll be safe. (I guess they didn't think about just going out the front door.) But then a snake comes under the roof door. (It's computer-generated, then a prop.) Dennis Quaid picks up a roof tile or something and decapitates it. Then Dorff shows up and rescues them, but Quaid is certain that Dorff put the snakes there and fires him. Later on when Quaid directly accuses him of filling the house with snakes, Dorff doesn't deny it and tells him to prove it. Then Dorff goes even crazier, and the violence escalates, but none of that involves any more snake. The movie is worth seeing for the snakes-in-the-house scene, but not much else.