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 iSubType=4 AND p.iUserType='2' AND p.iItemType='5' AND iCityID IN (13154,13191,13224,13104,13091,13133,13196,13192,14772,13204,13127,13082,16674,14777,13071,13108,13156,16675,13124,13148,13179,13201,14773,13112,14779,13200,13143,13065,13053,13059,13136,13176,13066,13099,13103,13193,13166,13046,13060,13132,13217,14774,13165,13168,16372,16461) ORDER BY FIELD(iCityID, 13154,13191,13224,13104,13091,13133,13196,13192,14772,13204,13127,13082,16674,14777,13071,13108,13156,16675,13124,13148,13179,13201,14773,13112,14779,13200,13143,13065,13053,13059,13136,13176,13066,13099,13103,13193,13166,13046,13060,13132,13217,14774,13165,13168,16372,16461) ASC, p.tmPosted DESC LIMIT 24
Hotels/Resorts for Rent, Hotels/Resorts Rental by Agent in Peoria
