Home > Reception Venue Perth

Reception Venue Perth

245 result(s) found. View Your Favorites List

Peppermint Grove WA 6011

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=26681 or tblfeedback.strbusinessname='Royal Freshwater Bay Yacht Club' or tblfeedback.strbusinessname='Royal Freshwater Bay Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

Acqua Viva on the Swan

Nedlands WA 6009

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=21875 or tblfeedback.strbusinessname='Acqua Viva on the Swan' or tblfeedback.strbusinessname='Acqua Viva on the Swan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
5 reviews

Sandalford Wines

Caversham WA 6055

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=4145 or tblfeedback.strbusinessname='Sandalford Wines' or tblfeedback.strbusinessname='Sandalford Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

Mandurah Quays

Erskine WA 6210

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=26638 or tblfeedback.strbusinessname='Mandurah Quays' or tblfeedback.strbusinessname='Mandurah Quays') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

King Road Brewing Co

Oldbury WA 6121

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=46358 or tblfeedback.strbusinessname='King Road Brewing Co' or tblfeedback.strbusinessname='King Road Brewing Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Peel Estate Winery

Karnup WA 6176

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=29087 or tblfeedback.strbusinessname='Peel Estate Winery' or tblfeedback.strbusinessname='Peel Estate Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

The Flour Factory

Perth WA 6000

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=27739 or tblfeedback.strbusinessname='The Flour Factory' or tblfeedback.strbusinessname='The Flour Factory') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Peel Manor House

Karnup NSW 6176

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=20885 or tblfeedback.strbusinessname='Peel Manor House' or tblfeedback.strbusinessname='Peel Manor House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Coast Port Beach

North Fremantle WA 6159

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=45865 or tblfeedback.strbusinessname='Coast Port Beach' or tblfeedback.strbusinessname='Coast Port Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Mandoon Estate

Caversham WA 6055

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=25832 or tblfeedback.strbusinessname='Mandoon Estate' or tblfeedback.strbusinessname='Mandoon Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.8 stars
5 reviews

Mustang Bar

Northbridge WA 6003

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=44815 or tblfeedback.strbusinessname='Mustang Bar' or tblfeedback.strbusinessname='Mustang Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Fraser's State Reception Centre

Kings Park WA 6005

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=27355 or tblfeedback.strbusinessname='Fraser''s State Reception Centre' or tblfeedback.strbusinessname='Fraser''s State Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
4 reviews

Perth flying squadron yacht club

Dalkeith WA 6009

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=42933 or tblfeedback.strbusinessname='Perth flying squadron yacht club' or tblfeedback.strbusinessname='Perth flying squadron yacht club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Post

Perth WA 6000

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

5 stars
1 review

Belvoir

Upper Swan WA 6069

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

5 stars
1 review

Wyening Mission Farm

Calingiri WA 6569

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

5 stars
1 review

Aravina Estate

Yallingup WA 6282

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=27746 or tblfeedback.strbusinessname='Aravina Estate' or tblfeedback.strbusinessname='Aravina Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Rose and Crown

Guildford WA 6055

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=26730 or tblfeedback.strbusinessname='Rose and Crown' or tblfeedback.strbusinessname='Rose and Crown') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4 stars
1 review

Sandalford Winery

Caversham WA 6055

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=27425 or tblfeedback.strbusinessname='Sandalford Winery' or tblfeedback.strbusinessname='Sandalford Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
6 reviews

Core Cider House

Pickering Brook WA 6076

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=25509 or tblfeedback.strbusinessname='Core Cider House' or tblfeedback.strbusinessname='Core Cider House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Redcliffe on the Murray

Pinjarra WA 6208

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=37448 or tblfeedback.strbusinessname='Redcliffe on the Murray' or tblfeedback.strbusinessname='Redcliffe on the Murray') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.5 stars
2 reviews

Evedon Lakeside Retreat

Burekup WA 6227

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=29510 or tblfeedback.strbusinessname='Evedon Lakeside Retreat' or tblfeedback.strbusinessname='Evedon Lakeside Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
4 reviews

Pan Pacific Perth

Perth WA 6000

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=26441 or tblfeedback.strbusinessname='Pan Pacific Perth' or tblfeedback.strbusinessname='Pan Pacific Perth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Point Walter Golf Course

Bicton WA 6157

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=29576 or tblfeedback.strbusinessname='Point Walter Golf Course' or tblfeedback.strbusinessname='Point Walter Golf Course') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Marmion Angling & Aquatic Club

Marmion WA 6020

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=17932 or tblfeedback.strbusinessname='Marmion Angling &%%semi%% Aquatic Club' or tblfeedback.strbusinessname='Marmion Angling & Aquatic Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

COMO The Treasury, Perth AU

