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
Heron Court #3 is one of 28 elegant townhouses situated in a prime residential housing development in the popular parish of St. James on the outskirts of Holetown but close to the golf resort of ...
Jamestown Park is a small development of five two storey town housses, located in the heart of holetown in a quiet cul-de-sac.As you enter the livingroom of this fully tiled 2 bedroom, 2.5 bathroom&nb...
Grazettes Main Rd, Lot 29 Third Avenue, St Michael.
Lot 29 Third Avenue, Grazettes, is an older property with lots of potential and scope for development. Some DIY work is needed to bring the property back to its former greatness however given its loca...
Vuemont Villa130 is a single storey property that has been appropriately designed with extra wide doors for wheelchairs and grab rails in bathrooms. It has been carefully positioned to complement...
Located in the heart of Mullins on 10,551 sqft of land, is a single storey 2,000 sqft property with 3 bedrooms 2 bathrooms, another room that could be used as a 4th bedroom / study / gym, a garage, op...
OverviewGolden Acres development comprises of 8 spacious, newly constructed , 3 bedroom, 2 1/2 bathroom townhouses.These units have high quality finishes, with a spacious kitchen, living and dinning r...
Mango Court is a charming modern styled Barbadian Development built approximately 15 years ago on approximately 10,000 sqft of land. It features a communal pool, private sitting ar...
2.5 
