select * from states where statecode='#form.s#' select * from companies order by companyname select * from companies where state='#getstate.statecode#' order by companyname select * from companies a, company_group b, groups c where a.companyid=b.companyid and b.groupid=c.groupid and c.groupid=#form.g# order by a.companyname select * from companies a, company_group b, groups c where a.companyid=b.companyid and b.groupid=c.groupid and a.state='#getstate.statecode#' and c.groupid=#form.g# order by a.companyname SELECT *, b.state as fullstatename FROM companies a, states b WHERE a.state=b.statecode SELECT * FROM companies a, states b WHERE a.state=b.statecode AND b.statecode='#form.s#' SELECT * FROM states WHERE statecode='#form.s#' SELECT distinct state,statecode,fullstatename FROM getcompanies ORDER BY fullstatename SELECT distinct statecode FROM getstatecompanies ORDER BY companyname SELECT distinct a.groupname, a.groupid FROM groups a, company_group b WHERE a.groupid=b.groupid select a.state,a.statecode,a.imgmap from states a, companies b where a.statecode=b.state Search for a Godwin Product Reseller
Galion Godwin RS Godwin Champion Hoist Champion Hoist
Champion Hoist

Search for a GODWIN Reseller

Realty Map
Opps! Looks like you forgot something in these fields:
#i#

Click on a state in the map above to start your search OR use the form below:

Godwin Group:       State:    

Also see our resellers in Canada and Europe.


Results

#companyname#
#address#
#city#, #state# #zipcode#
Phone: #phone#
Cell Phone: #cell#
#email#
#website#
This location has a WAREHOUSE
select * from company_group a, groups b where a.companyid=#getresults.companyid# and a.groupid=b.groupid #groupname# 

Results


We're sorry, but no match was found for your search.


#state#