Rating Northern Beaches Limousines
Northern Beaches Limousines
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=17347 or tblfeedback.strbusinessname='Northern Beaches Limousines' or tblfeedback.strbusinessname='Northern Beaches Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Committed to providing a luxury standard of old fashioned service at excellent rates.
Rating Classic Bridal Cars
Classic Bridal Cars
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=19474 or tblfeedback.strbusinessname='Classic Bridal Cars' or tblfeedback.strbusinessname='Classic Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Sydney's most awarded wedding car operators understand that wedding cars are all about quality, reliability and service. With Sydney's largest exclusively silver collecti
Rating 7th Heaven Wedding Cars
7th Heaven Wedding Cars
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=18359 or tblfeedback.strbusinessname='7th Heaven Wedding Cars' or tblfeedback.strbusinessname='7th Heaven Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Twenty years of champagne heaven - the start of your fairytale!

Rating
WOW Limos
Wetherill Park NSW 2164
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=38364 or tblfeedback.strbusinessname='WOW Limos' or tblfeedback.strbusinessname='WOW Limos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A1 Limousines
Bass Hill NSW 2197
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=21905 or tblfeedback.strbusinessname='A1 Limousines' or tblfeedback.strbusinessname='A1 Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Klassic Kombiz
Woolooware NSW 2230
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=23288 or tblfeedback.strbusinessname='Klassic Kombiz' or tblfeedback.strbusinessname='Klassic Kombiz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roll Up In A Rolls
Taren Point NSW 2229
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=11210 or tblfeedback.strbusinessname='Roll Up In A Rolls' or tblfeedback.strbusinessname='Roll Up In A Rolls') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castlereagh Wedding Carriages
Badgerys Creek NSW 2171
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=8558 or tblfeedback.strbusinessname='Castlereagh Wedding Carriages' or tblfeedback.strbusinessname='Castlereagh Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sydney seaplanes
Rose Bay NSW 2029
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=25944 or tblfeedback.strbusinessname='Sydney seaplanes' or tblfeedback.strbusinessname='Sydney seaplanes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sydney Brock Hire
Strathfield NSW 2135
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=26489 or tblfeedback.strbusinessname='Sydney Brock Hire' or tblfeedback.strbusinessname='Sydney Brock Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Broadway limousines
Sydney NSW 2200
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=21884 or tblfeedback.strbusinessname='Broadway limousines' or tblfeedback.strbusinessname='Broadway limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
ACE American Convertibles
Berkshire Park NSW 2765
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=2657 or tblfeedback.strbusinessname='ACE American Convertibles' or tblfeedback.strbusinessname='ACE American Convertibles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kombi Weddings
Mona Vale NSW 2103
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=29138 or tblfeedback.strbusinessname='Kombi Weddings' or tblfeedback.strbusinessname='Kombi Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ashdown & Bee
Summer Hill NSW 2130
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=23256 or tblfeedback.strbusinessname='Ashdown &%%semi%% Bee' or tblfeedback.strbusinessname='Ashdown & Bee') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Oz Limo Hire
Guildford NSW 2161
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=26215 or tblfeedback.strbusinessname='Oz Limo Hire' or tblfeedback.strbusinessname='Oz Limo Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Entice Wedding Cars
Cecil Hills NSW 2171
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=20130 or tblfeedback.strbusinessname='Entice Wedding Cars' or tblfeedback.strbusinessname='Entice Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roll up in style
Peakhurst NSW 2210
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=24777 or tblfeedback.strbusinessname='Roll up in style' or tblfeedback.strbusinessname='Roll up in style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Show Limousines
Wattle Grove NSW 2173
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=27793 or tblfeedback.strbusinessname='Show Limousines' or tblfeedback.strbusinessname='Show Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Variety Wedding Cars
Cammeray NSW 2062
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=11853 or tblfeedback.strbusinessname='Variety Wedding Cars' or tblfeedback.strbusinessname='Variety Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Queen St Car Hire
Revesby NSW 2212
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=23839 or tblfeedback.strbusinessname='Queen St Car Hire' or tblfeedback.strbusinessname='Queen St Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castlecrest Wedding Carriages
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=27151 or tblfeedback.strbusinessname='Castlecrest Wedding Carriages' or tblfeedback.strbusinessname='Castlecrest Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sydney Eleanor Hire
Ryde NSW 2112
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=36353 or tblfeedback.strbusinessname='Sydney Eleanor Hire' or tblfeedback.strbusinessname='Sydney Eleanor Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tuf 57 Chevy's
Rooty Hill NSW 2766
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=1229 or tblfeedback.strbusinessname='Tuf 57 Chevy'%%semi%%s' or tblfeedback.strbusinessname='Tuf 57 Chevy's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
HF Wedding & Hire Cars
Haberfield NSW 2045
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=21437 or tblfeedback.strbusinessname='HF Wedding & Hire Cars' or tblfeedback.strbusinessname='HF Wedding & Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castlereagh Wedding Carriages
Badgerys Creek NSW 2555
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=29604 or tblfeedback.strbusinessname='Castlereagh Wedding Carriages' or tblfeedback.strbusinessname='Castlereagh Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Astra Chauffeured Limousines of Australia
Mascot NSW 2020
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=7924 or tblfeedback.strbusinessname='Astra Chauffeured Limousines of Australia' or tblfeedback.strbusinessname='Astra Chauffeured Limousines of Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
French Limousines
Northbridge NSW 2063
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=9369 or tblfeedback.strbusinessname='French Limousines' or tblfeedback.strbusinessname='French Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brides In Mind Car Hire
Glenhaven NSW 2156
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=8386 or tblfeedback.strbusinessname='Brides In Mind Car Hire' or tblfeedback.strbusinessname='Brides In Mind Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Circle Wedding Centre
Chippendale NSW 2008
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=8675 or tblfeedback.strbusinessname='Circle Wedding Centre' or tblfeedback.strbusinessname='Circle Wedding Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Humphries Wedding Cars
Lidcombe NSW 2141
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=9761 or tblfeedback.strbusinessname='Humphries Wedding Cars' or tblfeedback.strbusinessname='Humphries Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rock & Roll Weddings
Leichhardt NSW 2040
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=11188 or tblfeedback.strbusinessname='Rock &%%semi%% Roll Weddings' or tblfeedback.strbusinessname='Rock & Roll Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vogue Limousines
Concord NSW 2137
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=11921 or tblfeedback.strbusinessname='Vogue Limousines' or tblfeedback.strbusinessname='Vogue Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac King
Leichhardt NSW 2040
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=1099 or tblfeedback.strbusinessname='Cadillac King' or tblfeedback.strbusinessname='Cadillac King') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Western Hills Hire Cars
Beverly Hills NSW 2209
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=12010 or tblfeedback.strbusinessname='Western Hills Hire Cars' or tblfeedback.strbusinessname='Western Hills Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Camelot Bridal Cars
Regents Park NSW 2143
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=18326 or tblfeedback.strbusinessname='Camelot Bridal Cars' or tblfeedback.strbusinessname='Camelot Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A A A Limousines
Kings Park NSW 2148
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=2433 or tblfeedback.strbusinessname='A A A Limousines' or tblfeedback.strbusinessname='A A A Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A St George & Districts Limousines
Narraweena NSW 2099
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=7668 or tblfeedback.strbusinessname='A St George &%%semi%% Districts Limousines' or tblfeedback.strbusinessname='A St George & Districts Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Streetcar Named Desire
Randwick NSW 2031
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=1303 or tblfeedback.strbusinessname='A Streetcar Named Desire' or tblfeedback.strbusinessname='A Streetcar Named Desire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pontiac Classic Hire
South Wentworthville NSW 2145
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=11015 or tblfeedback.strbusinessname='Pontiac Classic Hire' or tblfeedback.strbusinessname='Pontiac Classic Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
HSV Wedding Classics
Casula NSW 2170
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=9749 or tblfeedback.strbusinessname='HSV Wedding Classics' or tblfeedback.strbusinessname='HSV Wedding Classics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
White Rose Limousines Wedding Cars
Annandale NSW 2038
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=12035 or tblfeedback.strbusinessname='White Rose Limousines Wedding Cars' or tblfeedback.strbusinessname='White Rose Limousines Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
North West Hire Cars
Blacktown NSW 2148
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=1102 or tblfeedback.strbusinessname='North West Hire Cars' or tblfeedback.strbusinessname='North West Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Christy's
Baulkham Hills NSW 2153
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=1319 or tblfeedback.strbusinessname='A Christy'%%semi%%s' or tblfeedback.strbusinessname='A Christy's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Cruisers
Fairfield NSW 2165
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=8701 or tblfeedback.strbusinessname='Classic Cruisers' or tblfeedback.strbusinessname='Classic Cruisers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Honest STU the Cadillac King
Leichhardt NSW 2040
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=9716 or tblfeedback.strbusinessname='Honest STU the Cadillac King' or tblfeedback.strbusinessname='Honest STU the Cadillac King') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pymble Hire Cars
West Pymble NSW 2073
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=11085 or tblfeedback.strbusinessname='Pymble Hire Cars' or tblfeedback.strbusinessname='Pymble Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wild Weddings Pty Ltd
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=1226 or tblfeedback.strbusinessname='Wild Weddings Pty Ltd' or tblfeedback.strbusinessname='Wild Weddings Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Limousines 2000 Pty Ltd
Smithfield NSW 2164
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=1210 or tblfeedback.strbusinessname='Limousines 2000 Pty Ltd' or tblfeedback.strbusinessname='Limousines 2000 Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Aegean Chauffeur Limousines
Beverly Hills NSW 2209
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=1314 or tblfeedback.strbusinessname='A Aegean Chauffeur Limousines' or tblfeedback.strbusinessname='A Aegean Chauffeur Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lar Limousines
Five Dock NSW 2046
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=10151 or tblfeedback.strbusinessname='Lar Limousines' or tblfeedback.strbusinessname='Lar Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 354 Sort search results alphabetically