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
100 Properties found

Villas 1 - 9 of 100

Show:
Falls Townhouse

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...

2 2.5
Browns Land

Land in Browns Xch

Lantana

2 2.5
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...

Husband Heights

Retangular in shape, residential land, in quiet residential area near main road with good bus route. Land has building permisson for residential development.

Mullins Bagatelle

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.

Cherry Grove Cresent,

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 Heights Lot 184 near Apes Hill

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 ...

Four Cross Roads Lot 38, St Lucy

Wooden house measuring 58sqm with ramp on 4300 sqft of land.  

3 1
Gays Land

GREAT VALUE This slightly elivated, retangular shaped lot, measures 11,532sqft and has views of the Carribean sea. It is located in the quiet and respectable neighbourhood of Gays, Bosc...

Villas 1 - 9 of 100

Show: