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
Ellco Agriculture LtdDistance = 4 Miles
Click here for full details about Ellco Agriculture LtdAnglia Heat LogsDistance = 4 Miles
Click here for full details about Anglia Heat LogsChris Mortimer Grounds MaintenanceDistance = 8 Miles
Click here for full details about Chris Mortimer Grounds MaintenanceRed oak Tree serviesDistance = 8 Miles
Click here for full details about Red oak Tree serviesL. Whymark contractorsDistance = 12 Miles
Click here for full details about L. Whymark contractorsCPL Essex CoalDistance = 12 Miles
Click here for full details about CPL Essex CoalHatters Chimney SweepsDistance = 14 Miles
Click here for full details about Hatters Chimney Sweepsfelsted firewoodDistance = 15 Miles
Click here for full details about felsted firewoodFireSafe Chimney ServicesDistance = 15 Miles
Click here for full details about FireSafe Chimney ServicesBiowood fuels LtdDistance = 18 Miles
Click here for full details about Biowood fuels Ltdbanded birch logsDistance = 18 Miles
Click here for full details about banded birch logsOpies Uk LimitedDistance = 18 Miles
Click here for full details about Opies Uk LimitedLogs and CompostDistance = 22 Miles
Click here for full details about Logs and CompostTHE ESSEX FIRE WOOD LOGSDistance = 25 Miles
Click here for full details about THE ESSEX FIRE WOOD LOGSWrittle Forest LimitedDistance = 26 Miles
Click here for full details about Writtle Forest Limitedg western & partnersDistance = 26 Miles
Click here for full details about g western & partnersdj davisonDistance = 27 Miles
Click here for full details about dj davisonMaple Tree Surgery & Landscapes LtdDistance = 27 Miles
Click here for full details about Maple Tree Surgery & Landscapes LtdWCT BAYFORD LTDDistance = 29 Miles
Click here for full details about WCT BAYFORD LTD
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.
