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

HCT, LLC

7032 E Cortez Drive, Scottsdale, AZ 85254
(888) 788-5807

View More...

Hd Fowler Company

13440 SE 30th Street, Bellevue, WA 98005
(425) 746-8400

View More...

Helena Agri-Enterpries, LLC

13639 Littlecrest Drive, Farmers Branch, TX 75234
(903) 456-9824

View More...

Henderson & Company, Inc.

1460 2nd Street, Westmoreland City, PA 15692
(724) 454-1281

View More...

Heritage Links

6707 FM 1960 Rd W, Houston, TX 77069
(832) 712-5914

View More...

Heritage Professional Products Group

2143 Stonehaven, New Braunfels, TX 78130
(830) 475-2043

View More...

HICAP Formulations (Hong Kong) Limited

3 Ringos Mill Road, Hopewell, NJ 08525
(609) 851-2982

View More...

Hoffman Equipment Co.

300 S Randolphville Road, Piscataway, NJ 08854
(631) 553-1555

View More...

Horschel Brothers Precision LLC, DBA Buffalo Turbine LLC

180 Zoar Valley Road, Springville, NY 14141
(716) 592-2700

View More...

Howard Fertilizer & Chemical Company

9142 Dollanger Ct, Orlando, FL 32819
(407) 855-1841

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Turf Control, LLC

Turf Control, LLC

PondHawk® by LINNE Industries

PondHawk® by LINNE Industries

Mavrik Solutions LLC

Mavrik Solutions LLC

Link2Pump Corp

Spidermower USA

Spidermower USA

To Top

×

Mavrik Solutions LLC

20 Continue to site →