Perth WA 6000

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=46684 or tblfeedback.strbusinessname='COMO The Treasury, Perth AU' or tblfeedback.strbusinessname='COMO The Treasury, Perth AU') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Mosman Park Art Foundation (MosArts)

Mosman Park WA 6012

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=26010 or tblfeedback.strbusinessname='Mosman Park Art Foundation (%%semi%%MosArts)%%semi%%' or tblfeedback.strbusinessname='Mosman Park Art Foundation (MosArts)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

2 stars
1 review

Millbrook Winery

Jarrahdale WA 6124

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=26765 or tblfeedback.strbusinessname='Millbrook Winery' or tblfeedback.strbusinessname='Millbrook Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
7 reviews

Novotel Vines Resort Swan Valley

The Vines WA 6069

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=46150 or tblfeedback.strbusinessname='Novotel Vines Resort Swan Valley' or tblfeedback.strbusinessname='Novotel Vines Resort Swan Valley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Rendezvous Hotel (Scarborough)

Scarborough WA 6018

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=17965 or tblfeedback.strbusinessname='Rendezvous Hotel (%%semi%%Scarborough)%%semi%%' or tblfeedback.strbusinessname='Rendezvous Hotel (Scarborough)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.5 stars
4 reviews

Core Cider House

Pickering Brook WA 6076

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=24959 or tblfeedback.strbusinessname='Core Cider House' or tblfeedback.strbusinessname='Core Cider House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Yanchep Cabaret Cave

Yanchep WA 6035

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=38212 or tblfeedback.strbusinessname='Yanchep Cabaret Cave' or tblfeedback.strbusinessname='Yanchep Cabaret Cave') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

Nanga Bush Camp

Dwellingup WA 6153

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=25733 or tblfeedback.strbusinessname='Nanga Bush Camp' or tblfeedback.strbusinessname='Nanga Bush Camp') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Caversham House

Caversham WA 6055

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=17394 or tblfeedback.strbusinessname='Caversham House' or tblfeedback.strbusinessname='Caversham House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.95 stars
19 reviews

Joondalup Resort

Connolly WA 6027

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=22132 or tblfeedback.strbusinessname='Joondalup Resort' or tblfeedback.strbusinessname='Joondalup Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
17 reviews

Perth Zoo

Perth WA 6151

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=37760 or tblfeedback.strbusinessname='Perth Zoo' or tblfeedback.strbusinessname='Perth Zoo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Mustard Catering at Perth Zoo

South Perth WA 6151

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=39832 or tblfeedback.strbusinessname='Mustard Catering at Perth Zoo' or tblfeedback.strbusinessname='Mustard Catering at Perth Zoo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Quarry Farm WA

Whitby WA 6123

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

5 stars
3 reviews

Maylands Yacht club

Maylands WA 6051

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=26015 or tblfeedback.strbusinessname='Maylands Yacht club' or tblfeedback.strbusinessname='Maylands Yacht club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Mulberry Estate

Caversham WA 6055

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=22371 or tblfeedback.strbusinessname='Mulberry Estate' or tblfeedback.strbusinessname='Mulberry Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
6 reviews

Duxton Hotel Perth

Perth WA 6000

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

5 stars
4 reviews

Kings Park Function Centre

West Perth WA 6005

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=17931 or tblfeedback.strbusinessname='Kings Park Function Centre' or tblfeedback.strbusinessname='Kings Park Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Silversprings

Metricup WA 6280

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

5 stars
1 review

Bridgeleigh

Wanneroo WA 6065

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

5 stars
1 review

The Old Laundry

North Perth WA 6006

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=27328 or tblfeedback.strbusinessname='The Old Laundry' or tblfeedback.strbusinessname='The Old Laundry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Perth City Farm

Perth WA 6004

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

3 stars
1 review

Ambrose Estate

Wembley Downs WA 6019

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=38031 or tblfeedback.strbusinessname='Ambrose Estate' or tblfeedback.strbusinessname='Ambrose Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

The Old Pickle Factory

West Perth WA 6065

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=24943 or tblfeedback.strbusinessname='The Old Pickle Factory' or tblfeedback.strbusinessname='The Old Pickle Factory') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Coast to Coast Golden Roast WA

Malaga WA 6944

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=35797 or tblfeedback.strbusinessname='Coast to Coast Golden Roast WA' or tblfeedback.strbusinessname='Coast to Coast Golden Roast WA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
3 reviews

Pagoda Resort & Spa

Como WA 6152

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=25917 or tblfeedback.strbusinessname='Pagoda Resort &%%semi%% Spa' or tblfeedback.strbusinessname='Pagoda Resort & Spa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

1 - 50 of 245 Sort search results alphabetically