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 37 - 45 of 45

Show:
#104 Palm Beach Condominium,

3 3.5
Villa Soleil

Villa Soliel is set at the end of a quiet cul-de sac and offers a prime vantage point as the villa is elevated.This fully furnished two storey, 3 x bedroom, 3.5 x bathroom villa also ha...

3     3.5
Summerland Penthouse

Summerland aprtment is a two storey Penthouse locataed across the road from Paynes Bay Beach located on Barbados' famed west coast with spectacular views of the sea.The penthouse is accessed via ...

4 4.5
Banff Spring House

Banff Spring House is a beautiful bright and airy single story villa set in the heart of Sandy Lane. The villa comprises of 5 bedrooms 4 1/2 bathrooms large living room with a wonderful covered patio ...

4     4.5
Casa De Leo, Studio 2, Poinsettia Avenue

This studio apartment is located in a quiet residential area of Holetown and is a stroll away from beaches shopping and banking facilities. The develpment has on site laundry facilities with three oth...

1 1
Vuemont Villa 130

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 105

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
The Villages at

Unit 000 is 3 bed 2 bathroom propertyin a prime vantage point that offers outstanding panoramic views and provides pleasant, cooling breezes. These residential areas will combine with open, terrace la...

3     1.5
Turtle View #6, Porters, St James, Barbados

The Turtle View Development is a small gated community of 10 luxury semi-detached two storey houses, located on the desirable West Coast of Barbados between Holetown and Speightstown and is approximat...

3 2

Villas 37 - 45 of 45

Show: