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

The American Way Real Estate Co., Inc.

Home Page
Find a Property
Real Estate Resources
Relocation
Our Agents
About American Way
About Cookeville
Contact Us
Our Preferred Mortgage Lender

The American Way
Real Estate Co., Inc.
710 South Jefferson
Cookeville, TN 38501
(866) 319-5655 toll free
(931) 526-9581 phone
(931) 528-6569 fax
info@american-way.com
Find a Property
Our Agents
About Us
Contact Us
MLS Search:       

Multiple Family Property Search

Basic Search
- To view all listings, leave fields blank.
- To narrow your search, enter your choices in the fields below.
Price At least dollars but no more than dollars
# of Units At least units but no more than units
Detailed Search (Optional)
I want to search for properties that are located in the cities/regions I selected below. (Leave blank for all areas. Hold Control or Option while clicking to select multiple cities.)
I want to search for properties with of the features I check.
Construction
Frame
Landscaping
220 V. Service
Block Foundation
Builder Warranty
Dishwasher
Electronic Lock Box
In Living Room
In Living Room
None
Outbuildings
Screened Porch
Skylights
Slopes Below Road
Tap Fee Paid
Tennis Court
Two
Vinyl Floors
Roof
Block
Interior
Cedar Shake
Dishwasher
Fence-Wood
Horses Allowed
Indoor Grill
Jet Tub
Outbuildings
Paved Street
Porch Covered
Appliances

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 'Unit apa,Agents, Pl,Also inclu,Attention,AWESOME YE,Each lot i,
 
The error occurred in /home/web/a/american-way.com/www/searchmul.cfm: line 214
Called from /home/web/a/american-way.com/www/searchmul.cfm: line 1
Called from /home/web/a/american-way.com/www/searchmul.cfm: line 214
Called from /home/web/a/american-way.com/www/searchmul.cfm: line 1
 
212 :               #column# order by #column# </cfquery> <cfif a.recordcount is not 0>
213 :                 <cfquery name="b" datasource="ucmls" dbtype="#Application.DBType#">
214 :                 select text,id from features where id in (#valuelist(a.col)#) 
215 :                 order by text 
216 :                 </cfquery>
SQLSTATE   42000
SQL    select text,id from features where id in (7 Unit apa,Agents, Pl,Also inclu,Attention,AWESOME YE,Each lot i,Great inco,Great inve,Great pric,Great rent,Income pro,Investment,Investors,Looking fo,Lots and l,Manufactur,NEW DUPLEX,One good d,Sooooooooo,T-3832 Mob,T-3987 Ve,T-4158 Ni,These apar,These Cust,This Custo) order by text
VENDORERRORCODE   1064
DATASOURCE   ucmls
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   192.168.1.4
Referrer  
Date/Time   09-May-08 07:33 PM
Stack Trace
at cfsearchmul2ecfm2004189182._factor0(/home/web/a/american-way.com/www/searchmul.cfm:214) at cfsearchmul2ecfm2004189182.runPage(/home/web/a/american-way.com/www/searchmul.cfm:1) at cfsearchmul2ecfm2004189182._factor0(/home/web/a/american-way.com/www/searchmul.cfm:214) at cfsearchmul2ecfm2004189182.runPage(/home/web/a/american-way.com/www/searchmul.cfm:1) 

com.mysql.jdbc.exceptions.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 'Unit apa,Agents, Pl,Also inclu,Attention,AWESOME YE,Each lot i,
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)
	at com.mysql.jdbc.Statement.execute(Statement.java:706)
	at com.mysql.jdbc.Statement.execute(Statement.java:783)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1220)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
	at cfsearchmul2ecfm2004189182._factor0(/home/web/a/american-way.com/www/searchmul.cfm:214)
	at cfsearchmul2ecfm2004189182.runPage(/home/web/a/american-way.com/www/searchmul.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)