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
Desirable land lot #84 located on the popular Residential Heywoods Estate,St Peter, Barbados. This residential lot is square and flat and is located centrally within the Estate. It has easy access to ...
Tino Terrace a desireble area / neighbourhood, located in the heart of Christ Church and within close proximity to the Sherraton Mall Complex and several south coast amenities, including wh...
Great residential lot located in a quiet, desireable area of Barbados. The lot offers wonderful distant views of the Caribbean Sea and backs onto a lush gully.The area is a short drive away to Consett...
This square shaped, elevated lot measures 21,769 sqft and is located in the prime, quiet and desirable neighbourhood of Mount Pleasant Ridge, St Phillip.The land backs onto a gully gv...
This corner lot in Welches Terrace lot 114 is located in a residential area close to homes on your left and open mature landscape with breathtaking views of rolling hills to the north.The lot offers p...
