Old Mt. Pleasant Homes For Sale


Old Mt. Pleasant Subdivision Information

Located North of Pitt Street and the Old Village, Old Mt. Pleasant is a wonderful neighborhood adjacent to Coleman Boulevard. Featuring ancient live oak trees, Mt. Pleasant Academy, and the Pitt Street Bridge Park, this area has much to offer. The quiet streets have homes of all shapes and sizes - traditional southern style and ranch pervades with beautiful remodels as well as new construction. This location is 5 minutes to Sullivans Island and 15 minutes to Downtown Charleston, not to mention all that Mt. Pleasant has to offer. The Old Mt. Pleasant homes range in prices from $350,000 to over $800,000.

Lucee 5.3.1.102 Error (database)
Message Unknown column 'Old Mt Pleasant' 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 "Old Mt Pleasant"


)



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 'Old Mt Pleasant' 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.GeneratedMethodAccessor60.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.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.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 6/5/20 12:17:48 AM EDT