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

Show:
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
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
Turtle View #5, 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.5
Hillbury, St George

Large two story, 5 bedroom house built around a central court yard on 2 acres of land. The property is fully enclosed with panaoramic sea and country views. 

5 5.5
Summerland Villas 101

Summerland a lxuary developmentUnit 101 is a Luxury ground floor condo in a gated development with three bedrooms a/c & built in closets, two bathrooms (one en-suite) all finished to a h...

3     2.5
El Nido

El Nido is a charming private, single storey Spanish styled property,with high ceilings and clay floor tiles throughout. An open-plan living, dining and kitchen area forms one section of the “L shap...

3 2.5
Theron House,

Beautiful two storey open plan, 5 bed house, 5.5 bathroom house with an office, indoor court yard, lush gardens 

5     5.5
Charingworth

Luxury Villa with 3 bedrooms, 2½ bathrooms, wrought-iron throughout house and J.E.24 hour Security system.Upstairs is 3 air-conditioned bedrooms with ceiling fans and closets. The...

3 2.5

Villas 28 - 37 of 45

Show: