UAE

Post an Ad

2017-04-29 10:24:22

Array ( [sub_category_2] => 9 ) -----SELECT a1.ad_id, `ad_title`, `ad_price`, `ad_main_photo`, `category_id`, `ad_date`, `main_photo_status`, `ad_photo_1`, `photo_1_status`, `ad_photo_2`, `photo_2_status`, `user_id`, `city`, `land_mark`, `ad_photo_3`, `photo_3_status`, `ad_photo_4`, `photo_4_status`, `ad_photo_5`, `photo_5_status`, `ad_photo_6`, `photo_6_status`, `ad_photo_7`, `photo_7_status`, `ad_photo_8`, `photo_8_status`, `ad_photo_9`, `photo_9_status`,`bedroom`,`bathroom`,`area`,`seller_type` FROM `tbl_ad` a1, tbl_ad_field a2 WHERE a1.city='Ras Al Khaimah' AND a1.ad_featured=0 AND a1.ad_status=1 AND a1.category_id in (9,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973) AND a1.ad_id = a2.ad_id group by a1.ad_id ORDER BY a1.ad_id DESC limit 0, 20

7 ads for Camera / Digicams in Ras Al Khaimah

Canon DLSR E500D for SALE ASAP @aed1,500

Canon DLSR E500D for SALE ASAP @aed1,500 ONLY!!! 3 Images

AED 1500.00

Classifieds >> Camera / Digicams >> Digital Cameras >> SLR/Professional

  • Posted on 7th July 2014
  • Age 6-12 months
  • Usage Used for a few times only
  • Condition Perfect inside and out
  • Brand Canon
  • Located Ras al Khaimah

Canon DLSR E500D for SALE ASAP @aed1,500 ONLY!!!

images 3

Price : AED 1,500

  • Age:6-12 months
  • Usage:Used for a few times only
  • Condition:Flawless
  • Brand:Canon

Posted on : 7th July 2014

Ad Category : Classifieds >> Camera / Digicams >> Digital Cameras >> SLR/Professional

Located : Ras al Khaimah >> Al Nakheel


canon 7d for sale

images 1

Price : AED 2,203

  • Age:Brand New
  • Usage:Unused
  • Condition:Flawless
  • Brand:Canon

Posted on : 22nd March 2014

Ad Category : Classifieds >> Camera / Digicams >> Digital Cameras >> SLR/Professional

Located : Ras al Khaimah >> Airport Road


Nikon D700 with AF-S 24-120mm f/4G ED-IF VR II Camera

images 3

Price : AED 2,500

  • Age:Brand New
  • Usage:Unused
  • Condition:Flawless
  • Brand:Nikon

Posted on : 11th July 2013

Ad Category : Classifieds >> Camera / Digicams >> Digital Cameras >> SLR/Professional

Located : Ras al Khaimah >> Al Araibi


Nikon D7000 16MP Digital SLR Camera

images 3

Price : AED 1,836

  • Age:Brand New
  • Usage:Unused
  • Condition:Flawless
  • Brand:Nikon

Posted on : 22nd June 2013

Ad Category : Classifieds >> Camera / Digicams >> Digital Cameras >> SLR/Professional

Located : Ras al Khaimah >> Commercial Centre


Casio Exilim EX-ZS5 14MP Digital Camera

images 1

Price : AED 1,836

  • Age:Brand New
  • Usage:Unused
  • Condition:Flawless
  • Brand:Casio

Posted on : 15th June 2013

Ad Category : Classifieds >> Camera / Digicams >> Digital Cameras >> SLR/Professional

Located : Ras al Khaimah >> Commercial Centre


We deal in all kind of canon, nikon cameras, and lens, they are origin

images 2

Price : AED 900

  • Age:Brand New
  • Usage:Unused
  • Condition:Flawless
  • Brand:Canon

Posted on : 7th October 2012

Ad Category : Classifieds >> Camera / Digicams >> Digital Cameras

Located : Ras al Khaimah >> Sham


canon 60d and 7d for sale brand new

canon 60d and 7d for sale brand new images 0

Price : AED 1,400

  • Age:Brand New
  • Usage:Unused
  • Condition:Flawless
  • Brand:Canon

Posted on : 7th October 2012

Ad Category : Classifieds >> Camera / Digicams >> Digital Cameras >> SLR/Professional

Located : Ras al Khaimah >> Airport Road


1   
60