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 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 144, 6
BUA 3,414 SqFt, Jumeirah Golf Estate, 4 BR Premium Townhouse delivered in 2019
For detailed virtual tours of properties in Dubai, visit
www.capellaproperties.ae
capella properties, Redefining Re ......
BUA 3,331 Sq Ft, Dubai Sports City, 5 BR Townhouse with Premium Finishing at Affordable Price
For detailed virtual tours of properties in Dubai, visit
www.capellaproperties.ae
capella properties, ......
Search Results: 343 Properties
Map
2,223Sq Ft – Garden View, with direct access to the beach. Vacant on Transfer For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae This three bedroom apartment have Garden &Partial Sea views and a built-up area of 2,223Sq Ft. The master bedroom is an en-suite with walk-in closet, two bedroomshave a sharing washroom, living
……
To view the Virtual Tour of this property, click BUA 3,923Sq Ft, This spacious detached villa has four bedrooms, plus Maids room with attached bathroom and two covered car parking’s in Al Waha. It is vacant and ready to move in. This fabulous villa has an impressive floor plan of four bedrooms that consists of
……
BUA 2249 Sq Ft – Canal Residence West, three bedrooms + maids room with canal/stadium view. Vacant and ready to move in. For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae Dubai Sports Citylocated in Dubailand and is five minutes’ drive to Sheikh Zayed Road, twenty minutes’ drive to the heart of city and
……
Downtown Apt with 2 En-Suite Bedrooms, Terrace, Lounge & Dining/Study Room on Higher Floor on a Higher Floor in 29 Boulevard Towers with 360 degree View of Dubai Mall Fountain’s, Old Town & Business Bay Lake Driving down the heart of Dubai – Down-town!! The Boulevard, land-mark buildings with state of the art architecture located
……
BUA 3,386 Sq ft, Dubai land, 5 Bedrooms Classic Mediterranean Style Townhouse with Maids Room Payment Plan: Immediate 10% 15-Jul-17 5% 15-Jan-18 5% 15-Jul-18 5% 15-Jan-19 5% 15-Jul-19 5% 15-Jan-20 5% Handover (Q3 2020) 60% For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE Dubailand was
……
The property consists of three bedrooms and two bathrooms upstairs, including a master en-suite and access to a balcony with a magnificent scenic view. Study and laundry are downstairs, with a powder room for the guests and the beautiful lounge looks into the front garden, while the kitchen is fully equipped. For detailed virtual tours
……