PropType = 'cnd' and City = 'Charlotte' and ComplexName in ('Celadon','Lela Court','Skybridge Terrace','Summit Greenway','The Grandin','Uptown View','Walnut Hill')