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 66, 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
This high-end freehold villas prestigious project is being developed by a world renowned premium developer. This exclusive project is centrally located in Dubai, at only three minutes’ drive from Burj Khalifa In order to acquire further details about this project please share your passport copy with us, we will connect you with the developer for
……
This high-end freehold villas prestigious project is being developed by a world renowned premium developer. This exclusive project is centrally located in Dubai, at only three minutes’ drive from Burj Khalifa In order to acquire further details about this project please share your passport copy with us, we will connect you with the developer for
……
This high-end freehold villas prestigious project is being developed by a world renowned premium developer. This exclusive project is centrally located in Dubai, at only three minutes’ drive from Burj Khalifa In order to acquire further details about this project please share your passport copy with us, we will connect you with the developer for
……
BUA 1,822Sq Ft, buy direct from the Developer, a luxurious residential property with fully furnished two bedroom deluxe apartment with guaranteed Higher (ROI) Return On Investment for the first three Years, incase you place the apartment in the Rental Pool. All apartments have spectacular views, overlooking the Arabian Gulf, Atlantis, the Burj AI Arab and
……
BUA 1,771Sq Ft, buy direct from the Developer, a luxurious residential property with fully furnished two bedroom apartment with guaranteed Higher (ROI) Return On Investment for the first two Years, incase you place the apartment in the Rental Pool. All apartments have spectacular views, overlooking the Arabian Gulf, Atlantis, the Burj AI Arab and the
……
BUA 1,523Sq Ft, buy direct from the Developer, a luxurious residential property with fully furnished one bedroom deluxe apartment with guaranteed Higher (ROI) Return On Investment for the first two Years, incase you place the apartment in the Rental Pool. All apartments have spectacular views, overlooking the Arabian Gulf, Atlantis, the Burj AI Arab and
……
