All properties   in South Coast - Jervis Bay
Prices shown for Monday, 24 Apr 2017 to Monday, 24 Apr 2017

`

Page 6 of 6

Holiday Home

Sandy Feet Getaway

Sanctuary Point, South Coast - Jervis Bay

Sandy Feet Getaway is a three bedroom, one bathroom, free standing home in a quite cul-de-sac at Sanctuary Point in the heart of the Jervis Bay area and presents the style and laid back vibe you expect from your perfect South Coast get away.

  •  5 
  •  3 
  •  2 
Holiday Home

Gibson House

Sanctuary Point, South Coast - Jervis Bay

Gibson House is a delightfully decorated four bedroom, two bathroom, free standing home in a quiet residential street in Sanctuary Point in the heart of the Jervis Bay Area.

  •  8 
  •  6 
  •  2 
Holiday Villa

Calm Waters, Cottage 6

Sussex Inlet, South Coast - Jervis Bay

Just refurbed in Sept 2015, Calm Waters Waterfront Cottages are 6 x 1940's Classic Beach Style Cottages with Panoramic water views.

  •  5 
  •  3 
  •  2 
Holiday Home

Calm Waters, Cottage 5

Sussex Inlet, South Coast - Jervis Bay

Calm Waters Cottage 5 Pet Friendly fully fenced yard @ Sussex Inlet is just set back from the water contains 2 bedrooms and is fully self contained with 1 Queen size bed & 1 double Tri Bunk ie with single bunk above the double Sleeps 5, best 2 couples 1 child.

  •  5 
  •  5 
  •  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-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