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:
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 - 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
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: