Ah Snap, an error occurred.We apologize for the inconvenience! An administrator has been notified about this error. If you wish to submit further information about this problem, you can email cferrors@thinairwebmail.com. Error DetailsError URL: http://aspenarearealestate.com/page.cfm?LIST_15=Closed&LIST_22_from=(any)&LIST_68_from=(any)&Search=Search&LIST_48_to=(any)&quicksearch=0&LIST_57_to=(any)&LIST_22_to=(any)&LIST_57_from=(any)&LIST_66_from=(any)&display=thumbnail&pageid=44396&LIST_48_from=(any)&LIST_66_to=(any)&maxrows=20&mls=1&LIST_106=20120222164803187988000000&LIST_68_to=(any)&startrow=1&orderby=LIST_22%2520DESC&LIST_1=20151021161730039837000000&RealtyOfficeID=72 Error Location: CFQUERY tag in C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsquery.cfm, line 177 Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The data types float and int are incompatible in the modulo operator. The error occurred on line 177. SQL: SELECT mpr.colisting_member_name, mpr.LIST_0,mpr.LIST_1,mpr.LIST_2,mpr.LIST_3 ,mpr.LIST_4,mpr.LIST_5,mpr.LIST_6 ,mpr.LIST_7,mpr.LIST_8,mpr.LIST_87 ,mpr.LIST_104,mpr.LIST_106 ,mpr.LIST_105,mpr.LIST_115 ,mpr.LIST_118,mpr.LIST_120,mpr.LIST_22,mpr.LIST_41,mpr.LIST_48 ,mpr.LIST_53,mpr.LIST_57,mpr.LIST_66,mpr.LIST_68,mpr.LIST_69 ,mpr.LIST_73,mpr.LIST_75,mpr.LIST_77,mpr.LIST_78,mpr.LIST_88,mpr.LIST_9 ,mpr.listing_member_name ,mpr.UNBRANDEDIDXVIRTUALTOUR, mpr.LIST_15, mpr.LIST_23 ,p.PhotoSeq,p.PhotoCaption,p.largeURL,p.smallURL , CASE WHEN mpr.LIST_106 = '20120222164803187988000000' THEN 1 ELSE 0 END AS OfficeListing FROM MLSProperties_spark mpr CROSS APPLY( SELECT TOP 1 * FROM MLSPhotos_spark p1 WHERE p1.LIST_1 = mpr.LIST_1 ORDER BY p1.photoSeq ASC ) p WHERE mpr.list_3 > 0 AND mpr.LIST_15 = 'Closed' AND mpr.LIST_132 > {d '2020-04-24'} AND ( mpr.LIST_106 = '20120222164803187988000000' OR mpr.listOfficeId = '20120222164803187988000000' OR mpr.coListOfficeId = '20120222164803187988000000' OR mpr.buyerOfficeId = '20120222164803187988000000' OR mpr.LIST_62 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (661)) OR mpr.listAgentId IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (661)) OR mpr.coListAgentId IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (661)) ) AND (mpr.LIST_5 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (661)) OR mpr.LIST_6 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (661)) OR (mpr.LIST_62 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (661))) ) ORDER BY LIST_87 DESC,LIST_23%20DESC Calling Stack: C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsquery.cfm, line 177 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsnextprevious.cfm, line 12 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsproperty_responsive.cfm, line 107 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsproperty_responsive.cfm, line 106 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsproperty_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mls_responsive.cfm, line 31 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 122 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 116 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 101 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 100 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\pagecontent_responsive.cfm, line 223 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\pagecontent_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\pagecontent_responsive.cfm, line 1 c:\inetpub\wwwroot\completesite\aare\page.cfm, line 155 |SQLServer|6.0.0.1282|, line 1103 |SQLServer|6.0.0.1282|, line 980 |SQLServer|6.0.0.1282|, line 1124 |SQLServer|6.0.0.1282|, line 193 |SQLServer|6.0.0.1282|, line 1153 |SQLServer|6.0.0.1282|, line 4126 |SQLServer|6.0.0.1282|, line 1059 |SQLServer|6.0.0.1282|, line 327 |SQLServer|6.0.0.1282|, line 4275 |SQLServer|6.0.0.1282|, line 856 |SQLServer|6.0.0.1282|, line 815 |SQLServer|6.0.0.1282|, line 463 |SQLServer|6.0.0.1282|, line 1376 |SQLServer|6.0.0.1282|, line 2505 |SQLServer|6.0.0.1282|, line 1358 |SQLServer|6.0.0.1282|, line 4478 Date and Time: 4/24/2024 5:49 PM Browser: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) Remote Address: 3.144.233.150 |