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
Ajoupa Villas is located in Fitts Village, St James, close to restaurants, bars, a supermarket and banking facilities. This modern unfurnished 2 storey townhouse is set in tranquil tropical gardens wi...
Ajoupa Villas is located in Fitts Village, St James, close to restaurants, bars, a supermarket and banking facilities. This modern 2 storey townhouse is set in tranquil tropical gardens with a communa...
Large lot measuring 20,000 sqft in quiet residential neighborhood located between Searls and Lowlands in Christ Church.This is a very private lot with good transport links close to Oistins a...
Clermont Terrace South #13 Clermont, St James, Barbados
Clermont Terrace South is a large two storey, corner plot property with 5/6 bedrooms 2.5 bathrooms, a built in garage, storage room and a large 1 bed apartment with separate entrance.Located in a...
Set in the heart of St.Thomas, this single storey, detached property sits on approx 8,000 sq ft of enclosed, elevated land. This 3 bedroom, 2.5 bathrooms property benefits from a large driveway, singl...
Violet Drive #96 Cane Gardens, St Thomas, Barbados
#96 Violet Drive, Cane Gardens, is a large two storey stand alone house, built almost 14 years ago, sitting on a quiet residential lot measuring 6,370sqft. The property has 3 bedrooms, 2 bathrooms, a ...
Lemon Circle 380 is an extended single storey property with 3 bedrooms & 2 bathrooms located on a lot sized 5,745sqft in a quite and desireable neibourhood.As you enter the gates and walk on ...
Large rectangular, residential, plot located in a quiet cul-de-sac, measuring approx 10,000sqft with gentle gradient from east to west.Views of the sea can be obtained from any upstairs developm...