Rivertowne Homes For Sale


Rivertowne Subdivision Information

Rivertowne is a newer planned community that offers the best of Charleston golf and lowcountry living. The community features an Arnold Palmer designed course that was awarded 4.5 stars by Golf Digest. Located off Highway 41. The neighborhood has two community docks on the Wando River, swimming pools, tennis courts and a play park. The community consists of single-family custom and semi-custom homes in true lowcountry style. Homes range from the high $300s to over $3 million for the  custom homes with private docks on the river.

Lucee 5.3.1.102 Error (database)
Message Unknown column 'Rivertowne' in 'where clause'
SQL SELECT
mastertable.street_number,mastertable.street_name,mastertable.city,mastertable.zip_code,mastertable.state,mastertable.mlsnumber,mastertable.mlsid,mastertable.wsid,mastertable.unit_number,mastertable.list_price,mastertable.subdivision,mastertable.bedrooms,mastertable.baths_full,mastertable.acreage,mastertable.zoning,mastertable.kind,mastertable.photo_link,mastertable.addressdisplayyn,mastertable.legaladdress,mastertable.shortsale,mastertable.foreclosure,property_dates.created_at,mastertable.longitude,mastertable.latitude
FROM mastertable
Inner Join property_dates
where mastertable.MLSNumber = property_dates.mlsnumber and mastertable.mlsid = '3' and property_dates.mlsid = '3'
and mastertable.mlsid = property_dates.mlsid
and mastertable.wsid = property_dates.wsid



and


(


mastertable.subdivision rlike "Rivertowne" or



mastertable.subdivision rlike "Rivertowne Country Club" or



mastertable.subdivision rlike "Rivertowne On The Wando"


)



order by list_price DESC
DatabaseName MySQL
DatabaseVersion 8.0.19
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.15 (Revision: 79a4336f140499bd22dd07f02b708e163844e3d5)
Datasource mlsmaster30
Stacktrace The Error Occurred in
E:\inetpub\wwwroot\domains\askfrankrealestate.com\htdocs\mls\components\neighborhood-listings.cfm: line 28
26: )
27: </cfif>
28: <!---END: SPECIAL CODE FOR THE ION--->
29:
30: order by list_price DESC

called from E:\inetpub\wwwroot\domains\askfrankrealestate.com\htdocs\mls\charleston-neighborhood.cfm: line 81
Java Stacktrace lucee.runtime.exp.DatabaseException: Unknown column 'Rivertowne' in 'where clause'
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782)
  at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:666)
  at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:286)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:267)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:221)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1044)
  at lucee.runtime.tag.Query._doEndTag(Query.java:644)
  at lucee.runtime.tag.Query.doEndTag(Query.java:537)
  at mls.components.neighborhood_listings_cfm585$cf.call(/mls/components/neighborhood-listings.cfm:28)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:911)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:803)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:785)
  at mls.charleston_neighborhood_cfm495$cf.call(/mls/charleston-neighborhood.cfm:81)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:911)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:803)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2367)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2357)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2332)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1045)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:991)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
  at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
  at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
  at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:478)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)
 
Timestamp 5/25/20 4:40:15 PM EDT