10 : <cfif LEN(fixedsd) GT 2>AND lower(subdivision) LIKE '#lcase(fixedsd)#%'</cfif>
11 : <cfif LEN(url.2) GT 0 AND url.2 NEQ "all-cities">AND Lower(city) = '#LCase(Replace(url.2, "-", " ", "all"))#'<cfelseif len(url.4) LTE 0 AND url.2 EQ "all-cities">AND Lower(city) = '#LCase(site.city)#'</cfif>
12 : <cfif #site.site_type# EQ "lake" OR #site.site_type# EQ "school" OR #site.site_type# EQ "subdivision"><cfinclude template="querytype.cfm" /></cfif>
13 : AND Lower(state) = '#LCase(url.1)#'
14 : AND subdivision <> "NONE"
|