Firewood Suppliers around near Harrow

select *,rtrim(left(postcode,len(postcode)-3)) as smallpostcode from serviceproviders where len(postcode)>5 and ( rtrim(left(postcode,len(postcode)-3)) = 'AL1' or rtrim(left(postcode,len(postcode)-3)) = 'AL10' or rtrim(left(postcode,len(postcode)-3)) = 'AL2' or rtrim(left(postcode,len(postcode)-3)) = 'AL3' or rtrim(left(postcode,len(postcode)-3)) = 'AL4' or rtrim(left(postcode,len(postcode)-3)) = 'AL5' or rtrim(left(postcode,len(postcode)-3)) = 'AL6' or rtrim(left(postcode,len(postcode)-3)) = 'AL7' or rtrim(left(postcode,len(postcode)-3)) = 'AL8' or rtrim(left(postcode,len(postcode)-3)) = 'AL9' or rtrim(left(postcode,len(postcode)-3)) = 'BR1' or rtrim(left(postcode,len(postcode)-3)) = 'BR2' or rtrim(left(postcode,len(postcode)-3)) = 'BR3' or rtrim(left(postcode,len(postcode)-3)) = 'BR4' or rtrim(left(postcode,len(postcode)-3)) = 'BR5' or rtrim(left(postcode,len(postcode)-3)) = 'BR6' or rtrim(left(postcode,len(postcode)-3)) = 'BR7' or rtrim(left(postcode,len(postcode)-3)) = 'BR8' or rtrim(left(postcode,len(postcode)-3)) = 'CM13' or rtrim(left(postcode,len(postcode)-3)) = 'CM14' or rtrim(left(postcode,len(postcode)-3)) = 'CM15' or rtrim(left(postcode,len(postcode)-3)) = 'CM16' or rtrim(left(postcode,len(postcode)-3)) = 'CM17' or rtrim(left(postcode,len(postcode)-3)) = 'CM18' or rtrim(left(postcode,len(postcode)-3)) = 'CM19' or rtrim(left(postcode,len(postcode)-3)) = 'CM20' or rtrim(left(postcode,len(postcode)-3)) = 'CM21' or rtrim(left(postcode,len(postcode)-3)) = 'CM23' or rtrim(left(postcode,len(postcode)-3)) = 'CM5' or rtrim(left(postcode,len(postcode)-3)) = 'CR0' or rtrim(left(postcode,len(postcode)-3)) = 'CR2' or rtrim(left(postcode,len(postcode)-3)) = 'CR3' or rtrim(left(postcode,len(postcode)-3)) = 'CR4' or rtrim(left(postcode,len(postcode)-3)) = 'CR5' or rtrim(left(postcode,len(postcode)-3)) = 'CR6' or rtrim(left(postcode,len(postcode)-3)) = 'CR7' or rtrim(left(postcode,len(postcode)-3)) = 'CR8' or rtrim(left(postcode,len(postcode)-3)) = 'DA1' or rtrim(left(postcode,len(postcode)-3)) = 'DA10' or rtrim(left(postcode,len(postcode)-3)) = 'DA11' or rtrim(left(postcode,len(postcode)-3)) = 'DA13' or rtrim(left(postcode,len(postcode)-3)) = 'DA14' or rtrim(left(postcode,len(postcode)-3)) = 'DA15' or rtrim(left(postcode,len(postcode)-3)) = 'DA16' or rtrim(left(postcode,len(postcode)-3)) = 'DA17' or rtrim(left(postcode,len(postcode)-3)) = 'DA18' or rtrim(left(postcode,len(postcode)-3)) = 'DA2' or rtrim(left(postcode,len(postcode)-3)) = 'DA3' or rtrim(left(postcode,len(postcode)-3)) = 'DA4' or rtrim(left(postcode,len(postcode)-3)) = 'DA5' or rtrim(left(postcode,len(postcode)-3)) = 'DA6' or rtrim(left(postcode,len(postcode)-3)) = 'DA7' or rtrim(left(postcode,len(postcode)-3)) = 'DA8' or rtrim(left(postcode,len(postcode)-3)) = 'DA9' or rtrim(left(postcode,len(postcode)-3)) = 'E1' or rtrim(left(postcode,len(postcode)-3)) = 'E10' or rtrim(left(postcode,len(postcode)-3)) = 'E11' or rtrim(left(postcode,len(postcode)-3)) = 'E12' or rtrim(left(postcode,len(postcode)-3)) = 'E13' or rtrim(left(postcode,len(postcode)-3)) = 'E14' or rtrim(left(postcode,len(postcode)-3)) = 'E15' or rtrim(left(postcode,len(postcode)-3)) = 'E16' or rtrim(left(postcode,len(postcode)-3)) = 'E17' or rtrim(left(postcode,len(postcode)-3)) = 'E18' or rtrim(left(postcode,len(postcode)-3)) = 'E1W' or rtrim(left(postcode,len(postcode)-3)) = 'E2' or rtrim(left(postcode,len(postcode)-3)) = 'E3' or rtrim(left(postcode,len(postcode)-3)) = 'E4' or rtrim(left(postcode,len(postcode)-3)) = 'E5' or rtrim(left(postcode,len(postcode)-3)) = 'E6' or rtrim(left(postcode,len(postcode)-3)) = 'E7' or rtrim(left(postcode,len(postcode)-3)) = 'E8' or rtrim(left(postcode,len(postcode)-3)) = 'E9' or rtrim(left(postcode,len(postcode)-3)) = 'EC1' or rtrim(left(postcode,len(postcode)-3)) = 'EC1A' or rtrim(left(postcode,len(postcode)-3)) = 'EC1M' or rtrim(left(postcode,len(postcode)-3)) = 'EC1N' or rtrim(left(postcode,len(postcode)-3)) = 'EC1R' or rtrim(left(postcode,len(postcode)-3)) = 'EC1V' or rtrim(left(postcode,len(postcode)-3)) = 'EC1Y' or rtrim(left(postcode,len(postcode)-3)) = 'EC2' or rtrim(left(postcode,len(postcode)-3)) = 'EC2A' or rtrim(left(postcode,len(postcode)-3)) = 'EC2M' or rtrim(left(postcode,len(postcode)-3)) = 'EC2N' or rtrim(left(postcode,len(postcode)-3)) = 'EC2R' or rtrim(left(postcode,len(postcode)-3)) = 'EC2V' or rtrim(left(postcode,len(postcode)-3)) = 'EC2Y' or rtrim(left(postcode,len(postcode)-3)) = 'EC3' or rtrim(left(postcode,len(postcode)-3)) = 'EC3A' or rtrim(left(postcode,len(postcode)-3)) = 'EC3M' or rtrim(left(postcode,len(postcode)-3)) = 'EC3N' or rtrim(left(postcode,len(postcode)-3)) = 'EC3P' or rtrim(left(postcode,len(postcode)-3)) = 'EC3R' or rtrim(left(postcode,len(postcode)-3)) = 'EC3V' or rtrim(left(postcode,len(postcode)-3)) = 'EC4' or rtrim(left(postcode,len(postcode)-3)) = 'EC4A' or rtrim(left(postcode,len(postcode)-3)) = 'EC4M' or rtrim(left(postcode,len(postcode)-3)) = 'EC4N' or rtrim(left(postcode,len(postcode)-3)) = 'EC4R' or rtrim(left(postcode,len(postcode)-3)) = 'EC4V' or rtrim(left(postcode,len(postcode)-3)) = 'EC4Y' or rtrim(left(postcode,len(postcode)-3)) = 'EN1' or rtrim(left(postcode,len(postcode)-3)) = 'EN10' or rtrim(left(postcode,len(postcode)-3)) = 'EN11' or rtrim(left(postcode,len(postcode)-3)) = 'EN2' or rtrim(left(postcode,len(postcode)-3)) = 'EN3' or rtrim(left(postcode,len(postcode)-3)) = 'EN4' or rtrim(left(postcode,len(postcode)-3)) = 'EN5' or rtrim(left(postcode,len(postcode)-3)) = 'EN6' or rtrim(left(postcode,len(postcode)-3)) = 'EN7' or rtrim(left(postcode,len(postcode)-3)) = 'EN8' or rtrim(left(postcode,len(postcode)-3)) = 'EN9' or rtrim(left(postcode,len(postcode)-3)) = 'GU1' or rtrim(left(postcode,len(postcode)-3)) = 'GU11' or rtrim(left(postcode,len(postcode)-3)) = 'GU12' or rtrim(left(postcode,len(postcode)-3)) = 'GU13' or rtrim(left(postcode,len(postcode)-3)) = 'GU14' or rtrim(left(postcode,len(postcode)-3)) = 'GU15' or rtrim(left(postcode,len(postcode)-3)) = 'GU16' or rtrim(left(postcode,len(postcode)-3)) = 'GU17' or rtrim(left(postcode,len(postcode)-3)) = 'GU18' or rtrim(left(postcode,len(postcode)-3)) = 'GU19' or rtrim(left(postcode,len(postcode)-3)) = 'GU2' or rtrim(left(postcode,len(postcode)-3)) = 'GU20' or rtrim(left(postcode,len(postcode)-3)) = 'GU21' or rtrim(left(postcode,len(postcode)-3)) = 'GU22' or rtrim(left(postcode,len(postcode)-3)) = 'GU23' or rtrim(left(postcode,len(postcode)-3)) = 'GU24' or rtrim(left(postcode,len(postcode)-3)) = 'GU25' or rtrim(left(postcode,len(postcode)-3)) = 'GU3' or rtrim(left(postcode,len(postcode)-3)) = 'GU4' or rtrim(left(postcode,len(postcode)-3)) = 'GU46' or rtrim(left(postcode,len(postcode)-3)) = 'GU47' or rtrim(left(postcode,len(postcode)-3)) = 'GU5' or rtrim(left(postcode,len(postcode)-3)) = 'GU51' or rtrim(left(postcode,len(postcode)-3)) = 'GU52' or rtrim(left(postcode,len(postcode)-3)) = 'GU6' or rtrim(left(postcode,len(postcode)-3)) = 'GU7' or rtrim(left(postcode,len(postcode)-3)) = 'HA0' or rtrim(left(postcode,len(postcode)-3)) = 'HA1' or rtrim(left(postcode,len(postcode)-3)) = 'HA2' or rtrim(left(postcode,len(postcode)-3)) = 'HA3' or rtrim(left(postcode,len(postcode)-3)) = 'HA4' or rtrim(left(postcode,len(postcode)-3)) = 'HA5' or rtrim(left(postcode,len(postcode)-3)) = 'HA6' or rtrim(left(postcode,len(postcode)-3)) = 'HA7' or rtrim(left(postcode,len(postcode)-3)) = 'HA8' or rtrim(left(postcode,len(postcode)-3)) = 'HA9' or rtrim(left(postcode,len(postcode)-3)) = 'HP1' or rtrim(left(postcode,len(postcode)-3)) = 'HP10' or rtrim(left(postcode,len(postcode)-3)) = 'HP11' or rtrim(left(postcode,len(postcode)-3)) = 'HP12' or rtrim(left(postcode,len(postcode)-3)) = 'HP13' or rtrim(left(postcode,len(postcode)-3)) = 'HP14' or rtrim(left(postcode,len(postcode)-3)) = 'HP15' or rtrim(left(postcode,len(postcode)-3)) = 'HP16' or rtrim(left(postcode,len(postcode)-3)) = 'HP17' or rtrim(left(postcode,len(postcode)-3)) = 'HP19' or rtrim(left(postcode,len(postcode)-3)) = 'HP2' or rtrim(left(postcode,len(postcode)-3)) = 'HP20' or rtrim(left(postcode,len(postcode)-3)) = 'HP21' or rtrim(left(postcode,len(postcode)-3)) = 'HP22' or rtrim(left(postcode,len(postcode)-3)) = 'HP23' or rtrim(left(postcode,len(postcode)-3)) = 'HP27' or rtrim(left(postcode,len(postcode)-3)) = 'HP3' or rtrim(left(postcode,len(postcode)-3)) = 'HP4' or rtrim(left(postcode,len(postcode)-3)) = 'HP5' or rtrim(left(postcode,len(postcode)-3)) = 'HP6' or rtrim(left(postcode,len(postcode)-3)) = 'HP7' or rtrim(left(postcode,len(postcode)-3)) = 'HP8' or rtrim(left(postcode,len(postcode)-3)) = 'HP9' or rtrim(left(postcode,len(postcode)-3)) = 'IG1' or rtrim(left(postcode,len(postcode)-3)) = 'IG10' or rtrim(left(postcode,len(postcode)-3)) = 'IG11' or rtrim(left(postcode,len(postcode)-3)) = 'IG2' or rtrim(left(postcode,len(postcode)-3)) = 'IG3' or rtrim(left(postcode,len(postcode)-3)) = 'IG4' or rtrim(left(postcode,len(postcode)-3)) = 'IG5' or rtrim(left(postcode,len(postcode)-3)) = 'IG6' or rtrim(left(postcode,len(postcode)-3)) = 'IG7' or rtrim(left(postcode,len(postcode)-3)) = 'IG8' or rtrim(left(postcode,len(postcode)-3)) = 'IG9' or rtrim(left(postcode,len(postcode)-3)) = 'KT1' or rtrim(left(postcode,len(postcode)-3)) = 'KT10' or rtrim(left(postcode,len(postcode)-3)) = 'KT11' or rtrim(left(postcode,len(postcode)-3)) = 'KT12' or rtrim(left(postcode,len(postcode)-3)) = 'KT13' or rtrim(left(postcode,len(postcode)-3)) = 'KT14' or rtrim(left(postcode,len(postcode)-3)) = 'KT15' or rtrim(left(postcode,len(postcode)-3)) = 'KT16' or rtrim(left(postcode,len(postcode)-3)) = 'KT17' or rtrim(left(postcode,len(postcode)-3)) = 'KT18' or rtrim(left(postcode,len(postcode)-3)) = 'KT19' or rtrim(left(postcode,len(postcode)-3)) = 'KT2' or rtrim(left(postcode,len(postcode)-3)) = 'KT20' or rtrim(left(postcode,len(postcode)-3)) = 'KT21' or rtrim(left(postcode,len(postcode)-3)) = 'KT22' or rtrim(left(postcode,len(postcode)-3)) = 'KT23' or rtrim(left(postcode,len(postcode)-3)) = 'KT24' or rtrim(left(postcode,len(postcode)-3)) = 'KT3' or rtrim(left(postcode,len(postcode)-3)) = 'KT4' or rtrim(left(postcode,len(postcode)-3)) = 'KT5' or rtrim(left(postcode,len(postcode)-3)) = 'KT6' or rtrim(left(postcode,len(postcode)-3)) = 'KT7' or rtrim(left(postcode,len(postcode)-3)) = 'KT8' or rtrim(left(postcode,len(postcode)-3)) = 'KT9' or rtrim(left(postcode,len(postcode)-3)) = 'LU1' or rtrim(left(postcode,len(postcode)-3)) = 'LU2' or rtrim(left(postcode,len(postcode)-3)) = 'LU3' or rtrim(left(postcode,len(postcode)-3)) = 'LU4' or rtrim(left(postcode,len(postcode)-3)) = 'LU5' or rtrim(left(postcode,len(postcode)-3)) = 'LU6' or rtrim(left(postcode,len(postcode)-3)) = 'LU7' or rtrim(left(postcode,len(postcode)-3)) = 'N1' or rtrim(left(postcode,len(postcode)-3)) = 'N10' or rtrim(left(postcode,len(postcode)-3)) = 'N11' or rtrim(left(postcode,len(postcode)-3)) = 'N12' or rtrim(left(postcode,len(postcode)-3)) = 'N13' or rtrim(left(postcode,len(postcode)-3)) = 'N14' or rtrim(left(postcode,len(postcode)-3)) = 'N15' or rtrim(left(postcode,len(postcode)-3)) = 'N16' or rtrim(left(postcode,len(postcode)-3)) = 'N17' or rtrim(left(postcode,len(postcode)-3)) = 'N18' or rtrim(left(postcode,len(postcode)-3)) = 'N19' or rtrim(left(postcode,len(postcode)-3)) = 'N2' or rtrim(left(postcode,len(postcode)-3)) = 'N20' or rtrim(left(postcode,len(postcode)-3)) = 'N21' or rtrim(left(postcode,len(postcode)-3)) = 'N22' or rtrim(left(postcode,len(postcode)-3)) = 'N3' or rtrim(left(postcode,len(postcode)-3)) = 'N4' or rtrim(left(postcode,len(postcode)-3)) = 'N5' or rtrim(left(postcode,len(postcode)-3)) = 'N6' or rtrim(left(postcode,len(postcode)-3)) = 'N7' or rtrim(left(postcode,len(postcode)-3)) = 'N8' or rtrim(left(postcode,len(postcode)-3)) = 'N9' or rtrim(left(postcode,len(postcode)-3)) = 'NW1' or rtrim(left(postcode,len(postcode)-3)) = 'NW10' or rtrim(left(postcode,len(postcode)-3)) = 'NW11' or rtrim(left(postcode,len(postcode)-3)) = 'NW2' or rtrim(left(postcode,len(postcode)-3)) = 'NW3' or rtrim(left(postcode,len(postcode)-3)) = 'NW4' or rtrim(left(postcode,len(postcode)-3)) = 'NW5' or rtrim(left(postcode,len(postcode)-3)) = 'NW6' or rtrim(left(postcode,len(postcode)-3)) = 'NW7' or rtrim(left(postcode,len(postcode)-3)) = 'NW8' or rtrim(left(postcode,len(postcode)-3)) = 'NW9' or rtrim(left(postcode,len(postcode)-3)) = 'OX39' or rtrim(left(postcode,len(postcode)-3)) = 'OX49' or rtrim(left(postcode,len(postcode)-3)) = 'RG1' or rtrim(left(postcode,len(postcode)-3)) = 'RG10' or rtrim(left(postcode,len(postcode)-3)) = 'RG12' or rtrim(left(postcode,len(postcode)-3)) = 'RG2' or rtrim(left(postcode,len(postcode)-3)) = 'RG4' or rtrim(left(postcode,len(postcode)-3)) = 'RG40' or rtrim(left(postcode,len(postcode)-3)) = 'RG41' or rtrim(left(postcode,len(postcode)-3)) = 'RG42' or rtrim(left(postcode,len(postcode)-3)) = 'RG45' or rtrim(left(postcode,len(postcode)-3)) = 'RG5' or rtrim(left(postcode,len(postcode)-3)) = 'RG6' or rtrim(left(postcode,len(postcode)-3)) = 'RG9' or rtrim(left(postcode,len(postcode)-3)) = 'RH1' or rtrim(left(postcode,len(postcode)-3)) = 'RH10' or rtrim(left(postcode,len(postcode)-3)) = 'RH11' or rtrim(left(postcode,len(postcode)-3)) = 'RH2' or rtrim(left(postcode,len(postcode)-3)) = 'RH3' or rtrim(left(postcode,len(postcode)-3)) = 'RH4' or rtrim(left(postcode,len(postcode)-3)) = 'RH5' or rtrim(left(postcode,len(postcode)-3)) = 'RH6' or rtrim(left(postcode,len(postcode)-3)) = 'RH7' or rtrim(left(postcode,len(postcode)-3)) = 'RH8' or rtrim(left(postcode,len(postcode)-3)) = 'RH9' or rtrim(left(postcode,len(postcode)-3)) = 'RM1' or rtrim(left(postcode,len(postcode)-3)) = 'RM10' or rtrim(left(postcode,len(postcode)-3)) = 'RM11' or rtrim(left(postcode,len(postcode)-3)) = 'RM12' or rtrim(left(postcode,len(postcode)-3)) = 'RM13' or rtrim(left(postcode,len(postcode)-3)) = 'RM14' or rtrim(left(postcode,len(postcode)-3)) = 'RM15' or rtrim(left(postcode,len(postcode)-3)) = 'RM16' or rtrim(left(postcode,len(postcode)-3)) = 'RM17' or rtrim(left(postcode,len(postcode)-3)) = 'RM18' or rtrim(left(postcode,len(postcode)-3)) = 'RM19' or rtrim(left(postcode,len(postcode)-3)) = 'RM2' or rtrim(left(postcode,len(postcode)-3)) = 'RM20' or rtrim(left(postcode,len(postcode)-3)) = 'RM3' or rtrim(left(postcode,len(postcode)-3)) = 'RM4' or rtrim(left(postcode,len(postcode)-3)) = 'RM5' or rtrim(left(postcode,len(postcode)-3)) = 'RM6' or rtrim(left(postcode,len(postcode)-3)) = 'RM7' or rtrim(left(postcode,len(postcode)-3)) = 'RM8' or rtrim(left(postcode,len(postcode)-3)) = 'RM9' or rtrim(left(postcode,len(postcode)-3)) = 'SE1' or rtrim(left(postcode,len(postcode)-3)) = 'SE10' or rtrim(left(postcode,len(postcode)-3)) = 'SE11' or rtrim(left(postcode,len(postcode)-3)) = 'SE12' or rtrim(left(postcode,len(postcode)-3)) = 'SE13' or rtrim(left(postcode,len(postcode)-3)) = 'SE14' or rtrim(left(postcode,len(postcode)-3)) = 'SE15' or rtrim(left(postcode,len(postcode)-3)) = 'SE16' or rtrim(left(postcode,len(postcode)-3)) = 'SE17' or rtrim(left(postcode,len(postcode)-3)) = 'SE18' or rtrim(left(postcode,len(postcode)-3)) = 'SE19' or rtrim(left(postcode,len(postcode)-3)) = 'SE2' or rtrim(left(postcode,len(postcode)-3)) = 'SE20' or rtrim(left(postcode,len(postcode)-3)) = 'SE21' or rtrim(left(postcode,len(postcode)-3)) = 'SE22' or rtrim(left(postcode,len(postcode)-3)) = 'SE23' or rtrim(left(postcode,len(postcode)-3)) = 'SE24' or rtrim(left(postcode,len(postcode)-3)) = 'SE25' or rtrim(left(postcode,len(postcode)-3)) = 'SE26' or rtrim(left(postcode,len(postcode)-3)) = 'SE27' or rtrim(left(postcode,len(postcode)-3)) = 'SE28' or rtrim(left(postcode,len(postcode)-3)) = 'SE3' or rtrim(left(postcode,len(postcode)-3)) = 'SE4' or rtrim(left(postcode,len(postcode)-3)) = 'SE5' or rtrim(left(postcode,len(postcode)-3)) = 'SE6' or rtrim(left(postcode,len(postcode)-3)) = 'SE7' or rtrim(left(postcode,len(postcode)-3)) = 'SE8' or rtrim(left(postcode,len(postcode)-3)) = 'SE9' or rtrim(left(postcode,len(postcode)-3)) = 'SG1' or rtrim(left(postcode,len(postcode)-3)) = 'SG10' or rtrim(left(postcode,len(postcode)-3)) = 'SG11' or rtrim(left(postcode,len(postcode)-3)) = 'SG12' or rtrim(left(postcode,len(postcode)-3)) = 'SG13' or rtrim(left(postcode,len(postcode)-3)) = 'SG14' or rtrim(left(postcode,len(postcode)-3)) = 'SG2' or rtrim(left(postcode,len(postcode)-3)) = 'SG3' or rtrim(left(postcode,len(postcode)-3)) = 'SG4' or rtrim(left(postcode,len(postcode)-3)) = 'SG5' or rtrim(left(postcode,len(postcode)-3)) = 'SG6' or rtrim(left(postcode,len(postcode)-3)) = 'SG9' or rtrim(left(postcode,len(postcode)-3)) = 'SL0' or rtrim(left(postcode,len(postcode)-3)) = 'SL1' or rtrim(left(postcode,len(postcode)-3)) = 'SL2' or rtrim(left(postcode,len(postcode)-3)) = 'SL3' or rtrim(left(postcode,len(postcode)-3)) = 'SL4' or rtrim(left(postcode,len(postcode)-3)) = 'SL5' or rtrim(left(postcode,len(postcode)-3)) = 'SL6' or rtrim(left(postcode,len(postcode)-3)) = 'SL7' or rtrim(left(postcode,len(postcode)-3)) = 'SL8' or rtrim(left(postcode,len(postcode)-3)) = 'SL9' or rtrim(left(postcode,len(postcode)-3)) = 'SM1' or rtrim(left(postcode,len(postcode)-3)) = 'SM2' or rtrim(left(postcode,len(postcode)-3)) = 'SM3' or rtrim(left(postcode,len(postcode)-3)) = 'SM4' or rtrim(left(postcode,len(postcode)-3)) = 'SM5' or rtrim(left(postcode,len(postcode)-3)) = 'SM6' or rtrim(left(postcode,len(postcode)-3)) = 'SM7' or rtrim(left(postcode,len(postcode)-3)) = 'SW1' or rtrim(left(postcode,len(postcode)-3)) = 'SW10' or rtrim(left(postcode,len(postcode)-3)) = 'SW11' or rtrim(left(postcode,len(postcode)-3)) = 'SW12' or rtrim(left(postcode,len(postcode)-3)) = 'SW13' or rtrim(left(postcode,len(postcode)-3)) = 'SW14' or rtrim(left(postcode,len(postcode)-3)) = 'SW15' or rtrim(left(postcode,len(postcode)-3)) = 'SW16' or rtrim(left(postcode,len(postcode)-3)) = 'SW17' or rtrim(left(postcode,len(postcode)-3)) = 'SW18' or rtrim(left(postcode,len(postcode)-3)) = 'SW19' or rtrim(left(postcode,len(postcode)-3)) = 'SW1A' or rtrim(left(postcode,len(postcode)-3)) = 'SW1E' or rtrim(left(postcode,len(postcode)-3)) = 'SW1H' or rtrim(left(postcode,len(postcode)-3)) = 'SW1P' or rtrim(left(postcode,len(postcode)-3)) = 'SW1V' or rtrim(left(postcode,len(postcode)-3)) = 'SW1W' or rtrim(left(postcode,len(postcode)-3)) = 'SW1X' or rtrim(left(postcode,len(postcode)-3)) = 'SW1Y' or rtrim(left(postcode,len(postcode)-3)) = 'SW2' or rtrim(left(postcode,len(postcode)-3)) = 'SW20' or rtrim(left(postcode,len(postcode)-3)) = 'SW3' or rtrim(left(postcode,len(postcode)-3)) = 'SW4' or rtrim(left(postcode,len(postcode)-3)) = 'SW5' or rtrim(left(postcode,len(postcode)-3)) = 'SW6' or rtrim(left(postcode,len(postcode)-3)) = 'SW7' or rtrim(left(postcode,len(postcode)-3)) = 'SW8' or rtrim(left(postcode,len(postcode)-3)) = 'SW9' or rtrim(left(postcode,len(postcode)-3)) = 'TN13' or rtrim(left(postcode,len(postcode)-3)) = 'TN14' or rtrim(left(postcode,len(postcode)-3)) = 'TN15' or rtrim(left(postcode,len(postcode)-3)) = 'TN16' or rtrim(left(postcode,len(postcode)-3)) = 'TN8' or rtrim(left(postcode,len(postcode)-3)) = 'TW1' or rtrim(left(postcode,len(postcode)-3)) = 'TW10' or rtrim(left(postcode,len(postcode)-3)) = 'TW11' or rtrim(left(postcode,len(postcode)-3)) = 'TW12' or rtrim(left(postcode,len(postcode)-3)) = 'TW13' or rtrim(left(postcode,len(postcode)-3)) = 'TW14' or rtrim(left(postcode,len(postcode)-3)) = 'TW15' or rtrim(left(postcode,len(postcode)-3)) = 'TW16' or rtrim(left(postcode,len(postcode)-3)) = 'TW17' or rtrim(left(postcode,len(postcode)-3)) = 'TW18' or rtrim(left(postcode,len(postcode)-3)) = 'TW19' or rtrim(left(postcode,len(postcode)-3)) = 'TW2' or rtrim(left(postcode,len(postcode)-3)) = 'TW20' or rtrim(left(postcode,len(postcode)-3)) = 'TW3' or rtrim(left(postcode,len(postcode)-3)) = 'TW4' or rtrim(left(postcode,len(postcode)-3)) = 'TW5' or rtrim(left(postcode,len(postcode)-3)) = 'TW6' or rtrim(left(postcode,len(postcode)-3)) = 'TW7' or rtrim(left(postcode,len(postcode)-3)) = 'TW8' or rtrim(left(postcode,len(postcode)-3)) = 'TW9' or rtrim(left(postcode,len(postcode)-3)) = 'UB1' or rtrim(left(postcode,len(postcode)-3)) = 'UB10' or rtrim(left(postcode,len(postcode)-3)) = 'UB11' or rtrim(left(postcode,len(postcode)-3)) = 'UB2' or rtrim(left(postcode,len(postcode)-3)) = 'UB3' or rtrim(left(postcode,len(postcode)-3)) = 'UB4' or rtrim(left(postcode,len(postcode)-3)) = 'UB5' or rtrim(left(postcode,len(postcode)-3)) = 'UB6' or rtrim(left(postcode,len(postcode)-3)) = 'UB7' or rtrim(left(postcode,len(postcode)-3)) = 'UB8' or rtrim(left(postcode,len(postcode)-3)) = 'UB9' or rtrim(left(postcode,len(postcode)-3)) = 'W1' or rtrim(left(postcode,len(postcode)-3)) = 'W10' or rtrim(left(postcode,len(postcode)-3)) = 'W11' or rtrim(left(postcode,len(postcode)-3)) = 'W12' or rtrim(left(postcode,len(postcode)-3)) = 'W13' or rtrim(left(postcode,len(postcode)-3)) = 'W14' or rtrim(left(postcode,len(postcode)-3)) = 'W1B' or rtrim(left(postcode,len(postcode)-3)) = 'W1C' or rtrim(left(postcode,len(postcode)-3)) = 'W1D' or rtrim(left(postcode,len(postcode)-3)) = 'W1F' or rtrim(left(postcode,len(postcode)-3)) = 'W1G' or rtrim(left(postcode,len(postcode)-3)) = 'W1H' or rtrim(left(postcode,len(postcode)-3)) = 'W1J' or rtrim(left(postcode,len(postcode)-3)) = 'W1K' or rtrim(left(postcode,len(postcode)-3)) = 'W1M' or rtrim(left(postcode,len(postcode)-3)) = 'W1S' or rtrim(left(postcode,len(postcode)-3)) = 'W1T' or rtrim(left(postcode,len(postcode)-3)) = 'W1U' or rtrim(left(postcode,len(postcode)-3)) = 'W1W' or rtrim(left(postcode,len(postcode)-3)) = 'W2' or rtrim(left(postcode,len(postcode)-3)) = 'W3' or rtrim(left(postcode,len(postcode)-3)) = 'W4' or rtrim(left(postcode,len(postcode)-3)) = 'W5' or rtrim(left(postcode,len(postcode)-3)) = 'W6' or rtrim(left(postcode,len(postcode)-3)) = 'W7' or rtrim(left(postcode,len(postcode)-3)) = 'W8' or rtrim(left(postcode,len(postcode)-3)) = 'W9' or rtrim(left(postcode,len(postcode)-3)) = 'WC1' or rtrim(left(postcode,len(postcode)-3)) = 'WC1A' or rtrim(left(postcode,len(postcode)-3)) = 'WC1B' or rtrim(left(postcode,len(postcode)-3)) = 'WC1E' or rtrim(left(postcode,len(postcode)-3)) = 'WC1H' or rtrim(left(postcode,len(postcode)-3)) = 'WC1N' or rtrim(left(postcode,len(postcode)-3)) = 'WC1R' or rtrim(left(postcode,len(postcode)-3)) = 'WC1V' or rtrim(left(postcode,len(postcode)-3)) = 'WC1X' or rtrim(left(postcode,len(postcode)-3)) = 'WC2' or rtrim(left(postcode,len(postcode)-3)) = 'WC2A' or rtrim(left(postcode,len(postcode)-3)) = 'WC2B' or rtrim(left(postcode,len(postcode)-3)) = 'WC2E' or rtrim(left(postcode,len(postcode)-3)) = 'WC2H' or rtrim(left(postcode,len(postcode)-3)) = 'WC2N' or rtrim(left(postcode,len(postcode)-3)) = 'WC2R' or rtrim(left(postcode,len(postcode)-3)) = 'WD1' or rtrim(left(postcode,len(postcode)-3)) = 'WD17' or rtrim(left(postcode,len(postcode)-3)) = 'WD18' or rtrim(left(postcode,len(postcode)-3)) = 'WD19' or rtrim(left(postcode,len(postcode)-3)) = 'WD2' or rtrim(left(postcode,len(postcode)-3)) = 'WD23' or rtrim(left(postcode,len(postcode)-3)) = 'WD24' or rtrim(left(postcode,len(postcode)-3)) = 'WD25' or rtrim(left(postcode,len(postcode)-3)) = 'WD3' or rtrim(left(postcode,len(postcode)-3)) = 'WD4' or rtrim(left(postcode,len(postcode)-3)) = 'WD5' or rtrim(left(postcode,len(postcode)-3)) = 'WD6' or rtrim(left(postcode,len(postcode)-3)) = 'WD7' ) and webVisible = 1 AND wood = 1 AND stoveinstal = 0 AND fireplaceinstal = 0 AND doubleskinflue = 0 AND liner = 0 order by len(areas) asc

