All properties   in Northern Rivers - Kingscliff
Prices shown for Monday, 24 Apr 2017 to Monday, 24 Apr 2017

`

Page 1 of 2

Holiday Home

Mango Tree Cottage

Pottsville, Northern Rivers - Kingscliff

Imagine yourself sitting in a claw foot bathtub enjoying the sweet essence of an argan oil infused warm bath, listening to the sounds of nature, indulging in your favourite glass of wine, and looking onto lush green undulating hills.

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

Holiday Heaven

Hastings Point, Northern Rivers - Kingscliff

Finally a house to chill out in with air conditioning, ceiling fans in every room and a nice big yard for the kids and dog to play in.

  •  8 
  •  3 
  •  2 
Holiday Villa

Clovelly Beach Townhouse

Kingscliff, Northern Rivers - Kingscliff

Clovelly is our best Marine Parade home for you to enjoy.

  •  6 
  •  4 
  •  2 
Holiday Home

Orchid On Kamala

Casuarina, Northern Rivers - Kingscliff

Orchid on Kamala has a beautiful east facing deck to sit back and enjoy those cool summer breezes.

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

Salty Pause @ Bondi

Kingscliff, Northern Rivers - Kingscliff

This new beach themed home is located in the Salt village of Kingscliff and boasts a great position only walking distance to the beach, creek and central park shopping precinct.

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

Slipstream By The Sea

Casuarina, Northern Rivers - Kingscliff

The kitchen is just as you would like in your own home such as coffee plunger, baking ware, BBQ set and loads of glassware for that chilled beer or sparkling white.

  •  8 
  •  5 
  •  2 
Holiday Home

Syd's View

Kingscliff, Northern Rivers - Kingscliff

Syd's View is north facing perched on the edhe of Kingscliff hill making it a short walk to the beach, town centre and newly refurbished Kingscliff Beach Hotel.

  •  8 
  •  4 
  •  2 
Holiday Home

Sandcastles

Fingal Head, Northern Rivers - Kingscliff

Welcome to Sandcastles! From the moment you arrive to this beachside residence, you feel an immediate sense of relaxation.

  •  9 
  •  7 
  •  2 
Holiday Home

Dreamtime

Fingal Head, Northern Rivers - Kingscliff

Welcome to Dreamtime! For the lovers of relaxing in nature, surf, sand and sun this is your ultimate beach frontholiday.

  •  6 
  •  3 
  •  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-04-24' AND Date_to >= '2017-04-24' GROUP BY propertyID )) AND P.status IN (2,4) AND C.customer_type = 1 ORDER BY propertyID DESC