SELECT
node.nid as nid, node.title as ptitle , min(content_type_property.field_sale_min_amount) as NR , min(content_type_property.field_sale_max_amount) as NR_max, content_type_property.field_property_ispor_value as POR
FROM node 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 inner join term_node tn on (tn.nid=node.nid) inner join term_data td on (tn.tid=td.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 = 3) AND (newlist_td.tid = 497) GROUP BY node.nid ORDER BY POR ASC, NR ASC, NR_max ASC
This large triangular shaped lot measures approximately 20,000sqft and is situated within the exclusive Apes Hill Polo Estate giving access to the Apes Hill Golf Course and Polo Club with its fir...
Neptune Close, is a four bedroom three bathroom property with a single car garage, set in a quiet residential road in the heart of St Philip.This property is in immaculate condition, tastefully furnis...
Located in the quiet cul-de-sac and residential area of Crystal Heights, St James is this large single storey, 4 bed 3 bath, fully tiled, open plan home with high ceilings, bars on all windows and spa...
Lodge Gardens is located near the popular Warrens area and is an exclusive gated community consisting of three spacious well appointed townhouses.Lodge Garden townhouse #1 comprises 2 bedrooms and 2.5...
Costa Vista a set of 7 town houses set on the west coast with communal pool and panoramic ocean vews, peaceful central location, 5 min Walk to beach, sleeps 8 (4 Bedrooms)Costa Vista 3 has three floor...
Your chance to purchase this unique investment duplex / townhouse property.Two modern townhouses / Duplex are being offered for sale as one remarkable property. Each offering two bedrooms 1.5 ba...
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 ...
Prime residential ridge plot with panoramic views located in a quiet, breezy, cul-de-sac measuring 11,070sqft with a gentle slop from east to west and mature plants.The location takes full advantage o...
Platinum Heights. Tucked away in a quiet cul-de-sac is #64, a two storey, 4-bedroom, 3-bathroom stand-a-lone home with a separate 2 bed, 2 bath cottage, separate garage, swiming pool and private manic...