Cloverdale
From The Stargate Omnipedia
Possibly fictional town where Lt. Matthew Scott dreamed himself returning home after being infected with the spores of an alien creature. Cloverdale may also be Matt's real-life home town.
In Matt's dream his father was Everett Young, his high school sweetheart was Chloe Armstrong, and her brother was Eli Wallace -- all members of Destiny's crew. Adam Brody ran the local bar, Brody's, and Nicholas Rush was the town's Justice of the Peace.
KEY EPISODE
Cloverdale - Scott dreams that he returns home to Cloverdale to marry his high school sweetheart, Chloe.