118 : <cfquery name="verifysubdivision" datasource="#listingdsn#" cachedwithin="#CreateTimeSpan(0,3,0,0)#" timeout="5">
119 : select distinct subdivision from mlslistings
120 : WHERE mls = '#mlscode#' AND subdivision = '#subdfix2#' AND county = "#Trim(ReReplace(url.1, "-county|-", " ", "all"))#" AND Lower(city) = '#LCase(cityfix3)#'
121 : </cfquery>
122 : <cfif verifysubdivision.recordcount EQ 1>
|