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

Flagler Home Builders Association Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

Florida Testing & Engineering INC

Post Office BOX 275, Bunnell, FL 32110
(386) 246-2159

View More...

Forestar

14785 Old St Augustine Rd Suite 300, Jacksonville, FL 32258
(904) 421-4699

View More...

Foundation Risk Partners

1540 Cornerstone Blvd Suite 200, Daytona Beach, FL 32117
(386) 677-4761

View More...

Generation Homes, Llc

5860 US Hwy 1 N, St. Augustine, FL 32095
(904) 268-0100

View More...

Geosam Capital

424 Luna Bella Lane, New Smyrna Beach, Florida 32168
(904) 404-6442

View More...

Glecker & Sons Building Supply

View More...

Glecker & Sons Building Supply

2175 W 18th Street, Jacksonville, FL. 32209
(813) 789-1269

View More...

Gleckler information

2175 W 18th St, Jacksonville, FL 32209
(813) 789-1269

View More...

Gold Coast Homes

17 Old Kings Rd Suite AB, Palm Coast, FL 32164
(386) 313-6221

View More...

Golden Fox Homes

72 Hernandez Avenue, Palm Coast, FL 32137
(386) 627-0430

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Lore L. LTD.

Wholesale Lighting, Inc.

Wholesale Lighting, Inc.

Servpro of Flagler County

Servpro of Flagler County

Bedrosians Tile and Stone

Bedrosians Tile and Stone

To Top

×

Overhead Door Co of Daytona Beach™

20 Continue to site →