Professional Real Estate Services
810-844-1430   |  |   
The Gills
The Gills
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
Mortgage Calculators
Get Pre-Qualified
Free Market Analysis
Glossary of Terms
Contact Form

About The Gills
Like us on Facebook
Follow us on Twitter

810-844-1430



Home Search
Search through thousands of local area homes just like real estate agents do.
Price Range:
  to 
City/Area: 
School District: 
Square Footage:
  to  
Bedrooms:
  min. 
Bathrooms:
  min. 
Acreage:
  to  
Lake Front: Homes with lake frontage.
Basement: Homes with basements.
Garage: Homes with Garages.
 


Search by
Street Name:
Partial entries are fine e.g. Miller for
properties listed on Miller Road.
   
Search by
MLS or Ad Code:
Enter MLS number, local newspaper
ad code and click search!


Featured Homes
Vacant Land Search
Lake Front Homes
Elegant Homes
Open Houses
Home By Email


My Featured Listings
 Photo/Tour  Price  Beds  Baths  Sq. Feet  City/Area
$1,450,000 5 4.1 4,082 GENOA TWP View Details
$769,900 5 5.1 5,000 GENOA TWP View Details
$739,000 5 4.1 4,500 BRIGHTON TWP View Details
$725,000 3 2.1 2,840 NOVI View Details
$484,900 5 3.1 3,435 HAMBURG TWP View Details
$479,000 4 4 3,579 GENOA TWP View Details
$397,500 4 2.1 2,366 BRIGHTON TWP View Details
$368,900 5 3.1 3,248 FENTON TWP View Details
$345,000 4 2.1 2,425 HARTLAND TWP View Details
$345,000 4 2.1 2,700 MARION TWP View Details
$309,500 4 2.1 2,473 OCEOLA TWP View Details
$284,900 4 2.1 2,386 GRAND BLANC View Details
$279,900 2 1.1 2,713 ALGANSEE TWP View Details
$229,940 2 3 1,875 FARMINGTON HILLS View Details
$229,900 3 1.1 1,125 BRIGHTON TWP View Details
$209,900 3 2 2,352 COHOCTAH TWP View Details
$199,000 2 1 1,170 BRIGHTON TWP View Details
$149,900 2 2 1,336 BRIGHTON View Details
$45,000 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\home_search.cfm: line 405
Called from C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm: line 1
Called from C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_70.cfm: line 460
Called from C:\inetpub\wwwroot\CBTownAndCountry\websites\JRGill\index.cfm: line 14
Called from C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm: line 405
Called from C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm: line 1
Called from C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_70.cfm: line 460
Called from C:\inetpub\wwwroot\CBTownAndCountry\websites\JRGill\index.cfm: line 14
403 : <CFQUERY NAME="GetFSBO" DATASOURCE="IDX">
404 :     SELECT * FROM fsbohomes WHERE MemberID = #MemberID#
405 : 	 AND BrokersID = #BrokersSiteID# AND STATUS LIKE 'Act%' ORDER BY price
406 : </CFQUERY>
407 : <cfif GetFSBO.RecordCount is not 0>

SQL    SELECT * FROM fsbohomes WHERE MemberID = 520 AND BrokersID = 86 AND STATUS LIKE 'Act%' ORDER BY price
DATASOURCE   IDX
VENDORERRORCODE   1146
SQLSTATE   42S02
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   23.20.165.182
Referrer  
Date/Time   23-Apr-18 12:55 PM
Stack Trace
at cfhome_search2ecfm402997990._factor2(C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm:405) at cfhome_search2ecfm402997990.runPage(C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm:1) at cfWebSiteStyle_702ecfm1531738144.runPage(C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_70.cfm:460) at cfindex2ecfm1447038814.runPage(C:\inetpub\wwwroot\CBTownAndCountry\websites\JRGill\index.cfm:14) at cfhome_search2ecfm402997990._factor2(C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm:405) at cfhome_search2ecfm402997990.runPage(C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm:1) at cfWebSiteStyle_702ecfm1531738144.runPage(C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_70.cfm:460) at cfindex2ecfm1447038814.runPage(C:\inetpub\wwwroot\CBTownAndCountry\websites\JRGill\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 cfhome_search2ecfm402997990._factor2(C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm:405)
	at cfhome_search2ecfm402997990.runPage(C:\inetpub\wwwroot\realestateonline\Includes\home_search.cfm:1)
	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_702ecfm1531738144.runPage(C:\inetpub\wwwroot\realestateonline\Includes\WebSiteStyle_70.cfm:460)
	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 cfindex2ecfm1447038814.runPage(C:\inetpub\wwwroot\CBTownAndCountry\websites\JRGill\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)