Home > Reception Venue Eyre Pensinsula

Reception Venue Eyre Pensinsula

9 result(s) found. View Your Favorites List

Moonta SA 5558

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=46039 or tblfeedback.strbusinessname='Redwing Farm' or tblfeedback.strbusinessname='Redwing Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Tickle Belly Hill

Saltia SA 5433

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=25768 or tblfeedback.strbusinessname='Tickle Belly Hill' or tblfeedback.strbusinessname='Tickle Belly Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Foreshore Motor Inn

Whyalla SA 5600

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=6418 or tblfeedback.strbusinessname='Foreshore Motor Inn' or tblfeedback.strbusinessname='Foreshore Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

ANI Cooinda Club

Port Augusta SA 5700

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=6361 or tblfeedback.strbusinessname='ANI Cooinda Club' or tblfeedback.strbusinessname='ANI Cooinda Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Grand Tasman Hotel

Port Lincoln SA 5606

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=6426 or tblfeedback.strbusinessname='Grand Tasman Hotel' or tblfeedback.strbusinessname='Grand Tasman Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Spear Creek Tourism & Training Centre

Stirling North SA 5710

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=6516 or tblfeedback.strbusinessname='Spear Creek Tourism &%%semi%% Training Centre' or tblfeedback.strbusinessname='Spear Creek Tourism & Training Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Hannahville Hotel

Port Augusta SA 5700

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=6434 or tblfeedback.strbusinessname='Hannahville Hotel' or tblfeedback.strbusinessname='Hannahville Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Westland Hotel

Whyalla Norrie SA 5608

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=19243 or tblfeedback.strbusinessname='Westland Hotel' or tblfeedback.strbusinessname='Westland Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Mill Motel Quorn

Quorn SA 5433

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=6464 or tblfeedback.strbusinessname='Mill Motel Quorn' or tblfeedback.strbusinessname='Mill Motel Quorn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

1 - 9 of 9 Sort search results alphabetically