All properties   in South Coast - Jervis Bay NSW
Prices shown for Sunday, 21 Jan 2018 to Sunday, 21 Jan 2018

`

Page 2 of 2

Holiday Home

Chapman Cottage

Callala Bay, South Coast - Jervis Bay NSW

Chapman Cottage is a comfortable beach cottage only 250m from the blue waters of Jervis Bay, park & boat ramp.

  •  7 
  •  4 
  •  2 
Holiday Home

Warra

Culburra Beach, South Coast - Jervis Bay NSW

'Warra' is a quaint and cosy cottage, in a quiet street offering beautiful views of the area.

  •  9 
  •  6 
  •  2 
Holiday Home

Comarong Cottage

Greenwell Point, South Coast - Jervis Bay NSW

This delightful two bedroom cottage in a quiet location is perfect for a weekend away, a short break or the school holidays.

  •  7 
  •  3 
  •  2 
Holiday Home

Beach Cottage

Callala Beach, South Coast - Jervis Bay NSW

Beach Cottage is fully fenced which is absolutely perfect for children or pets, with plenty of yard for all to enjoy a game of cricket, soccer, football etc.

  •  6 
  •  4 
  •  2 
Holiday Acreage

Bay and Basin Boutique Pet Boarding

St Georges Basin, South Coast - Jervis Bay NSW

Unique 2 acre property cosy private room Queen bed quality linen & tv or a twin single room.

  •  4 
  •  3 
  •  1 
  •  2 
  •  1 
  • Pets allowed inside
Property Search




Price/Night:  -

Guests:  -

Beds:  -

Dogs:  -

Cats:  -

Horses:  -

Birds:  -

Choose desired features

Sort results by

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