Oklahoma Trucking Association 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=31976570 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=31976570 and wse_displayflag=4))) ORDER BY [adv_priority] DESC,[adv_basic] DESC,[adv_associate] DESC,[adv_company_AZ_name] ASC ) Oklahoma Trucking Association Buyers Guide :: Listings

Oklahoma Trucking Association Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

Bruckner Truck Sales Enid

(866) 311-6225

View More...

Bruckner Truck Sales Inc Okc

(405) 942-4800

View More...

Bruckner Truck Sales West Tulsa

(918) 446-5571

View More...

Bruckner's Truck & Equipment - Enid

5913 E Owen K Garriott, Enid, OK 73702
(866) 311-6225

View More...

Bruckner's Truck & Equipment - West Tulsa

5301 W 60th Street, Tulsa, Ok 74107
(918) 446-5571

View More...

Bruckner's Truck & Equipment -OKC

10120 W Reno Avenue, Oklahoma City, OK 73127
(405) 942-4800

View More...

C8 Truck & Trailer Sales, LLC

Post Office Box 1774, Mustang, OK 73064
(405) 352-9933

View More...

Caddo Kiowa Tech Center

P O Box 190, Fort Cobb, OK 73038
(405) 643-3279

View More...

Canary LLC

(405) 670-2806

View More...

CARCO Rentals, Inc.

415 S Western Avenue, Oklahoma City, OK 73109
(405) 239-2555

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Joe's Hand Cleaner

Joe's Hand Cleaner

Oklahoma City Tarp and Supply

Oklahoma City Tarp and Supply

Spirit Lead Revival Ministries

Spirit Lead Revival Ministries

CSTK Oklahoma City

CSTK Oklahoma City

To Top

×

CITY TRAILER, INC.

20 Continue to site →