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 84, 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 5,284Sq Ft, Plot size 10,642Sq Ft – A superb Garden Hall villa with spectacular lake view situated in the sought after Jumeirah Islands gated community For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae The villa presents a master bedroom with balcony, en-suite dressing room & bathroom and there are 3 further bedrooms
……
BUA 7,300Sq Ft, Plot Size 14,000Sq Ft, 4 Ensuite Bedrooms Villa with Private Pool and Garden The contemporary architectural style, international influence and distinctive interior aesthetics combine to create a home in which every detail celebrates serenity and simplicity. Quality finishing underscores the timeless design as the spacious rooms flow from one to another. The
……
BUA 3,100Sq Ft, The World, Marine luxury at its peak on exclusive prices, the Floating Seahorse Delivery Dec’16 To view the Virtual/Video Tour of this property, click on For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Payment Plan: Instalment 1 – 20% Signing the contract
……
BUA 3,100Sq Ft, The World, Marine Luxury At Its Peak On Exclusive Prices, The Floating Seahorse Delivery Dec 17 For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Payment Plan: Instalment 1 – 20% + 4% for oqood at the time of signing the contract (AED
……
BUA 1,378Sq Ft – Tastefully furnished one bedroom en-suite apartment over 52nd Floor with a powder room for the guests + study area with breathtaking Dubai Mall Fountain and Sea View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae Burj Khalifa – The World’s tallest man-made structure was completed in 2009. This beautifully
……
