SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID 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 ASC 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
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
……
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
……
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
……
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 +
……
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
……
This distinctive newly built spacious villa is fully furnished by Versace, all 5 bedrooms have attached bathrooms, private cinema, state of the art Study, relaxing backyard that features a private pool and private beach with immaculate views of the Sea and Marina Sky Line Two entertainment foyers, dining room, terrace to sit in the evenings,
……