Peltrade Ltd
Distance = 5 Miles
Click here for full details about Peltrade Ltd


Olive Wood Direct.com
Distance = 6 Miles
Click here for full details about Olive Wood Direct.com


Camden Boxframe Co. Ltd
Distance = 7 Miles
Click here for full details about Camden Boxframe Co. Ltd


Akashi Energy Ltd
Distance = 7 Miles
Click here for full details about Akashi Energy Ltd


BARRY AYRES LOG MERCHANT
Distance = 9 Miles
Click here for full details about BARRY AYRES LOG MERCHANT


www.the-log-merchant.co.uk
Distance = 9 Miles
Click here for full details about www.the-log-merchant.co.uk


Microbee Tree Management
Distance = 9 Miles
Click here for full details about Microbee Tree Management


BARRY AYRES THE LOG MERCHANT
Distance = 9 Miles
Click here for full details about BARRY AYRES THE LOG MERCHANT


Coombe Forestry
Distance = 10 Miles
Click here for full details about Coombe Forestry


4SGM
Distance = 10 Miles
Click here for full details about 4SGM


K. Ayres Logs
Distance = 11 Miles
Click here for full details about K. Ayres Logs


wimbledon firewood suppliers
Distance = 11 Miles
Click here for full details about wimbledon firewood suppliers


