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 24, 6
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, ......
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
BUA 876 Sq Ft – A Quality Project that Overlooks Burj Khalifa & Towers Over Business Bay Lake For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE 1 bedrooms in the Imperial Avenue are located between 6th floor and 13th floor, all the 1 bedrooms come
……
[ Convert Currency ] AED 1660PER SQ FTAED 15,000,0005 6 From 4,800 - 15,064 sq ft
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, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE The Alef brand is truly the first of its kind through design,
……
BUA 8,415Sq Ft, Countryside living at only 3 km from Dubai Downtown on a limited offer For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Customised villas. Quaint townhouses. Celebrity penthouses. Designer duplexes. Appointed apartments…lovingly hidden by a zillion leaves, flowers, plants, and trees. 8 million
……
BUA 6,259 Sq Ft, Country side living at only 3 Kms from Dubai Downtown For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Customised villas. Quaint townhouses. Celebrity penthouses. Designer duplexes. Appointed apartments…lovingly hidden by a zillion leaves, flowers, plants, and trees. 8 million sq feet
……
BUA 10,842Sq Ft, The Only Apartment on a Single Floor, With Direct View of Burj Khalifa, Dubai Fountain and Dubai Opera Payment Plan: 1st Instalment (10%) – Purchase Date 2nd Instalment (5%) 3rd Instalment (5%) 10% Construction Completion (10%) 20% Construction Completion (10%) 40% Construction Completion (15%) 60% Construction Completion (15%) 80% Construction Completion (15%)
……
BUA 5,104Sq Ft, Only 2 units on single floor with direct Burj Khalifa and Dubai Fountain Views Payment Plan 1st Instalment (10%) – Purchase Date 2nd Instalment (5%) 3rd Instalment (5%) 10% Construction Completion (10%) 20% Construction Completion (10%) 40% Construction Completion (15%) 60% Construction Completion (15%) 80% Construction Completion (15%) 100% Construction Completion (15%)
……
