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 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
BUA 642Sq Ft Fully furnished and equipped Studio Apartment with a Lagoon View, and guaranteed 10% Return on Investment (ROI) for 5 years
The Palm Jumeirah continues to lead the market in property value retention. While 45,000 new residential units are scheduled for completion by the end of 2015, only 4% of these projects will take place on the Palm Jumeirah, ensuring real estate in these areas continues to be highly sought. Its limited residential opportunities combined with its unique settings have placed it at the forefront of rental yields as well with Palm Jumeirah apartments and villas commanding a significant premium over other affluent areas
BUA 1,190.59Sq 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 808 Sq Ft, Hollywood Style Luxurious 1 Bedroom Apt 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
……
BUA 939.15Sq 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 377Sq Ft Fully furnished and equipped Studio Apartment with a Lagoon View, and guaranteed 10% Return on Investment (ROI) for 5 years
The Palm Jumeirah continues to lead the market in property value retention. While 45,000 new residential units are scheduled for completion by the end of 2015, only 4% of these projects will take place on the Palm Jumeirah, ensuring real estate in these areas continues to be highly sought. Its limited residential opportunities combined with its unique settings have placed it at the forefront of rental yields as well with Palm Jumeirah apartments and villas commanding a significant premium over other affluent areas
BUA 457Sq Ft, The world, The European Themed Boutique Hotel Apt Expected Delivery in Q1-2019, Marine Luxury At Its Peak On Exclusive Prices For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Payment Plan: Installment 1 – 10% Signing the contract + 4% Oqood Installment 2
……
