All properties   in Cairns Barrier Reef QLD
Prices shown for Friday, 21 Jul 2017 to Friday, 21 Jul 2017

`

Page 1 of 2

Holiday Home

Lilypad

Palm Cove, Cairns Barrier Reef QLD

Elegant Executive Oceans Edge Holiday Home

The contemporary design together withthe indoor/outdoor spaces, evoke a lifestyle of simple elegance and informality.

  •  6 
  •  4 
  •  2 
  • Pets allowed inside
Holiday Home

Kewarra Beach Retreat 2

Cairns, Cairns Barrier Reef QLD

150 METRES TO THE BEACH, PET FRIENDLY, PRIVATE

Set behind private gates Kewarra Beach Retreat offers 2 neat stylish fully equipped beachside retreats.

  •  6 
  •  5 
  •  2 
  • Pets allowed inside
Holiday Home

Kewarra Beach Retreat 1

Cairns, Cairns Barrier Reef QLD

PRIVATE, PET FRIENDLY AND ONLY A SHORT STROLL TO THE BEACH

Set Behind private gates Kewarra Beach Retreat is a neat stylish fully equipped beachside retreat.

  •  6 
  •  3 
  •  2 
Holiday Home

Villa Koh Lanta @ Palm Cove

Cairns, Cairns Barrier Reef QLD

Inviting and refreshing, superb VALUE holiday accommodation.

  •  9 
  •  5 
  •  2 
Holiday Home

Trinity Breezes @ Trinity Beach

Trinity Beach, Cairns Barrier Reef QLD

Comfortable Beachside Getaway, Pet Friendly with Room for all the Family

Trinity Breezes holiday home is just 75 meters from popular Trinity Beach and the many restaurants and eateries it has to offer.

  •  9 
  •  6 
  •  2 
Holiday Home

Serendipity

Trinity Beach, Cairns Barrier Reef QLD

Pet Friendly Family Beach House a short walk to beautiful Trinity Beach

Located 2 streets back from the beach and an easy 650 metres or 3 minute walk to the patrolled swimming area of Trinity Beach is this 4 bedroom, 2 bathroom beach house.

  •  8 
  •  4 
  •  2 
Holiday Home

Kintamani Holiday Villa

Cairns, Cairns Barrier Reef QLD

The true art of relaxation

The only decision you need to make is .

  •  8 
  •  5 
  •  2 
Holiday Home

Beachcomber @ Trinity Beach

Trinity Beach, Cairns Barrier Reef QLD

TRINITY BEACH FAMILY HOLIDAY HOME A SHORT STROLL TO THE BEACH

The Ray White Cairns Beaches Holiday Collection is proud to present this tropical family holiday home, complete with outdoor swimming pool and spa.

  •  10 
  •  5 
  •  2 
  •  2 
Holiday Home

Latania Holiday Villa @ Palm Cove

Trinity Beach, Cairns Barrier Reef QLD

Sophisticated and stylish, designed specifically for the ultimate tropical experience.

  •  8 
  •  4 
  •  2 
  •  2 
Holiday Home

Laguna Retreat

Trinity Beach, Cairns Barrier Reef QLD

Stylish holiday home only a 5 minute stroll to the beach

Elegance and style;- Laguna Retreat the perfect holiday getaway home.

  •  8 
  •  6 
  •  2 
  •  2 
Property Search




Price/Night:  -

Guests:  -

Beds:  -

Dogs:  -

Cats:  -

Horses:  -

Birds:  -

Choose desired features

Sort results by

Featured properties
SELECT P.propertyID, P.name, P.description, P.pets_policy, P.reasons_to_stay, P.suburb, P.state, R.region, PT.description AS property_type, P.guests, P.beds, P.dogs, P.cats, P.horses, P.birds, P.fenced, LL.lat, LL.lng, prices.min_price, P.booking_system, P.booking_URL, C.apply_HP_fee_to_rates FROM properties as P WITH (NOLOCK) INNER JOIN customers C WITH (NOLOCK) ON C.customerID = P.customerID INNER JOIN property_types PT WITH (NOLOCK) ON P.property_type = PT.typeID LEFT OUTER JOIN (SELECT PP.propertyID, min(PP.seven_night) AS min_price FROM property_prices_new as PP WITH (NOLOCK) WHERE PP.Date_from <= ? AND PP.Date_to >=? GROUP BY PP.propertyID) prices ON prices.propertyID = P.propertyID JOIN regions as R WITH(NOLOCK) ON R.regionID = P.regionID JOIN property_latlng as LL ON P.propertyID = LL.propertyID WHERE 1=1 AND P.regionID=? AND P.guests>=1 AND P.guests<=50 AND P.Beds<=50 AND P.dogs<=10 AND P.cats<=10 AND P.horses<=10 AND (P.propertyID IN (SELECT property_prices_new.propertyID FROM property_prices_new WITH (NOLOCK) WHERE (Seven_night/7) >= 10 AND (Seven_night/7) <= 5000 AND Date_from <= '2017-07-21' AND Date_to >= '2017-07-21' GROUP BY propertyID )) AND P.status IN (2,4) AND C.customer_type = 1 ORDER BY propertyID DESC