SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=1 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+listed +homes +for +sale' IN BOOLEAN MODE)) AND iCityID IN (16333,14256,14290,14343,16352,14196,14302,14285,14342,14219,14215,14327,14246,16417,14306,14247,14227,14207,14240,14239,14307,14206,14269,14330,16583,14313,14304,14325,14205,14286,14282,14184,14263,14305,16619,16559,14210,14208,14323,14267,14220,14221,14260,14203,14279,14280,14245,16617,14213,14309,14241,14317,16618,14266,14255) ORDER BY FIELD(iCityID, 16333,14256,14290,14343,16352,14196,14302,14285,14342,14219,14215,14327,14246,16417,14306,14247,14227,14207,14240,14239,14307,14206,14269,14330,16583,14313,14304,14325,14205,14286,14282,14184,14263,14305,16619,16559,14210,14208,14323,14267,14220,14221,14260,14203,14279,14280,14245,16617,14213,14309,14241,14317,16618,14266,14255) ASC, p.tmPosted DESC LIMIT 24
listed homes for sale, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in Air Force Academy
