Rating Vibe Hotels
Vibe Hotels
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=19557 or tblfeedback.strbusinessname='Vibe Hotels' or tblfeedback.strbusinessname='Vibe Hotels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Vibe Hotels offer fresh & vibrant venues for your reception & are perfectly located. We work with you to create your dream event from "will you marry me" to "I do". At Vibe, we want your wedding to be all about you, your family & friends. And lots of fun!

Rating Pennant Hills Function Centre
Pennant Hills 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=19880 or tblfeedback.strbusinessname='Pennant Hills Function Centre' or tblfeedback.strbusinessname='Pennant Hills Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Extensive function facilities for weddings, all individualised.
Rating Parramatta Waldorf Apartment Hotel
Parramatta Waldorf Apartment Hotel
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=19882 or tblfeedback.strbusinessname='Parramatta Waldorf Apartment Hotel' or tblfeedback.strbusinessname='Parramatta Waldorf Apartment Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Extensive facilities for Weddings, up to 400 guests.

Rating
Four Seasons Hotel
Sydney NSW 2000
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=18338 or tblfeedback.strbusinessname='Four Seasons Hotel' or tblfeedback.strbusinessname='Four Seasons Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sir Stamford Double Bay
Double Bay NSW 2028
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=18346 or tblfeedback.strbusinessname='Sir Stamford Double Bay' or tblfeedback.strbusinessname='Sir Stamford Double Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Intercontinental Hotel
Sydney NSW 2000
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=18364 or tblfeedback.strbusinessname='Intercontinental Hotel' or tblfeedback.strbusinessname='Intercontinental Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hills Lodge Boutique Hotel
Castle Hill NSW 2154
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=9697 or tblfeedback.strbusinessname='Hills Lodge Boutique Hotel' or tblfeedback.strbusinessname='Hills Lodge Boutique Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Observatory Hotel
Sydney NSW 2000
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=18343 or tblfeedback.strbusinessname='Observatory Hotel' or tblfeedback.strbusinessname='Observatory Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jonahs
Palm Beach NSW 2108
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=18339 or tblfeedback.strbusinessname='Jonahs' or tblfeedback.strbusinessname='Jonahs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Park Hyatt Sydney
The Rocks NSW 2000
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=18344 or tblfeedback.strbusinessname='Park Hyatt Sydney' or tblfeedback.strbusinessname='Park Hyatt Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Sheraton on the Park
Sydney NSW 2000
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=18347 or tblfeedback.strbusinessname='The Sheraton on the Park' or tblfeedback.strbusinessname='The Sheraton on the Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating