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 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 433 Sq Ft – Studio apartment in a lifestyle community, the green heart of Dubai “The grass is indeed greener at Al-Barari” by Elle Magazine A community that is thriving, known to be the green heart of Dubai. Al Barari has come up with a small segment for its investors called the neighborhood. Set
……
BUA 816 Sq Ft – For an audience that understands legacy in the making For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE The Opus, it comes with a legacy attached to it that needs no introduction. A destination designed with a cube structure that is
……
BUA 1,156Sq Ft, 30% Guaranteed Returns to be paid upfront in one payment at the time of purchase All apartments have spectacular views, overlooking the Arabian Gulf, Atlantis, the Burj AI Arab and the Palm Jumeirah. Apartments are ready to move in and beautifully finished with smooth wooden floors, panoramic views of Palm Jumeirah, the
……
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 2,050 Sq. Ft, Panoramic Views of The Lake, A 3 Bedroom That Stands Out in The Downtown Skyline For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Stunning 3 bedrooms with panoramic view of the lake/Burj Khalifa located between 15th to 24th floor, all the
……
BUA 1,278 Sq. Ft – An Address that Truly Suits The Vision of Downtown, Invest for Capital Gain For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE 2 bedrooms in the Imperial Avenue are located between 7th floor to 24th floor, all the 2 bedrooms come
……
