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 48, 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 2,015Sq Ft – Tonino Lamborghini Residences Dubai, Retreat To An Oasis From The Outside 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
……
BUA 1,921 Sq Ft. Hollywood Style Luxurious 2 BR Duplex Apt With Maids Room Having 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,
……
BUA 1,074Sq Ft, 2 Bedrooms Lavishly Furnished and Serviced Apartments with Burj Khalifa, Dubai Opera and Dubai Fountain View Payment Plan 1st Instalment (10%) = AED 309,688.80/- 2nd Instalment (10%) = AED 309,688.80/- 3rd Instalment (10%) = AED 309,688.80/- 10% Construction Completion (10%) = AED 309,688.80/- 20% Construction Completion (5%) = AED 154,844/- 30% Construction
……
BUA 1,160Sq Ft, buy direct from the Developer, a luxurious residential property with fully furnished one 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,648Sq Ft – Tonino Lamborghini Residences Dubai, Intelligent Living For A New Era 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
……
BUA 828Sq Ft, Type 1A This unit has an open plan kitchen with large dining area, powder room for the guests and a balcony. One large en-suite bedroom is designed for lots of sunlight with walk-in closet. The Palm Jumeirah continues to lead the market in property value retention. While 45,000 new residential units are
……
