SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID 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 = 'Leasing' )
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 0, 6
Search Results: 8 Properties
Map
BUA 13,398 sq Ft, Frond B Palm Jumeirah, Dubai For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai Palm Jumeirah Villa A one of a kind semi-furnished villa in the ecstatic man-made island Palm Jumeirah, home to the most exuberant villas in Dubai. This villa has a
……
BUA 3,777 Sq Ft An Environment Friendly Community for People Who are Conscious A community that has a conscience! Socially, economically and environmentally sustainable. Functions on 100% reused and recycled water, 100% recycled waste, 100% renewable energy, green production, mobility via electric cars and much more. A lifestyle, a city of tomorrow. The solar panels
……
BUA 1,639Sq Ft, Gorgeous 2 BR Apt with Blvd and Old Town View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE Burj Khalifa – The World’s tallest man-made structure was completed in 2009. The beautifully designed eco-friendly gigantic tower is located at the core of
……
BUA 826 Sq Ft – One bedroom en-suite apartment with a powder room for the guests with breathtaking Dubai Mall Fountain 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 designed eco-friendly gigantic tower is located at the core
……
Stylishly Upgraded & Furnished by a Renowned Artist, 6 Bedrooms Signature Villa with Large Swimming Pool, Private Beach – Palm Jumeirah Beautifully kept villa, fully furnished interior designed by a renowned artist. Extremely spacious 6 Bedroom with Relaxing backyard that features a private pool, Built Up Area of 7,000 sq. ft., with Fantastic View of
……
BUA 6,702Sq Ft, 4 Bedrooms Villa with Private Pool, Garden and Spectacular Sea Views For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE Palm Jumeirah is the world’s largest man-made island. It is a residential and tourism destination launched in the early 2000. It includes a
……
