anke SELECT DISTINCT p.ProductId, p.Make, p.ModelNo, p.SellingPrice, p.WebFlags, p.ShortDesc, p.EnergyRating, p.StrapLine, p.OldPrice, p.Itemtype, p.Producttype, p.DeliverySurcharge, p.Group1, p.Group2, p.Group3, p.Colour, p.MainImageName, p.ActualStock, p.ManufactureGuarantee, p.SellOnWeb , pf.FilterOptions FROM productgroups p Inner Join productfilters pf ON p.ModelNo = pf.ModelNo AND p.Group1 = pf.Group1Name AND p.Group2 = pf.Group2Name WHERE p.ProductId IS NOT NULL AND NOT (p.ProductId = 1719 OR p.ProductId = 5595) AND ( Group1 = 'sound & vision' AND Group2 = 'headphones' AND Mid(pf.FilterOptions,1,2) = '01' ) GROUP BY p.ModelNo ORDER BY SellingPrice ASC, p.Make ASC, p.ModelNo ASC
Headphones - Buy Headphones Online | E.B. Marsh

Apply product filters...


Price range:

Minimum Price

Maximum Price

Free Delivery & Installation

In some cases we are able to offer free local delivery and installation.

Please see our 'Delivery & Installation' page for more information.

Showing of 2 items

Sort by:

This is the first page  This is the first page  Prev  [ Page 1 of 1 ]  Next  This is the last page  This is the last page

Back to top