SELECT DISTINCT *
FROM (`res_properties`)
WHERE  (
`res_properties`.`active` = 1
AND `res_properties`.`plan_id` IS NOT NULL
AND `res_properties`.`plan_id` <> 0
AND `res_properties`.`location_id` IS NOT NULL
AND  (
`res_properties`.`plan_expires` > 1583027433
OR `res_properties`.`plan_expires` = 0
)
AND  (
`res_properties`.`price` > 0
OR `res_properties`.`poa` = 1
)
)
AND `res_properties`.`property_type` = 'rent'
AND `res_properties`.`location_id` IN (4) 
AND `res_properties`.`property_type` = 'rent'
ORDER BY `res_properties`.`ordname` asc LIMIT 0, 200
Luxury Boats | Search results
Found 2 properties
Alani - 82 foot Sunseeker
From $13,000 per night

Alani - 82 foot Sunseeker

4   35   4   0

Welcome to the stunning Alani! This 5 star luxury boat is the perfect way to see the Whitsundays from the water. Based in Hamilton island this impressive 82 foot Sunseeker could be all yours for an afternoon, a whole day or a week! The Alani can accommodate up to 35 guests on a cruise, or up to 9 guests comfortably overnight. There are 4 spacious cabins and a large living area. This boat is for those…

Book Me Details
Awol - 72 foot Lazzarra
From $9,500 per night

Awol - 72 foot Lazzarra

4   8   4   0

The whitsundays can be experienced in a number of different ways, if you're going to do it on the water, why not do it in class on the exclusive Yacht, AWOL. Relax and unwind in the serene environment surrounded by nature’s finest white sandy beaches and crystal clear turquoise water. Whether it be cruising around with friends and family, entertaining VIP guests, anchoring at Whitehaven Beach, one…

Book Me Details
Found 2 properties