Bens Firewood
Distance = 12 Miles
Click here for full details about Bens Firewood


CPL London Coal
Distance = 12 Miles
Click here for full details about CPL London Coal


log-delivery.co.uk
Distance = 12 Miles
Click here for full details about log-delivery.co.uk


Great Norwood Logs
Distance = 13 Miles
Click here for full details about Great Norwood Logs


Landmark Tree Surgery
Distance = 14 Miles
Click here for full details about Landmark Tree Surgery


Premium Wood Ltd.
Distance = 14 Miles
Click here for full details about Premium Wood Ltd.


MG POWER TRADE Ltd
Distance = 15 Miles
Click here for full details about MG POWER TRADE Ltd


Lofty Heights Tree Surgeons
Distance = 16 Miles
Click here for full details about Lofty Heights Tree Surgeons


Woodland Logs
Distance = 17 Miles
Click here for full details about Woodland Logs


Treesuk
Distance = 17 Miles
Click here for full details about Treesuk


The Woodlands Farm Trust
Distance = 18 Miles
Click here for full details about The Woodlands Farm Trust


easylogs.co.uk
Distance = 18 Miles
Click here for full details about easylogs.co.uk


Braaiwood UK
Distance = 18 Miles
Click here for full details about Braaiwood UK


Surrey tree care ltd
Distance = 18 Miles
Click here for full details about Surrey tree care ltd


