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 content_field_short_term_lifestyle lifestyle ON node.vid = lifestyle.vid 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 node Rnode ON RR.nid = Rnode.nid LEFT JOIN content_type_property ON node.vid = content_type_property.vid WHERE node.status <> 0 AND Rnode.status <>0 AND node.type = 'property' and (td.vid=1) and (td.tid = 1) AND (lifestyle.field_short_term_lifestyle_value = 287) AND (content_type_property.field_island_value = '169') GROUP BY node.nid ORDER BY NR ASC
FOUND 26 Villas SORT RESULTS BY

FILTER RESULTS

Villas 11 - 20 of 26
1 2 3

Half Century House, Sugar Hill

Plantation Drive, Sugar Hill, St. James
6 Bedrooms | 6.5 Baths
An inviting Barbados luxury villa located in the Sugar Hill Resort Community, Half Century House commands a breathtaking view of the Caribbean Sea. On the interior, tasteful, neutral tones interplay w...
FROM$1,000 /NIGHT

Alila, Sandy Lane

Sandy Lane Estate
4 Bedrooms | 4 Baths
Designed by accomplished architect, Michael Gomes, Alila is nothing short of an exclusive luxury retreat. Themed with Balinese-inspired elements in earthy hues with pops of colour in the bedrooms, the...
FROM$1,350 /NIGHT

Halle Rose

Sandy Lane, St. James
6 Bedrooms | 6 Baths
Located near the West Ridge of the prestigious Sandy Lane estate in Barbados is the intriguing Halle Rose. A surprisingly spacious yet intimate six-bedroom colonial style property, this charming ...
FROM$1,450 /NIGHT

Rose of Sharon

Sandy Lane Estate,Sandy Lane, St. James
6 Bedrooms | 6 Baths
Rose of Sharon has once more undergone a further refurbishment in recent months.  Rose of Sharon is a six bedroom house upgraded to a AAA standard with all bedrooms having en suite bathrooms. The...
FROM$1,450 /NIGHT

The Westerings, Royal Westmoreland

12 Ocean Drive, Royal Westmoreland, St. James
6 Bedrooms | 6 Baths
  A most prestigious colonial style Caribbean holiday villa located in the exclusive Royal Westmoreland resort, Barbados, with stunning views across the golf course to the turquoise blue of the C...
FROM$1,800 /NIGHT

Landmark House and Cottage, Sandy Lane Beach

Sandy Lane
6 Bedrooms | 7 Baths
Landmark House is one of only three villas situated directly on the exclusive Sandy Lane Beach, the premier location along Barbados’ platinum coast. Set within a tropical garden it is a most strikin...
FROM$1,800 /NIGHT

Bluff House, Sandy Lane

Sandy Lane, St. James
6 Bedrooms | 6 Baths
Bluff House is an impressive luxury villa with private, direct access to the legendary Sandy Lane beach. Set in over an acre of mature tropical gardens, this property has recently been enlarged and be...
FROM$2,530 /NIGHT

Horizons, Sandy Lane

South Road, Sandy Lane, St. James
7 Bedrooms | 6.5 Baths
Located within a quiet cul-de-sac on the grounds of the prestigious Sandy Lane Estate is Horizons, an outstanding villa set out over 10,000 square feet, surrounded by two acres of beautifully landscap...
FROM$2,750 /NIGHT

Windward

Sandy Lane, St. James
5 Bedrooms | 5 Baths
Windward is a private 5-bedroom luxury villa for rent on the exclusive Sandy Lane Estate on Barbados’ West Coast, with its own fully equipped, air-conditioned gym, media room and swimming pool. Idea...
FROM$3,000 /NIGHT

St. Helena

Old Queens Fort, St. James
8 Bedrooms | 8.5 Baths
St. Helena offers guests a unique feeling of the Old Colonial Style of living. This beautiful beach house is nestled within lush tropical gardens and the white, sandy shores of a picturesque West Coas...
FROM$3,000 /NIGHT

ABOUT US:

Altman Real Estate Group is a full service real estate provider specializing in luxury property for sale and holiday villa rentals in Barbados and the Caribbean. For more than 40 years, we have developed a reputation for delivering first-class service to our clients around the globe who seek to invest in Caribbean real estate. Our core services include property for sale, holiday rentals, long-term rentals, property management, property consulting, and commercial property for sale and rent.

We offer clients the finest selection of properties on the island, especially on the sought-after West Coast. These include magnificent luxury villas, historic plantation homes, beachfront condos and Barbados lifestyle developments such as: Apes Hill, Lion Castle, Royal Westmoreland, Sugar Hill Resort, Sandy Lane Estate, Port Ferdinand, Port St. Charles and Saint Peter’s Bay.

Our qualified team of agents and professionals are on hand to expertly guide you through your search for the ideal Barbados property to your unique lifestyle.

Altman Real Estate is an international affiliate of Savills

        
Copyright © 2015 Altman Barbados. All Rights Reserved