16 : WHERE mls = '#mlscode#'
17 : <cfif url.2 EQ "all-cities" AND LEN(url.2) LTE 0>AND lower(city) = '#site.city#'<cfelseif url.2 NEQ "all-cities" AND LEN(url.2) GT 0>AND Lower(city) = '#LCase(Replace(url.2, "-", " ", "all"))#'<cfelse>AND (lower(hschool) LIKE '%#lcase(fixedschool)#%' OR lower(mschool) LIKE '%#lcase(fixedschool)#%' OR lower(eschool) LIKE '%#lcase(fixedschool)#%')</cfif>
18 : <cfif #site.site_type# EQ "lake" OR #site.site_type# EQ "school" OR #site.site_type# EQ "subdivision"><cfinclude template="querytype.cfm"></cfif>
19 : AND hschool <> "other"
20 : AND mschool <> "other"
|