REAL ESTATE SALES
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 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) GROUP BY node.nid ORDER BY POR ASC, NR ASC, NR_max ASC
-
- Sunset Crest, St. James
- Parish: St. James
- Property Status:
For Sale
- Property Type:
Apartment, Residential
- List Price: US$
170,000
- Bedrooms: 1
- Bathrooms: 1
-
- Cove,St. Lucy
- Parish: St. Lucy
- Property Status:
For Sale
- Property Type:
Land
- List Price: US$
175,000
-
- Sunset Crest, Golden Dream 8, St.James
- Parish: St. James
- Property Status:
For Sale
- Property Type:
Apartment, Residential
- List Price: US$
175,000
- Bedrooms: 1
- Bathrooms: 1
-
- Littland,St. Joseph
- Parish: St. Joseph
- Property Status:
For Sale
- Property Type:
Land
- List Price: US$
175,000
-
- Buttals, St. George
- Parish: St. George
- Property Status:
For Sale
- Property Type:
Land, Residential
- List Price: US$
180,000
-
- Flint Hall, St. Michael
- Parish: St. Michael
- Property Status:
For Sale
- Property Type:
House / Villa, Residential, Unfurnished
- List Price: US$
187,500
- Bedrooms: 5
- Bathrooms: 3.5
-
- Content Cot,St. Philip
- Parish: St. Philip
- Property Status:
For Sale
- Property Type:
Land
- List Price: US$
187,500
-
- Walkes Spring Lot B5, St. Thomas
- Parish: St. Thomas
- Property Status:
For Sale
- Property Type:
Land, Residential
- List Price: US$
197,500
-
- Rolling Hills 73, St. George
- Parish: St. George
- Property Status:
For Sale
- Property Type:
Land, Residential
- List Price: US$
197,500
-
- Rolling Hills 78,St. George
- Parish: St. George
- Property Status:
For Sale
- Property Type:
Land, Residential
- List Price: US$
197,500