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 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 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 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...
Rolling Hills, Lot 55 Golden Palms, Byde Mill, St George
LAND FOR SALE - Rolling Hills St George This lot measures approx. 16,000 sqft of residential land which slopes from north to south and is roughly rectangular in shape. The lot is fully serviced w...
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 ...
Unit 24 is a quaint and cozy 3 bedroom, 2 bathroom townhouse, located in the Foursquare cluster which houses the best swimming pool of all the clusters within Rockley Resort. As you enter the liv...