UAE

Post an Ad

2017-04-29 10:24:35

Array ( [sub_category_2] => 67 ) -----(SELECT a1.ad_id, `ad_title`,`ad_featured`, `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` ,`promote_counter`,`regular_counter`, `ad_order`,`bedroom`,`bathroom`,`area`,`seller_type` FROM `tbl_ad` a1 WHERE a1.city='Ras Al Khaimah' AND a1.category_id in (67) AND a1.ad_featured=1 AND a1.ad_status=1 AND a1.promote_counter != 0 ORDER BY a1.promote_counter DESC limit 0,0 ) UNION(SELECT a1.ad_id, `ad_title`,`ad_featured`, `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` ,`promote_counter`,`regular_counter`, `ad_order`,`bedroom`,`bathroom`,`area`,`seller_type` FROM `tbl_ad` a1 WHERE a1.city='Ras Al Khaimah' AND a1.category_id in (67) AND a1.ad_featured=0 AND a1.ad_status=1 AND a1.promote_counter = 0 AND a1.regular_counter != 0 ORDER BY a1.regular_counter DESC limit 0,0 ) UNION(SELECT a1.ad_id, `ad_title`,`ad_featured`, `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` ,`promote_counter`,`regular_counter`, `ad_order`,`bedroom`,`bathroom`,`area`,`seller_type` FROM `tbl_ad` a1 WHERE a1.city='Ras Al Khaimah' AND a1.category_id in (67) AND a1.ad_status=1 AND a1.regular_counter = 0 AND a1.promote_counter = 0 ORDER BY a1.ad_id DESC limit 0,15 )

2 ads for Multiple Units for Sale in Ras Al Khaimah

Perfect Chance to Own Beachfront Duplex

Perfect Chance to Own Beachfront Duplex Apt in RAK 10 Images

AED 1504261.00

Property For Sale >> Multiple Units for Sale

  • Posted on 8th August 2016
  • Area 1429.35
  • Seller Type Agent
  • Located Ras Al Khaimah

Perfect Chance to Own Beachfront Duplex Apt in RAK

images 10

Price : AED 1,504,261

  • Bedroom : N/A
  • Bathroom : N/A
  • Area : 1429.35
  • Seller Type :Agent

Posted on : 8th August 2016

Ad Category : Property For Sale >> Multiple Units for Sale

Located : Ras Al Khaimah >> Al Marjan Island


Residential Building - Complete with Retail

images 7

Price : AED 45,000,000

  • Bedroom : N/A
  • Bathroom : N/A
  • Area : 45360.00
  • Seller Type :Agent

Posted on : 17th January 2016

Ad Category : Property For Sale >> Multiple Units for Sale

Located : Ras Al Khaimah >> Mina Al Arab


1   
60