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 84, 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
Jumeirah Island – European Cluster, Garden Hall with Spectacular Lake View

Jumeirah Island – European Cluster, Garden Hall with Spectacular Lake View

[ Convert Currency ] AED 940PER SQ FTProperty is sold4 5 19642 sq ft
Modern Contemporary 4 Ensuite Bedrooms Villa with Private Pool and Garden, Distinctive Interiors in Plush Green Community

Modern Contemporary 4 Ensuite Bedrooms Villa with Private Pool and Garden, Distinctive Interiors in Plush Green Community

[ Convert Currency ]                        Property is sold4 5 9,000 to 15,000 sq ft
Marine Luxury At Its Peak On Exclusive Prices, The Floating Seahorse Delivery Dec’16

Marine Luxury At Its Peak On Exclusive Prices, The Floating Seahorse Delivery Dec’16

[ Convert Currency ] AED 3226PER SQ FTProperty is sold1 2 3100 sq ft
The World, Marine Luxury At Its Peak On Exclusive Prices, The Floating Seahorse Delivery Dec 17

The World, Marine Luxury At Its Peak On Exclusive Prices, The Floating Seahorse Delivery Dec 17

[ Convert Currency ] AED 2483PER SQ FTProperty is sold1 2 3100 sq ft
Downtown, Burj Khalifa, Lavishly Furnished 1 BR En-suite Apt over 52nd Floor with Fountain and Sea View

Downtown, Burj Khalifa, Lavishly Furnished 1 BR En-suite Apt over 52nd Floor with Fountain and Sea View

[ Convert Currency ] AED 5007PER SQ FTProperty is sold1 2

Select Currency in which you want to convert