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
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...
Neptune Close, is a four bedroom three bathroom property with a single car garage, set in a quiet residential road in the heart of St Philip.This property is in immaculate condition, tastefully furnis...
This large triangular shaped lot measures approximately 20,000sqft and is situated within the exclusive Apes Hill Polo Estate giving access to the Apes Hill Golf Course and Polo Club with its fir...
Located in the quiet cul-de-sac and residential area of Crystal Heights, St James is this large single storey, 4 bed 3 bath, fully tiled, open plan home with high ceilings, bars on all windows and spa...
RECENTLY REDUCEDThis Clerview Heights property is a fully furnished single storey, 3 bed 2 bathroom house for sale, in the established residential neighbourhood of Clerview in St James/Mich...
3.5 