Seans Property Services
Distance = 18 Miles
Click here for full details about Seans Property Services


LogsBase
Distance = 19 Miles
Click here for full details about LogsBase


SJT TRACKFORCE LTD
Distance = 20 Miles
Click here for full details about SJT TRACKFORCE LTD


BARRINGTONS
Distance = 21 Miles
Click here for full details about BARRINGTONS


Tree Services
Distance = 21 Miles
Click here for full details about Tree Services


CPL North London Coal
Distance = 21 Miles
Click here for full details about CPL North London Coal


R E North Firewood Merchant
Distance = 21 Miles
Click here for full details about R E North Firewood Merchant


Collis Tree Services Ltd
Distance = 22 Miles
Click here for full details about Collis Tree Services Ltd


Thomas Broom & Son (Farmers)
Distance = 22 Miles
Click here for full details about Thomas Broom & Son (Farmers)


piddington firewood
Distance = 23 Miles
Click here for full details about piddington firewood


Logboys
Distance = 24 Miles
Click here for full details about Logboys


LC Energy
Distance = 25 Miles
Click here for full details about LC Energy


Green Fuel Technologies Limited
Distance = 25 Miles
Click here for full details about Green Fuel Technologies Limited


Winterfold Tree Services
Distance = 25 Miles
Click here for full details about Winterfold Tree Services


