Real Estate

Real Estate Main Image
SITE:cdaniels.cbidaho.com
SERVER:iq-web-1
DATA SERVER:cust-sql-3
COMPANY ID:iq_cb_schneidmiller
REFERER:
REMOTE ADDRESS:54.90.204.233
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://cdaniels.cbidaho.com/real-estate/zip/83851
DATE:02/16/2019 19:40:49



Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT COMPANY = ( CASE WHEN (companyid = 'iq_cb_schneidmiller') THEN (1) ELSE (2) END ), l.id , 0 AS Distance FROM Listings l WITH (NOLOCK) WHERE (l.mlsid IN ('mls_coeurdalene','mls_spokane')) and (l.propertytype IN ('Commercial','MultiFamily','Residential','Land')) AND (l.DeleteFlag = 'N') AND (l.Zip_Code IN ('83851')) AND (l.isprivate = 'f') ORDER BY List_Price desc, ML_Number ASC
DataSource
stringiq_cb_schneidmiller
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringConnection reset by peer: socket write error
NativeErrorCode
number0
queryError
stringSELECT COMPANY = ( CASE WHEN (companyid = 'iq_cb_schneidmiller') THEN (1) ELSE (2) END ), l.id , 0 AS Distance FROM Listings l WITH (NOLOCK) WHERE (l.mlsid IN ('mls_coeurdalene','mls_spokane')) and (l.propertytype IN ('Commercial','MultiFamily','Residential','Land')) AND (l.DeleteFlag = 'N') AND (l.Zip_Code IN ('83851')) AND (l.isprivate = 'f') ORDER BY List_Price desc, ML_Number ASC
Sql
stringSELECT COMPANY = ( CASE WHEN (companyid = 'iq_cb_schneidmiller') THEN (1) ELSE (2) END ), l.id , 0 AS Distance FROM Listings l WITH (NOLOCK) WHERE (l.mlsid IN ('mls_coeurdalene','mls_spokane')) and (l.propertytype IN ('Commercial','MultiFamily','Residential','Land')) AND (l.DeleteFlag = 'N') AND (l.Zip_Code IN ('83851')) AND (l.isprivate = 'f') ORDER BY List_Price desc, ML_Number ASC
SQLState
string08S01
StackTrace
stringlucee.runtime.exp.DatabaseException: Connection reset by peer: socket write error at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2435) at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:2008) at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:4096) at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:4009) at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:3197) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7519) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:465) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:393) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:282) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:226) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1133) at lucee.runtime.tag.Query._doEndTag(Query.java:693) at lucee.runtime.tag.Query.doEndTag(Query.java:583) at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:265) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:155) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2010) at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:569) at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207) at components.listings_cfc$cf.udfCall1_000018(/components/listings.cfc:729) at components.listings_cfc$cf.udfCall1(/components/listings.cfc:533) at components.listings_cfc$cf.udfCall(/components/listings.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2006) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:224) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:197) at iqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:149) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812) at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82) at lib.iq_cfc$cf.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at iqweb.sitetemplates._02.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/02/layouts/_site.cfm:176) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812) at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59) at lib.iq_cfc$cf.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:809) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39) at lib.iq_cfc$cf.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at application_cfc$cf.udfCall(/application.cfc:325) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:438) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2480) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2470) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2443) at lucee.runtime.engine.Request.exe(Request.java:44) at lucee.runtime.engine.Request.run(Request.java:30)
TagContext
Array
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number265
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:265)
template
string/iqquery.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number155
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:155)
template
string/iqquery.cfc
type
stringcfml
3
Struct
codePrintHTML
string727: &lt;cfif arguments.propertystory eq &quot;T&quot;&gt;AND (l.propertystory != &lt;cfiqqueryparam value=&quot;&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt; and l.propertystorystatus = &lt;cfiqqueryparam value=&quot;a&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt;)&lt;/cfif&gt;<br> 728: &lt;cfif arguments.distance NEQ 0&gt;AND (dbo.fn_LatLongDistance(#arguments.lat#, #arguments.lon#, l.lat, l.lon) between &lt;cfiqqueryparam value=&quot;0&quot; cfsqltype=&quot;cf_sql_numeric&quot;&gt; and &lt;cfiqqueryparam value=&quot;#arguments.distance#&quot; cfsqltype=&quot;cf_sql_numeric&quot;&gt;)&lt;/cfif&gt;<br> <b>729: &lt;/cfif&gt;</b><br> 730: ORDER BY #arguments.officelistingsfirst eq 't' ? 'COMPANY ASC,' : ''# #arguments.lat neq 0 and arguments.lon neq 0 ? 'distance, ' : ''# #arguments.OrderBy# #LCase(arguments.OrderDirection)#, ML_Number ASC<br> 731: &lt;/cfiqquery&gt;<br>
codePrintPlain
string727: <cfif arguments.propertystory eq "T">AND (l.propertystory != <cfiqqueryparam value="" cfsqltype="cf_sql_varchar"> and l.propertystorystatus = <cfiqqueryparam value="a" cfsqltype="cf_sql_varchar">)</cfif> 728: <cfif arguments.distance NEQ 0>AND (dbo.fn_LatLongDistance(#arguments.lat#, #arguments.lon#, l.lat, l.lon) between <cfiqqueryparam value="0" cfsqltype="cf_sql_numeric"> and <cfiqqueryparam value="#arguments.distance#" cfsqltype="cf_sql_numeric">)</cfif> 729: </cfif> 730: ORDER BY #arguments.officelistingsfirst eq 't' ? 'COMPANY ASC,' : ''# #arguments.lat neq 0 and arguments.lon neq 0 ? 'distance, ' : ''# #arguments.OrderBy# #LCase(arguments.OrderDirection)#, ML_Number ASC 731: </cfiqquery>
column
number0
id
string??
line
number729
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1_000018(/components/listings.cfc:729)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string531: <br> 532: &lt;cfreturn local.retVal&gt;<br> <b>533: &lt;/cfif&gt;</b><br> 534: <br> 535: &lt;cfoutput&gt;<br>
codePrintPlain
string531: 532: <cfreturn local.retVal> 533: </cfif> 534: 535: <cfoutput>
column
number0
id
string??
line
number533
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1(/components/listings.cfc:533)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string147: &lt;cfinvokeargument name=&quot;maxrows&quot; value=&quot;24&quot;&gt;<br> 148: &lt;cfinvokeargument name=&quot;impression_from&quot; value=&quot;Search Results&quot;&gt;<br> <b>149: &lt;/cfinvoke&gt;</b><br> 150: <br> 151: &lt;cfif retListings.Status EQ 1 or fieldvalue eq &quot;&quot;&gt;<br>
codePrintPlain
string147: <cfinvokeargument name="maxrows" value="24"> 148: <cfinvokeargument name="impression_from" value="Search Results"> 149: </cfinvoke> 150: 151: <cfif retListings.Status EQ 1 or fieldvalue eq "">
column
number0
id
string??
line
number149
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:149)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
6
Struct
codePrintHTML
string80: <br> 81: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br> <b>82: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br> 83: &lt;cfelse&gt;<br> 84: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string80: 81: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")> 82: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /> 83: <cfelse> 84: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number82
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
7
Struct
codePrintHTML
string174: &lt;/cfif&gt;<br> 175: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#&quot;&gt;<br> <b>176: #request.iqlib.RenderPage()#</b><br> 177: &lt;/div&gt;<br> 178: &lt;/div&gt;<br>
codePrintPlain
string174: </cfif> 175: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"> 176: #request.iqlib.RenderPage()# 177: </div> 178: </div>
column
number0
id
string??
line
number176
Raw_Trace
stringiqweb.sitetemplates._02.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/02/layouts/_site.cfm:176)
template
stringC:\realistiq\production\iqweb\sitetemplates\02\layouts\_site.cfm
type
stringcfml
8
Struct
codePrintHTML
string57: &lt;cfelse&gt;<br> 58: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br> <b>59: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br> 60: &lt;cfelse&gt;<br> 61: &lt;strong&gt;File Not Found.&lt;/strong&gt;&lt;br&gt;The file &amp;quot;&lt;em&gt;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&lt;/em&gt;&amp;quot; could not be found.<br>
codePrintPlain
string57: <cfelse> 58: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")> 59: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" /> 60: <cfelse> 61: <strong>File Not Found.</strong><br>The file &quot;<em>#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm</em>&quot; could not be found.
column
number0
id
string??
line
number59
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
9
Struct
codePrintHTML
string37: &lt;/cfif&gt;<br> 38: &lt;cfscript&gt;<br> <b>39: doLayout();</b><br> 40: &lt;/cfscript&gt;<br> 41: &lt;/cfif&gt;<br>
codePrintPlain
string37: </cfif> 38: <cfscript> 39: doLayout(); 40: </cfscript> 41: </cfif>
column
number0
id
string??
line
number39
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string323: &lt;cfset local.url = new lib.url() /&gt;<br> 324: &lt;cfset local.url.process(CGI.path_info) /&gt;<br> <b>325: &lt;cfoutput&gt;#request.iqlib.RenderContent()#&lt;/cfoutput&gt;</b><br> 326: &lt;/cfif&gt;<br> 327: &lt;/cfif&gt;<br>
codePrintPlain
string323: <cfset local.url = new lib.url() /> 324: <cfset local.url.process(CGI.path_info) /> 325: <cfoutput>#request.iqlib.RenderContent()#</cfoutput> 326: </cfif> 327: </cfif>
column
number0
id
string??
line
number325
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:325)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string