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
44 Properties found

Villas 1 - 9 of 44

Show:
Jamestown Park No 3

Jamestown Park is small development of five two storey town housses, located in the heart of holetown in a quiet cul-de-sac.As you enter the livingroom of this fully tiled 2 bedroom, 2.5 bathroom ...

2 2.5
Mariposa House

Located in St Peter Gibbs Hill Miriposa house is a luxury three bedroom 2.5 bathroom property complete:swimming pool, sea views,  mature gardens, inland countryside views, luxury spa style bathro...

3     2.5
Warrens Commercial Rental

Substantial office space available

Emerald Park West Apt A

Newly referbished ground floor apartment tiled throughout has own enterance, parking, garage and garden area all located just off the main round-a-bout at Six Roads, St Phillip. This property offers a...

3     2
Emerald Park West Apt B

Newly referbished first floor apartment tiled throughout has country views, own enterance, parking and garden area all located just off the main round-a-bout at Six Roads, St Phillip.This propert...

3 1
Maycocks Bay Development #55

Detached 3 bed 2 bath corner house is partly furnished in nice area cloae to sea. the property is clean bright and tiled thoughout.  

3     2
Clerview Heights #2, Stage 3

This is an unfurnished, single storey, 3 bed 2 bathroom house for rent in an established residential neighbourhood on the St Michael/St james boarders close to Queens College and the Warrens developme...

3 2
Royal View

Royal View is a local 5 bedroom, 4 bathroom Barbadian style home which has been modenised and redeveloped over the years. It is set on approx 8,848 sqft of land and located close to the award winn...

2     2
Clermont Gardens, Lot D, Ground Floor Apt,

Clermont Gardens lot D is a large two storey building comprising of 2 x 3 bed apartments with buit in garage.The property is located in a quiet residential road of Clermont, it has the benefits of gre...

3 2
Clerview Heights, Stage 1 #48

This Clerview Heights property is a fully furnished single storey, 3 bed 2 bathroom house for rent, in the established residential neighbourhood of Clermont in St James/Michael boarders close to ...

3     2

Villas 1 - 9 of 44

Show: