Harleston Village Homes For Sale


Harleston Village Subdivision Information

Founded in the late 1700’s, Harleston Village is one of the more diverse neighborhoods of Downtown Charleston. From large single family antebellum style homes, to condominiums, to college students walking to class, this neighborhood offers everything. This pedestrian friendly area is minutes to hospitals,  local grocery stores, The City Marina, Cannon Park, Colonial Lake, and numerous businesses. Prices for these historic homes range from $500,000 to $12,000,000, with condominiums starting at $250,000.

Lucee 5.3.1.102 Error (database)
Message Unknown column 'Harleston Green' 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 "Harleston Green" or



mastertable.subdivision rlike "Harleston Place" or



mastertable.subdivision rlike "Harleston Village"


)



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 'Harleston Green' 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.GeneratedMethodAccessor49.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.GeneratedMethodAccessor48.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.GeneratedMethodAccessor47.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 7/8/20 6:50:50 AM EDT