Selected country
WAHL Global logo

Pet Grooming

Products

7 products match your search criteria

Narrow Your Results
Categories
I'm trying to:
Product Type
Price

Sort By:

Bravura

1870-0447

MSRP: $

Bravura

1870-0447

MSRP: $

Chromini Red

1591-0444

MSRP: $

Chromini Red

1591-0444

MSRP: $

MIKE BOYLES TEST PRODUCT

333-333

MSRP: $3.00

Mike Boyles Test

Show Pro

9265-2055PA

MSRP: $

Show Pro

9265-2055PA

MSRP: $

SELECT distinct productTitle, Video1Thumb, Image1, MSRP, price, Paragraph, categoriesFilter, tryingToFilter, productTypeFilter, serialNumber, url, ProductDescriptionID, importance FROM WahlGlobalKentico.dbo.custom_ProductDescription inner join CMS_Document on custom_ProductDescription.productTitle = CMS_Document.DocumentName WHERE (DocumentPublishTo IS NULL OR DocumentPublishTo > GETDATE()) AND CMS_Document.DocumentCulture = 'en-US' AND categoriesFilter = 'petGrooming' AND ( productTypeFilter like '%cordlessClippers%') ORDER BY importance DESC