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
St. Silas HeightsLocated within the highly desirable residential neighbourhood of St. Silas Heights, this level lot comprises approximately 12,000 sq.ft and permissions would allow a two-storey reside...
This is a well balanced and well proportioned two storey duplex, located in a quiet area between Bular & Union St Phillip.As you look at the property unit 3b is on the right. The open plan design ...
This is a well balanced and well proportioned two storey duplex, located in a quiet area between Bular & Union St Phillip.As you look at the property unit 3a is on the left. The open plan design c...
This one bedroom apartment is on the first floor of The Golden Haven Condo block. which is located on the west coast with sea views, overlooking the brand new car park behind the new Massy Supermarket...
This well appointed fixer upper, single storey, stand alone property is located on approx 5,500sqft of land in a quiet residential cul-de-sac. It is listed at $400,000 negotiab...
Situated in a breezy location on slopping land with stunning views overlooking the rolling hills of St George, Christ Church and the sea.Lot55 is located in a cul de sac, allowing for good privacy wit...
This brand new development consists of 10 x very well priced single storey 2 bed / 2 bathroom homes with garage. Located in Lower Cartes Gap, Christ Church it is only minuets away from Miami beach and...
The Sands (Sandy Bay) Worthing, Christ Church, Barbados
Located on 2.48 acres of stunning beachfront, The Sands delivers stylish Condo-Hotel Living ACCOMMODATION SCHEDULE 7 x Studio units20 x One-bed units38 x Two-bed duplex/lofted units12 ...
1.5 
