Firewood Suppliers near Colchester

select *,rtrim(left(postcode,len(postcode)-3)) as smallpostcode from serviceproviders where len(postcode)>5 and ( rtrim(left(postcode,len(postcode)-3)) = 'CB10' or rtrim(left(postcode,len(postcode)-3)) = 'CB11' or rtrim(left(postcode,len(postcode)-3)) = 'CB9' or rtrim(left(postcode,len(postcode)-3)) = 'CM0' or rtrim(left(postcode,len(postcode)-3)) = 'CM1' or rtrim(left(postcode,len(postcode)-3)) = 'CM11' or rtrim(left(postcode,len(postcode)-3)) = 'CM12' or rtrim(left(postcode,len(postcode)-3)) = 'CM13' or rtrim(left(postcode,len(postcode)-3)) = 'CM15' or rtrim(left(postcode,len(postcode)-3)) = 'CM2' or rtrim(left(postcode,len(postcode)-3)) = 'CM22' or rtrim(left(postcode,len(postcode)-3)) = 'CM24' or rtrim(left(postcode,len(postcode)-3)) = 'CM3' or rtrim(left(postcode,len(postcode)-3)) = 'CM4' or rtrim(left(postcode,len(postcode)-3)) = 'CM5' or rtrim(left(postcode,len(postcode)-3)) = 'CM6' or rtrim(left(postcode,len(postcode)-3)) = 'CM7' or rtrim(left(postcode,len(postcode)-3)) = 'CM8' or rtrim(left(postcode,len(postcode)-3)) = 'CM9' or rtrim(left(postcode,len(postcode)-3)) = 'CO1' or rtrim(left(postcode,len(postcode)-3)) = 'CO10' or rtrim(left(postcode,len(postcode)-3)) = 'CO11' or rtrim(left(postcode,len(postcode)-3)) = 'CO12' or rtrim(left(postcode,len(postcode)-3)) = 'CO13' or rtrim(left(postcode,len(postcode)-3)) = 'CO14' or rtrim(left(postcode,len(postcode)-3)) = 'CO15' or rtrim(left(postcode,len(postcode)-3)) = 'CO16' or rtrim(left(postcode,len(postcode)-3)) = 'CO2' or rtrim(left(postcode,len(postcode)-3)) = 'CO3' or rtrim(left(postcode,len(postcode)-3)) = 'CO4' or rtrim(left(postcode,len(postcode)-3)) = 'CO5' or rtrim(left(postcode,len(postcode)-3)) = 'CO6' or rtrim(left(postcode,len(postcode)-3)) = 'CO7' or rtrim(left(postcode,len(postcode)-3)) = 'CO8' or rtrim(left(postcode,len(postcode)-3)) = 'CO9' or rtrim(left(postcode,len(postcode)-3)) = 'IP1' or rtrim(left(postcode,len(postcode)-3)) = 'IP10' or rtrim(left(postcode,len(postcode)-3)) = 'IP11' or rtrim(left(postcode,len(postcode)-3)) = 'IP12' or rtrim(left(postcode,len(postcode)-3)) = 'IP13' or rtrim(left(postcode,len(postcode)-3)) = 'IP14' or rtrim(left(postcode,len(postcode)-3)) = 'IP2' or rtrim(left(postcode,len(postcode)-3)) = 'IP23' or rtrim(left(postcode,len(postcode)-3)) = 'IP29' or rtrim(left(postcode,len(postcode)-3)) = 'IP3' or rtrim(left(postcode,len(postcode)-3)) = 'IP30' or rtrim(left(postcode,len(postcode)-3)) = 'IP31' or rtrim(left(postcode,len(postcode)-3)) = 'IP32' or rtrim(left(postcode,len(postcode)-3)) = 'IP33' or rtrim(left(postcode,len(postcode)-3)) = 'IP4' or rtrim(left(postcode,len(postcode)-3)) = 'IP5' or rtrim(left(postcode,len(postcode)-3)) = 'IP6' or rtrim(left(postcode,len(postcode)-3)) = 'IP7' or rtrim(left(postcode,len(postcode)-3)) = 'IP8' or rtrim(left(postcode,len(postcode)-3)) = 'IP9' or rtrim(left(postcode,len(postcode)-3)) = 'SS0' or rtrim(left(postcode,len(postcode)-3)) = 'SS1' or rtrim(left(postcode,len(postcode)-3)) = 'SS11' or rtrim(left(postcode,len(postcode)-3)) = 'SS12' or rtrim(left(postcode,len(postcode)-3)) = 'SS13' or rtrim(left(postcode,len(postcode)-3)) = 'SS14' or rtrim(left(postcode,len(postcode)-3)) = 'SS15' or rtrim(left(postcode,len(postcode)-3)) = 'SS16' or rtrim(left(postcode,len(postcode)-3)) = 'SS2' or rtrim(left(postcode,len(postcode)-3)) = 'SS3' or rtrim(left(postcode,len(postcode)-3)) = 'SS4' or rtrim(left(postcode,len(postcode)-3)) = 'SS5' or rtrim(left(postcode,len(postcode)-3)) = 'SS6' or rtrim(left(postcode,len(postcode)-3)) = 'SS7' or rtrim(left(postcode,len(postcode)-3)) = 'SS8' or rtrim(left(postcode,len(postcode)-3)) = 'SS9' ) 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.