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 72, 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,160Sq Ft, buy direct from the Developer, a luxurious residential property with fully furnished one bedroom apartment with guaranteed Higher (ROI) Return On Investment for the first two 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 the
……
BUA 7,000Sq Ft, Plot Size 13,000Sq Ft, This fully furnished Signature Villa equipped with all amenities has 6 spacious bedrooms with relaxing backyard that features a private pool with immaculate view of the Sea, two entertainment foyers with a large dining room, terrace to sit in the evenings, maid/driver rooms, private pool and beach, with
……
BUA 15,000Sq Ft approximately, La Reve is a 52-floor residential tower located in Dubai Marina and consists of luxury penthouse apartments only This full floor penthouse consists of 8 bedrooms with attached bathrooms with high-end finishing kitchen and white goods, woodwork with hand painted stain glass and precious marble flooring. This luxurious penthouse has a
……
BUA: 13,976 Sq Ft. Unit Area: 7,793 Sq Ft, Balcony Area: 6,183 Sq Ft. This magnificent penthouse is set on breathtaking property with spectacular views of Palm Jumeirah, Sea and skyline of Dubai Marina This residence has 4 en-suite bedrooms, large kitchen, formal dining area, large lounge and entertainment room for the guests This property
……
This distinctive newly built spacious villa is fully furnished by Versace, all 5 bedrooms have attached bathrooms, private cinema, state of the art Study, relaxing backyard that features a private pool and private beach with immaculate views of the Sea and Marina Sky Line Two entertainment foyers, dining room, terrace to sit in the evenings,
……
BUA 1,133 Sq Ft – Tastefully furnished one bedroom en-suite apartment over 87th Floor with a powder room for the guests + study area with breathtaking Dubai Mall Fountain, Dubai Mall and Address Hotel View For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae Burj Khalifa – The World’s tallest man-made structure was completed
……
