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
Unit 24 is a quaint and cozy 3 bedroom, 2 bathroom townhouse, located in the Foursquare cluster which houses the best swimming pool of all the clusters within Rockley Resort. As you enter the liv...
Apple Hall #56 Close No2, Hill Drive Rd, Apple Hall, St Philip
#56 Close No2, Hill Drive Rd, Apple Hall, St Phillip. Above is a two storey apartment block sitting on approximately 5,500 ft.² of land and containing 2 two bedroom apartments measuring ap...
** The ideal Fixer-Upper **This proepty is priced to sell and is perfect for the first-time buyer, family and or investors alike. This older style, standalone sngle storey property has ...
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...
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...
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...
Land size approximately 9,000 ft.²House size approximately 3,000 ft.² of habitable space 3 Bedrooms, 2.5 Bathrooms House1 Bedroom, 1 Bathroom Apartment1 Bedroom, 1 Bathroom Apartment The s...
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 ...
1 
