All properties   in Hunter NSW
Prices shown for Friday, 21 Jul 2017 to Friday, 21 Jul 2017



Luxury Pet Friendly Accommodation in the Hunter Valley, NSW

When you're looking to travel with your family's furry friend, make sure you stay in absolute comfort.   More...

`

Page 1 of 1

Holiday Acreage

Roscrea Homestead

Glen William, Hunter NSW

Roscrea Homestead is set in a private and tranquil setting, on a working beef cattle property at Glen William on the banks of the picturesque Williams River.

  •  12 
  •  7 
  •  2 
Holiday Home

The Homestead @ The Vintage Resort

Rothbury, Hunter NSW

At The Homestead you are right in the action and located in the prestigious Vintage Resort and Golf Complex, next door to Bimbadgen Estate (so handy for concerts).

  •  6 
  •  3 
  •  2 
Holiday Acreage

The Ponderosa on Merewether

North Rothbury, Hunter NSW

At The Ponderosa you are right near the freeway exit/entry, close to shops and just up the way from the Vineyards.

  •  6 
  •  3 
  •  2 
Holiday Home

O'Shea Cottage @ Vineyard Grove

Cessnock, Hunter NSW

Single Level, Spacious as new 4br Home just a short hop to Vineyards, Shops, Restaurants, and Clubs.

  •  10 
  •  4 
  •  2 
Holiday Home

Loxley Cottage

Allandale, Hunter NSW

Beautiful brand new, free-standing cottage on a one acre fenced paddock, perfect for the family holiday or a weekend escape with friends, located on one hundred acres of open fields and woodlands in Lovedale.

  •  10 
  •  6 
  •  2 
Holiday Acreage

Wedge-tail Loft @ Red Belly Farm

Ellalong, Hunter NSW

Wedge-tail Loft (1br) & Wallaby Cottage (3br) are located on Red Belly Farm in the Hunter Valley - The views from Wedge-tail Loft need to be seen to be believed.

  •  3 
  •  3 
  •  2 
Holiday Acreage

Marrowbone Homestead on the Hilltop

Cessnock, Hunter NSW

Marrowbone Homestead on the Marrowbone is a comfortable and clean Country Cottage offering 4 bedrooms, 2-3 bathrooms, wood fire and swimming pool all located close to the vineyards and Cessnock CBD which is The perfect location for a family getaway, girls weekend, golfers base, sleeping 10.

  •  9 
  •  7 
  •  2 
Holiday Acreage

Wallaby Cottage Country Escape @ Red Belly Farm

Ellalong, Hunter NSW

Wallaby Cottage Country Escape @ Red Belly Farm, Ellalong, Hunter Valley is an affordable, peaceful paradise which is only a short drive from the main vineyards and all that the Hunter Valley has to offer.

  •  8 
  •  4 
  •  2 
  •  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-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