All properties   in Gold Coast QLD
Prices shown for Sunday, 23 Jul 2017 to Sunday, 23 Jul 2017

`

Show map

Page 1 of 1

Fun Heaven Waters

Holiday Home

Fun Heaven Waters

Broadbeach Waters, Gold Coast QLD

~ COMFORTABLY SLEEPS UP more than 16

~ HOSTESS KITCHEN

~ GORGEOUS POOL

~ SUPERB OUTDOOR ENTERTAINING BBQ OVER LOOKING POOL AND CANAL

~ FREE WI-FI

~ CENTRAL TO PACIFIC FAIR SC, BEACHES, ROBINA SC, GOLF CLUBS, CONVENTION CENTRE, CASINO & THEME PARKS

~ OFF STREET PARKING

Better Offer: Match your lowest quote with similar property

Perfect accommodation for larger or combined family with 4 bedrooms and 2 bathrooms comfortably sleeping a maximum of 16 this home oozes quality throughout

Stunning open plan living space with a modern well equipped central kitchen, large dining area and huge two living room with TV, DVD which leads out to a large undercover timber decking with outdoor dining overlooking the EAST-north facing swimming pool and canal.

  •  20 
  •  18 
  •  2 
  • Pets allowed inside
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