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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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