"Let your imagination be our business"

  Video Menu
SELECT node.created as pcreated, node.nid as nid, node.title as ptitle , MIN( NULLIF( RR.field_nightly_rate_amount, 0 ) ) as NR 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_rental_rate RR ON RP.nid = RR.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 = 1) AND (content_type_property.field_island_value = '330') GROUP BY node.nid ORDER BY NR ASC

Villas 1 to 9 of 22

Show: View All
View Fort

Anguilla 

8 Beds | 8.5 Baths

VIEW DETAILS
Cerulean

Anguilla 

9 Beds | Baths

VIEW DETAILS

from
US$100,000/wk

Blue Diamond at Altamer

Anguilla 

Beds | Baths

VIEW DETAILS

from
US$23,500/wk

African Sapphire at Altamer

Anguilla 

Beds | Baths

VIEW DETAILS

from
US$25,000/wk

Antilles Pearl at Altamer

Anguilla 

5 Beds | 5.5 Baths

VIEW DETAILS

from
US$22,500/wk

Tequila Sunrise

Anguilla 

3 Beds | 3.5 Baths

VIEW DETAILS

from
US$900/nt

Ultimacy Anguilla

Anguilla 

8 Beds | 8.5 Baths

VIEW DETAILS

from
US$1,000/nt

Villa Paradise Anguilla

Anguilla 

7 Beds | 7.5 Baths

VIEW DETAILS

from
US$1,200/nt

Beaches Edge East

Anguilla 

5 Beds | 5 Baths

VIEW DETAILS

from
US$1,500/nt

Villas 1 to 9 of 22

Show: View All

Join us at Leviticus Lifestyle & Travel Services

JOIN NOW