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, wp_posts.post_date DESC
LIMIT 354, 6
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 ......
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
BUA 1,445Sq Ft , Partially Fitted Office that has a private washroom, fitted kitchenette and complete flooring already in place. The option to either paint the ceiling or install false ceiling has been left open, to modify the office space as per the specific requirement of the customers For detailed virtual tours of properties in
……
BUA 1,147Sq Ft , Partially Fitted Office that has a private washroom, fitted kitchenette and complete flooring already in place. The option to either paint the ceiling or install false ceiling has been left open, to modify the office space as per the specific requirement of the customers For detailed virtual tours of properties in
……
BUA 943Sq Ft, Partially Fitted Office that has a private washroom, fitted kitchenette and complete flooring already in place. The option to either paint the ceiling or install false ceiling has been left open, to modify the office space as per the specific requirement of the customers For detailed virtual tours of properties in Dubai,
……
BUA 18,693Sq Ft, Partially Fitted Office that has a private washroom, fitted kitchenette and complete flooring already in place. The option to either paint the ceiling or install false ceiling has been left open, to modify the office space as per the specific requirement of the customers For detailed virtual tours of properties in Dubai,
……
BUA 2,253Sq Ft, Partially Fitted Office that has a private washroom, fitted kitchenette and complete flooring already in place. The option to either paint the ceiling or install false ceiling has been left open, to modify the office space as per the specific requirement of the customers For detailed virtual tours of properties in Dubai,
……
BUA 1,193Sq Ft, Partially Fitted Office that has a private washroom, fitted kitchenette and complete flooring already in place. The option to either paint the ceiling or install false ceiling has been left open, to modify the office space as per the specific requirement of the customers For detailed virtual tours of properties in Dubai,
……
