62 : <cfquery name="getmls" datasource="#listingdsn#">
63 : select * from mlslistingssf
64 : WHERE mls = '#mlscode#' AND mlsnumber = "#url.6#" AND subdivision = "#Replace(url.4, "-", " ", "all")#" AND city = "#Replace(url.2, "-", " ", "all")#" AND Lower(state) = '#LCase(url.1)#'
65 : </cfquery>
66 :
|