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 30, 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 4,974Sq Ft, Only 2 units on single floor with direct view of 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%) 100% Construction Completion (15%) Completion in
……
BUA 1292Sq Ft The world, The European Themed Boutique Hotel Apt Expected Q1-2019, Marine Luxury At Its Peak On Exclusive Prices For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Payment Plan: Instalment 1 – 10% Signing the contract + 4% DLD Fee Instalment 2 –
……
BUA 457Sq Ft, The world, The European Themed Boutique Hotel Apt Expected Delivery in Q1-2019, Marine Luxury At Its Peak On Exclusive Prices For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Payment Plan: Installment 1 – 10% Signing the contract + 4% Oqood Installment 2
……
BUA 4,004 SqFt, The World, Marine luxury at its peak on exclusive prices, the floating Sea-Horse Delivery Q1-2019 For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Payment plan: Instalment 1 – 10% Signing the contract + 4% OQOOD Instalment 2 – 10% Instalment 3 –
……
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 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
……
