Sand Francisco Dreamin'

"So I think that's why everyone's been crazy. They're not dealing with their subconscious issues while they're dreaming."

- Phoebe to her sisters and Leo.

Sand Francisco Dreamin' is the 14th episode of the fifth season and the 102nd overall episode of Charmed.

Summary
A demon attacks the Charmed Ones with dream dust he stole from a Sandman, causing their nightmares to come to life, Phoebe dreams about someone trying to kill her, Piper dreams she has a secret and sexy love, Paige feels alone and Leo dreams about something happening to the baby. The sisters must defeat their worries in their dreams, before they are destroyed. Ultimately Phoebe learns that her mysterious attacker is herself, Paige is afraid of being alone due to her secret birth, and Piper's lover is actually Leo. Leo ends up feeling closer to the baby when he feels it kick. The demon shows up expecting to have their nightmares backing him up and is shocked to see that they're not. Piper, annoyed with him, simply blows him up.

Main Cast

 * Alyssa Milano as Phoebe Halliwell
 * Rose McGowan as Paige Matthews
 * Holly Marie Combs as Piper Halliwell
 * Brian Krause as Leo Wyatt

Guest Stars

 * Henry Gibson as Sandman
 * Rebecca Balding as Elise Rothman
 * Darin Heames as Tracer Demon
 * Austin Peck as Ryder
 * Tim Kelleher as Axel
 * Allison Munn as Wendy
 * Clarissa Romano as Becca

Special Musical Guest

 * Beth Orton

Co-Stars

 * Troy Blendell as Slappy
 * Shauna Sand as Sienna
 * Shari Shaw as Soccer Mom
 * Chris Ufland as Bill
 * Jossie Tacker as Reporter #2
 * Christian Keiber as Reporter #3
 * Amanda Sickler as Sophie

Tracer Demons

 * These lower-level 
 * demons are prized
 * as mercenaries in 
 * the underworld
 * for their ability
 * to follow magical
 * prey across
 * different
 * dimensions.
 * Powerful
 * and cunning
 * they are nearly
 * impossible to
 * escape.

Sleeping Spell
The Charmed Ones cast this spell to put themselves to sleep. That way they could find out what their dreams meant and they could make the characters from their dreams go away.


 * Let we who waken from our sleep,
 * return at once to slumber deep.

Potions

 * Paige brought a vanquishing potion for the Tracer Demon, but he destroyed it with a lightning bolt before it could hit him.

Powers

 * Astral Premonition: Phoebe has an Astral Premonition of the Sandman being killed while dreaming.
 * Telekinetic Orbing: Used by Paige to orb the end of a streamer into her hands.
 * Orbing: Type of Teleportation used by Leo and Paige.
 * Super Strength: Used by Axel to punch a Tracer Demon, causing him to fly through the lair.
 * Fading: Type of Teleportation used by the Tracer Demon and Axel.
 * Summoning: Used by the Tracer Demon to summon the Sandman to the Physical Plane.
 * Electrokinesis: Used by the Tracer Demon to destroy a potion bottle and to attack Phoebe and the Sandman. He later used a lightning bolt to knock down Leo and to kill the Sandman and Axel.
 * Healing: Used by Leo to heal Phoebe.
 * Molecular Combustion: Used by Piper to blow up the Tracer Demon.

Artifacts

 * Dream Dust - Dust that causes good beings to dream. It is sprinkled in their eyes by Sandmen. When there is sprinkled too much Dream Dust in some one's eyes, the dreams of that person will come to life.
 * Crystals - Used by the Charmed Ones to trap their brought-to-life dream characters in Crystal Cages.

Magical Beings

 * Sandmen - They sprinkle Dream Dust in people's eyes, while they are sleeping. Axel offered bounties to Tracer Demons kill the Sandmen, because it would make people much more agressive, since they couldn't deal with problems from the subconscious in their dreams.
 * Tracer Demons - They worked for Axel and killed Sandmen. One of them also wanted to kill the Charmed Ones.
 * Axel - An Upper-Level Demon who ordered Tracer Demons to kill Sandmen. He was later killed by a Tracer Demon.

