query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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.txtPropertyStatus = 'A' OR tblResidentialProperties.txtPropertyStatus LIKE 'Active%') AND tblResidentialProperties.lngListingOfficeID = ? AND tblResidentialProperties.lngListPrice >= 300000 AND tblResidentialProperties.lngListPrice <= 700000 ORDER BY tblResidentialProperties.ysnFeatured DESC, newid() | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLPARAMETERS |
|
Featured Properties
Over 5,000 Homes Sold!
If you are looking for a REALTOR® for guidance in purchasing your next home, let The Honeymichael Group help you. Browse through our home listings with a wide range of prices and sizes. As a top REALTOR® in Evans, GA, The Honeymichael Group guarantees their 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 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,