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 = '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, wp_2_posts.post_date ASC
LIMIT 0, 6
Search Results: 8 Properties
Map
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
……
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 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
……
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
……
Apartment on a Higher Floor with Full Dubai Mall Fountain View – 2 En-suite Bedrooms plus Maid Room with Attached Bath and a Powder Room for Guests 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 an integrated township Downtown
……
