SELECT
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, content_type_property.field_property_ispor_value as POR
FROM node INNER JOIN term_node newlist_tn ON node.nid = newlist_tn.nid INNER JOIN term_data newlist_td ON newlist_td.tid = newlist_tn.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 node.type = 'property' and (td.vid=1) and (td.tid = 3) AND (newlist_td.tid = 497) GROUP BY node.nid ORDER BY POR ASC, NR ASC, NR_max ASC
Port Ferdinand Luxury Beach Front Marina Resort, St Peter, Barbados
Port Ferdinand’s 82 homes are designed to maximize the owner’s experience. Designed by architects Michael Gomes and Associates, every residence is ideally positioned above a slip to allow for incr...
The Falls is an exclusive development located next to the exclusive Sandy Lane estate and near to Holetown with it's fine dining resturants, night-life, duty free shops, banking facilities and&nb...
Retangular in shape, residential land, in quiet residential area near main road with good bus route. Land has building permisson for residential development.
Flat, residential land, square in shape in quiet residential area near well maintained communal park in Mullins. Land has sea views and building permisson for one house.
This lot measures 4,261sqft of residential development land which is flat, rectangular in shape and is fully serviced with essential water and Light & Power supplies.The lot is located in close pr...
St. Silas HeightsLocated within the highly desirable residential neighbourhood of St. Silas Heights. This level lot is tri-angular in shape and and comprises approximately 8,400 sq.ft and permissions ...
2.5 
