Home > Wedding Formal Wear and Hire Newcastle & Hunter Valley

Wedding Formal Wear and Hire Newcastle & Hunter Valley

23 result(s) found. View Your Favorites List

Varsity Lakes QLD 4227

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=26976 or tblfeedback.strbusinessname='Made With Love Bridal' or tblfeedback.strbusinessname='Made With Love Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
23 reviews

Ed Harry

Hindmarsh SA 5007

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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

The Wedding Shoppe

Dubbo NSW 2830

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=25308 or tblfeedback.strbusinessname='The Wedding Shoppe' or tblfeedback.strbusinessname='The Wedding Shoppe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.6 stars
10 reviews

Ed Harry

Hindmarsh SA 5007

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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

Science Formal Wear Hire Service

Newcastle West NSW 2302

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=11317 or tblfeedback.strbusinessname='Science Formal Wear Hire Service' or tblfeedback.strbusinessname='Science Formal Wear Hire Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Gentlemens Outfitters

Charlestown NSW 2290

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=9436 or tblfeedback.strbusinessname='Gentlemens Outfitters' or tblfeedback.strbusinessname='Gentlemens Outfitters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Abercrombie Mens & Boys Wear

Mayfield NSW 2304

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=7708 or tblfeedback.strbusinessname='Abercrombie Mens &%%semi%% Boys Wear' or tblfeedback.strbusinessname='Abercrombie Mens & Boys Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Lane Ken Mensland

Maitland NSW 2320

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=10147 or tblfeedback.strbusinessname='Lane Ken Mensland' or tblfeedback.strbusinessname='Lane Ken Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Hiltop Formal Hire

Charlestown NSW 2290

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=9702 or tblfeedback.strbusinessname='Hiltop Formal Hire' or tblfeedback.strbusinessname='Hiltop Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Rundle Australia

Broadmeadow NSW 2292

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=11259 or tblfeedback.strbusinessname='Rundle Australia' or tblfeedback.strbusinessname='Rundle Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Pure Classic Fashions

Singleton NSW 2330

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=11079 or tblfeedback.strbusinessname='Pure Classic Fashions' or tblfeedback.strbusinessname='Pure Classic Fashions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

West Terrace Menswear

Newcastle NSW 2300

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=12008 or tblfeedback.strbusinessname='West Terrace Menswear' or tblfeedback.strbusinessname='West Terrace Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Roger David

Maitland NSW 2320

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=11196 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.25 stars
4 reviews

Gentlemens Outfitters

Newcastle NSW 2300

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=9435 or tblfeedback.strbusinessname='Gentlemens Outfitters' or tblfeedback.strbusinessname='Gentlemens Outfitters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Catcha Dream Suit Hire

Tanilba Bay NSW 2319

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=8562 or tblfeedback.strbusinessname='Catcha Dream Suit Hire' or tblfeedback.strbusinessname='Catcha Dream Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Singleton Formal Hire

Singleton NSW 2330

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=11424 or tblfeedback.strbusinessname='Singleton Formal Hire' or tblfeedback.strbusinessname='Singleton Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Beveridge's Menswear & Formal Hire

Cessnock NSW 2325

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=8193 or tblfeedback.strbusinessname='Beveridge'%%semi%%s Menswear &%%semi%% Formal Hire' or tblfeedback.strbusinessname='Beveridge's Menswear & Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Ferarri Formal Hire

Charlestown NSW 2290

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=9268 or tblfeedback.strbusinessname='Ferarri Formal Hire' or tblfeedback.strbusinessname='Ferarri Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Harvey's Men's Wear

Maitland NSW 2320

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=9627 or tblfeedback.strbusinessname='Harvey'%%semi%%s Men'%%semi%%s Wear' or tblfeedback.strbusinessname='Harvey's Men's Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Rundle Tailoring

Newcastle West NSW 2302

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=11260 or tblfeedback.strbusinessname='Rundle Tailoring' or tblfeedback.strbusinessname='Rundle Tailoring') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Grace Bros Mens Formal Hire

Charlestown NSW 2290

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=1842 or tblfeedback.strbusinessname='Grace Bros Mens Formal Hire' or tblfeedback.strbusinessname='Grace Bros Mens Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Roger David

Garden City NSW 2289

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=11197 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.25 stars
4 reviews

Roger David

Newcastle NSW 2300

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=11194 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.25 stars
4 reviews

1 - 23 of 23 Sort search results alphabetically