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=5 AND p.iUserType='2' AND p.iItemType='2' AND iCityID IN (689,1047,963,962,649,889,1024,1140,638,815,973,995,1266,570,814,1186,1061,961,786,1173,1258,1254,683,653,1074,885,852,965,1003,782,720,1060,707,1233,610,1004,1253,964,634,738,1019,1068,802,566,583,828,1265,1183,767,592,997,588,629,1256,1187,753,705,851,1188,1264,955,1077,686,1192,959,1222,633,910,16130,1240,1023,1267,16132,960,684,760,908,784,1164,680,1113,1185,863,1184,16319,1277,864,1191,1219,1013,1072,1002,1038,1204,996,868,1205,944,909,1209,1105,685,1050,679,1051,688,699,1203,1084,731,1260,865,1106,1165,700,1057,16111,901,1200,1085,919,791,822,16306,616,1097,714,615,986,617,916,830,817,757,873,1230,715,623,564,1016,836,1146,581,1001,906,1166,898,794,897,1247,1046) ORDER BY FIELD(iCityID, 689,1047,963,962,649,889,1024,1140,638,815,973,995,1266,570,814,1186,1061,961,786,1173,1258,1254,683,653,1074,885,852,965,1003,782,720,1060,707,1233,610,1004,1253,964,634,738,1019,1068,802,566,583,828,1265,1183,767,592,997,588,629,1256,1187,753,705,851,1188,1264,955,1077,686,1192,959,1222,633,910,16130,1240,1023,1267,16132,960,684,760,908,784,1164,680,1113,1185,863,1184,16319,1277,864,1191,1219,1013,1072,1002,1038,1204,996,868,1205,944,909,1209,1105,685,1050,679,1051,688,699,1203,1084,731,1260,865,1106,1165,700,1057,16111,901,1200,1085,919,791,822,16306,616,1097,714,615,986,617,916,830,817,757,873,1230,715,623,564,1016,836,1146,581,1001,906,1166,898,794,897,1247,1046) ASC, p.tmPosted DESC LIMIT 24 Retail Stores for Sale by Agent in Country Club
logo

Country Club

Commercial for Sale

POST AD
Country Club
Real Estate
Commercial for Sale

Retail Stores for Sale in Country Club

Property typeRetail Stores
Posted byAgent
Built area
Search
Price
Search
Features
No results found!

Looking for something? Get notified when it's posted. Setup an Email Alert now!

Similar searches:

See if any of the following ads are interesting to you . . .

Post Free Classified Terms of Use Privacy Policy RSS Feeds Submit Feed Email Alerts Mobile App Contact us Sitemap
Free Classifieds United States, ©Classi4U.com 2018-2024
By Using this website, you agree to Terms of Use & Privacy Policy. Got it