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

FILTER RESULTS

Villas 1 - 3 of 3
1
Under Offer

Thespina - Church Point 3

Folkstone, Holetown, St. James
4 Bedrooms | 4 Baths
Located in the exclusive community of Church Point on the West Coast, Thespina is a delightful beachfront Barbados holiday rental. This contemporary beach villa offers a back terrace with several outd...
FROM$850 /NIGHT

Greentails Residence 1

Sion Hill, St. James
4 Bedrooms | 4 Baths
Residence One is located within the exclusive, private and gated Greentails community and offers over 5,000 sq. ft. of elegant and luxurious living space with four en suite bedrooms, a beautiful wrap-...
FROM$1,000 /NIGHT
Under Offer

Kailani

Plum Tree Road, Mahogany Ridge
5 Bedrooms | 5.5 Baths
Kailani is a luxurious 5-bedroom ridge-front villa and cottage located in St. James on the West Coast of Barbados. This elevated position provides stunning panoramic views of the turquoise waters of t...
FROM$2,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