Home > Wedding Jewellery Newcastle & Hunter Valley

Wedding Jewellery Newcastle & Hunter Valley

20 result(s) found. View Your Favorites List

QLD

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

5 stars
3 reviews

Baileys Jewellers Maitland

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=36363 or tblfeedback.strbusinessname='Baileys Jewellers Maitland' or tblfeedback.strbusinessname='Baileys Jewellers Maitland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Gregory's Jewellers (Bondi Junction)

Bondi Junction NSW 2022

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=29218 or tblfeedback.strbusinessname='Gregory'%%semi%%s Jewellers (%%semi%%Bondi Junction)%%semi%%' or tblfeedback.strbusinessname='Gregory's Jewellers (Bondi Junction)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Sundari Gems

NSW

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=25983 or tblfeedback.strbusinessname='Sundari Gems' or tblfeedback.strbusinessname='Sundari Gems') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Glam Couture Bridal

Bondi Junction NSW 2022

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=43500 or tblfeedback.strbusinessname='Glam Couture Bridal' or tblfeedback.strbusinessname='Glam Couture Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Tiffany

Melbourne VIC 3000

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

4.67 stars
3 reviews

Black & Bloom

Melbourne VIC 3000

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=43994 or tblfeedback.strbusinessname='Black &%%semi%% Bloom' or tblfeedback.strbusinessname='Black & Bloom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Michael Hill

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=26473 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.78 stars
9 reviews

Michael Hill

Warrnambool VIC 3280

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=29129 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.71 stars
7 reviews

Michael Hill

Warrnambool VIC 3280

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=29129 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.71 stars
7 reviews

Michael Hill

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=26473 or tblfeedback.strbusinessname='Michael Hill' or tblfeedback.strbusinessname='Michael Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

4.78 stars
9 reviews

Crystal Bay Bridal

Brisbane QLD 4000

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=27737 or tblfeedback.strbusinessname='Crystal Bay Bridal' or tblfeedback.strbusinessname='Crystal Bay Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

QLD

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

Pope Kevin Atwood Manufacturing Jeweller Pty Ltd

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=11018 or tblfeedback.strbusinessname='Pope Kevin Atwood Manufacturing Jeweller Pty Ltd' or tblfeedback.strbusinessname='Pope Kevin Atwood Manufacturing Jeweller Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Barrett Derek

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=8092 or tblfeedback.strbusinessname='Barrett Derek' or tblfeedback.strbusinessname='Barrett Derek') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Terrace Jewellery Pty Ltd

Raymond Terrace NSW 2324

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=11706 or tblfeedback.strbusinessname='Terrace Jewellery Pty Ltd' or tblfeedback.strbusinessname='Terrace Jewellery Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

CBH Jewelery Design

Jesmond NSW 2299

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=8571 or tblfeedback.strbusinessname='CBH Jewelery Design' or tblfeedback.strbusinessname='CBH Jewelery Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Moore

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

Cagney

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

1 - 20 of 20 Sort search results alphabetically