SELECT node.nid as nid, node.title as ptitle , min(content_type_property.field_property_ltrental_min_amount) as NR , min(content_type_property.field_property_ltrental_max_amount) as NR_max, content_type_property.field_rent_request_value as POR FROM node inner join term_node tn on (tn.nid=node.nid) inner join term_data td on (tn.tid=td.tid) 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 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 = 2) AND (newlist_td.tid = 496) GROUP BY node.nid ORDER BY POR ASC, NR ASC, NR_max ASC
45 Properties found

Villas 21 - 31 of 45

Show:
Lodge Gardens Unit 3

 Lodge Gardens, a small and exclusive gated community designed and finished to a high standard consisting of three bright & spacious townhouses, each with 2 bedrooms, 2.5 bathrooms,...

2 2.5
Vuemont Villa 135

Vuemont Barbados is located only 2 miles from beaches, set on a ridge overlooking Port St. Charles and Speightstown on the highly desirable West Coast in the Parish of St Peter, . The Lifestyle Resort...

3     2
Vuemont Villa 125

The Vuemont Development is set on a spectacular ridge in the tropical location of Mount Brevitor, St   Peter on a prime vantage point that offers outstanding panoramic views and provides pleasant...

3 2
Prior Park #25

Vuemont Villa 118.

This 3 bedroom, 2 bathroom villa enjoys an elevated position above the west coast of Barbados. Vuemont Villa 118 provides breath-taking views of the Caribbean Sea and the rolling cane fields of the St...

3 2
Clerview Heights 41

Lovely family home fully enclosed that offers complete privacy situated in a quiet desirable neighbourhood on the St James St Michael boarders.The house has three large bedrooms with two bat...

3     2
Summerland Villas 104

This first floor condo has two bedrooms, two bathroom and is finished to a high specification with a full range of kitchen appliances. The development is located on the west coast near ...

2 2.5
Heron Court #19

Heron Court Devlopment is a gated development is situated on the outskirts of Holetown in Porters, which is within the popular parish of St. James and is just 10 minutes walk to Heron Bay beach a...

3     2.5
Harbour View

Harbour View is an open plan, island style living conspet with garden and ocean / harbour views. A must-see!A large, bright, modern, fully furnished, executive style multi-level home with stunning vie...

4 3
Heron Court #18

Heron Court a prime residential development consisting of 28 townhouses. Number 18 is a beautifully, built 3 bedroom 2.5 bathroom luxury townhouse with high quality fittings and finishes throughout, c...

3     2.5

Villas 21 - 31 of 45

Show: