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=104 AND p.iAdType='1' AND p.iUserType='1' AND iCityID IN (68665,69303,67861,68382,70377,67231,67212,69152,69323,68569,70136,67271,68964,68990,70323,67699,68233,70016,67442,68195,68384,70213) ORDER BY FIELD(iCityID, 68665,69303,67861,68382,70377,67231,67212,69152,69323,68569,70136,67271,68964,68990,70323,67699,68233,70016,67442,68195,68384,70213) ASC, p.tmPosted DESC LIMIT 24 Boats & Ships for Sale by Owner in Khem Karan

Boats & Ships for Sale in Khem Karan

Ad typeFor Sale

Posted byOwner

Price

No results found!

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

Similar searches:

Boats/Ships Vehicles Wanted

Boats-Ships by Dealer

Boats-Ships by Owner

Boats-Ships - For Rent/Lease

auto for sale sites

used car websites for sale

automobile sale websites

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

By Using this website, you agree to Terms of Use & Privacy Policy. Got it