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 ASC
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
BUA 7,000Sq Ft, Plot Size 13,000Sq Ft, This fully furnished Signature Villa equipped with all amenities has 6 spacious bedrooms with relaxing backyard that features a private pool with immaculate view of the Sea, two entertainment foyers with a large dining room, terrace to sit in the evenings, maid/driver rooms, private pool and beach, with
……
BUA 10,842Sq Ft, The Only Apartment on a Single Floor, With Direct View of Burj Khalifa, Dubai Fountain and Dubai Opera Payment Plan: 1st Instalment (10%) – Purchase Date 2nd Instalment (5%) 3rd Instalment (5%) 10% Construction Completion (10%) 20% Construction Completion (10%) 40% Construction Completion (15%) 60% Construction Completion (15%) 80% Construction Completion (15%)
……
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 +
……
This high-end freehold villas prestigious project is being developed by a world renowned premium developer. This exclusive project is centrally located in Dubai, at only three minutes’ drive from Burj Khalifa In order to acquire further details about this project please share your passport copy with us, we will connect you with the developer for
……
BUA 1,378Sq Ft – Tastefully furnished one bedroom en-suite apartment over 52nd Floor with a powder room for the guests + study area with breathtaking Dubai Mall Fountain and Sea View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae Burj Khalifa – The World’s tallest man-made structure was completed in 2009. This beautifully
……
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
……