SELECT node.created as pcreated, node.nid as nid, node.title as ptitle , min(content_type_property.field_sale_min_amount) as NR , min(content_type_property.field_sale_max_amount) as NR_max FROM node 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_property ON node.vid = content_type_property.vid WHERE node.status <> 0 AND node.type = 'property' and (td.vid=1) and (td.tid = 317) GROUP BY node.nid ORDER BY NR ASC


Properties 1 - 10 of 20
1 2
Under Offer

The Savannah Hotel

Parade View, The Garrison
The Savannah Hotel is a world heritage site situated on one of Barbados' beautiful south coast beaches. Sitting on approximately 3.32 acres of land, its prime location offers easy access to dining, sh...
Price on Request

Lower Estate Commercial Lots

Lower Estate, St. Michael
This development consists of sixteen commercial lots ranging in size from 23,715 sq. ft. to 42,222 sq. ft. Conveniently situated in Lower Estate, St. Michael, this site offers easy access to the ABC H...
$ 157,500 - $ 411,669

Ficus Court

Brighton, St Michael
Ficus Court, located at No.1 Brighton  is a single storey concrete and wooden structure located in a predominately commercial area with primarily light manufacturing, warehousing, offices and som...
$ 297,500
Under Offer

10th Avenue Belleville

This commercial building located on 10th Avenue Belleville is in the hub of offices and medical practices on the island, presently used as a dentist office, it is already set-up for this type of pract...
$ 337,500
Under Offer

Maxwell Main Road

A tastefully refurbished and nicely furnished single storey office located along a popular section of the south coast. A sheltered and breezy front patio leads inside to a large executive reception ar...
$ 375,000
Under Offer

Yorkshire House

Strathclyde Drive, St. Michael
REDUCED FROM US $462,500 to  US $397,500.
$ 397,500

Maxwell Main Road

Maxwell, Christ Church
This plot comprises 17,000 sq.ft. of land and is adjacent to the main road and next to Butterfly Beach Hotel, while just a minute’s walk from the beach and in close proximity to St. Lawrence Gap. Th...
$ 425,000

Maple Meadows

Bottom Bay, St. Philip
Situated in a peaceful neighbourhood in Bottom Bay, St. Philip, Maple Meadows consists of 12 bedrooms, each with an ensuite bathroom. In addition, there is a separate, self-contained one-bedroom apart...
$ 750,000


Pine Road, Belleville, St. Michael
Shenstone is found in the Belleville area, originally the setting for numerous established Barbadian homes and now an important commercial district. The main coral stone structure offers three bedroom...
$ 750,000

Oistins, Lot 2

Located on the main road at Oistins, Christ Church is this commercial building opportunity listed for sale.  It consists of approximately 4,500 sq.ft. of covered area and sits on approximately 12...
$ 800,000


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. 足彩优化用什么软件