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 24, 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 3,401Sq Ft, This luxurious 3 bedrooms plus store room apartment is built in a low-rise and low density development, every unit is set into the natural tree canopy with landscaped gardens and beautiful skyline views. This elite plush green community is located 20 minutes from Dubai International Airport!! There are two categories in
……
BUA 1,642Sq Ft, Type 3A This unit has an open plan kitchen with large dining area, powder room for the guests, laundry room and a balcony. Two large en-suite bedrooms that are designed for lots of sunlight, master bedroom has a walk-in closet, the third bedrooms washroom is outside so it can be used by
……
BUA 1,133 Sq Ft – Tastefully furnished one bedroom en-suite apartment over 87th Floor with a powder room for the guests + study area with breathtaking Dubai Mall Fountain, Dubai Mall and Address Hotel View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae Burj Khalifa – The World’s tallest man-made structure was completed
……
BUA 1,690Sq Ft, Type 3A This unit has an open plan kitchen with large dining area, powder room for the guests, laundry room and a balcony. Two large en-suite bedrooms that are designed for lots of sunlight, master bedroom has a walk-in closet, the third bedrooms washroom is outside so it can be used by
……
BUA3,223Sq Ft, This luxurious 2 bedrooms plus maid’s room apartment is built in a low-rise and low density development, every unit is set into the natural tree canopy with landscaped gardens and beautiful skyline views This elite plush green community is located 20 minutes from Dubai International Airport!! There are two categories in the community,
……
BUA 1292Sq Ft The world, The European Themed Boutique Hotel Apt Expected 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: Instalment 1 – 10% Signing the contract + 4% DLD Fee Instalment 2 –
……
