UAE

Post an Ad

2017-08-18 08:53:54

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

Residential Building - Complete with Ret

Residential Building - Complete with Retail 7 Images

AED 45000000.00

Property For Sale >> Multiple Units for Sale

  • Posted on 17th January 2016
  • Area 45360.00
  • Seller Type Agent
  • Located Ras Al Khaimah

10% income from a brand new building in RAK

images 10

Price : AED 12,000,000

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

Posted on : 19th July 2017

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

Located : Ras Al Khaimah >> Al Seer


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