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 = 40) AND (content_type_property.field_island_value = '169') GROUP BY node.nid ORDER BY NR ASC
FOUND 37 Villas SORT RESULTS BY

FILTER RESULTS

Villas 11 - 20 of 37
1 2 3 4

Schooner Bay 201- Flamboyant

Speightstown, St. Peter
2 Bedrooms | 2 Baths
Schooner Bay is one of the most luxurious beachfront condominiums on the exclusive west coast of Barbados. The development is set on a secluded beach in a wonderfully picturesque setting and the apart...
FROM$350 /NIGHT

Villas on the Beach 201

3 Bedrooms | 4 Baths
Villas on the Beach is located on a beautiful West Coast beach in the heart of Holetown, St. James and sits in an oasis of beautifully landscaped tropical gardens.  Just a few steps from the fron...
FROM$375 /NIGHT

Villas on the Beach 103

2 Bedrooms
Villas on the Beach is located on a beautiful West Coast beach in the heart of Holetown, St. James and was designed by well known architect, Ian Morrison.  This idyllic holiday spot is just a sho...
FROM$380 /NIGHT

Reeds House Penthouse 13

Weston, St. James
2 Bedrooms | 2 Baths
*Roofdeck Patio *On the Beach *Wet Bar on Rooftop Reeds House is ideally situated directly on the white sandy beaches of Reeds Bay in an exotic tropical garden setting. The crystal clear waters of the...
FROM$450 /NIGHT

Emerald Beach 1 Solandra

Gibbes Beach, St. Peter
3 Bedrooms | 3 Baths
  One of just six luxury villas wonderfully sited on Gibbs Bay in over an acre of landscaped gardens. Each villa has three generously large air-conditioned bedrooms, two on the upper level and on...
FROM$650 /NIGHT

Saint Peter's Bay

Hwy 1B, Little Battaleys, St. Peter
Situated on a beautiful stretch of Barbados’ famed west coast, Saint Peter’s Bay offers a selection of stunning ocean front homes for vacation rental and an array of amenities and services to make...
FROM$675 /NIGHT

Reeds House Penthouse 12

Weston, St. James
3 Bedrooms | 3 Baths
Reeds House is a beachfront apartment/condominium, located in Reeds Bay, St. James, on the idyllic West Coast of Barbados.  Situated between the Royal Pavillion and Cobblers Cove hotels it is in ...
FROM$695 /NIGHT

Emerald Beach 4 Plumbago

Gibbes, St. Peter
3 Bedrooms | 3.5 Baths
One of just six luxury villas wonderfully sited on Gibbs Bay in over an acre of landscaped gardens. Each villa has three generously large air-conditioned bedrooms, two on the upper level and one of th...
FROM$700 /NIGHT

Emerald Beach 3 Ixoria

Gibbes Beach, St. Peter
3 Bedrooms | 3 Baths
Just six luxury villas wonderfully situated on Gibbs Bay in over an acre of landscaped gardens. Each villa has three generously large air-conditioned bedrooms, two on the upper level and one on the gr...
FROM$700 /NIGHT

Emerald Beach 6 Cassia

Gibbes Beach, St. Peter
3 Bedrooms | 3 Baths
One of just six luxury villas wonderfully situated on Gibbs Bay in over an acre of landscaped gardens. Each villa has three generously large air-conditioned bedrooms, two on the upper level and one on...
FROM$700 /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