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 = 'Residential 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 198, 6
BUA 3,498Sq Ft, Umm Suqeim, Gorgeous 4 Bedrooms Upgraded Villa
For detailed virtual tours of properties in Dubai, visit
www.capellaproperties.ae
capella properties, Redefining Real Estates in D ......
BUA 1,788Sq Ft, Palm Jumeirah, Large 2 BR Apt With Marina Skyline and Sea View
For detailed virtual tours of properties in Dubai, visit
www.capellaproperties.ae
capella properties, Redefining Rea ......
Search Results: 388 Properties
Map
BUA 1,570Sq Ft, JLT, 2 BR Apt With Panoramic Lake View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE JLT is surrounded by four calming artificial lakes, landscaped gardens and meandering waterways, spread over two hundred hectares of land. Conveniently located along main Sheikh Zayed
……
BUA 977Sq Ft, IMPZ, 2 BR Apt With Maids Room For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE The International Media Production Zone (IMPZ) is a free zone and freehold area that caters to media production companies. Spreading over an area of 43,000,000 square feet,
……
BUA 1,788Sq Ft, Palm Jumeirah, Large 2 BR Apt With Marina Skyline and Sea View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE Within the Palm Jumeirah you will find grocery shops, salons, spas, restaurants and bars. Together with children’s play areas, cafes and even
……
BUA 753Sq Ft, Dubai Marina, 1 BR with Balcony Near Metro For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE Dubai Marina is an artificial canal city which includes vast amount of residential buildings, built along the shore-line of Persian Gulf. It is situated near Jebal
……
BUA 1,280Sq Ft, Dubai Marina, Fully Furnished 1 BR Apartment with Palm View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE Each unit in this building has a dramatically different view. This development is situated in the premium acreage of Dubai, surrounded by five-star resorts,
……
BUA 3,300Sq ft, Dubai Marina, Dubai Marina, 4 Bedrooms Apartment with Stunning Palm and Sea Views For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE Dubai Marina is an artificial canal city which includes vast amount of residential buildings, built along the shore-line of Persian Gulf.
……
