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=102 AND p.iAdType='1' AND p.iItemType='7' AND s.iCondition='1' AND iCityID IN (69765,67402,68669,66983,67926,67484,68691,68939,67753,70314,68416,68719,68457,67806,67482,69193,70196,68585,69477,67821,69038,68670,67238,69662,66986,67720,69569,68247,69923,67691) ORDER BY FIELD(iCityID, 69765,67402,68669,66983,67926,67484,68691,68939,67753,70314,68416,68719,68457,67806,67482,69193,70196,68585,69477,67821,69038,68670,67238,69662,66986,67720,69569,68247,69923,67691) ASC, p.tmPosted DESC LIMIT 24 Used Trailers for Sale in Bhor
logo

Bhor

Commercial Vehicles

POST AD
Bhor
Automobiles
Commercial Vehicles

Used Trailers for Sale in Bhor

Vehicle typeTrailers
ConditionUsed
Ad typeFor Sale
Posted by
Price
Search
Make
Year
Search
Fuel
Mileage
Search
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 India, ©Classi4U.com 2018-2024
By Using this website, you agree to Terms of Use & Privacy Policy. Got it