Firewood Suppliers near Blackburn

select *,rtrim(left(postcode,len(postcode)-3)) as smallpostcode from serviceproviders where len(postcode)>5 and ( rtrim(left(postcode,len(postcode)-3)) = 'BB1' or rtrim(left(postcode,len(postcode)-3)) = 'BB10' or rtrim(left(postcode,len(postcode)-3)) = 'BB11' or rtrim(left(postcode,len(postcode)-3)) = 'BB12' or rtrim(left(postcode,len(postcode)-3)) = 'BB18' or rtrim(left(postcode,len(postcode)-3)) = 'BB2' or rtrim(left(postcode,len(postcode)-3)) = 'BB3' or rtrim(left(postcode,len(postcode)-3)) = 'BB4' or rtrim(left(postcode,len(postcode)-3)) = 'BB5' or rtrim(left(postcode,len(postcode)-3)) = 'BB6' or rtrim(left(postcode,len(postcode)-3)) = 'BB7' or rtrim(left(postcode,len(postcode)-3)) = 'BB8' or rtrim(left(postcode,len(postcode)-3)) = 'BB9' or rtrim(left(postcode,len(postcode)-3)) = 'BD1' or rtrim(left(postcode,len(postcode)-3)) = 'BD10' or rtrim(left(postcode,len(postcode)-3)) = 'BD12' or rtrim(left(postcode,len(postcode)-3)) = 'BD13' or rtrim(left(postcode,len(postcode)-3)) = 'BD14' or rtrim(left(postcode,len(postcode)-3)) = 'BD15' or rtrim(left(postcode,len(postcode)-3)) = 'BD16' or rtrim(left(postcode,len(postcode)-3)) = 'BD17' or rtrim(left(postcode,len(postcode)-3)) = 'BD18' or rtrim(left(postcode,len(postcode)-3)) = 'BD19' or rtrim(left(postcode,len(postcode)-3)) = 'BD2' or rtrim(left(postcode,len(postcode)-3)) = 'BD20' or rtrim(left(postcode,len(postcode)-3)) = 'BD21' or rtrim(left(postcode,len(postcode)-3)) = 'BD22' or rtrim(left(postcode,len(postcode)-3)) = 'BD23' or rtrim(left(postcode,len(postcode)-3)) = 'BD24' or rtrim(left(postcode,len(postcode)-3)) = 'BD3' or rtrim(left(postcode,len(postcode)-3)) = 'BD4' or rtrim(left(postcode,len(postcode)-3)) = 'BD5' or rtrim(left(postcode,len(postcode)-3)) = 'BD6' or rtrim(left(postcode,len(postcode)-3)) = 'BD7' or rtrim(left(postcode,len(postcode)-3)) = 'BD8' or rtrim(left(postcode,len(postcode)-3)) = 'BD9' or rtrim(left(postcode,len(postcode)-3)) = 'BL0' or rtrim(left(postcode,len(postcode)-3)) = 'BL1' or rtrim(left(postcode,len(postcode)-3)) = 'BL2' or rtrim(left(postcode,len(postcode)-3)) = 'BL3' or rtrim(left(postcode,len(postcode)-3)) = 'BL4' or rtrim(left(postcode,len(postcode)-3)) = 'BL5' or rtrim(left(postcode,len(postcode)-3)) = 'BL6' or rtrim(left(postcode,len(postcode)-3)) = 'BL7' or rtrim(left(postcode,len(postcode)-3)) = 'BL8' or rtrim(left(postcode,len(postcode)-3)) = 'BL9' or rtrim(left(postcode,len(postcode)-3)) = 'BT38' or rtrim(left(postcode,len(postcode)-3)) = 'BT40' or rtrim(left(postcode,len(postcode)-3)) = 'FY1' or rtrim(left(postcode,len(postcode)-3)) = 'FY2' or rtrim(left(postcode,len(postcode)-3)) = 'FY3' or rtrim(left(postcode,len(postcode)-3)) = 'FY4' or rtrim(left(postcode,len(postcode)-3)) = 'FY5' or rtrim(left(postcode,len(postcode)-3)) = 'FY6' or rtrim(left(postcode,len(postcode)-3)) = 'FY7' or rtrim(left(postcode,len(postcode)-3)) = 'FY8' or rtrim(left(postcode,len(postcode)-3)) = 'HD1' or rtrim(left(postcode,len(postcode)-3)) = 'HD2' or rtrim(left(postcode,len(postcode)-3)) = 'HD3' or rtrim(left(postcode,len(postcode)-3)) = 'HD4' or rtrim(left(postcode,len(postcode)-3)) = 'HD5' or rtrim(left(postcode,len(postcode)-3)) = 'HD6' or rtrim(left(postcode,len(postcode)-3)) = 'HD7' or rtrim(left(postcode,len(postcode)-3)) = 'HD9' or rtrim(left(postcode,len(postcode)-3)) = 'HX1' or rtrim(left(postcode,len(postcode)-3)) = 'HX2' or rtrim(left(postcode,len(postcode)-3)) = 'HX3' or rtrim(left(postcode,len(postcode)-3)) = 'HX4' or rtrim(left(postcode,len(postcode)-3)) = 'HX5' or rtrim(left(postcode,len(postcode)-3)) = 'HX6' or rtrim(left(postcode,len(postcode)-3)) = 'HX7' or rtrim(left(postcode,len(postcode)-3)) = 'L10' or rtrim(left(postcode,len(postcode)-3)) = 'L11' or rtrim(left(postcode,len(postcode)-3)) = 'L12' or rtrim(left(postcode,len(postcode)-3)) = 'L13' or rtrim(left(postcode,len(postcode)-3)) = 'L14' or rtrim(left(postcode,len(postcode)-3)) = 'L16' or rtrim(left(postcode,len(postcode)-3)) = 'L20' or rtrim(left(postcode,len(postcode)-3)) = 'L21' or rtrim(left(postcode,len(postcode)-3)) = 'L22' or rtrim(left(postcode,len(postcode)-3)) = 'L23' or rtrim(left(postcode,len(postcode)-3)) = 'L25' or rtrim(left(postcode,len(postcode)-3)) = 'L27' or rtrim(left(postcode,len(postcode)-3)) = 'L28' or rtrim(left(postcode,len(postcode)-3)) = 'L29' or rtrim(left(postcode,len(postcode)-3)) = 'L30' or rtrim(left(postcode,len(postcode)-3)) = 'L31' or rtrim(left(postcode,len(postcode)-3)) = 'L32' or rtrim(left(postcode,len(postcode)-3)) = 'L33' or rtrim(left(postcode,len(postcode)-3)) = 'L34' or rtrim(left(postcode,len(postcode)-3)) = 'L35' or rtrim(left(postcode,len(postcode)-3)) = 'L36' or rtrim(left(postcode,len(postcode)-3)) = 'L37' or rtrim(left(postcode,len(postcode)-3)) = 'L38' or rtrim(left(postcode,len(postcode)-3)) = 'L39' or rtrim(left(postcode,len(postcode)-3)) = 'L4' or rtrim(left(postcode,len(postcode)-3)) = 'L40' or rtrim(left(postcode,len(postcode)-3)) = 'L6' or rtrim(left(postcode,len(postcode)-3)) = 'L9' or rtrim(left(postcode,len(postcode)-3)) = 'LA1' or rtrim(left(postcode,len(postcode)-3)) = 'LA2' or rtrim(left(postcode,len(postcode)-3)) = 'LA3' or rtrim(left(postcode,len(postcode)-3)) = 'LA4' or rtrim(left(postcode,len(postcode)-3)) = 'LA5' or rtrim(left(postcode,len(postcode)-3)) = 'LA6' or rtrim(left(postcode,len(postcode)-3)) = 'LS29' or rtrim(left(postcode,len(postcode)-3)) = 'M1' or rtrim(left(postcode,len(postcode)-3)) = 'M11' or rtrim(left(postcode,len(postcode)-3)) = 'M12' or rtrim(left(postcode,len(postcode)-3)) = 'M13' or rtrim(left(postcode,len(postcode)-3)) = 'M14' or rtrim(left(postcode,len(postcode)-3)) = 'M15' or rtrim(left(postcode,len(postcode)-3)) = 'M16' or rtrim(left(postcode,len(postcode)-3)) = 'M17' or rtrim(left(postcode,len(postcode)-3)) = 'M18' or rtrim(left(postcode,len(postcode)-3)) = 'M19' or rtrim(left(postcode,len(postcode)-3)) = 'M2' or rtrim(left(postcode,len(postcode)-3)) = 'M20' or rtrim(left(postcode,len(postcode)-3)) = 'M21' or rtrim(left(postcode,len(postcode)-3)) = 'M22' or rtrim(left(postcode,len(postcode)-3)) = 'M23' or rtrim(left(postcode,len(postcode)-3)) = 'M24' or rtrim(left(postcode,len(postcode)-3)) = 'M25' or rtrim(left(postcode,len(postcode)-3)) = 'M26' or rtrim(left(postcode,len(postcode)-3)) = 'M27' or rtrim(left(postcode,len(postcode)-3)) = 'M28' or rtrim(left(postcode,len(postcode)-3)) = 'M29' or rtrim(left(postcode,len(postcode)-3)) = 'M3' or rtrim(left(postcode,len(postcode)-3)) = 'M30' or rtrim(left(postcode,len(postcode)-3)) = 'M31' or rtrim(left(postcode,len(postcode)-3)) = 'M32' or rtrim(left(postcode,len(postcode)-3)) = 'M33' or rtrim(left(postcode,len(postcode)-3)) = 'M34' or rtrim(left(postcode,len(postcode)-3)) = 'M35' or rtrim(left(postcode,len(postcode)-3)) = 'M38' or rtrim(left(postcode,len(postcode)-3)) = 'M4' or rtrim(left(postcode,len(postcode)-3)) = 'M40' or rtrim(left(postcode,len(postcode)-3)) = 'M41' or rtrim(left(postcode,len(postcode)-3)) = 'M43' or rtrim(left(postcode,len(postcode)-3)) = 'M44' or rtrim(left(postcode,len(postcode)-3)) = 'M45' or rtrim(left(postcode,len(postcode)-3)) = 'M46' or rtrim(left(postcode,len(postcode)-3)) = 'M5' or rtrim(left(postcode,len(postcode)-3)) = 'M6' or rtrim(left(postcode,len(postcode)-3)) = 'M60' or rtrim(left(postcode,len(postcode)-3)) = 'M7' or rtrim(left(postcode,len(postcode)-3)) = 'M8' or rtrim(left(postcode,len(postcode)-3)) = 'M9' or rtrim(left(postcode,len(postcode)-3)) = 'M90' or rtrim(left(postcode,len(postcode)-3)) = 'OL1' or rtrim(left(postcode,len(postcode)-3)) = 'OL10' or rtrim(left(postcode,len(postcode)-3)) = 'OL11' or rtrim(left(postcode,len(postcode)-3)) = 'OL12' or rtrim(left(postcode,len(postcode)-3)) = 'OL13' or rtrim(left(postcode,len(postcode)-3)) = 'OL14' or rtrim(left(postcode,len(postcode)-3)) = 'OL15' or rtrim(left(postcode,len(postcode)-3)) = 'OL16' or rtrim(left(postcode,len(postcode)-3)) = 'OL2' or rtrim(left(postcode,len(postcode)-3)) = 'OL3' or rtrim(left(postcode,len(postcode)-3)) = 'OL4' or rtrim(left(postcode,len(postcode)-3)) = 'OL5' or rtrim(left(postcode,len(postcode)-3)) = 'OL6' or rtrim(left(postcode,len(postcode)-3)) = 'OL7' or rtrim(left(postcode,len(postcode)-3)) = 'OL8' or rtrim(left(postcode,len(postcode)-3)) = 'OL9' or rtrim(left(postcode,len(postcode)-3)) = 'PR1' or rtrim(left(postcode,len(postcode)-3)) = 'PR2' or rtrim(left(postcode,len(postcode)-3)) = 'PR25' or rtrim(left(postcode,len(postcode)-3)) = 'PR26' or rtrim(left(postcode,len(postcode)-3)) = 'PR3' or rtrim(left(postcode,len(postcode)-3)) = 'PR4' or rtrim(left(postcode,len(postcode)-3)) = 'PR5' or rtrim(left(postcode,len(postcode)-3)) = 'PR6' or rtrim(left(postcode,len(postcode)-3)) = 'PR7' or rtrim(left(postcode,len(postcode)-3)) = 'PR8' or rtrim(left(postcode,len(postcode)-3)) = 'PR9' or rtrim(left(postcode,len(postcode)-3)) = 'SK1' or rtrim(left(postcode,len(postcode)-3)) = 'SK13' or rtrim(left(postcode,len(postcode)-3)) = 'SK14' or rtrim(left(postcode,len(postcode)-3)) = 'SK15' or rtrim(left(postcode,len(postcode)-3)) = 'SK16' or rtrim(left(postcode,len(postcode)-3)) = 'SK2' or rtrim(left(postcode,len(postcode)-3)) = 'SK3' or rtrim(left(postcode,len(postcode)-3)) = 'SK4' or rtrim(left(postcode,len(postcode)-3)) = 'SK5' or rtrim(left(postcode,len(postcode)-3)) = 'SK6' or rtrim(left(postcode,len(postcode)-3)) = 'SK7' or rtrim(left(postcode,len(postcode)-3)) = 'SK8' or rtrim(left(postcode,len(postcode)-3)) = 'WA1' or rtrim(left(postcode,len(postcode)-3)) = 'WA10' or rtrim(left(postcode,len(postcode)-3)) = 'WA11' or rtrim(left(postcode,len(postcode)-3)) = 'WA12' or rtrim(left(postcode,len(postcode)-3)) = 'WA13' or rtrim(left(postcode,len(postcode)-3)) = 'WA14' or rtrim(left(postcode,len(postcode)-3)) = 'WA15' or rtrim(left(postcode,len(postcode)-3)) = 'WA2' or rtrim(left(postcode,len(postcode)-3)) = 'WA3' or rtrim(left(postcode,len(postcode)-3)) = 'WA4' or rtrim(left(postcode,len(postcode)-3)) = 'WA5' or rtrim(left(postcode,len(postcode)-3)) = 'WA8' or rtrim(left(postcode,len(postcode)-3)) = 'WA9' or rtrim(left(postcode,len(postcode)-3)) = 'WN1' or rtrim(left(postcode,len(postcode)-3)) = 'WN2' or rtrim(left(postcode,len(postcode)-3)) = 'WN3' or rtrim(left(postcode,len(postcode)-3)) = 'WN4' or rtrim(left(postcode,len(postcode)-3)) = 'WN5' or rtrim(left(postcode,len(postcode)-3)) = 'WN6' or rtrim(left(postcode,len(postcode)-3)) = 'WN7' or rtrim(left(postcode,len(postcode)-3)) = 'WN8' ) and webVisible = 1 AND wood = 1 AND stoveinstal = 0 AND fireplaceinstal = 0 AND doubleskinflue = 0 AND liner = 0 order by len(areas) asc

Click here to conduct another search

If you are a wood supplier and would like to appear here for free then please complete this simple Application form

We provide this as a an extra information service to our customers but obviously do not have time to go out and individually vet all the people listed. We cannot be held responsible if you are not satisfied with any of the people or companies listed here as you will be dealing with them directly. Please do let us know though is you have a particular complaint about someone listed.