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 18, 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,156Sq Ft, 30% Guaranteed Returns to be paid upfront in one payment at the time of purchase All apartments have spectacular views, overlooking the Arabian Gulf, Atlantis, the Burj AI Arab and the Palm Jumeirah. Apartments are ready to move in and beautifully finished with smooth wooden floors, panoramic views of Palm Jumeirah, the
……
BUA 1120 Sq Ft – Ain Dubai, lively Bluewater’s – every day is a festival – best views in town Ain Dubai, lively Bluewater’s – every day is a festival – best views in town For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estates in Dubai UAE With an
……
BUA1,448Sq Ft, This luxurious 1 bedroom apartment is built in a low-rise and low density development, every unit is set into the natural tree canopy with landscaped gardens and beautiful skyline views This elite plush green community is located 20 minutes from Dubai International Airport!! There are two categories in the community, each category is
……
BUA 822Sq Ft Fully furnished and equipped Studio Apartment with a Lagoon View, and guaranteed 10% Return on Investment (ROI) for 5 years
The Palm Jumeirah continues to lead the market in property value retention. While 45,000 new residential units are scheduled for completion by the end of 2015, only 4% of these projects will take place on the Palm Jumeirah, ensuring real estate in these areas continues to be highly sought. Its limited residential opportunities combined with its unique settings have placed it at the forefront of rental yields as well with Palm Jumeirah apartments and villas commanding a significant premium over other affluent areas
BUA 1,278 Sq. Ft – An Address that Truly Suits The Vision of Downtown, Invest for Capital Gain For detailed virtual tours of properties in Dubai, visit www.capellaproperties.ae capella properties, Redefining Real Estate in Dubai UAE 2 bedrooms in the Imperial Avenue are located between 7th floor to 24th floor, all the 2 bedrooms come
……
BUA1,565Sq Ft, This luxurious 1 bedroom apartment is built in a low-rise and low density development, every unit is set into the natural tree canopy with landscaped gardens and beautiful skyline views This elite plush green community is located 20 minutes from Dubai International Airport!! There are two categories in the community, each category is
……
