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 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 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 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 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 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
……
Classy 1 En-suite Fully Furnished Apartment with Sea, Dubai Mall Fountain View – Study/office and One Powder Room for the Guests – BUA 1,378 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 Burj Khalifa, which
……
