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, wp_2_posts.post_date DESC LIMIT 78, 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
Emirates Hills, W-Sector – 7 En-suite BR with Pristine Panoramic Lake View

Emirates Hills, W-Sector – 7 En-suite BR with Pristine Panoramic Lake View

[ Convert Currency ] AED 1240PER SQ FTAED 37,000,0007 9 28229 sq ft
Palm Jumeirah – 6 BR Gallery View, Arabic Style Signature Villa with Sea View

Palm Jumeirah – 6 BR Gallery View, Arabic Style Signature Villa with Sea View

[ Convert Currency ] AED 2077PER SQ FTAED 30,000,0006 6 13000 sq ft
Burj Khalifa, 1 Bedroom Ensuite Vacant Apt on a Lower Floor with Emaar Blvd and Sea View

Burj Khalifa, 1 Bedroom Ensuite Vacant Apt on a Lower Floor with Emaar Blvd and Sea View

[ Convert Currency ] AED 3620PER SQ FTAED 3,800,0001 2
The Reserve, Al Barari – Luxury Living – Villa for Sale in Dubai

The Reserve, Al Barari – Luxury Living – Villa for Sale in Dubai

[ Convert Currency ] AED 1300PER SQ FTPrice on request5 6 50000 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

Select Currency in which you want to convert