SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID 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) 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 24, 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: 83 Properties

Map
Order by Date or Price
Order DESC or ASC
Palm Jumeirah, Luxurious 3 BR’s Apartment with Palm Jumeirah View and a Maids Room on Attractive Payment Plan

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

[ Convert Currency ] AED 3197PER SQ FTAED 5,250,0003 3
Downtown, Burj Khalifa, Tastefully Furnished 1 BR En-suite Apt over 87th Floor with Fountain View

Downtown, Burj Khalifa, Tastefully Furnished 1 BR En-suite Apt over 87th Floor with Fountain View

[ Convert Currency ] AED 4500PER SQ FTAED 5,000,0001 2
Palm Jumeirah, Luxurious 3 BR’s Apartment with Palm View and a Maids Room on Attractive Payment Plan

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

[ Convert Currency ] AED 2915PER SQ FTAED 4,927,0003 3
Chic 2 Bedrooms Apartment in a Low-rise with Maid’s Room and High-end Finishing’s, Surrounded by Natural Tree Canopy with Landscaped Gardens

Chic 2 Bedrooms Apartment in a Low-rise with Maid’s Room and High-end Finishing’s, Surrounded by Natural Tree Canopy with Landscaped Gardens

[ Convert Currency ] AED 1522PER SQ FTAED 4,907,1872 3 3223 sq ft
The European Themed Boutique Hotels Apt Expected Delivery Q1-2019, Marine Luxury At Its Peak On Exclusive Prices

The European Themed Boutique Hotels Apt Expected Delivery Q1-2019, Marine Luxury At Its Peak On Exclusive Prices

[ Convert Currency ] AED 3792PER SQ FTAED 4,900,0001 2 1292 sq ft
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

Select Currency in which you want to convert