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=2 AND p.iUserType='1' AND p.iItemType='5' AND iCityID IN (756,16300,847,16299,812,891,641,668,1180,913,998,632,607,1160,820,612,1070,832,1272,631,1107,831,657,16131,671,696,876,16327,724,947,1174,1207,771,1244,605,877,914,810,16283,1214,704,948,1148,1127,1131,813,1289,1153,845,16485,797,1151,1014,833,16494,16482,16493,16489,578,674,1197,1248,1152,16316,972,834,16318,1293,595,16317,744,905,977,856,979,1220,697,1195,16326,1058,1091,1292,1018,1012,929,989,1275,662,1282,1274,739,871,12,16486,980,1055,862,597,16297,16601,667,825,1017,16312,1208,574,890,16488,779,1159,1083,16296,882,670,652,669,672,789,1279,1201,651) ORDER BY FIELD(iCityID, 756,16300,847,16299,812,891,641,668,1180,913,998,632,607,1160,820,612,1070,832,1272,631,1107,831,657,16131,671,696,876,16327,724,947,1174,1207,771,1244,605,877,914,810,16283,1214,704,948,1148,1127,1131,813,1289,1153,845,16485,797,1151,1014,833,16494,16482,16493,16489,578,674,1197,1248,1152,16316,972,834,16318,1293,595,16317,744,905,977,856,979,1220,697,1195,16326,1058,1091,1292,1018,1012,929,989,1275,662,1282,1274,739,871,12,16486,980,1055,862,597,16297,16601,667,825,1017,16312,1208,574,890,16488,779,1159,1083,16296,882,670,652,669,672,789,1279,1201,651) ASC, p.tmPosted DESC LIMIT 24
Villas for Sale by Owner/Individual in Floral City
