Skip to Primary Navigation Skip to Primary Content Skip to Footer Navigation

Dale Hollow Lake - Houseboat Prices

The pricing information presented below will help you compare houseboat rental prices at Dale Hollow Lake. Pricing is subject to change without notice. .

If you would like to discuss your options more fully, please contact us toll-free at 888-454-8825 or select Request Info to submit a request for assistance. Our knowledgeable Houseboat Rental Agents will be happy to help.



* Table shows pricing only. Please call for availability. A deposit may be required for some houseboats.
Trip Length Marina Season Dates 50' Family Cruiser Houseboat 60 Discoverer 64 Jamestowner 65' Mid-Size Cruiser Houseboat 74' Flagship Houseboat 75' Bigfoot 84' Bigfoot II Houseboat

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.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and dx.start_date >= '2019-04-01' and dx.start_date <= '2019-10-31' ' at line 53
 
The error occurred in D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1941
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1812
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1802
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/modules/content/addedPageSections.cfm: line 225
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/templates/houseboat_3.0_page.template.cfm: line 121
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 167
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 105
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 53
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 357
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 847
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1941
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1812
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1802
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/modules/content/addedPageSections.cfm: line 225
Called from D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/templates/houseboat_3.0_page.template.cfm: line 121
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 167
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 105
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 53
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 357
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 847
1939 : 								and p.duration_number = #prices.daysOrNights#
1940 : 								and dx.start_date >= '#dateFormat( prices.start_date, "yyyy-mm-dd" )#'
1941 : 								and dx.start_date <= '#dateFormat( prices.end_date, "yyyy-mm-dd" )#'
1942 : 
1943 : 

VENDORERRORCODE   1064
SQLSTATE   42000
SQL    select p.price, h.short_name as houseboatName, m.short_name as marinaName, dx.start_date, dx.end_date, p.duration_number as daysOrNights, supps.nights = 1 as isNights, p.id_pricing, p.display as d_pricing, p.duration_number, m.short_name as d_marina, s.id_pricing_seasons, m.id_marinas from pricing p inner join houseboats h on p.houseboats = h.id_houseboats inner join houseboats__marinas hm on h.id_houseboats = hm.id_houseboats inner join marinas m on hm.id_marinas = m.id_marinas left outer join trip_length t on p.trip_length = t.id_trip_length left outer join pricing__pricing_seasons ps on p.id_pricing = ps.id_pricing left outer join pricing_seasons s on ps.id_pricing_seasons = s.id_pricing_seasons left outer join pricing_seasons__season_dates lx on s.id_pricing_seasons = lx.id_pricing_seasons left outer join season_dates dx on lx.id_season_dates = dx.id_season_dates left outer join suppliers supps on p.suppliers = supps.id_suppliers where p.ids_pricing = 1 and hm.id_marinas in ( 119 ) and p.houseboats = 485 and p.duration_number = and dx.start_date >= '2019-04-01' and dx.start_date <= '2019-10-31' order by dx.start_date
DATASOURCE   work_crm_houseboating
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   162.158.74.181
Referrer  
Date/Time   18-Feb-19 05:07 AM
Stack Trace
at cfpricingTool2ecfm565061250._factor6(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1941) at cfpricingTool2ecfm565061250._factor7(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1812) at cfpricingTool2ecfm565061250._factor10(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1802) at cfpricingTool2ecfm565061250._factor11(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1) at cfpricingTool2ecfm565061250.runPage(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1) at cfaddedPageSections2ecfm1018524590.runPage(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/modules/content/addedPageSections.cfm:225) at cfhouseboat_32e0_page2etemplate2ecfm1526134065.runPage(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/templates/houseboat_3.0_page.template.cfm:121) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor6(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:167) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor8(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:105) at cfcontent2ecfc812926230$funcRENDERCONTENT.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:53) at cfapp2ecfc1996423358$funcEXECUTELAYERTRIGGERS.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:357) at cfapp2ecfc1996423358$funcONREQUESTEND.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:847) at cfpricingTool2ecfm565061250._factor6(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1941) at cfpricingTool2ecfm565061250._factor7(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1812) at cfpricingTool2ecfm565061250._factor10(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1802) at cfpricingTool2ecfm565061250._factor11(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1) at cfpricingTool2ecfm565061250.runPage(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/modules/david/pricingTool.cfm:1) at cfaddedPageSections2ecfm1018524590.runPage(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/modules/content/addedPageSections.cfm:225) at cfhouseboat_32e0_page2etemplate2ecfm1526134065.runPage(D:/Dropbox/gts/webroot/platform/instances/earthdiver/houseboating.org/redesign/templates/houseboat_3.0_page.template.cfm:121) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor6(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:167) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor8(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:105) at cfcontent2ecfc812926230$funcRENDERCONTENT.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:53) at cfapp2ecfc1996423358$funcEXECUTELAYERTRIGGERS.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:357) at cfapp2ecfc1996423358$funcONREQUESTEND.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:847)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and dx.start_date >= '2019-04-01'
								and dx.start_date <= '2019-10-31'

' at line 53
	at sun.reflect.GeneratedConstructorAccessor388.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:927)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1451)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfpricingTool2ecfm565061250._factor6(D:\Dropbox\gts\webroot\platform\instances\earthdiver\houseboating.org\redesign\modules\david\pricingTool.cfm:1941)
	at cfpricingTool2ecfm565061250._factor7(D:\Dropbox\gts\webroot\platform\instances\earthdiver\houseboating.org\redesign\modules\david\pricingTool.cfm:1812)
	at cfpricingTool2ecfm565061250._factor10(D:\Dropbox\gts\webroot\platform\instances\earthdiver\houseboating.org\redesign\modules\david\pricingTool.cfm:1802)
	at cfpricingTool2ecfm565061250._factor11(D:\Dropbox\gts\webroot\platform\instances\earthdiver\houseboating.org\redesign\modules\david\pricingTool.cfm:1)
	at cfpricingTool2ecfm565061250.runPage(D:\Dropbox\gts\webroot\platform\instances\earthdiver\houseboating.org\redesign\modules\david\pricingTool.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfaddedPageSections2ecfm1018524590.runPage(D:\Dropbox\gts\webroot\platform\instances\earthdiver\houseboating.org\modules\content\addedPageSections.cfm:225)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
	at cfhouseboat_32e0_page2etemplate2ecfm1526134065.runPage(D:\Dropbox\gts\webroot\platform\instances\earthdiver\houseboating.org\redesign\templates\houseboat_3.0_page.template.cfm:121)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfcontent2ecfc812926230$funcRENDERCONTENT._factor6(D:\Dropbox\gts\webroot\platform\prototype\shared\layers\content.cfc:167)
	at cfcontent2ecfc812926230$funcRENDERCONTENT._factor8(D:\Dropbox\gts\webroot\platform\prototype\shared\layers\content.cfc:105)
	at cfcontent2ecfc812926230$funcRENDERCONTENT.runFunction(D:\Dropbox\gts\webroot\platform\prototype\shared\layers\content.cfc:53)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:402)
	at cfapp2ecfc1996423358$funcEXECUTELAYERTRIGGERS.runFunction(D:\Dropbox\gts\webroot\platform\prototype\shared\engine\app.cfc:357)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2451)
	at cfapp2ecfc1996423358$funcONREQUESTEND.runFunction(D:\Dropbox\gts\webroot\platform\prototype\shared\engine\app.cfc:847)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
	at coldfusion.runtime.AppEventInvoker.onRequestEnd(AppEventInvoker.java:343)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:447)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)