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 ASC
LIMIT 42, 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 16,056 Sq Ft, 5 Bedrooms Modern Arabic Styled Luxury Villa In An Exclusive Community For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE The address you want to be at, the latest wonder to join the list of wonders in Dubai. Mohammed Bin Rashid Al
……
BUA 17,976 Sq Ft, 6 Bedrooms Mediterranean Styled Luxury Villa In An Exclusive Community For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE The address you want to be at, the latest wonder to join the list of wonders in Dubai. Mohammed Bin Rashid Al Maktoum
……
BUA 1,452Sq Ft, 3 Bedrooms Lavishly Furnished and Serviced Apartments with Burj Khalifa, Dubai Opera and Dubai Fountain View Payment Plan 1st Instalment (10%) = AED 470,488/- 2nd Instalment (10%) = AED 470,488/- 3rd Instalment (10%) = AED 470,488/- 10% Construction Completion (10%) = AED 470,488/- 20% Construction Completion (5%) = AED 235,244/- 30% Construction
……
BUA 1,074Sq Ft, 2 Bedrooms Lavishly Furnished and Serviced Apartments with Burj Khalifa, Dubai Opera and Dubai Fountain View Payment Plan 1st Instalment (10%) = AED 309,688.80/- 2nd Instalment (10%) = AED 309,688.80/- 3rd Instalment (10%) = AED 309,688.80/- 10% Construction Completion (10%) = AED 309,688.80/- 20% Construction Completion (5%) = AED 154,844/- 30% Construction
……
BUA 5,253Sq Ft, 5 Bedrooms Lavishly Furnished and Serviced Penthouse with Burj Khalifa, Dubai Opera and Dubai Fountain View Payment Plan 1st Instalment (10%) = AED 1,945,688.80/- 2nd Instalment (10%) = AED 1,945,688.80/- 3rd Instalment (10%) = AED 1,945,688.80/- 10% Construction Completion (10%) = AED 1,945,688.80/- 20% Construction Completion (5%) = AED 972,844.40/- 30% Construction
……
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
……