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

Louisiana Home Builders Association Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

A-1 Affordable Home Improvements

1104 Bear Creek Circle, Breaux Bridge, LA 70517
(337) 849-8610

View More...

A-1 Appliance, Bedding, & Furniture

1925 Industrial Blvd, Harvey, LA 70058
(504) 341-9999

View More...

A-1 Glass Service, Inc.

Post Office Box 1788, Covington, LA 70434
(985) 892-5312

View More...

A-1 Remodeling & Building, Inc.

33490 Sylve Road, Suite A, Slidell, LA 70460
(985) 643-3502

View More...

A-ONE Siding and Remodeling, LLC

107 GABRIELLE LN, DESTREHAN, LA 70047
(504) 416-7058

View More...

A-Team Custom Carpentry, LLC

216 Stuart Avenue, Shreveport, LA 71105
(318) 751-2101

View More...

A-Tek Home Solutions

Post Office Box 531, Lake Charles, LA 70615
(337) 936-1767

View More...

A. B. Miles Company

2030 Dickory Avenue, Suite 200, Harahan, LA 70123
(504) 339-5981

View More...

A. Galvan Construction, LLC

38238 Hwy 621, Gonzales, LA 70737
(225) 337-0838

View More...

A. J. Rayner

586 Caney Lake Road, Minden, LA 71055
(318) 371-0200

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Southern Framers of LA, LLC

Southern Framers of LA, LLC

ProSource of Gonzales, LA

ProSource of Gonzales, LA

Barksdale Federal Credit Union

Barksdale Federal Credit Union

Peace of Mind Security, Inc.

Peace of Mind Security, Inc.

CGM Productions

CGM Productions

To Top

×

Waste Connections of Louisiana, Inc.

20 Continue to site →