Need help finding the right Water Treatment?

Tested and proven effective, our water treatment products are known for delivering reliable results and making water care less complex.
Use our wizard assistance tool to get you to the right products. 
Simply answer the questions as you go... and though process of elimination we will get you to the products you need.

At any point you can abort the process by clicking on any displayed product picture which will take you to that product in our online catalog....... Lets get Started!






In order to use water treatment effectively, you will need a rough estimate of how much water is in your pool.
Use our Pool Volume Calculator!
We are starting with 191 possible products.

Question 1
Are you looking for water treatment products for your Pool or Hot Tub?
 



More online client services than any other Pool/Spa Dealer

Discover Now

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
 
The error occurred in C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm: line 141
Called from C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm: line 43
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 815
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 814
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 1
Called from C:/home/clearwaterpools.ca/config/footer1.cfm: line 103
Called from C:/home/clearwaterpools.ca/vs/index.cfm: line 407
Called from C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm: line 141
Called from C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm: line 43
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 815
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 814
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 1
Called from C:/home/clearwaterpools.ca/config/footer1.cfm: line 103
Called from C:/home/clearwaterpools.ca/vs/index.cfm: line 407
139 : 					expiry = '3000-01-01',
140 : 					active = 0
141 : 			where id = #VEtasks.couponID#
142 : 		</cfquery>
143 : 	</cfif>

SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   clearwater
VENDORERRORCODE   102
SQL   update CM_coupons set publishfrom = '3000-01-01', publishto = '3000-01-01', expiry = '3000-01-01', active = 0 where id =
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.226.72.194
Referrer  
Date/Time   24-Jul-24 06:30 PM
Stack Trace
at cfVEEND2ecfm1862785394.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm:141) at cfact_runVETask2ecfm69135559.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm:43) at cftriggers2ecfm179046781._factor36(C:/home/clearwaterpools.ca/config/triggers.cfm:815) at cftriggers2ecfm179046781._factor40(C:/home/clearwaterpools.ca/config/triggers.cfm:814) at cftriggers2ecfm179046781.runPage(C:/home/clearwaterpools.ca/config/triggers.cfm:1) at cffooter12ecfm353177356.runPage(C:/home/clearwaterpools.ca/config/footer1.cfm:103) at cfindex2ecfm291410970.runPage(C:/home/clearwaterpools.ca/vs/index.cfm:407) at cfVEEND2ecfm1862785394.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm:141) at cfact_runVETask2ecfm69135559.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm:43) at cftriggers2ecfm179046781._factor36(C:/home/clearwaterpools.ca/config/triggers.cfm:815) at cftriggers2ecfm179046781._factor40(C:/home/clearwaterpools.ca/config/triggers.cfm:814) at cftriggers2ecfm179046781.runPage(C:/home/clearwaterpools.ca/config/triggers.cfm:1) at cffooter12ecfm353177356.runPage(C:/home/clearwaterpools.ca/config/footer1.cfm:103) at cfindex2ecfm291410970.runPage(C:/home/clearwaterpools.ca/vs/index.cfm:407)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
	at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
	at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
	at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892)
	at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
	at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1623)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1365)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1295)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfVEEND2ecfm1862785394.runPage(C:\home\clearwaterpools.ca\secure_html\etrack\VE\VEEND.cfm:141)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfact_runVETask2ecfm69135559.runPage(C:\home\clearwaterpools.ca\secure_html\etrack\VE\act_runVETask.cfm:43)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cftriggers2ecfm179046781._factor36(C:\home\clearwaterpools.ca\config\triggers.cfm:815)
	at cftriggers2ecfm179046781._factor40(C:\home\clearwaterpools.ca\config\triggers.cfm:814)
	at cftriggers2ecfm179046781.runPage(C:\home\clearwaterpools.ca\config\triggers.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cffooter12ecfm353177356.runPage(C:\home\clearwaterpools.ca\config\footer1.cfm:103)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfindex2ecfm291410970.runPage(C:\home\clearwaterpools.ca\vs\index.cfm:407)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)