North Texas Home Finders


North Texas
Home Finders

Office: 972 347 9970
info@northtexashomefinders.com

Need Assistance?

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 'WHERE `aic_property`.`property_Area` = '2' GROUP BY `aic_property`.`property_ID`' at line 74
SELECT `aic_property`.`property_ID`, `aic_property`.`property_MLS`, `aic_property`.`property_CreateBy`, `aic_property`.`property_CreateDate`, `aic_property`.`property_CategoryID`, `aic_property`.`property_LocationID`, `aic_property`.`property_NeighborHoodID`, `aic_property`.`property_Cat`, `aic_property`.`property_StatusID`, `aic_property`.`property_TypeID`, `aic_property`.`property_FilterID`, `aic_property`.`property_ListPrice`, `aic_property`.`property_ListPrice2`, `aic_property`.`property_HideListPrice`, `aic_property`.`property_LeasePrice`, `aic_property`.`property_SoldPrice`, `aic_property`.`property_StreetNum`, `aic_property`.`property_StreetName`, `aic_property`.`property_HideStreet`, `aic_property`.`property_City`, `aic_property`.`property_State`, `aic_property`.`property_Zip`, `aic_property`.`property_Bedrooms`, `aic_property`.`property_Bedrooms2`, `aic_property`.`property_Bathrooms`, `aic_property`.`property_Bathrooms2`, `aic_property`.`property_LivingSize`, `aic_property`.`property_LotSize`, `aic_property`.`property_Meter`, `aic_property`.`property_Title`, `aic_property`.`property_HotText`, `aic_property`.`property_Details`, `aic_property`.`property_VirtualTour`, `aic_property`.`property_ExpireDate`, `aic_property`.`property_Featured`, `aic_property`.`property_Rating`, `aic_property`.`property_PDF`, `aic_property`.`property_OpenHouse`, `aic_property`.`property_Rank`, `aic_property`.`property_latitude`, `aic_property`.`property_longitude`, `aic_property`.`property_Internal_Comments`, `aic_property`.`property_ID_Number`, `aic_property`.`property_Builder_ID`, `aic_property`.`property_Area`, `aic_property`.`meta_PageTitle`, `aic_property`.`meta_Title`, `aic_property`.`meta_Keywords`, `aic_property`.`meta_Description`, `aic_property`.`meta_Robots`, `aic_property`.`meta_Analytics`, `aic_property_filter`.`filter_Title`, `aic_property_filter`.`SortOrder`, COALESCE(`aic_photo`.`photo_File`, '/images/house_sil.gif') as photo_File, COALESCE(`aic_photo`.`photo_Thumb`, '/images/house_sil.gif') as photo_Thumb, `aic_photo`.`photo_Title`, `aic_photo`.`photo_Alt`, `aic_neighborhood`.`nei_Name` FROM `aic_property` LEFT JOIN `aic_photo` ON `aic_photo`.`photo_PropertyID` = `aic_property`.`property_ID` AND `aic_photo`.`SortOrder` <= 1 LEFT JOIN `aic_property_filter` ON `aic_property_filter`.`filter_ID` = `aic_property`.`property_FilterID` LEFT JOIN `aic_neighborhood` ON `aic_neighborhood`.`nei_ID` = `aic_property`.`property_FilterID` WHERE `aic_property`.`property_Cat` = 1 WHERE `aic_property`.`property_Area` = '2' GROUP BY `aic_property`.`property_ID` ORDER BY `aic_neighborhood`.`nei_Name`,`aic_property`.`property_Title` LIMIT 0, 5