UAE

Post an Ad

2017-02-23 07:14:07

Array ( [sub_category_2] => 62 ) -----(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 (62) 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 (62) 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 (62) AND a1.ad_status=1 AND a1.regular_counter = 0 AND a1.promote_counter = 0 ORDER BY a1.ad_id DESC limit 0,15 )

77 ads for Villa for Sale in Ras Al Khaimah

Cove Chalet prime location on the hill

Cove Chalet prime location on the hill 10 Images

AED 950000.00

Property For Sale >> Villa for Sale

  • Posted on 22nd January 2017
  • Bedrooms 1
  • Bathrooms 1
  • Area 1200.00
  • Located Ras Al Khaimah

3 beds villa for sale in Ras Al Khaimah

images 10

Price : AED 1,650,000

  • Bedroom : 3
  • Bathroom : 3
  • Area : 2500.00
  • Seller Type :Agent

Posted on : 25th January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Ras Al Khaimah Waterfront


Cove Chalet prime location on the hill

images 10

Price : AED 950,000

  • Bedroom : 1
  • Bathroom : 1
  • Area : 1200.00
  • Seller Type :Agent

Posted on : 22nd January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Sheikh Mohammed Bin Zayed Road


Distinctive Design - Spectacular Views - Cove 3 Bedroom Villa

images 10

Price : AED 4,000,000

  • Bedroom : 3
  • Bathroom : 3
  • Area : 3825.00
  • Seller Type :Agent

Posted on : 18th January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Cove


Excellent Views - 3 Bedroom Villa - Al Hamra

images 10

Price : AED 1,500,000

  • Bedroom : 3
  • Bathroom : 3
  • Area : 2173.00
  • Seller Type :Agent

Posted on : 18th January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Al Hamra Village


Picturesque Surroundings in this Duplex with Swimming Pool

images 10

Price : AED 2,360,000

  • Bedroom : 4
  • Bathroom : 5
  • Area : 4843.00
  • Seller Type :Agent

Posted on : 11th January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Al Hamra Village


Beach Front Villa - Al Hamra Residences

images 10

Price : AED 10,000,000

  • Bedroom : 5
  • Bathroom : 5
  • Area : 6000.00
  • Seller Type :Agent

Posted on : 2nd January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Al Hamra Village


One of a Kind Exclusive Cove Villa - The Cove

images 10

Price : AED 2,200,000

  • Bedroom : 3
  • Bathroom : 3
  • Area : 2800.00
  • Seller Type :Agent

Posted on : 2nd January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Sheikh Mohammed Bin Zayed Road


Gorgeous villa with a swimming pool and rooftop terrace

images 10

Price : AED 3,933,000

  • Bedroom : 5
  • Bathroom : 5
  • Area : 4983.00
  • Seller Type :Agent

Posted on : 2nd January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Al Hamra Village


A Place to Call Home - Al Hamra Village

images 10

Price : AED 1,300,000

  • Bedroom : 3
  • Bathroom : 3
  • Area : 2720.00
  • Seller Type :Agent

Posted on : 2nd January 2017

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Al Hamra Village


A Place to Call Home - Duplex - Al Hamra Village

images 10

Price : AED 2,600,000

  • Bedroom : 4
  • Bathroom : 4
  • Area : 3821.19
  • Seller Type :Agent

Posted on : 29th December 2016

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Al Hamra Village


Unbelievable Price - Cove Rotana - 5 Star- Exclusive Beach- 5 Star fac

images 10

Price : AED 1,330,000

  • Bedroom : 2
  • Bathroom : 2
  • Area : 2894.00
  • Seller Type :Agent

Posted on : 20th December 2016

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Sheikh Mohammed Bin Zayed Road


Mina Al Arab - Malibu - Four Bedroom Bright and Extra Large Villa

images 10

Price : AED 3,123,060

  • Bedroom : 4
  • Bathroom : 5
  • Area : 4132.00
  • Seller Type :Agent

Posted on : 14th December 2016

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Mina Al Arab


Price Reduced - Affordable Luxury - Mina Al Arab - Malibu

images 10

Price : AED 2,000,000

  • Bedroom : 3
  • Bathroom : 3
  • Area : 3250.00
  • Seller Type :Agent

Posted on : 13th December 2016

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Mina Al Arab


Mina Al Arab - Granada - Spacious Three Bedroom Villa with View of Gre

images 9

Price : AED 2,161,000

  • Bedroom : 3
  • Bathroom : 4
  • Area : 3250.00
  • Seller Type :Agent

Posted on : 13th December 2016

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Mina Al Arab


Unique Investment - The Cove

images 10

Price : AED 2,000,000

  • Bedroom : 2
  • Bathroom : 2
  • Area : 2431.00
  • Seller Type :Agent

Posted on : 12th December 2016

Ad Category : Property For Sale >> Villa for Sale

Located : Ras Al Khaimah >> Sheikh Mohammed Bin Zayed Road


1   2   3   4   Next >>   Last >>
60