Rating
Oeil Makeup and Hairstyling
Central Coast 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=29274 or tblfeedback.strbusinessname='Oeil Makeup and Hairstyling' or tblfeedback.strbusinessname='Oeil Makeup and Hairstyling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bridal Glow Hair Design
Central Coast NSW 2083
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=29619 or tblfeedback.strbusinessname='Bridal Glow Hair Design' or tblfeedback.strbusinessname='Bridal Glow Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brooke Ellen Makeup Artistry
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=39817 or tblfeedback.strbusinessname='Brooke Ellen Makeup Artistry' or tblfeedback.strbusinessname='Brooke Ellen Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Face On Beauty
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=29209 or tblfeedback.strbusinessname='Face On Beauty' or tblfeedback.strbusinessname='Face On Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Make Up Artistry By Alex
Central Coast NSW 2083
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=29618 or tblfeedback.strbusinessname='Make Up Artistry By Alex' or tblfeedback.strbusinessname='Make Up Artistry By Alex') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
JBMA makeup
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=29368 or tblfeedback.strbusinessname='JBMA makeup' or tblfeedback.strbusinessname='JBMA makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair by Aimee Hanslow
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=26806 or tblfeedback.strbusinessname='Hair by Aimee Hanslow' or tblfeedback.strbusinessname='Hair by Aimee Hanslow') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Signature Hair Designs
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=39618 or tblfeedback.strbusinessname='Signature Hair Designs' or tblfeedback.strbusinessname='Signature Hair Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All Made Up Makeup Beauty Hair
Turramurra NSW 2074
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=44730 or tblfeedback.strbusinessname='All Made Up Makeup Beauty Hair' or tblfeedback.strbusinessname='All Made Up Makeup Beauty Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Raw Hair & Makeup
The Entrance 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=27346 or tblfeedback.strbusinessname='Raw Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='Raw Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flayr
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=38132 or tblfeedback.strbusinessname='Flayr' or tblfeedback.strbusinessname='Flayr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sam Mooney - Hair & Makeup Artist
Berowra NSW 2081
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=43119 or tblfeedback.strbusinessname='Sam Mooney - Hair & Makeup Artist' or tblfeedback.strbusinessname='Sam Mooney - Hair & Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shazzam Makeup Artistry
Somersby 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=26829 or tblfeedback.strbusinessname='Shazzam Makeup Artistry' or tblfeedback.strbusinessname='Shazzam Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kayla Clifford Makeup Artist
The Entrance 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=39742 or tblfeedback.strbusinessname='Kayla Clifford Makeup Artist' or tblfeedback.strbusinessname='Kayla Clifford Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kimidoll Makeup Artistry
Muswellbrook NSW 2333
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=21596 or tblfeedback.strbusinessname='Kimidoll Makeup Artistry' or tblfeedback.strbusinessname='Kimidoll Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Silk Hair and Beauty Bar
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=29111 or tblfeedback.strbusinessname='Silk Hair and Beauty Bar' or tblfeedback.strbusinessname='Silk Hair and Beauty Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Luxe Makeup Artistry
Central Coast 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=21554 or tblfeedback.strbusinessname='Luxe Makeup Artistry' or tblfeedback.strbusinessname='Luxe Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sizzor Trix Hair Salon
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=27777 or tblfeedback.strbusinessname='Sizzor Trix Hair Salon' or tblfeedback.strbusinessname='Sizzor Trix Hair Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gloss Girl
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=26024 or tblfeedback.strbusinessname='Gloss Girl' or tblfeedback.strbusinessname='Gloss Girl') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cassy Morris Mobile Hairstylist
Central Coast 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=27502 or tblfeedback.strbusinessname='Cassy Morris Mobile Hairstylist' or tblfeedback.strbusinessname='Cassy Morris Mobile Hairstylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beck'n'call Mobile Hair Design
Kincumber NSW 2251
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=8135 or tblfeedback.strbusinessname='Beck'%%semi%%n'%%semi%%call Mobile Hair Design' or tblfeedback.strbusinessname='Beck'n'call Mobile Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bliss Hair Beauty Body
The Entrance 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=18526 or tblfeedback.strbusinessname='Bliss Hair Beauty Body' or tblfeedback.strbusinessname='Bliss Hair Beauty Body') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Killarney Vale Beauty Salon
Killarney 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=10075 or tblfeedback.strbusinessname='Killarney Vale Beauty Salon' or tblfeedback.strbusinessname='Killarney Vale Beauty Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beautiful Makeovers-Mobile
Narara 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=8131 or tblfeedback.strbusinessname='Beautiful Makeovers-Mobile' or tblfeedback.strbusinessname='Beautiful Makeovers-Mobile') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Face Mechanic The
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=9232 or tblfeedback.strbusinessname='Face Mechanic The' or tblfeedback.strbusinessname='Face Mechanic The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Zapps Hair Studio
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=18578 or tblfeedback.strbusinessname='Zapps Hair Studio' or tblfeedback.strbusinessname='Zapps Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jayne Harris Professional Make-Up Artist
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=9892 or tblfeedback.strbusinessname='Jayne Harris Professional Make-Up Artist' or tblfeedback.strbusinessname='Jayne Harris Professional Make-Up Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dial A Makeover
Holgate 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=9007 or tblfeedback.strbusinessname='Dial A Makeover' or tblfeedback.strbusinessname='Dial A Makeover') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Absolutely Glamorous
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=7721 or tblfeedback.strbusinessname='Absolutely Glamorous' or tblfeedback.strbusinessname='Absolutely Glamorous') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Radiance Hair Design
Green Point NSW 2251
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=11102 or tblfeedback.strbusinessname='Radiance Hair Design' or tblfeedback.strbusinessname='Radiance Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Woy Woy House of Hair
Woy Woy NSW 2256
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=12091 or tblfeedback.strbusinessname='Woy Woy House of Hair' or tblfeedback.strbusinessname='Woy Woy House of Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wyongah Hairport
Wyongah 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=12103 or tblfeedback.strbusinessname='Wyongah Hairport' or tblfeedback.strbusinessname='Wyongah Hairport') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Simone's for Hair
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=11412 or tblfeedback.strbusinessname='Simone'%%semi%%s for Hair' or tblfeedback.strbusinessname='Simone's for Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mobile Make Up Art by Samantha
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=10524 or tblfeedback.strbusinessname='Mobile Make Up Art by Samantha' or tblfeedback.strbusinessname='Mobile Make Up Art by Samantha') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Professional Make-Up Artist Tanya T
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=7664 or tblfeedback.strbusinessname='A Professional Make-Up Artist Tanya T' or tblfeedback.strbusinessname='A Professional Make-Up Artist Tanya T') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Belles Hair & Make-Up Service
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=11973 or tblfeedback.strbusinessname='Wedding Belles Hair &%%semi%% Make-Up Service' or tblfeedback.strbusinessname='Wedding Belles Hair & Make-Up Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ann Penny Make Up Artist
Wyoming 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=7855 or tblfeedback.strbusinessname='Ann Penny Make Up Artist' or tblfeedback.strbusinessname='Ann Penny Make Up Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Julie's Hair Loft
Wyoming 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=9987 or tblfeedback.strbusinessname='Julie'%%semi%%s Hair Loft' or tblfeedback.strbusinessname='Julie's Hair Loft') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cassidy & Cassidy
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=8551 or tblfeedback.strbusinessname='Cassidy &%%semi%% Cassidy' or tblfeedback.strbusinessname='Cassidy & Cassidy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cut Off Point The
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=8884 or tblfeedback.strbusinessname='Cut Off Point The' or tblfeedback.strbusinessname='Cut Off Point The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15