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 ('+property +listings +for +sale' IN BOOLEAN MODE)) AND iCityID IN (12997,12773,12979,12611,12893,12695,12879,12804,12781,12985,12589,12885,12721,12866,12883,12915,12788,12824,12703,12840,12909,12743,12677,12902,12806,12676,12680,12626,12973,12939,12995,12887,12672,12795,12899,12890,12815,12977,12801,12707,12930,12797,16637,12927,12949,12793,12612,12827,12664,12732,12714,12957,12892,12828,12822,12830,12964,12802,12622,12670,12836,12616,12709,12807,12595,12901,12688,12969) ORDER BY FIELD(iCityID, 12997,12773,12979,12611,12893,12695,12879,12804,12781,12985,12589,12885,12721,12866,12883,12915,12788,12824,12703,12840,12909,12743,12677,12902,12806,12676,12680,12626,12973,12939,12995,12887,12672,12795,12899,12890,12815,12977,12801,12707,12930,12797,16637,12927,12949,12793,12612,12827,12664,12732,12714,12957,12892,12828,12822,12830,12964,12802,12622,12670,12836,12616,12709,12807,12595,12901,12688,12969) ASC, p.tmPosted DESC LIMIT 24
property listings for sale, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in Wisconsin Dells
