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

Nebraska Hospitality Association Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

AMIGOS/ KINGS CLASSIC

1122 SECOND AVE S, KEARNEY, NE 68845
(308) 237-2428

View More...

AMIGOS/ KINGS CLASSIC

6310 HAVELOCK Avenue, LINCOLN, NE 68507
(402) 466-9222

View More...

AMIGOS/ KINGS CLASSIC

2325 N WEBB Road, GRAND ISLAND, NE 68802
(308) 384-1336

View More...

AMIGOS/ KINGS CLASSIC

4700 W HUNTINGTON, LINCOLN, NE 68524
(402) 470-2250

View More...

AMIGOS/ KINGS CLASSIC

3111 23RD Street, COLUMBUS, NE 68601
(402) 564-6252

View More...

AMIGOS/ KINGS CLASSIC

1210 S JEFFERS, NORTH PLATTE, NE 69101
(308) 534-0920

View More...

AMIGOS/ KINGS CLASSIC

4200 S 14TH Street, LINCOLN, NE 68502
(402) 223-4275

View More...

AMIGOS/ KINGS CLASSIC

4207 SECOND AVE N, KEARNEY, NE 68847
(308) 234-6991

View More...

AMIGOS/ KINGS CLASSIC

1520 S CODDINGTON, LINCOLN, NE 68522
(402) 476-5090

View More...

Amigos/Kings Classic

3700 YANKEE HILL Road, LINCOLN, NE 68516
(531) 500-3274

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Anderson Ford

Dykema POS Systems

Dykema POS Systems

Aqua Systems

DFA Dairy Brands (Kemps)

DFA Dairy Brands (Kemps)

To Top

×

Digital Cashbox

20 Continue to site →