SELECT node.created as pcreated, node.nid as nid, node.title as ptitle , min(content_type_property.field_sale_min_amount) as NR , min(content_type_property.field_sale_max_amount) as NR_max FROM node INNER JOIN term_node tnd ON node.nid = tnd.nid INNER JOIN term_data tdt ON tdt.tid = tnd.tid inner join term_node tn on (tn.nid=node.nid) inner join term_data td on (tn.tid=td.tid) LEFT JOIN content_field_r_property RP ON node.nid = RP.field_r_property_nid LEFT JOIN content_type_property ON node.vid = content_type_property.vid WHERE node.status <> 0 AND content_type_property.field_property_frontend_display_value=1 AND node.type = 'property' and (td.vid=1) and (td.tid = 3) AND (content_type_property.field_property_status_value = 'For Sale') AND (tdt.tid = 84) GROUP BY node.nid ORDER BY NR ASC propertySearchSales
20 Properties found.

Can’t find a specific Property?

Apes Hill Club is a world class Golf and Polo Community located 1000 feet above sea level with panoramic views of the Atlantic Ocean and Caribbean Sea. This luxury lifestyle resort, boasting the arrival of the first Country Club in Barbados in 2016, offers a high quality experience, from golf and polo, to tennis and swimming and within a safe and secure environment.

A family owned and operated development, Apes Hill Club prides itself on delivering an intimate and understated experience. The developer offers a range of luxury homes, from large estate homes and courtyard villas to bespoke land and villa packages, providing owners the opportunity to develop the Caribbean home of their dreams and all with the quality purchasers have come to expect at Apes Hill Club.

Copyright