Interior Design Society 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=31974832 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=31974832 and wse_displayflag=4))) ORDER BY [adv_priority] DESC,[adv_basic] DESC,[adv_associate] DESC,[adv_company_AZ_name] ASC ) Interior Design Society Buyers' Guide :: Listings

Interior Design Society Buyers' Guide

FEATURED COMPANIES

Company Listings All Listings

Black Lily Home

1326 Ocean Avenue, 2E, Brooklyn, NY 11230
(917) 680-8353

View More...

Blackstone Carpets

1401 Oak Lawn Avenue, Dallas, TX 75207
(214) 748-1570

View More...

Blinds Couture

12170 Tejon Street, Westminster, CO 80234
(720) 729-0091

View More...

Bloomingdale's

205 Third Avenue, 9 C, New York, NY 10003
(917) 586-4148

View More...

Bluestar

14102 Townshire Drive, Houston, TX 77077
(281) 726-7530

View More...

Boston Mills

2050 N Stemmons Fwy, Suite 6862, Dallas, TX 75207
(214) 808-0290

View More...

BP Design Group

5530 Kiam Street, Houston, TX 77007
(832) 875-7550

View More...

BP Design Group

11526 Bryson Creek Court, Cypress, TX 77433
(281) 706-5887

View More...

BRANDON COMPANY

219 Lake bennett Road, Greenbrier, AR 72058
(501) 733-9327

View More...

Bravo Payment Systems Inc

34119 W 12 Mile Road, Suite 201, Farmington Hills, MI 48331
(248) 530-7510

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Zing Patio

It's Oksana, LLC

It's Oksana, LLC

Architectural Wall Decor

Architectural Wall Decor

Hawkins Design Collective

Hawkins Design Collective

Naples Live Edge Wood, LLC

Naples Live Edge Wood, LLC

Wine As Art by Kessick

Wine As Art by Kessick

To Top

×

Baird's Drapery Services Inc

20 Continue to site →