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

FILTER RESULTS

Villas 1 - 10 of 21
1 2 3

Sugar Hill Tennis Village B305

Sugar Hill Tennis Commuity Resort, Porters, St. James
2 Bedrooms | 2 Baths
Located on the exclusive Sugar Hill Resort Community is penthouse B305. This charming apartment has a flare that sparkles in this prestigious resort.
FROM$200 /NIGHT

Beach View 208

Paynes Bay, St. James
2 Bedrooms | 2 Baths
Beach View is an exciting gated condominium complex on 3 acres located on Barbados’ famed West Coast, just accross the road from the Beach. The elevated position affords views from each apartment of...
FROM$200 /NIGHT

Schooner Bay 112, Moonshine

#112 Schooner Bay, Speightstown
1 Bedrooms | 1.5 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$250 /NIGHT

Sugar Hill Tennis Village B306

Sugar Hill Tennis Commuity Resort, Porters, St. James
2 Bedrooms | 2 Baths
Sugar Hill is an exclusive gated resort community featuring stunning views over the Caribbean. Located in the parish of St. James, Sugar Hill's Colonial-style clubhouse has its own 2000 sq. ft. pool, ...
FROM$250 /NIGHT

Schooner Bay 114, Amoré

Speightstown, St. Peter
1 Bedrooms | 2 Baths
Amore at Schooner Bay is part of the most luxurious beachfront condominiums on the exclusive West Coast of Barbados. The lush tropical gardens surround the large free form swimming pool along with dir...
FROM$250 /NIGHT

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

Sugar Hill Tennis Village B107

Sugar Hill Tennis Resort, St. James
2 Bedrooms | 2 Baths
A beautiful privately owned 2 bedroom, 2 bathroom villa apartment located in the exclusive resort community of Sugar Hill on the spectacular West Coast of Barbados. Facilities include two swimming poo...
FROM$300 /NIGHT

Sugar Hill Tennis Village E119, Palm Sugar

Sugar Hill, St. James
4 Bedrooms | 3 Baths
Sugar Hill Village E119 is a charming 4 bedroom townhouse located on the exclusive Sugar Hill Resort Community in St James on the west coast of Barbados.  The Sugar Hill Resort is a private gated...
FROM$400 /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

Old Trees 3, Halcyon

Paynes Bay, St. James
2 Bedrooms | 2 Baths
Tranquility, luxury, exquisite sea views – these are the essence of Old Trees. Set on one of Barbados’ most magnificent West Coast beaches just south of Sandy Lane Hotel, these exciting beachfront...
FROM$600 /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