| query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| EXECUTIONTIME | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQL | SELECT TOP 4 tblResidentialProperties.lngMLSNumber, tblResidentialProperties.txtStreetNumber, tblResidentialProperties.txtStreetDir, tblResidentialProperties.txtStreetName, tblResidentialProperties.txtCity, tblResidentialProperties.txtState, tblResidentialProperties.txtZipcode, tblResidentialProperties.lngBedrooms, tblResidentialProperties.lngBaths, tblResidentialProperties.lngListPrice, (SELECT TOP 1 tblPhotoLinks.txtPhotoLink FROM tblPhotoLinks WHERE tblPhotoLinks.lngMLSNumber = tblResidentialProperties.lngMLSNumber ORDER BY tblPhotoLinks.lngPhotoOrder) AS txtPhotoLink FROM tblResidentialProperties WHERE tblResidentialProperties.ysnActive = 1 AND tblResidentialProperties.lngListingOfficeID = ? ORDER BY tblResidentialProperties.ysnFeatured DESC, newid() | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLPARAMETERS |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Featured Properties
Over 3,000 Homes Sold!
If you are looking for a realtor in Evans, GA for guidance in purchasing your next home, let Greg Honeymichael help you. Browse through our listing of homes from all afforadable price ranges and sizes. As a top realtor in Evans, GA, Greg Honeymichael guarantees his customers are always sastisfied. Contact us today and let us help you find your dream home!
More About Our TeamClient Feedback
-
Greg Honeymichael was a very honest, professional, and accommodating real estate agent. He was especially helpful in dealing with the challenges of searching for a home from another part of the country. I would highly recommend him to anyone in the market for a new home in Columbia County!
~Danny Hurst | Grovetown, GA -
Greg never gave up on closing our house. It was a six month process because of financial institutions, etc. There were times when I was certain the deal was dead. Greg along with the other agent, Greg Oldom, were very pro-active with keeping the deal alive. This deal would have never closed without their involvement. They both took cuts in their personal commissions to make the deal work. I can’t say how thankful I am for using Greg H. and highly recommend him to anyone I can!
~Susan Curry | Riverwood Plantation, Evans , GA -
Greg was upfront, practical and extremely easy to work with. Greg presents a very laid back attitude but I feel he is actually very hard working and knowledgeable
~Barbara Shaffer | Blythe, GA -
HE WAS GREAT I WOULD USE HIM AGAIN THANKS TO ALL!
~Coy Bulluck | Sugar Creek,