Dealers in Florida

Ace Hardware of Cape Canaveral
8300 Astronaut Blvd.
Cape Canaveral, Florida 32920
P: 321-784-1520
 
Ace Hardware of Titusville
3636 S. Washington Avenue
Titusville, Florida 32780
P: 321-267-1030
 
BAD 2D BONE TRAILER
3625 NW 31 AVENUE
FORT LAUDERDALE, Florida 33309
P: 954-545-3020
 
Barry's Trailer
1801 Washington Blvd N
Sarasota, Florida 34234
P: 941-953-3468
 
Boat Master
12301 Metro Parkway
Fort Myers, Florida 33912
P: 239-768-2292
 
Boat Tune Inc
307 N Goldenrod Road
Orlando, Florida 32807
P: 407-249-1124
 
Evolution Trailer Technologies
4177 James Street
Charlotte Harbor, Florida 33980
P: 941-979-5539
 
Float-On Trailers
1925 98th Avenue
Vero Beach, Florida 32966
P: 772-569-4440
 
Funtime Boats
1872 E Merritt Island Causeway
Merritt Island, Florida 32952
P: 321-453-1111
 
Hamerick's Automotive, Inc
6895 Woodmere Road
Sebastian, Florida 32958
P: 772-388-5559
 
Machine Works
702 Hitchcock St.
Contact: PO Box 777
Plant City, Florida 33564
P: 888-765-5752
 
Meltra Boat Trailer Sales
309 S 3rd St
Fort Pierce, Florida 34950
P: 772-461-1193
 
Myco Trailers, Inc.
2703 29th Avenue East
Bradenton, Florida 34208
P: 941-748-2397
 
Owens And Sons
3601 8th Avenue South
St Petersburg, Florida 33711
P: 727-323-1088
 
Rocket International, Inc.
2360 Crystal Road
Fort Myers, Florida 33907
P: 239-275-0880
 
Rocky's Ace Hardware
5899 SE Federal Hwy
Stuart, Florida 34997
P: 772-283-2470
 
T.A. Mahoney, Co.
4990 E Adamo Drive
Tampa, Florida 33605
P: 813-241-6500
 
Textrail
5181 N US Hwy 441
Ocala, Florida 34472
P: 352-620-2202
 
The Expediter, Inc.
6667 White Drive
West Palm Beach, Florida 33470
P: 561-863-2220
 
Waterland Marine
9200 NW 58th Street
Doral, Florida 33178
P: 305-594-1022
 

Page 1 of 2, showing 20 records out of 21 total, starting on record 1, ending on 20

< previous12

(default) 4 queries took 5 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 `zone_id` = 18 AND `type` = 'dealer' AND `is_active` = '1' AND `is_new` = 0 ORDER BY `Dealer`.`name` asc LIMIT 2020203
2SELECT COUNT(*) AS `count` FROM `airtighthubs`.`dealers` AS `Dealer` LEFT JOIN `airtighthubs`.`zones` AS `Zone` ON (`Dealer`.`zone_id` = `Zone`.`id`) WHERE `zone_id` = 18 AND `type` = 'dealer' AND `is_active` = '1' AND `is_new` = 0111
3SELECT `Zone`.`id`, `Zone`.`code`, `Zone`.`name` FROM `airtighthubs`.`zones` AS `Zone` WHERE `Zone`.`id` = 18 LIMIT 1110
4SELECT `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` FROM `airtighthubs`.`dealers` AS `Dealer` WHERE `Dealer`.`zone_id` = (18)23231