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://www.demoraesproperties.com/page.cfm?LIST_15=Active&LIST_9=Multi-Family%2520Lot,Single%2520Family%2520Lot&LIST_77=Apple%2520Glen,Ironbridge,Lakota%2520Canyon%2520Ranch,Maroon%2520Creek%2520Club,Maroon%2520Creek%2520Townhome,Ran%2520at%2520Roaring%2520Fork%2520Condo,Ranch%2520at%2520Roaring%2520Fork,River%2520Valley%2520Ranch,Roaring%2520Fork%2520Club,Snowmass%2520Club&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=59719&LIST_48_from=(any)&LIST_66_to=(any)&maxrows=20&mls=1&LIST_68_to=(any)&REALTYOFFICEID=56&orderby=LIST_115,%2520LIST_88,%2520LIST_77 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]Incorrect syntax near '20'. 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 = '20140911212026854270000000' 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 = 'Active' AND (mpr.LIST_9 = 'Multi-Family%20Lot' OR mpr.LIST_9 = 'Single%20Family%20Lot') AND (mpr.LIST_77 IN ('Apple%20Glen','Ironbridge','Lakota%20Canyon%20Ranch','Maroon%20Creek%20Club','Maroon%20Creek%20Townhome','Ran%20at%20Roaring%20Fork%20Condo','Ranch%20at%20Roaring%20Fork','River%20Valley%20Ranch','Roaring%20Fork%20Club','Snowmass%20Club')) ORDER BY LIST_115,%20LIST_88,%20LIST_77 Calling Stack: C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsquery.cfm, line 177 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlslist_responsive.cfm, line 36 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlslist_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mls_responsive.cfm, line 52 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\demoraes\page.cfm, line 333 |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 2035 |SQLServer|6.0.0.1282|, line 632 |SQLServer|6.0.0.1282|, line 2699 |SQLServer|6.0.0.1282|, line 2508 |SQLServer|6.0.0.1282|, line 1358 |SQLServer|6.0.0.1282|, line 4478 Date and Time: 4/25/2024 9:29 PM Browser: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) Remote Address: 3.139.238.76 |