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=8 AND p.iItemType='1' AND iCityID IN (1248,1058,16493,1131,16318,1127,905,16317,1293,16316,929,16482,697,704,1208,16283,662,16312,890,1201,16601,16297,16494,947,1018,651,652,1148,1144,939,16286,721,876,16489,669,871,737,820,1076,862,1174,1160,1107,626,1250,1225,1193,12,1216,16485,16329,632,16326,856,595,1214,779,998,1098,631,989,834,1280,1091,726,739,16131,613,1021,825,16327,813,1111,597,899,780,1196,16488,1244,1125,751,1120,681,952,1045,695,1276,622,900,16484,773,1083,776,723,774,746,981,641,1163,573,818,590,673,657,582,756,1073,948,1180,602,912,1181,907,797,1119,1263,1278,848,604,855,1109,866,591,803,879,603,891,16300,1129,725,1283,1145,674,594,842,800,843,847,831,1235,832,1167,1104,932,16296,1103,1007,1217,670,972,701,16299,913,1128,801,706,886,1212,16486,568,668,810,812,722,926,761,1272,1289,977,833,607,612,1012,914,696,578,656,1070,771) ORDER BY FIELD(iCityID, 1248,1058,16493,1131,16318,1127,905,16317,1293,16316,929,16482,697,704,1208,16283,662,16312,890,1201,16601,16297,16494,947,1018,651,652,1148,1144,939,16286,721,876,16489,669,871,737,820,1076,862,1174,1160,1107,626,1250,1225,1193,12,1216,16485,16329,632,16326,856,595,1214,779,998,1098,631,989,834,1280,1091,726,739,16131,613,1021,825,16327,813,1111,597,899,780,1196,16488,1244,1125,751,1120,681,952,1045,695,1276,622,900,16484,773,1083,776,723,774,746,981,641,1163,573,818,590,673,657,582,756,1073,948,1180,602,912,1181,907,797,1119,1263,1278,848,604,855,1109,866,591,803,879,603,891,16300,1129,725,1283,1145,674,594,842,800,843,847,831,1235,832,1167,1104,932,16296,1103,1007,1217,670,972,701,16299,913,1128,801,706,886,1212,16486,568,668,810,812,722,926,761,1272,1289,977,833,607,612,1012,914,696,578,656,1070,771) ASC, p.tmPosted DESC LIMIT 24
Apartment Hotels Vacation Rental in Wesley Chapel
