Rating Port of Call Restaurant & Function Centre
Port of Call Restaurant & Function Centre
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18286 or tblfeedback.strbusinessname='Port of Call Restaurant &%%semi%% Function Centre' or tblfeedback.strbusinessname='Port of Call Restaurant & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
With seating for up to 150 and room for 300 socialising any size or style of wedding can be arranged. Our wedding co-ordinator is excitedly waiting to assist you. From walking down the aisle at the ceremony to exiting the reception as husband and wife, all can be organised by Port of Call Restaurant and Function Centre.

Rating
Walka Water Works
Oakhampton Heights NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29316 or tblfeedback.strbusinessname='Walka Water Works' or tblfeedback.strbusinessname='Walka Water Works') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stanley Park
Fullerton Cove NSW 2318
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27789 or tblfeedback.strbusinessname='Stanley Park' or tblfeedback.strbusinessname='Stanley Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marina Views Function Centre
Wickham NSW 2293
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26058 or tblfeedback.strbusinessname='Marina Views Function Centre' or tblfeedback.strbusinessname='Marina Views Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kirkton Park Hunter Valley
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26805 or tblfeedback.strbusinessname='Kirkton Park Hunter Valley' or tblfeedback.strbusinessname='Kirkton Park Hunter Valley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Potters - Hotel. Brewery. Resort
Nulkaba NSW 2325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26725 or tblfeedback.strbusinessname='Potters - Hotel. Brewery. Resort' or tblfeedback.strbusinessname='Potters - Hotel. Brewery. Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peppers Creek, Pokolbin
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21468 or tblfeedback.strbusinessname='Peppers Creek, Pokolbin' or tblfeedback.strbusinessname='Peppers Creek, Pokolbin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Easts Leisure and Golf Club
East Maitland NSW 2323
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26023 or tblfeedback.strbusinessname='Easts Leisure and Golf Club' or tblfeedback.strbusinessname='Easts Leisure and Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Longworth House
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25792 or tblfeedback.strbusinessname='Longworth House' or tblfeedback.strbusinessname='Longworth House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mindaribba house
Mindaribba NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25185 or tblfeedback.strbusinessname='Mindaribba house' or tblfeedback.strbusinessname='Mindaribba house') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peterson House
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27168 or tblfeedback.strbusinessname='Peterson House' or tblfeedback.strbusinessname='Peterson House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Noah's on the Beach
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27179 or tblfeedback.strbusinessname='Noah'%%semi%%s on the Beach' or tblfeedback.strbusinessname='Noah's on the Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wandin Valley Estate
Lovedale NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26462 or tblfeedback.strbusinessname='Wandin Valley Estate' or tblfeedback.strbusinessname='Wandin Valley Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Estate Tuscany
Hunter Valley NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=23119 or tblfeedback.strbusinessname='Estate Tuscany' or tblfeedback.strbusinessname='Estate Tuscany') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hunter Valley Gardens
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18271 or tblfeedback.strbusinessname='Hunter Valley Gardens' or tblfeedback.strbusinessname='Hunter Valley Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Riverwood Downs
Monkerai NSW 2415
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27886 or tblfeedback.strbusinessname='Riverwood Downs' or tblfeedback.strbusinessname='Riverwood Downs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Greenfield Farm Estate
Martinsville NSW 2265
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25632 or tblfeedback.strbusinessname='Greenfield Farm Estate' or tblfeedback.strbusinessname='Greenfield Farm Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cypress Lakes Golf & Country Club
Polkobin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27001 or tblfeedback.strbusinessname='Cypress Lakes Golf &%%semi%% Country Club' or tblfeedback.strbusinessname='Cypress Lakes Golf & Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Customs House Hotel
Newcastle NSW 2300
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=8883 or tblfeedback.strbusinessname='Customs House Hotel' or tblfeedback.strbusinessname='Customs House Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Catherine Hill Bowling Club
Catherine Hill Bay NSW 2281
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26097 or tblfeedback.strbusinessname='Catherine Hill Bowling Club' or tblfeedback.strbusinessname='Catherine Hill Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Green House Eatery
Medowie NSW 2318
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27936 or tblfeedback.strbusinessname='The Green House Eatery' or tblfeedback.strbusinessname='The Green House Eatery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brown Sugar Resturant & Functions
Warners Bay NSW 2282
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26536 or tblfeedback.strbusinessname='Brown Sugar Resturant &%%semi%% Functions' or tblfeedback.strbusinessname='Brown Sugar Resturant & Functions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Racine Restaurant
Nashdale NSW 2800
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=24455 or tblfeedback.strbusinessname='Racine Restaurant' or tblfeedback.strbusinessname='Racine Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wandin Valley Estate
Lovedale NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21553 or tblfeedback.strbusinessname='Wandin Valley Estate' or tblfeedback.strbusinessname='Wandin Valley Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Point Restaurant
Soldiers Point NSW 2317
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26250 or tblfeedback.strbusinessname='The Point Restaurant' or tblfeedback.strbusinessname='The Point Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Maitland City Bowling Club Ltd
Rutherford NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10334 or tblfeedback.strbusinessname='Maitland City Bowling Club Ltd' or tblfeedback.strbusinessname='Maitland City Bowling Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wallalong House
Wallalong NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27462 or tblfeedback.strbusinessname='Wallalong House' or tblfeedback.strbusinessname='Wallalong House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adams Peak Country Estate
Broke NSW 2330
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29481 or tblfeedback.strbusinessname='Adams Peak Country Estate' or tblfeedback.strbusinessname='Adams Peak Country Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Swansea RSL
Swansea NSW 2281
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26853 or tblfeedback.strbusinessname='Swansea RSL' or tblfeedback.strbusinessname='Swansea RSL') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Redhead Surf Lifesaving Club
Redhead NSW 2290
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27287 or tblfeedback.strbusinessname='Redhead Surf Lifesaving Club' or tblfeedback.strbusinessname='Redhead Surf Lifesaving Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Calvin Estate
Luskintyre NSW 2321
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26303 or tblfeedback.strbusinessname='Calvin Estate' or tblfeedback.strbusinessname='Calvin Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Circa 1876
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=23699 or tblfeedback.strbusinessname='Circa 1876' or tblfeedback.strbusinessname='Circa 1876') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Sebel Spa and Resort (Winsdor)
Windsor NSW 2756
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21642 or tblfeedback.strbusinessname='The Sebel Spa and Resort (%%semi%%Winsdor)%%semi%%' or tblfeedback.strbusinessname='The Sebel Spa and Resort (Winsdor)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hunter Resort Hunter Valley
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=9765 or tblfeedback.strbusinessname='Hunter Resort Hunter Valley' or tblfeedback.strbusinessname='Hunter Resort Hunter Valley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Harrigans Irish Pub
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29217 or tblfeedback.strbusinessname='Harrigans Irish Pub' or tblfeedback.strbusinessname='Harrigans Irish Pub') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Weddings at mirannie
Mirannie NSW 2330
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25994 or tblfeedback.strbusinessname='Weddings at mirannie' or tblfeedback.strbusinessname='Weddings at mirannie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mystwood Retreats
Wollombi NSW 2325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=24574 or tblfeedback.strbusinessname='Mystwood Retreats' or tblfeedback.strbusinessname='Mystwood Retreats') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Broughtons at the Bay
Nelson Bay NSW 2315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27034 or tblfeedback.strbusinessname='Broughtons at the Bay' or tblfeedback.strbusinessname='Broughtons at the Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Merewether Surfhouse
Merewether Beach NSW 2291
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21900 or tblfeedback.strbusinessname='Merewether Surfhouse' or tblfeedback.strbusinessname='Merewether Surfhouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Little Beach Boathouse
Nelson Bay NSW 2315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=35848 or tblfeedback.strbusinessname='Little Beach Boathouse' or tblfeedback.strbusinessname='Little Beach Boathouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tamburlaine Organic Wines
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26405 or tblfeedback.strbusinessname='Tamburlaine Organic Wines' or tblfeedback.strbusinessname='Tamburlaine Organic Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Club Macquarie Argenton
Argenton NSW 2284
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25069 or tblfeedback.strbusinessname='Club Macquarie Argenton' or tblfeedback.strbusinessname='Club Macquarie Argenton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chateau Elan at The Vintage
Rothbury, Hunter Valley NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=21392 or tblfeedback.strbusinessname='Chateau Elan at The Vintage' or tblfeedback.strbusinessname='Chateau Elan at The Vintage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gibraltar Country Club
Bowral NSW 2576
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26197 or tblfeedback.strbusinessname='Gibraltar Country Club' or tblfeedback.strbusinessname='Gibraltar Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shoal Bay Country Club
Shoal Bay NSW 2315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=39911 or tblfeedback.strbusinessname='Shoal Bay Country Club' or tblfeedback.strbusinessname='Shoal Bay Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peterson House
Pokolbin NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25178 or tblfeedback.strbusinessname='Peterson House' or tblfeedback.strbusinessname='Peterson House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tocal Homestead
Paterson NSW 2421
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=24945 or tblfeedback.strbusinessname='Tocal Homestead' or tblfeedback.strbusinessname='Tocal Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Botanic Gardens Hunter Region
Heatherbrae NSW 2324
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=8298 or tblfeedback.strbusinessname='Botanic Gardens Hunter Region' or tblfeedback.strbusinessname='Botanic Gardens Hunter Region') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peacock Palace Chinese Restaurant
Warners Bay NSW 2282
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10874 or tblfeedback.strbusinessname='Peacock Palace Chinese Restaurant' or tblfeedback.strbusinessname='Peacock Palace Chinese Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Westside Golf & Recreational Centre (Maitland)
Rutherford NSW 2320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=12016 or tblfeedback.strbusinessname='Westside Golf &%%semi%% Recreational Centre (%%semi%%Maitland)%%semi%%' or tblfeedback.strbusinessname='Westside Golf & Recreational Centre (Maitland)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 129 Sort search results alphabetically