SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) WHERE 1=1 AND wp_posts.ID IN (1009,1461,1778,2062,2045,2219,2205,1565,1551,1496,1924,1937,1971,1999,2190,2174,2146,2012,2114,2034,1984,1955,1583,1603,1743,1636,1652,1685,1788,1668,1761,1819,1804,1716,2270,2294,2323,2341,2361,2450,2479,2497,2518,2626,2643,2660,2719,2681,2751,2766,2780,2796,2810,2889,2904,2920,2933,2949,2966,2979,3004,3023,3063,3092,2532,3227,3244,3273,3286,3418,3471,3486,3501,3521,3535,3548,3561,3577,3590,3599,3608,3626,3641,3648,3668,3682,3711,3722,3735,3748,3760,3774,3790,3814,3827,3841,3855,3868,3881,3895,3907,3913,3929,3939,3952,3964,3977,3990,4686,4700,4712,4724,4736,4754,4767,4779,4792,4804,4816,4856,4869,4883,4895,4908,4920,4932,4935,4945,4959,4972,4979,4992,5004,5017,5035,5042,5069,5084,5096,5111,5126,5140,5153,5167,5181,5206,5218,5243,5258,5273,5288,5304,5318,5378,5393,5409,5425,5435,5449,5461,5480,5491,5598,5621,5635,5652,5670,5687,5701,5715,5728,5740,5775,5793,5827,5844,5864,5883,5900,5914,5926,5938,5950,5952,5964,6008,6022,6037,6049,6076,6158,6172,6184,6198,6264,6278,6293,6305,6318,6332,6344,6357,6369,6387,6431,6446,6487,6501,6515,6530,6554,6568,6580,6594,6629,6642,6660,6708,6794,6813,6835,6848,6878,6892,6905,6918,6931,6944,6956,6978,6991,7006,7025,7043,7053,7065,7080,7094,7107,7120,7132,7144,7202,7218,7252,7268,7286,7300,7318,7331,7350,7363,7375,7387,7399,7412,7425,7437,7451,7465,7478,7490,7549,7561,7636,7652,7667,7681,7693,7705,7718,7736,7751,7765,7777,7789,7801,7813,7825,7851,7863,7876,7889,7902,7914,7927,7940,7993,8007,8024,8040,8062,8076,8091,8104,8118,8131,8145,8158,8170,8184,8197,8209,8221,8248,8268,8285,8299,8314,8390,8431,8448,8466,8489,8505,8522,8540,8556,8725,8744,8765,8784,8797,8927,9065,9102,9117,9199,9219,9235,9248,9261,9276,9288,9300,9314,9335,9350,9395,9414,9441,9454,9467,9500,9539,9610,9628,9642,9700,9709,9724,9737,9750,9762,9773,9787,9798,9811,9824,9838,9849,9862,9876,9889,9902,9916,9986,10000,10040,10057,10103,10115,10162,10201,10214,10227,10250,10266,10279,10288,10307,10319,10335,10348,10362,10382,10394,10406,10418,10451,10474,10532,10548,10562,10575,10588,10600,10613,10624,10646,10663,10674,10685,10696,10707,10735,10749,10761,10777,10788,10799,11102,11115,11138,11340,11357,11374,11387,11401,11415,11431,11454,11483,11496,11508,11520,11533,11546,11561,11572,11585,11596,11611,11622,11633,11652,11663,11736,11749,11762,11815,11828,11841,11855,11868,11880,11893,11906,11917,11929,11941,11955,11968,11981,11995,12010,12026,12039,12053,12065,12077,12089,12109,12122,12138,12179,12209,12222,12269,12295,12308,12322,12342,12365,12437,12450,12516,12532,12546,12578,12592,12607,12623,12639,12667,12693,12719,12733,12746,12779,12891,12904,12918,12934,13032,13046,13058,13073,13085,13098,13111,13140,13189,13201,13212,13222,13239,13275,13289,13305,13318,13357,13368,13384,13398,13413,13427,13510,13534,13545,13614,13646,13669,13635,13682,13695,13709,13724,13739,13756,13767,13821,13832,13842,13861,13877,13895,13922,13937,14009,14031,14045,14061,14074,14086,14101,14115,14128,14141,14153,14177,14217,14190,14253,14267,14281,14304,14316,14329,14341,14355,14369,14389,14401,14417,14434,14450,14463,14476,14490,14544,14558,14615,14628,14641,14654,14686,14702,14715,14723,14737,14750,14757,14770,14784,14805,14815,14841,14867,14895,14950,14991,15001,15011,15021,15031,15041,15051,15125,15166,15183,15198,15211,15225,15238,15254,15269,15285,15302,15338,15359,15372,15409,15478,15633,15648,15669,15685,15718,15733,15758,15771,15782,15793,15814,15832,15851,15866,15891,15911,15926,15947,15962,15973,15984,16043,16054,16064,16078,16091,16104,16117,16131,16148,16190,16203,16219,16232,16251,16267,16280,16293,16308,16324,16336,16366,16348,16378,16426,16443,16591,16606,16622,16635,16650,16666,16682,16698,16714,16740,16756,16771,16785,16798,16810,16824,16848,16864,16875,16888,16901,16914,16931,16944,16957,16975,16990,17004,17019,17034,17049,17066,17082,17099,17117,17132,17144,17158,17174,17191,17204,17219,17234,17247,17259,17271,17288,17304,17320,17334,17347,17362,17377,17399,17416,17428,17441,17452,17465,17478,17499,17512,17537,17553,17565,17577,17590,17604,17619,17647,17663,17684,17700,17710,17723,17737,17750,17765,17779,17794,17813,17830,17848,17860,17888,17898,17910,17922,17934,17945,17963,17975,17988,18008,18021,18038,18050,18063,18078,18094,18107,18120,18132,18144,18157,18171,18184,18198,18210,18224,18236,18248,18260,18272,18284,18296,18308,18320,18332,18333,18373,18387,18400,18413,18426,18427,18440,18465,18478,18491,18504,18517,18530,18542,18553,18564,18575,18587,18599,18620,18632,18644,18658,18671,18683,18698,18713,18730,18729,18760,18776,18795,18811,18828,18841,18854,18866,18883,18900,18913,18926,18938,18963,18977,18989,19001,19002,19042,19056,19069,19084,19097,19109,19123,19136,19153,19165,19177,19191,19205,19219,19231,19243,19256,19268,19281,19296,19312,19327,19313,19352,19365,19379,19391,19404,19420,19434,19447,19460,19473,19506,19520,19534,19548,19561,19577,19590,19602,19615,19640,19655,19668,19683,19699,19712,19725,19737,19750,19763,19775,19787,19801,19810,19822,19836,19849,19861,19873,19885,19897,19909,19924,19936,19953,19966,19988,20001,20015,20073,20086,20098,20111,20123,20137,20150,20163,20178,20193,20208,20221,20230,20239,20266,20279,20295,20309,20323,20338,20351,20367,20380,20392,20404,20418,20451,20466,20478,20504,20517,20535,20554,20567,20579,20593,20608,20622,20637,20650,20662,20677,20689,20702,20717,20731,20747,20760,20773,20787,20800,20813,20828,20855,20871,20885,20911,20926,20938,20952,20967,20979,20992,21005,21019,21031,21045,21058,21081,21094,21108,21120,21132,21144,21156,21170,21189,21203,21218,21234,21251,21264,21278,21314,21339,21354,21367,21389,21406,21420,21442,21455,21468,21480,21492,21512,21523,21533,21544,21558,21559,21588,21603,21618,21619,21651,21666,21678,21705,21718,21732,21744,21756,21768,21769,21796,21809,21822,21834,21846,21865,21881,21896,21908,21921,21933,21951,21985,22003,22016,22029,22042,22054,22068,22083,22096,22108,22127,22153,22167,22183,22196,22208,22221,22233,22250,22263,22276,22288,22300,22312,22330,22346,22358,22371,22386,22398,22410,22422,22436,22450,22463,22477,22490,22503,22517,22529,22541,22554,22567,22581,22593,22605,22619,22634,22647,22661,22674,22687,22727,22741,22753,22765,22781,22794,22806,22819,22831,22840,22853,22864,22875,22907,22918,22929,22941,22953,22964,22978,22989,23003,23017,23031,23045,23057,23079,23091,23103,23115,23127,23139,23152,23165,23177,23190,23203,23216,23217,23251,23267,23292,23307,23321,23338,24566,24579,24591,24604,24621,24633,24646,24647,24678,24690,24703,24727,24742,24761,24777,24791,24804,24817,24831,24845,24873,24885,24916,24931,24957,24970,24984,25012,25024,25040,25055,25069,25082,25096,25108,25129,25143,25157,25169,25183,25195,25209,25225,25237,25251,25263,25275,25345,25362,25442,25468,25485,25512,25524,25548,25565,25599,25611,25623,25636,25651,25664,25677,25688,25689,25722,25744,25773,25800,25826,25851,25905,25922,25942,25955,25967,25979,25991,26012,26040,26068,26080,26094,26106,26156,26172,26184,26196,26238,26269,26282,26296,26313,26328,26344,26361,26373,26385,26397,26398,26439,26484,26496,26516,26531,26544,26557,26569,26582,26596,26658,26672,26688,26704,26783,26731,26743,26755,26770,26799,26861,26900,26817,26829,26847,26874,26881,26917,26960,26934,26948,26973,26985,26999,27026,27039,27130,27131,27229,27243,27257,27277,27297,27309,27325,27295,27442,27456,27359,27372,27415,27429,27478,27490,27506,27556,27591,27589,27629,27643,27690,27703,27744,27772) AND ( wp_postmeta.meta_key = '_price_sold_rented' AND ( ( mt1.meta_key = '_price_status' AND mt1.meta_value = 'Commercial Leasing' ) AND ( mt2.meta_key = '_price' AND CAST(mt2.meta_value AS SIGNED) <= '750000000' ) ) ) AND ((wp_posts.post_type = 'property' AND (wp_posts.post_status = 'publish'))) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, mt2.meta_value+0 DESC LIMIT 222, 6

