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 location_tn ON node.nid = location_tn.nid INNER JOIN term_data location_td ON location_td.tid = location_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_field_citizenship ON node.vid = content_field_citizenship.vid 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 (location_td.tid = 326) GROUP BY node.nid ORDER BY `content_type_property`.`field_sale_min_amount` DESC , NR ASC, NR_max ASC
Real Estate Sales Search | Nevis Style Realty
Nevis Style Realty

Results

15 properties found

Your Search Results: 1 to 15 of 15



St. Kitts and Nevis Real Estate Sales

Buying real estate on St Kitts or Nevis may be an astute investment, a lifestyle choice, or the culmination of a lifelong dream. Whatever your motivation, Nevis Style Realty will find the perfect property for you. In addition to our purchasing and listing services, our real estate expertise ensure that all legal aspects of buying, selling or renting homes are covered. Furthermore, we offer property management, holiday rentals, and car rental services with our sister company, Nevis Auto Rental Ltd.

OFFICE : 1-869-469-1120

INTERNATIONAL : 1-305-705-3345