Golf Course Superintendents Association of America Buyers Guide :: Listings

PDOStatement Object ( [queryString] => SELECT adv_id, adv_gui_id, adv_associate, adv_basic, adv_priority, adv_featured, adv_company_name, REPLACE(adv_company_name,'The ','') AS adv_company_AZ_name, adv_address1, adv_address2, adv_city, adv_state, adv_zip, adv_zip_ext, adv_first_name, adv_last_name, adv_showaddr, adv_phone, adv_phone2, adv_url, adv_company_desc, adv_company_desc_plain, adv_image_logo, adv_spr_id, adv_car_id, adv_url_display, adv_tamem, adv_sponsor, adv_size_upgrade, isnull(adv_sponsor_type,0) as adv_sponsor_type, adv_intl_phone, adv_phone_ext, adv_phone2_ext, adv_company_desc_textonly, adv_rank, gui_tamem_image_location, adv_twiter, adv_pintrest,adv_google,adv_facebook,adv_LinkedIn,adv_Instagram, adv_Youtube,adv_in, adv_email FROM advertisers JOIN Guide ON gui_id = adv_gui_id WHERE adv_gui_id=940002471 AND adv_id not in (SELECT adv1.adv_id FROM advertisers as adv1 JOIN mappings on map_adv_id = adv1.adv_id JOIN wscategory on wsc_id = map_wsc_id JOIN wcategory on wca_id = wsc_wca_id JOIN wsection on wse_id = wca_wse_id JOIN guide on gui_id = wse_gui_id WHERE map_wsc_id = wsc_id and ( wca_wse_id in (SELECT wse_id FROM wsection where wse_gui_id=940002471 and wse_displayflag=4))) ORDER BY [adv_priority] DESC,[adv_basic] DESC,[adv_associate] DESC,[adv_tamem] DESC,[adv_company_AZ_name] ASC ) Golf Course Superintendents Association of America Buyers Guide :: Listings

Golf Course Superintendents Association of America Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

Humate International, Inc.

6633 Stuart Avenue, Jacksonville, FL 32254
(904) 783-6396

View More...

Hunt Energy

1900 N Akard Street, Dallas, TX 75201
(512) 750-7025

View More...

Hunter Industries

1940 Diamond Street, San Marcos, CA 92078
(760) 744-5240

View More...

Hydraway

8250 Bunkum Road, Caseyville, IL 62232
(380) 867-3343

View More...

Ideal Landscape Group - Saint Louis, MO

6252 Olsen Road, Saint Louis, MO 63129
(314) 277-6011

View More...

Ideal Turf

8220 W Farmington Road, Hanna City, IL 61536
(309) 697-6691

View More...

INFORMEDAG

1089 Amber Ln, Auburn, AL 36830
(334) 718-7960

View More...

Infusion technology

7522 Catherine Claire Ln, Baton Rouge, LA 70810
(415) 860-0727

View More...

Innovative AG / Biological Solutions Group

Post Office Box 5, Lamar, IN 47550
(804) 432-6383

View More...

iNova Green GmbH

Am Stadtbad 24, Dannenberg, NI 29451
(855) 694-6682

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

South Dallas Turf Farm

South Dallas Turf Farm

Buffalo Turbine LLC

Buffalo Turbine LLC

Link2Pump Corp

BRANDT

Turf Control, LLC

Turf Control, LLC

To Top

×

Regency Wire & Cable

20 Continue to site →