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 18, 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,902Sq Ft, Handover After 60% Payment, 7 Bedrooms Luxury Villa with Private Pool Payment Plan 1st Instalment (10%) = AED 1,329,189 /- 2nd Instalment (10%) = AED 1,329,189/- 3rd Instalment (10%) = AED 1,329,189/- 30% Construction Completion (10%) = AED 1,329,189/- 60% Construction Completion (10%) = AED 1,329,189/- 100% Construction Completion (10%) = AED
……
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,
……
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 6,259 Sq Ft, Country side living at only 3 Kms from Dubai Downtown For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Customised villas. Quaint townhouses. Celebrity penthouses. Designer duplexes. Appointed apartments…lovingly hidden by a zillion leaves, flowers, plants, and trees. 8 million sq feet
……
BUA 5,151 Sq Ft – Panoramic View of The Burj Khalifa From the Comfort of Your Palatial Home For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Downtown doesn’t have a product like this, a functional 4-bedroom penthouse spread across the curve of the imperial tower,
……
BUA 3,691Sq Ft, This luxurious 3 bedrooms plus maids 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
……
