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 Sales' ) 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 120, 6

Main Sheikh Zayed Road, Freehold, Shell and Core Office

Convert Currency AED 1450 PER SQ FT AED 4200650

2,897 Sq Ft, The ultimate office address in Dubai “Main Sheikh Zayed Road”, located between Fairmont and Shangri la Hotels on Main Sheikh Zayed Road Few units have Sheikh Zayed Road Views, and ar ......

Main Sheikh Zayed Road, Freehold, Shell and Core Office

Convert Currency AED 1300 PER SQ FT AED 1368900

1,053 SqFt, The ultimate office address in Dubai “Main Sheikh Zayed Road”, located between Fairmont and Shangri la Hotels on Main Sheikh Zayed Road Few units have Sheikh Zayed Road Views and are ......

Search Results: 166 Properties

Map
Order by Date or Price
Order DESC or ASC
Fully Fitted Open Plan Office in Tiffany Towers

Fully Fitted Open Plan Office in Tiffany Towers

[ Convert Currency ] AED 1225PER SQ FTProperty is sold
JLT, Fully Fitted Office with Great Views Available for Sale

JLT, Fully Fitted Office with Great Views Available for Sale

[ Convert Currency ] AED 1225PER SQ FTProperty is sold1
Business Bay, Empire Heights, Shell and Core Office on a Higher Floor with Business Bay Lake View

Business Bay, Empire Heights, Shell and Core Office on a Higher Floor with Business Bay Lake View

[ Convert Currency ] AED 1055PER SQ FTProperty is sold1 1340 sq ft
Business Bay, Empire Heights, Shell and Core Office, on a Higher Floor with Business Bay Lake View

Business Bay, Empire Heights, Shell and Core Office, on a Higher Floor with Business Bay Lake View

[ Convert Currency ] AED 1055PER SQ FTProperty is sold1 1340 sq ft
Mazaya Business Avenue, JLT, Fitted Office on Higher Floor

Mazaya Business Avenue, JLT, Fitted Office on Higher Floor

[ Convert Currency ] AED 785PER SQ FTProperty is sold1787 sq ft
JLT, Fully Fitted Office, Already Rented for 103K at Lower Level in JBC 4 with Partial Sea & Community View

JLT, Fully Fitted Office, Already Rented for 103K at Lower Level in JBC 4 with Partial Sea & Community View

[ Convert Currency ] AED 1313PER SQ FTProperty is sold1

Select Currency in which you want to convert