C Daveies landscapes and tree care
Distance = 25 Miles
Click here for full details about C Daveies landscapes and tree care


hard graft countryside & urban LTD
Distance = 25 Miles
Click here for full details about hard graft countryside & urban LTD


C-Logs
Distance = 25 Miles
Click here for full details about C-Logs


mackrory & sons
Distance = 26 Miles
Click here for full details about mackrory & sons


Firewood-shop.com
Distance = 26 Miles
Click here for full details about Firewood-shop.com


Remote Lodge Sustainable Wood Fuel
Distance = 26 Miles
Click here for full details about Remote Lodge Sustainable Wood Fuel


KNT ( kindling n things ) LTD
Distance = 26 Miles
Click here for full details about KNT ( kindling n things ) LTD


Hotfirewood.com
Distance = 26 Miles
Click here for full details about Hotfirewood.com


Simon Farndon Woodland & Countryside
Distance = 26 Miles
Click here for full details about Simon Farndon Woodland & Countryside


Thames Valley Firewood
Distance = 26 Miles
Click here for full details about Thames Valley Firewood


Als tree surgery
Distance = 27 Miles
Click here for full details about Als tree surgery


Astwick Forestry services
Distance = 28 Miles
Click here for full details about Astwick Forestry services


David Fawkner
Distance = 28 Miles
Click here for full details about David Fawkner


paul parnell chimney sweep
Distance = 29 Miles
Click here for full details about paul parnell chimney sweep


Harringtons Fuels
Distance = 29 Miles
Click here for full details about Harringtons Fuels


Ardour Energy Ltd
Distance = 30 Miles
Click here for full details about Ardour Energy Ltd


P R Newson Ltd
Distance = 30 Miles
Click here for full details about P R Newson Ltd


Logs4Sale
Distance = 30 Miles
Click here for full details about Logs4Sale




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.


stovesonline saving on C02 stovesonline work with the international tree foundation. We look after 2 trees for every stove we sell you can pay for your stove with us by Paypal pay for your stove by visa pay for your stove by mastercard pay for your stove by maestro pay for your stove by delta card


Stovesonline Ltd, Flightway, Dunkeswell Business Park , Dunkeswell , Devon , EX14 4RD
0845 226 5754, info@stovesonline.co.uk, Contact Us
© Stovesonline Ltd. VAT: 801261871, Company: 04636920. Registered in England, UK