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, mt2.meta_value+0 ASC
LIMIT 42, 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 1,263Sq Ft, Type 2A with Sea View This unit has an open plan kitchen with large dining area, powder room for the guests, laundry room and a balcony. Two large en-suite bedrooms that are designed for lots of sunlight, master bedroom is designed with a walk-in closet. This units also has a maid’s room
……
01 Bedroom En-suite Apartment with Powder Room & Study on lower floor with E Boulevard & Sea View This beautiful apartment has one en-suite bedroom with gorgeous sea view, fully equipped kitchen that opens in large lounge. The bedroom and the lounge has lavish wooden flooring, and the entrance and washrooms has high grade ceramic
……
BUA 1,255Sq Ft, Type 2A Palm Jumeirah View with Maids Room This unit has an open plan kitchen with large dining area, powder room for the guests, laundry room and a balcony. Two large en-suite bedrooms that are designed for lots of sunlight, master bedroom is designed with a walk-in closet. This units also has
……
BUA 1,822Sq Ft, buy direct from the Developer, a luxurious residential property with fully furnished two bedroom deluxe apartment with guaranteed Higher (ROI) Return On Investment for the first three Years, incase you place the apartment in the Rental Pool. All apartments have spectacular views, overlooking the Arabian Gulf, Atlantis, the Burj AI Arab and
……
BUA 1,255Sq Ft, Type 2A Palm Jumeirah View with Maids Room This unit has an open plan kitchen with large dining area, powder room for the guests, laundry room and a balcony. Two large en-suite bedrooms that are designed for lots of sunlight, master bedroom is designed with a walk-in closet. This units also has
……
BUA 2,422.31Sq Ft – Tonino Lamborghini Residences Dubai, Retreat To An Oasis From The Outside Nestled between the royal palace grounds and the lavish private homes of the Dubai elite, lies a pristine enclave in Nad Al Sheba. Just a five-minute trip from Meydan One and Mohammed Bin Rashid City – a flourishing new precinct
……