All properties   in Fleurieu Peninsula SA
Prices shown for Tuesday, 30 May 2017 to Tuesday, 30 May 2017

`

Show map

Page 1 of 1

Sugar Shack

Holiday Home

Sugar Shack

Middleton, Fleurieu Peninsula SA

Your typical Aussie Beach Shack located near one of South Australia's premier Surf Beaches and winter home for Southern Right Whales.

  •  10 
  •  6 
  •  2 
Sea Side Escape

Holiday Home

Sea Side Escape

Port Elliot, Fleurieu Peninsula SA

This is a perfectly located gem provides the all the mod cons whilst keeping within the beautiful historic appearance of the Fleurieu Peninsula.

  •  7 
  •  3 
  •  2 
Bailey Breakaway

Holiday Home

Bailey Breakaway

Middleton, Fleurieu Peninsula SA

Bailey Breakaway is located an easy 5 minutes stroll to Middleton Point and the popular Middleton beaches.

  •  9 
  •  5 
  •  2 
The Purple Haze

Holiday Home

The Purple Haze

Encounter Bay, Fleurieu Peninsula SA

The Purple Haze is located 100 metres to the sea front at Encounter Bay with glimpses of the sea.

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