Cole Turner (RIPP)

Family
Cole is the son of Ben and Elizabeth Turner. His parents rather difficult relationship ended in the death of his father and being raised by his demonic mother.

His marriage to Phoebe Halliwell ended badly and subsequent attempts to get her back failed miserably. When he manipulted events to get the Winchester brothers' help saving Phoebe and her sisters, he was given another chance, this time with no powers and no hope of getting powers back, again. Although they are not sure where this is going to lead, he finally convinced her to give him another chance and he's deturmined not to blow it this time.

Powers
Although he had a large amount of powers, they were all stripped when the Angel of Destiny arrived.

The Halliwell Death Trap
Cole was planning on meeting the Winchester brothers and asking for their help, but when the demon induced earthquake nearly killed Dean, he decided to us the earthquake and its aftermath to trick Sam into staying in San Francisco long enough to find out about the manor and what was going on there. He was depending on Sam to want to help out despite the "loss" of his brother and went there to watch. Since he was invisible, the combatants inside couldn't see him and he wasn't attacked. He still couldn't do much, so he waited. He hadn't planned on getting caught, so he was surprised when the Angel of Destiny exposed him and stripped all the powers he had collected. He tried to convince Phoebe to take him back. She gave him a maybe. Then, she forced him to go over and apologize to the Winchester brothers. Since he wasn't actually sorry and in fact was rather pleased with himself, that was a rather unapologetic non apology. After that he left with a promise from Phoebe that they would talk more later.