Fully Fitted Office at AED 85psf, Facing Sheikh Zayed Road, Latifa Towers

Convert Currency AED 112720

BUA 1,409 Sq Ft, The ultimate office address in Dubai “Main Sheikh Zayed Road”, located between Fairmont and Shangri la Hotels on Main Sheikh Zayed Road Positioned between two metro stations, t ......

Fully Furnished and Serviced Office Space in a Business Center at Main Sheikh Zayed Road

Convert Currency AED 25000

Value Plus Management consultancy is a business center strategically located on main Sheikh Zayed road, situated near Crown Plaza Hotel between two metro stations it is easily accessible from both end ......

Search Results: 374 Properties

Map
Order by Date or Price
Order DESC or ASC
Mazaya Business Avenue, JLT, Fitted Office on Higher Floor

Mazaya Business Avenue, JLT, Fitted Office on Higher Floor

[ Convert Currency ] AED 80PER SQ FTProperty is rented1
Al Barsha 1, Fully Fitted Office with Free Chillers for 1 Year – Yes Business Centre

Al Barsha 1, Fully Fitted Office with Free Chillers for 1 Year – Yes Business Centre

[ Convert Currency ] AED 109PER SQ FTProperty is rented1
JLT – Fortune Tower, Fully Fitted & Furnished Office with Wooden Floor

JLT – Fortune Tower, Fully Fitted & Furnished Office with Wooden Floor

[ Convert Currency ] AED 133PER SQ FTProperty is rented1 1050 sq ft
Fully Fitted Office/Retail in Park Towers

Fully Fitted Office/Retail in Park Towers

[ Convert Currency ] AED 170PER SQ FTProperty is rented827.20 sq ft
Main Sheikh Zayed Road, Freehold, Shell and Core Office

Main Sheikh Zayed Road, Freehold, Shell and Core Office

[ Convert Currency ] AED 85PER SQ FTProperty is rented
JLT – Fitted Office at Higher Floor with Lake & Sh Zayed Rd View – JBC 4

JLT – Fitted Office at Higher Floor with Lake & Sh Zayed Rd View – JBC 4

[ Convert Currency ] AED 100PER SQ FTProperty is rented1

Select Currency in which you want to convert