SELECT SQL_CALC_FOUND_ROWS wp_2_posts.* FROM wp_2_posts INNER JOIN wp_2_postmeta ON ( wp_2_posts.ID = wp_2_postmeta.post_id ) INNER JOIN wp_2_postmeta AS mt1 ON ( wp_2_posts.ID = mt1.post_id ) INNER JOIN wp_2_postmeta AS mt2 ON ( wp_2_posts.ID = mt2.post_id ) WHERE 1=1 AND wp_2_posts.ID IN (415,456,481,570,580,602,735,744,778,818,848,869,892,909,931,952,982,1012,1039,1074,1161,1165,1199,1247,1272,1294,1316,1332,1345,1358,1374,1386,1400,1412,1425,1440,1452,1465,1481,1496,1525,1545,1564,1587,1608,1630,1656,1672,1686,1700,1842,1860,1883,1902,1921,1948,1964,1977,1990,2003,2017,2035,2051,2062,2071,2085,2098,2113,2129,2255,2279,2336,2365,2382,2404,2432,2478,2494,2549,2561,2576,2588,2600,2535,2627,2647,2667,2690,2711,2735,2736,2799,2826,2872,2892,2910,2934,2957) AND ( wp_2_postmeta.meta_key = '_price_sold_rented' AND ( ( mt1.meta_key = '_price_status' AND mt1.meta_value = 'Sales' ) AND ( mt2.meta_key = '_price' AND CAST(mt2.meta_value AS SIGNED) <= '750000000' ) ) ) AND ((wp_2_posts.post_type = 'property' AND (wp_2_posts.post_status = 'publish'))) GROUP BY wp_2_posts.ID ORDER BY wp_2_postmeta.meta_value DESC, mt2.meta_value+0 DESC LIMIT 30, 6

Serviced Mansions, Ultra-Prestigious Living Designed to Suit Your Lifestyle

5 6 Convert Currency AED 1660 PER SQ FT AED 15000000

BUA From 4,800 - 15,064Sq Ft, 2, 3, 4 & 5 Bedroom + Cinema Room Serviced Mansions, Ultra-Prestigious Living Pick the One Suited Your Lifestyle For detailed virtual tours of properties in Dubai, ......

4 BR Contemporary Styled Luxury Villa In An Exclusive Community

4 5 Convert Currency AED 1020 PER SQ FT AED 13500000

BUA 13,224 Sq Ft, 4 Bedrooms Contemporary Styled Luxury Villa In An Exclusive Community For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Re ......

Search Results: 89 Properties

Map
Order by Date or Price
Order DESC or ASC
Lavishly Furnished and Serviced Apartments with Burj Khalifa, Dubai Opera and Dubai Fountain at Door Step

Lavishly Furnished and Serviced Apartments with Burj Khalifa, Dubai Opera and Dubai Fountain at Door Step

[ Convert Currency ] AED 3057PER SQ FTAED 4,704,8883 3 1539 sq ft
Ain Dubai, Bluewaters – THE BEACH life – full sea view

Ain Dubai, Bluewaters – THE BEACH life – full sea view

[ Convert Currency ] AED 2198PER SQ FTAED 4,472,0003 4 2034 sq ft
Palm Jumeirah, Luxurious 2 BR’s Apartment with Palm View and a Maids Room on Attractive Payment Plan

Palm Jumeirah, Luxurious 2 BR’s Apartment with Palm View and a Maids Room on Attractive Payment Plan

[ Convert Currency ] AED 3384PER SQ FTAED 4,250,0002 3
Palm Jumeirah, Luxurious 2 BR’s Apartment with Palm View and a Maids Room on Attractive Payment Plan

Palm Jumeirah, Luxurious 2 BR’s Apartment with Palm View and a Maids Room on Attractive Payment Plan

[ Convert Currency ] AED 3296PER SQ FTAED 4,136,5002 3
Tonino Lamborghini Residences Dubai, Retreat To An Oasis from the Outside

Tonino Lamborghini Residences Dubai, Retreat To An Oasis from the Outside

[ Convert Currency ] AED 1600PER SQ FTAED 4,033,3494 5 2422.31 sq ft
Palm Jumeirah, Luxurious 2 BR’s Apartment with Sea View and a Maids Room on Attractive Payment Plan

Palm Jumeirah, Luxurious 2 BR’s Apartment with Sea View and a Maids Room on Attractive Payment Plan

[ Convert Currency ] AED 3201PER SQ FTAED 4,018,0002 3

Select Currency in which you want to convert