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 0, 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 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,133 Sq Ft. Hollywood Style Luxurious 1 BR Duplex 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
……
BUA 1,124 Sq Ft. Hollywood Style Luxurious 1 BR Loft 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 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 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 9,366Sq Ft, Beautiful 4 bedrooms sea facing villa with Fendi Furnishing,Private Lift, Pool, Private Landscaped Garden, Roof Deck with Entertainment Foyer and Jacuzzi plus Washroom with Stunning Sea Views, Covered Parking for Three Vehicles in the Basement, Maids Quarter with a Washroom, Basement. Set within lush grounds on the curving breakwater of the Crescent,
……
