Home > Reception Venue Central Coast NSW

Reception Venue Central Coast NSW

84 result(s) found. RatingView Your Favorites List

Rating
Bar Toto
Ettalong Beach NSW 2257
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=35923 or tblfeedback.strbusinessname='Bar Toto' or tblfeedback.strbusinessname='Bar Toto') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Morisset Country Club
Morisset NSW 2264
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=26003 or tblfeedback.strbusinessname='Morisset Country Club' or tblfeedback.strbusinessname='Morisset Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Bells at Killcare
Killcare NSW 2257
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=37825 or tblfeedback.strbusinessname='Bells at Killcare' or tblfeedback.strbusinessname='Bells at Killcare') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Crowne Plaza Terrigal
Terrigal NSW 2260
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=25583 or tblfeedback.strbusinessname='Crowne Plaza Terrigal' or tblfeedback.strbusinessname='Crowne Plaza Terrigal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Jessica Banks at Mercure Kooindah
Wyong NSW 2259
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=26470 or tblfeedback.strbusinessname='Jessica Banks at Mercure Kooindah' or tblfeedback.strbusinessname='Jessica Banks at Mercure Kooindah') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Ocean Beach Surf Life Saving Club
Umina NSW 2257
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=10758 or tblfeedback.strbusinessname='Ocean Beach Surf Life Saving Club' or tblfeedback.strbusinessname='Ocean Beach Surf Life Saving Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Pullman's Magenta Shores Resort
Magenta NSW 2261
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=27642 or tblfeedback.strbusinessname='Pullman'%%semi%%s Magenta Shores Resort' or tblfeedback.strbusinessname='Pullman's Magenta Shores Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Shelly Beach Golf Club
Shelly Beach NSW 2261
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=23318 or tblfeedback.strbusinessname='Shelly Beach Golf Club' or tblfeedback.strbusinessname='Shelly Beach Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
4 reviews
Rating
Forbes Golf and Sportsman Hotel
Forbes NSW 2871
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=26762 or tblfeedback.strbusinessname='Forbes Golf and Sportsman Hotel' or tblfeedback.strbusinessname='Forbes Golf and Sportsman Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Kangy Gardens
Kangy Angy NSW 2258
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=38083 or tblfeedback.strbusinessname='Kangy Gardens' or tblfeedback.strbusinessname='Kangy Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Raffertys Resort Cams Wharf
Cams Wharf 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=26110 or tblfeedback.strbusinessname='Raffertys Resort Cams Wharf' or tblfeedback.strbusinessname='Raffertys Resort Cams Wharf') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
St Aubyn's on Clairvaux
Bathurst NSW 2795
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=27217 or tblfeedback.strbusinessname='St Aubyn'%%semi%%s on Clairvaux' or tblfeedback.strbusinessname='St Aubyn's on Clairvaux') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Kantara House
Green Point NSW 2251
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=10008 or tblfeedback.strbusinessname='Kantara House' or tblfeedback.strbusinessname='Kantara House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
4 reviews
Rating
The Tame Fox
Erina NSW 2250
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=44114 or tblfeedback.strbusinessname='The Tame Fox' or tblfeedback.strbusinessname='The Tame Fox') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Mercure Kooindah Waters
Wyong NSW 2259
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=27013 or tblfeedback.strbusinessname='Mercure Kooindah Waters' or tblfeedback.strbusinessname='Mercure Kooindah Waters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Kantara House
Green Point NSW 2251
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=29191 or tblfeedback.strbusinessname='Kantara House' or tblfeedback.strbusinessname='Kantara House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
4 reviews
Rating
Pullman Magenta Shores
Magenta NSW 2261
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=27599 or tblfeedback.strbusinessname='Pullman Magenta Shores' or tblfeedback.strbusinessname='Pullman Magenta Shores') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Aanuka Beach Resort
Coffs Harbour NSW 2450
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=24966 or tblfeedback.strbusinessname='Aanuka Beach Resort' or tblfeedback.strbusinessname='Aanuka Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Avoca Beach House
Avoca Beach NSW 2251
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=44145 or tblfeedback.strbusinessname='Avoca Beach House' or tblfeedback.strbusinessname='Avoca Beach House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Awaba House
Booragul 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=27831 or tblfeedback.strbusinessname='Awaba House' or tblfeedback.strbusinessname='Awaba House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
The Whitehaven
Wamberal NSW 2260
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=27756 or tblfeedback.strbusinessname='The Whitehaven' or tblfeedback.strbusinessname='The Whitehaven') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Bidja Estate
Ourimbah NSW 2258
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=41250 or tblfeedback.strbusinessname='Bidja Estate' or tblfeedback.strbusinessname='Bidja Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
The Entrance Leagues Club
Bateau bay NSW 2261
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=25160 or tblfeedback.strbusinessname='The Entrance Leagues Club' or tblfeedback.strbusinessname='The Entrance Leagues Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
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
5 stars
1 review
Rating
Somersby Gardens Estate
Somersby NSW 2250
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=26340 or tblfeedback.strbusinessname='Somersby Gardens Estate' or tblfeedback.strbusinessname='Somersby Gardens Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
4.5 stars
2 reviews
Rating
Kincumber Hotel Resort
Kincumber NSW 2251
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=10082 or tblfeedback.strbusinessname='Kincumber Hotel Resort' or tblfeedback.strbusinessname='Kincumber Hotel Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
River Reflection
Tacoma NSW 2259
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=2064 or tblfeedback.strbusinessname='River Reflection' or tblfeedback.strbusinessname='River Reflection') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mingara Recreation Club Ltd
Tumbi Umbi NSW 2261
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=10513 or tblfeedback.strbusinessname='Mingara Recreation Club Ltd' or tblfeedback.strbusinessname='Mingara Recreation Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Letterbox Restaurant
Terrigal NSW 2260
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=10199 or tblfeedback.strbusinessname='Letterbox Restaurant' or tblfeedback.strbusinessname='Letterbox Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Avoca Tea House, The
Avoca Beach NSW 2251
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=2189 or tblfeedback.strbusinessname='Avoca Tea House, The' or tblfeedback.strbusinessname='Avoca Tea House, The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mutti's Coral Street Bistro
The Entrance NSW 2261
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=10610 or tblfeedback.strbusinessname='Mutti'%%semi%%s Coral Street Bistro' or tblfeedback.strbusinessname='Mutti's Coral Street Bistro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pizza PIT
Budgewoi NSW 2262
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=11003 or tblfeedback.strbusinessname='Pizza PIT' or tblfeedback.strbusinessname='Pizza PIT') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Forresters Resort
Forresters Beach NSW 2260
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=9343 or tblfeedback.strbusinessname='Forresters Resort' or tblfeedback.strbusinessname='Forresters Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Encore Brasserie
Wyoming NSW 2250
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=9174 or tblfeedback.strbusinessname='Encore Brasserie' or tblfeedback.strbusinessname='Encore Brasserie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pearls on the Beach
Pearl Beach NSW 2256
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=10876 or tblfeedback.strbusinessname='Pearls on the Beach' or tblfeedback.strbusinessname='Pearls on the Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gosford Race Club Ltd
Gosford West NSW 2250
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=9506 or tblfeedback.strbusinessname='Gosford Race Club Ltd' or tblfeedback.strbusinessname='Gosford Race Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wyee Party Hire
Wyee NSW 2259
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=12096 or tblfeedback.strbusinessname='Wyee Party Hire' or tblfeedback.strbusinessname='Wyee Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beachcomber The
Toukley NSW 2263
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=8118 or tblfeedback.strbusinessname='Beachcomber The' or tblfeedback.strbusinessname='Beachcomber The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Winning Post Catering Service The
Wyong NSW 2259
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=12065 or tblfeedback.strbusinessname='Winning Post Catering Service The' or tblfeedback.strbusinessname='Winning Post Catering Service The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hibiscus Lakeside Motel
Budgewoi NSW 2262
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=9688 or tblfeedback.strbusinessname='Hibiscus Lakeside Motel' or tblfeedback.strbusinessname='Hibiscus Lakeside Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gosford gold Club Ltd
Gosford NSW 2250
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=2002 or tblfeedback.strbusinessname='Gosford gold Club Ltd' or tblfeedback.strbusinessname='Gosford gold Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Connection The
Green Point NSW 2251
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=11980 or tblfeedback.strbusinessname='Wedding Connection The' or tblfeedback.strbusinessname='Wedding Connection The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Country Comfort Terrigal
Terrigal NSW 2260
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=8814 or tblfeedback.strbusinessname='Country Comfort Terrigal' or tblfeedback.strbusinessname='Country Comfort Terrigal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Caroline Bay Brasserie Cafe & Functions
Gosford East NSW 2250
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=8532 or tblfeedback.strbusinessname='Caroline Bay Brasserie Cafe &%%semi%% Functions' or tblfeedback.strbusinessname='Caroline Bay Brasserie Cafe & Functions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Trez's Castle of Horror
The Entrance NSW 2261
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=11785 or tblfeedback.strbusinessname='Trez'%%semi%%s Castle of Horror' or tblfeedback.strbusinessname='Trez's Castle of Horror') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Sea Sands Resort
Ettalong Beach NSW 2257
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=1936 or tblfeedback.strbusinessname='The Sea Sands Resort' or tblfeedback.strbusinessname='The Sea Sands Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wyong District Masonic Centre Pty Ltd
Wyong NSW 2259
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=12101 or tblfeedback.strbusinessname='Wyong District Masonic Centre Pty Ltd' or tblfeedback.strbusinessname='Wyong District Masonic Centre Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Murphy's Bay Waterfront Restaurant
Koolewong NSW 2256
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=10596 or tblfeedback.strbusinessname='Murphy'%%semi%%s Bay Waterfront Restaurant' or tblfeedback.strbusinessname='Murphy's Bay Waterfront Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Karrabee Floating Restaurant The
Gosford NSW 2250
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=10014 or tblfeedback.strbusinessname='Karrabee Floating Restaurant The' or tblfeedback.strbusinessname='Karrabee Floating Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bellbird Resort
Avoca Beach NSW 2251
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=1937 or tblfeedback.strbusinessname='Bellbird Resort' or tblfeedback.strbusinessname='Bellbird Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 84 Sort search results alphabetically