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 31 - 41 of 45

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

Villas 31 - 41 of 45

Show: