SELECT DISTINCT CountyDetails.CountyName AS name, CountyDetails.RecordID AS ID FROM CountyDetails, EstDetails WHERE EstDetails.County = CountyDetails.RecordID AND EstDetails.EstType=8 ORDER BY name
Antique Shops in <cfoutput query="counties">#name#, </cfoutput>
#name#, ">
