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 78, 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
We are pleased to offer this stunning 28,229Sq Ft luxury seven en-suite bedrooms villa in Emirates Hills that can be finished according to your own choice! In addition to the large living rooms, the property features a total of seven en-suite bedrooms, nine bathrooms, a kitchen, study/office, allocated area for gymnasium and a maid’s +
……
Gallery View 6 Bedrooms Signature Villa – Sea View – Vacant and Ready to Move-in Plot size 13,000Sq Ft BUA 7,000Sq Ft- Palm Jumeirah 6 Bedroom Gallery View, Arabic Style Signature Villa with incredible Sea View Spacious 6 Bedroom with relaxing backyard that features a private pool, with immaculate view of the Sea, two entertainment
……
01 Bedroom En-suite Apartment with Powder Room & Study on lower floor with E Boulevard & Sea View This beautiful apartment has one en-suite bedroom with gorgeous sea view, fully equipped kitchen that opens in large lounge. The bedroom and the lounge has lavish wooden flooring, and the entrance and washrooms has high grade ceramic
……
Unparalleled Luxury Living – Villa for Sale in Dubai, Al Barari, The Reserve Luxury is not a number, it is a lifestyle. It is not about being the biggest or the brightest or the first, it is about the subtle details that differentiate the ordinary from the extraordinary. The Reserve at Al Barari has been
……
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
……
