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 72, 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
……
BUA 785.23Sq Ft – A home for those who dream BIG!! Nestled between the royal palace grounds and the lavish private homes of the Dubai elite, lies a pristine enclave in Nad Al Sheba. Just a five-minute trip from Meydan One and Mohammed Bin Rashid City – a flourishing new precinct poised to become the
……
BUA 1,041 Sq Ft – A thriving, livable, green, wellness community – investor friendly “The grass is indeed greener at Al-Barari” by Elle Magazine A community that is thriving, known to be the green heart of Dubai. Al Barari has come up with a small segment for its investors called the neighborhood. Set within Al
……
BUA 669, Hollywood Style Luxurious Studio with Burj Khalifa View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Boasting 946 units, with 254 uniquely designed hotel rooms, 321 hotel apartments and 371 residences, spread over 75 floors, SLS Dubai will be one of the tallest
……
BUA 433 Sq Ft – Studio apartment in a lifestyle community, the green heart of Dubai “The grass is indeed greener at Al-Barari” by Elle Magazine A community that is thriving, known to be the green heart of Dubai. Al Barari has come up with a small segment for its investors called the neighborhood. Set
……
Unparalleled Luxury Living – Villa for Sale in Dubai, Al Barari, The Reserve Luxury is not a number, it is a lifestyle. It is not about being the biggest or the brightest or the first, it is about the subtle details that differentiate the ordinary from the extraordinary. The Reserve at Al Barari has been
……
