From The Stargate Omnipedia
Fictional restaurant and bar in Matthew Scott's dream of the small town of Cloverdale
. The bar was owned and operated by Adam Brody, who in the real world has coincidentally built a still to provide alcohol to the crew of Destiny
Brody's was the location of Matt's bachelor party in his dream. One of Brody's employees was Vanessa James, Scott's old flame.
Cloverdale - In Matt's dream Chloe takes him to Brody's for a surprise bachelor party.