The House in the intro song on the is different the show house. The door is way left and there is three windows on the left. There set up in the living room is door center windows on both sides. No porch on the intro but they have a brick porch in the show.
The trivia item below may give away important plot points.
During the last scene, Carrie puts on her pink "Pinky Tuscadero" helmet & Doug gets on the bike to supposedly "take a ride" without a helmet. The mandatory "helmet law" in New York State took effect in 2000, this episode first aired in 1999, therefore he can "ride a motorcycle without a helmet" in New York State.