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 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: 89 Properties

Map
Order by Date or Price
Order DESC or ASC
Chic 3 Bedrooms Apartment in a Low-rise with Store Room and High-end Finishing’s, Surrounded by Natural Tree Canopy with Landscaped Gardens

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

[ Convert Currency ] AED 1563PER SQ FTAED 5,317,0983 4 3401 sq ft
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

Select Currency in which you want to convert