UAE

Post an Ad

2017-03-27 01:40:50

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

30 ads for Office for Sale in Ras Al Khaimah

Fantastic Location - Julfar Tower Office

Fantastic Location - Julfar Tower Office - Nakheel 10 Images

AED 600000.00

Property For Sale >> Office for Sale

  • Posted on 18th January 2017
  • Area 750.00
  • Seller Type Agent
  • Located Ras Al Khaimah

Fantastic Location - Julfar Tower Office - Nakheel

images 10

Price : AED 600,000

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 750.00
  • Seller Type :Agent

Posted on : 18th January 2017

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Strategic location Spectacular Panoramic Views

images 10

Price : AED 630,000

  • Bedroom : N/A
  • Bathroom : 4
  • Area : 975.29
  • Seller Type :Agent

Posted on : 5th January 2017

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Strategic Location - Julfar Towers

images 10

Price : AED 550,000

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

Posted on : 12th December 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Premier Office Location in Ras Al Khaimah - Julfar Tower

images 10

Price : AED 550,000

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

Posted on : 24th November 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Prime Location - Commerical Unit - Al Hamra Village Golf Apartment

images 10

Price : AED 1,000,000

  • Bedroom : N/A
  • Bathroom : 2
  • Area : 1123.75
  • Seller Type :Agent

Posted on : 28th September 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Al Hamra Village


Julfar Tower - Spectacular Panoramic Views

images 10

Price : AED 412,750

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 635.00
  • Seller Type :Agent

Posted on : 14th August 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Julfar Tower - Premier Location

images 10

Price : AED 633,750

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 975.00
  • Seller Type :Agent

Posted on : 14th August 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Prized Location - Julfar Towers

images 10

Price : AED 514,150

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 791.00
  • Seller Type :Agent

Posted on : 14th August 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Fitted Office - Sea View - Julfar Tower

images 10

Price : AED 412,750

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 635.00
  • Seller Type :Agent

Posted on : 14th August 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Open to Offers - Julfar Tower

images 10

Price : AED 800,000

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 736.68
  • Seller Type :Agent

Posted on : 28th July 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Superior Location - Julfar Tower

images 10

Price : AED 310,700

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 478.00
  • Seller Type :Agent

Posted on : 20th June 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Premier Location at the Heart of RAK - Julfar Tower

images 10

Price : AED 479,050

  • Bedroom : N/A
  • Bathroom : 1
  • Area : 737.00
  • Seller Type :Agent

Posted on : 20th June 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Office in Julfar Tower 3rd floor for Sale

images 7

Price : AED 525,000

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

Posted on : 22nd February 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar Office


Fitted Office Space, Sea View in Julfar Tower

images 3

Price : AED 632,000

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

Posted on : 22nd February 2016

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


Strategic Location, Invest in the Tallest Building in Ras Al Khaimah -

images 10

Price : AED 1,095,000

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

Posted on : 5th November 2015

Ad Category : Property For Sale >> Office for Sale

Located : Ras Al Khaimah >> Julfar


1   2   Next >>   Last >>
60