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 6, 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
6 BR Mediterranean Styled Luxury Villa In An Exclusive Community

6 BR Mediterranean Styled Luxury Villa In An Exclusive Community

[ Convert Currency ] AED 1112PER SQ FTAED 20,000,0006 7
Lavishly Furnished and Serviced Penthouse with Burj Khalifa, Dubai Opera and Dubai Fountain at Door Step

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

[ Convert Currency ] AED 3391PER SQ FTAED 19,456,8885 5 5738 sq ft
Palm Jumeirah, Exceptional 4 Bedrooms Villa with Roof Deck, a Lift, Private Pool, Garden and Spectacular Sea Views

Palm Jumeirah, Exceptional 4 Bedrooms Villa with Roof Deck, a Lift, Private Pool, Garden and Spectacular Sea Views

[ Convert Currency ] AED 1076PER SQ FTAED 18,000,0004 6 15797 sq ft
Only 2 Units on Single Floor, With Direct View of Dubai Opera

Only 2 Units on Single Floor, With Direct View of Dubai Opera

[ Convert Currency ] AED 3619PER SQ FTAED 18,000,0004 5 5253 sq ft
Only 2 Units on Single Floor, With Direct View of Burj Khalifa And Dubai Fountain

Only 2 Units on Single Floor, With Direct View of Burj Khalifa And Dubai Fountain

[ Convert Currency ] AED 3527PER SQ FTAED 18,000,0004 5 5383 sq ft
Posh 5 Bedrooms Villa with Private Pool and Garden, Three Minutes’ Drive from Burj Khalifa

Posh 5 Bedrooms Villa with Private Pool and Garden, Three Minutes’ Drive from Burj Khalifa

[ Convert Currency ]                        AED 17,700,0005 6 8028 sq ft

Select Currency in which you want to convert