47 : <cfquery name="getmls" datasource="#listingdsn#">
48 : select * from mlslistingssf
49 : WHERE mls = '#mlscode#' AND mlsnumber = "#url.5#" AND subdivision = "#Replace(url.3, "-", " ", "all")#" AND city = "#Replace(url.2, "-", " ", "all")#" AND Lower(state) = '#LCase(url.1)#'
50 : </cfquery>
51 :
|