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=400 AND p.iItemType='10' AND iCityID IN (14341,14236,14187,14195,14274,14186,14230,14340,14335,16428,16600,14318,14244,14258,14338,14222,14317,14255,14331,14241,14294,14231,14213,14199,16618,14280,14221,14253,14260,14220,14189,14267,14266,16617,14328,14323,14270,14283,14208,14242,14272,14263,14210,16619,14184,14282,14332,16559,14217,14205,14854,14286,14848,14313,14198,16481,16373,14325,16583,14852,14265,14212,14206,14883,14304,14861,14857,14876,14859,14292,14877,14330,14845,14207,14868,14880,14254,14879,14307,14884,14194,14306,14847,14871,14239,14862,14326,14850,14869,14882,14249,14269,14878,14874,14202,14302,14856,14343,14290,14855,14864,14268) ORDER BY FIELD(iCityID, 14341,14236,14187,14195,14274,14186,14230,14340,14335,16428,16600,14318,14244,14258,14338,14222,14317,14255,14331,14241,14294,14231,14213,14199,16618,14280,14221,14253,14260,14220,14189,14267,14266,16617,14328,14323,14270,14283,14208,14242,14272,14263,14210,16619,14184,14282,14332,16559,14217,14205,14854,14286,14848,14313,14198,16481,16373,14325,16583,14852,14265,14212,14206,14883,14304,14861,14857,14876,14859,14292,14877,14330,14845,14207,14868,14880,14254,14879,14307,14884,14194,14306,14847,14871,14239,14862,14326,14850,14869,14882,14249,14269,14878,14874,14202,14302,14856,14343,14290,14855,14864,14268) ASC, p.tmPosted DESC LIMIT 24 Music Stores in Wheat Ridge
logo

Wheat Ridge

Local Stores & Businesses

POST AD
Wheat Ridge
Services
Local Stores & Businesses

Music Stores in Wheat Ridge

TypeMusic Stores
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