Mortals

 * Elise Rothman - Phoebe's boss. She gave orders to reporters on articles they had to write.
 * Sophie - Phoebe's assistant at the Bay Mirror. She warned Phoebe that Paige was on the phone.
 * Reporters - Elise gave them subjects to write articles on.
 * Bill - A reporter at the Bay Mirror. Elise ordered him to write an article on a hostage in State Bank in North Beach.
 * Sienna - A character from Piper's favorite series.
 * Soccer Mom - She was screaming to Paige about a parking space. She was agressive, probably because her Sandman had been killed.
 * Wendy and Becca - Piper's friends. They helped Paige with the baby shower for Piper's baby.
 * Beth Orton - She performed at P3.

Dream Manifestations

 * Ryder - A character in Piper's favorite series. When she was pregnant, she thought he was the perfect man and started dreaming about him. He was later brought to life due to too many Dream Dust in Piper's eyes.
 * Slappy - Paige's clown toy. In her dream of Piper's baby's baby shower, the clown said that nobody cared about the baby. He was brought to life due to too much Dream Dust in Paige's eyes.
 * Chainsaw Murderer - A mysterious killer that haunted Phoebe's dreams. He was brought to life due to too much Dream Dust in Paige's eyes.

Notes and Trivia
thumb|300px|right|Sand Francisco Dreamin' WB Trailer
 * The sisters use a modified version of the Awakening Spell used in season 2, Awakened.
 * The WB used the promo title Dreamspell.
 * Phoebe has her second Astral Premonition in this episode while she sleeps. This is the second of only three occasions in the series that Phoebe uses this advanced form of Premonition.
 * Along with Sin Francisco, this is one of two episodes to refer to the Charmed Ones hometown of San Francisco.
 * Piper comments the baby shower Paige is organizing is only a shower and not a 'coronation'. This echoes Phoebe's comment in "Brain Drain", who said that Piper was obsessing about their friend Wendy's baby shower, which she remarked was not a 'royal wedding'. Both scenes occurred in the kitchen and were references to the amount of food being prepared.
 * This is the first and only time that only three crystals were used to create a Crystal Cage. Usually the cages are made with five or six crystals.
 * Phoebe mentions that Piper is allergic to bees.
 * This episode scored 5.1 million viewers.
 * Phoebe's dream sequence touches on her previously established fondness of black and white horror movies, as well as her fear of the basement.

References to other movies, books, mythology etc.

 * The title is partly based on "California Dreamin'" by The Mamas and the Papas, and partly on the Sandman (hence "Sand" instead of "San").

Glitches

 * When Phoebe gets healed by Leo up in the attic, the wound shown being healed is clearly from another shot.
 * At the scene where the sisters are going to sleep to enter their dreams Phoebe opens the conservatory door and clearly closes it again. Yet, when the camera shows Leo putting the Sandman's sand on them you can see the door is open.
 * Piper's pregnant belly disappears. Just after the baby is transferred back to Piper after Leo feels it kick, Piper's pregnant belly bump swells massively. Seconds later when she turns towards the Tracer demon her pregnant belly is missing completely (her abdomen is flat) and Leo has the belly again. When Piper turns back after blowing up the Tracer, she has the belly again.
 * When the masks in Pheobe's dream dissappear it is clearly shown that Allyssa's head is taller than the masked man's.
 * Paige's final line of dialogue in this episode - "I just hope we can stay awake long enough to enjoy it" - has clearly been edited in.

International Titles

 * French: Le Marchand de Sable (The Mercant of Sand)
 * Czech: Dobrou noc (Good Night)
 * Slovak: Snívanie v San Franciscu (Dreaming in San Francisco)
 * Russian: Kogda ved'my spyat (When Witches are Sleeping)
 * Spanish (Spain): San Francisco soñado (San Francisco Dreamed)
 * Spanish (Latin America): Sueños de San Francisco (Dreams of San Francisco)
 * German: San Francisco träumt (San Francisco Is Dreaming)
 * Serbian: Vesticiji snovi (Witch's dreams)

Episode Stills
