Air-Tight Recognized Trailer Manufacturers

Advanced Boat Trailers
11747 Phillips Hwy
Contact: Suite 300
Jacksonville, Florida 32256
P: 904-288-5500
 
BEACH TRAILER SALES
3545 HWY 17
MURRELLS INLET, South Carolina 29576
P: 843-997-5254
Contact: ERIC ENGELKE
F: 843-651-4216
www.beachtrailersales.com
Comment:
 
Broward Trailer Company, Inc.
1050 East 9th St
Hialeah, Florida 33010
P: 954-491-0223
 

Page 1 of 1, showing 3 records out of 3 total, starting on record 1, ending on 3

< previousnext >

(default) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Dealer`.`id`, `Dealer`.`type`, `Dealer`.`name`, `Dealer`.`contact`, `Dealer`.`address1`, `Dealer`.`address2`, `Dealer`.`city`, `Dealer`.`zone_id`, `Dealer`.`zip`, `Dealer`.`website`, `Dealer`.`phone`, `Dealer`.`fax`, `Dealer`.`comments`, `Dealer`.`is_new`, `Dealer`.`is_active`, `Dealer`.`created`, `Dealer`.`modified`, `Zone`.`id`, `Zone`.`code`, `Zone`.`name` FROM `airtighthubs`.`dealers` AS `Dealer` LEFT JOIN `airtighthubs`.`zones` AS `Zone` ON (`Dealer`.`zone_id` = `Zone`.`id`) WHERE `type` = 'trailer' AND `is_active` = '1' AND `is_new` = 0 ORDER BY `Dealer`.`name` asc LIMIT 20331