UAE

Post an Ad

2017-08-22 11:14:46

-----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='Fujairah' 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

2 ads for Camera / Digicams in Fujairah

F/s....Nikon D610 24MP Digital SLR Came

 F/s....Nikon D610 24MP Digital SLR Camera 1 Images

AED 1300.00

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

  • Posted on 22nd September 2014
  • Age Brand New
  • Usage Same as new (unused)
  • Condition Perfect inside and out
  • Brand Nikon
  • Located Fujairah

F/s....Nikon D610 24MP Digital SLR Camera

images 1

Price : AED 1,300

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

Posted on : 22nd September 2014

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

Located : Fujairah >> Abu Dhabi Co operative


Canon EOS 5D Mark II 21MP DSLR Camera

images 2

Price : AED 4,407

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

Posted on : 19th November 2012

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

Located : Fujairah >> Fujairah Hospital Road


1