All properties   in Northern Rivers - Kingscliff NSW
Prices shown for Sunday, 23 Jul 2017 to Sunday, 23 Jul 2017

`

Page 1 of 1

Holiday Home

Orchid On Kamala

Casuarina, Northern Rivers - Kingscliff NSW

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 NSW

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 NSW

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 NSW

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 NSW

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 NSW

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

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