Rating
Kombi Event Hire
Tuggerah 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=23621 or tblfeedback.strbusinessname='Kombi Event Hire' or tblfeedback.strbusinessname='Kombi Event Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coast Kombis
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=21598 or tblfeedback.strbusinessname='Coast Kombis' or tblfeedback.strbusinessname='Coast Kombis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Central Coast Wedding Limousines
Berkeley Vale 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=8589 or tblfeedback.strbusinessname='Central Coast Wedding Limousines' or tblfeedback.strbusinessname='Central Coast Wedding Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Avis Central Coast
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=7989 or tblfeedback.strbusinessname='Avis Central Coast' or tblfeedback.strbusinessname='Avis Central Coast') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A P K Early Era Vintage Wedding Cars
Lake Haven 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=2436 or tblfeedback.strbusinessname='A P K Early Era Vintage Wedding Cars' or tblfeedback.strbusinessname='A P K Early Era Vintage Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac Affair
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=1231 or tblfeedback.strbusinessname='Cadillac Affair' or tblfeedback.strbusinessname='Cadillac Affair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Above All Limousines
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=7714 or tblfeedback.strbusinessname='Above All Limousines' or tblfeedback.strbusinessname='Above All Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gosford Limousines & Wedding Cars
Berkeley Vale 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=9505 or tblfeedback.strbusinessname='Gosford Limousines &%%semi%% Wedding Cars' or tblfeedback.strbusinessname='Gosford Limousines & Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Coast Wedding Cars
Mannering Park 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=7791 or tblfeedback.strbusinessname='All Coast Wedding Cars' or tblfeedback.strbusinessname='All Coast Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marks
Tascott 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=10397 or tblfeedback.strbusinessname='Marks' or tblfeedback.strbusinessname='Marks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Northlakes Limousines & Wedding Cars
Berkeley Vale 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=10734 or tblfeedback.strbusinessname='Northlakes Limousines &%%semi%% Wedding Cars' or tblfeedback.strbusinessname='Northlakes Limousines & Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A & J Classic Wedding Cars
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=1107 or tblfeedback.strbusinessname='A &%%semi%% J Classic Wedding Cars' or tblfeedback.strbusinessname='A & J Classic Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Classic Jags
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=7790 or tblfeedback.strbusinessname='All Classic Jags' or tblfeedback.strbusinessname='All Classic Jags') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Terrigal Hire Cars & Limousines
Erina Fair 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=11709 or tblfeedback.strbusinessname='Terrigal Hire Cars &%%semi%% Limousines' or tblfeedback.strbusinessname='Terrigal Hire Cars & Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peninsular Carriages
Dooralong 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=10890 or tblfeedback.strbusinessname='Peninsular Carriages' or tblfeedback.strbusinessname='Peninsular Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic American Wedding Cars
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=8687 or tblfeedback.strbusinessname='Classic American Wedding Cars' or tblfeedback.strbusinessname='Classic American Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brisbane Water Limousines
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=8395 or tblfeedback.strbusinessname='Brisbane Water Limousines' or tblfeedback.strbusinessname='Brisbane Water Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chevron Dreams Wedding Car Hire
Gorokan 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=1233 or tblfeedback.strbusinessname='Chevron Dreams Wedding Car Hire' or tblfeedback.strbusinessname='Chevron Dreams Wedding Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ACDC Wedding Vehicles
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=7729 or tblfeedback.strbusinessname='ACDC Wedding Vehicles' or tblfeedback.strbusinessname='ACDC Wedding Vehicles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
VIP Limousines & Hire Cars
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=11905 or tblfeedback.strbusinessname='VIP Limousines &%%semi%% Hire Cars' or tblfeedback.strbusinessname='VIP Limousines & Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Cats
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=8696 or tblfeedback.strbusinessname='Classic Cats' or tblfeedback.strbusinessname='Classic Cats') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shoebox Chevy's
Warnervale 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=11383 or tblfeedback.strbusinessname='Shoebox Chevy'%%semi%%s' or tblfeedback.strbusinessname='Shoebox Chevy's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Debbie & Ross Montgomery
Glenning Valley 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=8959 or tblfeedback.strbusinessname='Debbie &%%semi%% Ross Montgomery' or tblfeedback.strbusinessname='Debbie & Ross Montgomery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Australian Classic Cars
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=7787 or tblfeedback.strbusinessname='All Australian Classic Cars' or tblfeedback.strbusinessname='All Australian Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Old Time Bridal Cars
St Huberts Island 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=10770 or tblfeedback.strbusinessname='Old Time Bridal Cars' or tblfeedback.strbusinessname='Old Time Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A C D C Wedding Vehicles
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=2435 or tblfeedback.strbusinessname='A C D C Wedding Vehicles' or tblfeedback.strbusinessname='A C D C Wedding Vehicles ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ettalong Hire Cars & Limousines
Erina Fair 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=9197 or tblfeedback.strbusinessname='Ettalong Hire Cars &%%semi%% Limousines' or tblfeedback.strbusinessname='Ettalong Hire Cars & Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coastal Classic Bridal Cars
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=1234 or tblfeedback.strbusinessname='Coastal Classic Bridal Cars' or tblfeedback.strbusinessname='Coastal Classic Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Chrome
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=8697 or tblfeedback.strbusinessname='Classic Chrome' or tblfeedback.strbusinessname='Classic Chrome') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
APK Early Era Vintage Wedding Cars
Lake Haven 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=7875 or tblfeedback.strbusinessname='APK Early Era Vintage Wedding Cars' or tblfeedback.strbusinessname='APK Early Era Vintage Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Central Coast Wedding Cars
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=1115 or tblfeedback.strbusinessname='Central Coast Wedding Cars' or tblfeedback.strbusinessname='Central Coast Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ideal Limousines
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=9785 or tblfeedback.strbusinessname='Ideal Limousines' or tblfeedback.strbusinessname='Ideal Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elite Wedding Limousines
Warnervale 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=9143 or tblfeedback.strbusinessname='Elite Wedding Limousines' or tblfeedback.strbusinessname='Elite Wedding Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic American Wedding Cars
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=1116 or tblfeedback.strbusinessname='Classic American Wedding Cars' or tblfeedback.strbusinessname='Classic American Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15