306 : <cfquery name="getaddress" datasource="#listingdsn#" cachedwithin="#CreateTimeSpan(0,3,0,0)#" timeout="10">
307 : select * from mlslistings
308 : WHERE mls = '#mlscode#' AND streetname = "#addfix#" AND county = "#Trim(ReReplace(url.1, "-county|-", " ", "all"))#" AND Lower(city) = '#LCase(cityfix)#'
309 : ORDER BY mlsnumber DESC
310 : </cfquery>
|