Rating Sea Temple Resort & Spa Port Douglas, Pullman
Sea Temple Resort & Spa Port Douglas, Pullman
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=19861 or tblfeedback.strbusinessname='Sea Temple Resort &%%semi%% Spa Port Douglas, Pullman' or tblfeedback.strbusinessname='Sea Temple Resort & Spa Port Douglas, Pullman') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
The Sea Temple Resort & Spa Port Douglas is a stunning, luxurious five star property located at Four Mile Beach, with access to many ceremony and reception venues.

Rating
Castaways Resort and Spa
Mission Beach QLD 4852
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=22702 or tblfeedback.strbusinessname='Castaways Resort and Spa' or tblfeedback.strbusinessname='Castaways Resort and Spa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peppers Blue on Blue Resort Magnetic Island
Magnetic Island QLD 4819
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=46345 or tblfeedback.strbusinessname='Peppers Blue on Blue Resort Magnetic Island' or tblfeedback.strbusinessname='Peppers Blue on Blue Resort Magnetic Island') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All Souls and Saint Gabriels
Charters Towers QLD 4820
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=25646 or tblfeedback.strbusinessname='All Souls and Saint Gabriels' or tblfeedback.strbusinessname='All Souls and Saint Gabriels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
South Pacific Bridal
Cairns QLD 4870
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=27068 or tblfeedback.strbusinessname='South Pacific Bridal' or tblfeedback.strbusinessname='South Pacific Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Ville Resort Casino
Townsville City QLD 4810
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=43627 or tblfeedback.strbusinessname='The Ville Resort Casino' or tblfeedback.strbusinessname='The Ville Resort Casino') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elite Barn Weddings
Hervey Range QLD 4817
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=41744 or tblfeedback.strbusinessname='Elite Barn Weddings' or tblfeedback.strbusinessname='Elite Barn Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
HerveyRange Heritage Tea Rooms
Townsville QLD 4817
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=38501 or tblfeedback.strbusinessname='HerveyRange Heritage Tea Rooms' or tblfeedback.strbusinessname='HerveyRange Heritage Tea Rooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All Souls and Saint Gabriels
Charters Towers QLD 4820
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=25645 or tblfeedback.strbusinessname='All Souls and Saint Gabriels' or tblfeedback.strbusinessname='All Souls and Saint Gabriels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Port Douglas Weddings
Port Douglas QLD 4877
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=29021 or tblfeedback.strbusinessname='Port Douglas Weddings' or tblfeedback.strbusinessname='Port Douglas Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lumberjacks events wedding venue
Herveys Range QLD 4817
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=43576 or tblfeedback.strbusinessname='Lumberjacks events wedding venue' or tblfeedback.strbusinessname='Lumberjacks events wedding venue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bluewater Bar and Grill
Trinity Park QLD 4879
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=22560 or tblfeedback.strbusinessname='Bluewater Bar and Grill' or tblfeedback.strbusinessname='Bluewater Bar and Grill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cape Gloucester Resort
Hideaway Bay QLD 4800
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=35731 or tblfeedback.strbusinessname='Cape Gloucester Resort' or tblfeedback.strbusinessname='Cape Gloucester Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Farm Plumeria Road
Black River QLD 4818
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=35896 or tblfeedback.strbusinessname='The Farm Plumeria Road' or tblfeedback.strbusinessname='The Farm Plumeria Road') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Whitsunday Sands Resort
Bowen QLD 4805
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=41645 or tblfeedback.strbusinessname='Whitsunday Sands Resort' or tblfeedback.strbusinessname='Whitsunday Sands Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pepper's Blue on Blue
Nelly Bay QLD 4819
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=26597 or tblfeedback.strbusinessname='Pepper''s Blue on Blue' or tblfeedback.strbusinessname='Pepper''s Blue on Blue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Malanda Lodge
Malanda QLD 4885
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=44756 or tblfeedback.strbusinessname='Malanda Lodge' or tblfeedback.strbusinessname='Malanda Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Villa Botanica
Woodwark QLD 4802
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=21931 or tblfeedback.strbusinessname='Villa Botanica' or tblfeedback.strbusinessname='Villa Botanica') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St James Cathedral
Townsville QLD 4810
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=26157 or tblfeedback.strbusinessname='St James Cathedral' or tblfeedback.strbusinessname='St James Cathedral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rainforest Lakes
Kuranda QLD 4881
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=44340 or tblfeedback.strbusinessname='Rainforest Lakes' or tblfeedback.strbusinessname='Rainforest Lakes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
House of Vows
Townsville City QLD 4810
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=46315 or tblfeedback.strbusinessname='House of Vows' or tblfeedback.strbusinessname='House of Vows') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Greenmount Homestead
Walkerston QLD 4751
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=25691 or tblfeedback.strbusinessname='Greenmount Homestead' or tblfeedback.strbusinessname='Greenmount Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rosendals Tradgard
Sweden 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=41702 or tblfeedback.strbusinessname='Rosendals Tradgard' or tblfeedback.strbusinessname='Rosendals Tradgard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Townsville Heritage Centre
Townsville QLD 4810
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=25961 or tblfeedback.strbusinessname='Townsville Heritage Centre' or tblfeedback.strbusinessname='Townsville Heritage Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Salt House Cairns
Cairns QLD 4870
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=44795 or tblfeedback.strbusinessname='Salt House Cairns' or tblfeedback.strbusinessname='Salt House Cairns') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tradewinds Chapel by the Sea
Cairns QLD 4870
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=15575 or tblfeedback.strbusinessname='Tradewinds Chapel by the Sea' or tblfeedback.strbusinessname='Tradewinds Chapel by the Sea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St. Mary's by the Sea
Port Douglas QLD 4871
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=18994 or tblfeedback.strbusinessname='St. Mary'%%semi%%s by the Sea' or tblfeedback.strbusinessname='St. Mary's by the Sea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Mary's by the Sea
Port Douglas QLD 4871
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=15574 or tblfeedback.strbusinessname='St Mary'%%semi%%s by the Sea' or tblfeedback.strbusinessname='St Mary's by the Sea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Holiday Inn Hotels
Townsville QLD 4810
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=18949 or tblfeedback.strbusinessname='Holiday Inn Hotels' or tblfeedback.strbusinessname='Holiday Inn Hotels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15