Real Estate Sales Listing
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 = 3) AND (content_type_property.field_island_value = '318') GROUP BY node.nid ORDER BY NR ASC
FOUND 4 PROPERTIES SORT RESULTS BY

FILTER RESULTS

Properties 1 - 4 of 4
1
Under Offer

Moonrise, Moonhole

Property ID: AG464
Moonrise is a beautiful eco-friendly villa, just a short stroll away from its own private beach with magical views overlooking Moonhole Bay in Bequia, with the ocean and island of Saint Vincent just b...
$ 350,000
Under Offer

Balliceaux House

Property ID: AG397
A sophisticated house in a uniquely desirable location  
$ 950,000

Seacliff

Property ID: AG295
This is an absolutley faultless, elegantly casual villa in a stunningly beautiful location with panoramic views over Spring Estate, Spring Bay, Crown Point and the off shore islands of Battowia and Ba...
$ 1,150,000

Petite Nevis Island, St. Vincent & the Grenadines

St. Vincent & The Grenadines
Property ID: AG113
Petit Nevis Island is located three hundred yards (300 yards) off the south coast of Bequia. The area is 78 Acres, it's easy access to Bequia and ideal for a Boutique Hotel.
$ 15,000,000

ALTMAN REAL ESTATE GRENADA:

Altman Real Estate Grenada specializes in property sales and rentals and property management and caters to clients’ property interests in Grenada, Carriacou and Petite Martinique. Altman Real Estate also provides well-appointed and exquisitely detailed villas in Grenada. This has helped to make the island one of the top luxury tourist destinations. The island is home to traditional spice plantations and is transitioning into a luxury tourist destination. The tranquility of Grenada attracts a jet-setting crowd searching for the ultimate in rest and relaxation. Now considered home to one of the Caribbean’s finest mega-yacht marinas, Grenada is likely to become a required stop over for well-heeled yachtsmen. Whether you’re seeking land, a private villa, Altman Real Estate has a wide selection of properties for sale and rent to offer.

Altman Real Estate is an international associate of Savills

        
Copyright © 2015 Altman Real Estate Group. All Rights Reserved