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
Lemon Circle 380 is an extended single storey property with 3 bedrooms & 2 bathrooms located on a lot sized 5,745sqft in a quite and desireable neibourhood.As you enter the gates and walk on ...
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...
A two-bedroom apartment complex offers units with two separate bedrooms, shared living areas, and is ideal for roommates, small families, or those needing extra space,Status: FOR SALELocatio...
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...
RECENTLY REDUCEDThis Clerview Heights property is a fully furnished single storey, 3 bed 2 bathroom house for sale, in the established residential neighbourhood of Clerview in St James/Mich...
Grazettes Main Rd, Lot 29 Third Avenue, St Michael.
** Recently Reduced ** Lot 29 Third Avenue, Grazettes, is an older property with lots of potential and scope for development. Some DIY work is needed to bring the property back to its forme...
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...
2 
