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 27 Villas SORT RESULTS BY

FILTER RESULTS

Villas 1 - 10 of 27
1 2 3

Schooner Bay 108 - Chilterns

Speightstown, St. Peter
1 Bedrooms | 2 Baths
Schooner bay is a beachfront condominium that consists of three blocks of apartments with a freeform swimming pool as the focal point. Chilterns is a delightfully spacious one-bedroom, two bathroom ap...
FROM$300 /NIGHT

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

Schooner Bay 105

Speightstown, St. Peter
1 Bedrooms | 1 Baths
Schooner bay is a beachfront condominium that consists of three blocks of apartments with a freeform swimming pool as the focal point. Schooner Bay #105 is a delightfully spacious one-bedroom, two bat...
FROM$350 /NIGHT

Royal Villa 19, Royal Westmoreland

Royal Westmoreland, St. James
3 Bedrooms | 3.5 Baths
This elegant 3-bedroom, the 3.5-bathroom townhouse features an open plan living space and a covered terrace suited to alfresco dining with a peaceful backdrop and tropical garden views; the perfect vi...
FROM$500 /NIGHT
Under Offer

40 Westmoreland Hills

Westmoreland Hills
4 Bedrooms | 4 Baths
Located in the private gated community of Westmoreland Hills, a stone’s throw from the Royal Westmoreland Golf Course and the white sand beaches of the West Coast of Barbados, No. 40 Westmoreland Hi...
FROM$575 /NIGHT

Reeds House Penthouse 12

Weston, St. James
3 Bedrooms | 3 Baths
Reeds House is a boutique beachfront development, blessed with an idyllic tropical location directly on the white sandy beaches of Reeds Bay, on Barbados’ prestigious Platinum Coast. Its unbeatable ...
FROM$695 /NIGHT
Under Offer

Sugar Hill A18 - Paradise Found

Sugar Hill, St. James
4 Bedrooms | 4 Baths
Paradise Found, A18 Sugar Hill is a stylish luxury 4 bedroom villa located in the exclusive Sugar Hill community in St.James on the West Coast of Barbados. This beautiful detached, light, bright and a...
FROM$725 /NIGHT
Under Offer

La Lune

Gibbes Beach, St. Peter
2 Bedrooms | 2.5 Baths
Situated on the platinum coast of Barbados, La Lune is comfortably nestled among several mature trees and lush vegetation on a proud 3/4 acre lot with impressive views of the  the tranquil, glist...
FROM$750 /NIGHT

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

Oceana, Sugar Hill Resort

Lot 11, Ocean Ridge, Sugar Hill Resort Community, St. James
4 Bedrooms | 4 Baths
Overlooking the Caribbean Sea, Oceana is a magnificent four-bedroom estate villa on the prime location of Ocean Ridge in the exclusive gated community of Sugar Hill. Secluded amidst tropical trees and...
FROM$1,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 © 2023 Altman Barbados. All Rights Reserved