Ben Price
Ben Price
Property Search
Home Search
Vacant Land Search
Featured Homes
Open Houses
Elegant Homes
Lakefront Homes
Homes By Email
View Your Favorites

Real Estate Tools
Buyers Information
Sellers Information
Local County Info.
Mortgage Calculators
Get Pre-Qualified
Free Market Analysis
Glossary of Terms
Contact Form


517-851-8042

Today's National
Mortgage Rate
 Mtg Loan Today+/-Last Wk 
 30yr Fixed:  3.83% 3.80%
 15yr Fixed:  3.16% 3.14%
 30yr FHA:  3.49% 3.51%
 30yr Jumbo:  4.10% 4.12%
 1/1 ARM:  4.10% 3.99%
more mortgage info


517-851-8042   |  |   
Home Search: Advanced Search
 Search thousands of properties right here...
Price Range:  to 
City/Schools:
Square Footage:  to  
Bedrooms:  min.   
Baths:  min. 

Street Search:
 Enter first part of street name below, to
 find home for sale.
  
Ad Code or MLS# Lookup:
 Enter MLS number, local newspaper ad code
 and click go!

My Featured Listings
 Photo/Tour  Price  Beds  Baths  Sq. Feet  City/Area
$769,900 5 5.1 5,000 GENOA TWP View Details
$725,000 3 2.1 2,840 NOVI View Details
$479,000 4 4 3,579 GENOA TWP View Details
$479,000 5 3.1 3,435 HAMBURG TWP View Details
$398,900 4 2.1 2,504 MILFORD TWP View Details
$389,900 3 3.1 2,550 HOWELL TWP View Details
$339,000 4 2.1 2,425 HARTLAND TWP View Details
$334,900 4 2.1 2,700 MARION TWP View Details
$315,000 3 3 2,447 GREEN OAK TWP View Details
$309,900 4 2.1 2,364 BRIGHTON TWP View Details
$309,499 4 2.1 2,473 OCEOLA TWP View Details
$284,900 3 2 1,512 GENOA TWP View Details
$279,900 2 1.1 2,713 ALGANSEE TWP View Details
$243,000 3 2.1 2,189 HOWELL TWP View Details
$234,000 3 3 1,745 HOWELL View Details
$179,900 3 2 1,256 FOWLERVILLE VLG View Details
$179,000 3 2 1,038 BRIGHTON TWP View Details
$34,900 2 1 1,000 SURREY TWP View Details

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.

Table 'idx.fsbohomes' doesn't exist
 
The error occurred in C:\inetpub\wwwroot\realestateonline\Includes\BODY.cfm: line 359
Called from C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_40.cfm: line 448
Called from C:\inetpub\wwwroot\CBTownAndCountry\websites\BenPrice\index.cfm: line 14
Called from C:\inetpub\wwwroot\realestateonline\Includes\BODY.cfm: line 359
Called from C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_40.cfm: line 448
Called from C:\inetpub\wwwroot\CBTownAndCountry\websites\BenPrice\index.cfm: line 14
357 : <CFQUERY NAME="GetFSBO" DATASOURCE="IDX">
358 :     SELECT MLS,vtour,Price,Bedrooms,Bathrooms,SqFeet,city FROM fsbohomes WHERE MemberID = #MemberID#
359 : 	 AND BrokersID = #BrokersSiteID# AND STATUS LIKE 'Act%' ORDER BY price desc
360 : </CFQUERY>
361 : <cfif GetFSBO.RecordCount is not 0>

SQL    SELECT MLS,vtour,Price,Bedrooms,Bathrooms,SqFeet,city FROM fsbohomes WHERE MemberID = 540 AND BrokersID = 86 AND STATUS LIKE 'Act%' ORDER BY price desc
DATASOURCE   IDX
VENDORERRORCODE   1146
SQLSTATE   42S02
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.162.184.214
Referrer  
Date/Time   22-May-18 01:31 PM
Stack Trace
at cfBODY2ecfm1026579173.runPage(C:\inetpub\wwwroot\realestateonline\Includes\BODY.cfm:359) at cfWebSiteStyle_402ecfm1448277573.runPage(C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_40.cfm:448) at cfindex2ecfm1842916370.runPage(C:\inetpub\wwwroot\CBTownAndCountry\websites\BenPrice\index.cfm:14) at cfBODY2ecfm1026579173.runPage(C:\inetpub\wwwroot\realestateonline\Includes\BODY.cfm:359) at cfWebSiteStyle_402ecfm1448277573.runPage(C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_40.cfm:448) at cfindex2ecfm1842916370.runPage(C:\inetpub\wwwroot\CBTownAndCountry\websites\BenPrice\index.cfm:14)

java.sql.SQLException: Table 'idx.fsbohomes' doesn't exist
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
	at com.mysql.jdbc.Statement.execute(Statement.java:535)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
	at coldfusion.sql.Executive.executeQuery(Executive.java:719)
	at coldfusion.sql.Executive.executeQuery(Executive.java:652)
	at coldfusion.sql.Executive.executeQuery(Executive.java:613)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:499)
	at cfBODY2ecfm1026579173.runPage(C:\inetpub\wwwroot\realestateonline\Includes\BODY.cfm:359)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cfWebSiteStyle_402ecfm1448277573.runPage(C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_40.cfm:448)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cfindex2ecfm1842916370.runPage(C:\inetpub\wwwroot\CBTownAndCountry\websites\BenPrice\index.cfm:14)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
	at coldfusion.CfmServlet.service(CfmServlet.java:107)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doRequestNoFilter(FusionReactorCoreFilter.java:712)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:341)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at com.seefusion.Filter.doFilter(Filter.java:49)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)