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_sale_price_amount as POR FROM node INNER JOIN term_node tnd ON node.nid = tnd.nid INNER JOIN term_data tdt ON tdt.tid = tnd.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 (tdt.tid = 73) GROUP BY node.nid ORDER BY POR ASC, NR DESC, NR_max DESC
Real Estate Sales Search | Harry Manning

TRANSLATE THIS WEBSITE  

Toll Free: 1-888-622-6378
 
Toll Free: 0-800-098-8438
Freephone: +353-766060758
International: 1-246-262-8000

Results

41 properties found

Your Search Results: 41 to 41 of 41

Results Per Page:

Go to Page:

Villa Bonita, Prospect Bay, St. James, Barbados

USD 8,000,000.00


Go to Page:

Back to top



Barbados Real Estate Sales

Barbados real estate sales offer new and exciting Villas sales in Barbados, a great choice to meet either your personal holiday needs or for those seeking to enter the luxury Barbados real estate market. Our Barbados real estate reputable contacts include relationships with top island contractors and Barbados real estate property managers throughout Barbados villas for sale. Barbados undervalued Caribbean real estate properties and hard to find owners for non-listed Caribbean real estate. Inquire about top Barbados villa sales listings, from Harry Manning Real Estate Sales Barbados.