business_x_category.id,business.id,business.ts,business.business_name,business.home_page,business.email_address,business.phone,business.street,business.city,business.state,business.zip_code,business.full_address,business.category,business.rating,business.number_of_reviews,business.bbb_rating_or_license,business.latitude,business.longitude,business.cover_image,business.slogan,business.general_info,business.regular_hours,business.extra_phones,business.services_products,business.payment,business.price_range,business.aka,business.other_links,business.other_information,business.review_1_name,business.review_1_date,business.review_1_rating,business.review_1_text,business.review_2_name,business.review_2_date,business.review_2_rating,business.review_2_text
1756222,525915,"2020-09-27 03:22:27","Ferguson Waterworks",https://www.ferguson.com/category?cmpid=md_ntnl_plmb_nat_yp___order_,luther.mcgrew@ferguson.com,"(479) 646-8044","4304 Phoenix Ave","Fort Smith",AR,72903,"4304 Phoenix Ave,Fort Smith,AR 72903","Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Bath Equipment & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Fixtures, Cabinets & Accessories-Wholesale & Manufacturers, Building Materials-Wholesale & Manufacturers, Heating Equipment & Systems-Wholesale, Machinery-Rebuild & Repair, Pipe, Pipe Fittings, Pipe-Wholesale & Manufacturers, Piping Contractors, Plumbers, Plumbing Fixtures, Parts & Supplies, Sewer Contractors, Tools, Utility Companies, Utility Contractors, Valves, Valves-Wholesale & Manufacturers, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Works Contractors, Water Works Equipment & Supplies",,,,35.33709,-94.38494,https://i3.ypcdn.com/blob/90431dea3bbf7b9f83443c42d867363d957232af_100x100_crop.jpg?f832250,"Get the quality pipes, valves and fittings, waterworks, heating and cooling equipment, parts and supplies you need, when you need them.","For more than 60 years, Ferguson has earned a strong reputation among contractors, builders and plumbers across the country. We are the largest distributor of residential and commercial plumbing supplies and PVF in the U.S., and a major supplier of HVAC, waterworks and industrial products and services. Ferguson understands the challenges that contractors face. Our knowledgeable people, on-time delivery and commitment to our customers are just a few of the capabilities that set us apart, and keep you on schedule. Whether your project consists of construction on a commercial building, institutional facility or repair and remodel, we offer quick access to product. We don't just take orders. Our expertise allows us to evaluate your specific project or job to ensure that you always get: В• The right product for your application В• The industry's highest fill rates on stock items В• Short lead times on non-stock products В• Access to hard to find products based on our buying power and sourcing expertise В• On-time delivery to keep your project on track With 1,400 locations nationwide, contractors always have access to our vast distribution network. Depending on the size and scope of your project, we will even bring Ferguson to you with our onsite trailer stocked with the products you need to get the job done. We carry all the best and most-recognized brands, cutting edge technology & inventory management solutions, and much more. To find a Ferguson location near you, visit www.ferguson.com/locations-finder.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"amex, visa, mastercard",,,"Shop Online",,,,,,,,,
1781311,533419,"2020-09-27 03:23:02","Certified Mechanical Welding",http://certifiedmechanicalwelding.com,,"(602) 265-3571","2322 W Cheery Lynn Rd",Phoenix,AZ,85015,"2322 W Cheery Lynn Rd,Phoenix,AZ 85015","Machinery-Rebuild & Repair, Air Conditioning Contractors & Systems, Automobile Racing & Sports Cars, Building Contractors, Building Contractors-Commercial & Industrial, City, Village & Township Government, Consultants Referral Service, Drilling & Boring Contractors, Excavation Contractors, Federal Government, General Contractors, Mechanical Contractors, Military Bases, Pipe Bending & Fabricating, Pipe Line Companies, Piping Contractors, Plumbers, Trailers-Repair & Service, Utility Companies, Utility Contractors, Welders",,,,33.48569,-112.10942,https://i1.ypcdn.com/blob/44dc148d21bb1e7c12192ba30ab8f8bbf5bea384_100x100_crop.jpg?f832250,,,"Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,paypal,,,http://certifiedmechanicalwelding.com,,,,,,,,,
1787708,535418,"2020-09-27 03:23:15","Ferguson Waterworks",https://www.ferguson.com/category?cmpid=md_ntnl_plmb_nat_yp___order_,info@rhadi.com,"(864) 716-0955","131 Preamble Ct",Anderson,SC,29621,"131 Preamble Ct,Anderson,SC 29621","Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Air Conditioning Contractors & Systems, Bath Equipment & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Fixtures, Cabinets & Accessories-Wholesale & Manufacturers, Bedding, Building Materials-Wholesale & Manufacturers, Heating Contractors & Specialties, Heating Equipment & Systems-Wholesale, Kitchen Cabinets & Equipment-Wholesale & Manufacturers, Machinery-Rebuild & Repair, Pipe, Pipe Fittings, Piping Contractors, Plumbers, Plumbing Fixtures, Parts & Supplies, Sewer Contractors, Tools, Utility Companies, Utility Contractors, Valves, Valves-Wholesale & Manufacturers, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Works Contractors, Water Works Equipment & Supplies",,,,34.5767,-82.68748,https://i1.ypcdn.com/blob/90431dea3bbf7b9f83443c42d867363d957232af_100x100_crop.jpg?f832250,"Get the quality pipes, valves and fittings, waterworks, heating and cooling equipment, parts and supplies you need, when you need them.","For more than 60 years, Ferguson has earned a strong reputation among contractors, builders and plumbers across the country. We are the largest distributor of residential and commercial plumbing supplies and PVF in the U.S., and a major supplier of HVAC, waterworks and industrial products and services. Ferguson understands the challenges that contractors face. Our knowledgeable people, on-time delivery and commitment to our customers are just a few of the capabilities that set us apart, and keep you on schedule. Whether your project consists of construction on a commercial building, institutional facility or repair and remodel, we offer quick access to product. We don't just take orders. Our expertise allows us to evaluate your specific project or job to ensure that you always get: В• The right product for your application В• The industry's highest fill rates on stock items В• Short lead times on non-stock products В• Access to hard to find products based on our buying power and sourcing expertise В• On-time delivery to keep your project on track With 1,400 locations nationwide, contractors always have access to our vast distribution network. Depending on the size and scope of your project, we will even bring Ferguson to you with our onsite trailer stocked with the products you need to get the job done. We carry all the best and most-recognized brands, cutting edge technology & inventory management solutions, and much more. To find a Ferguson location near you, visit www.ferguson.com/locations-finder.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"amex, visa, mastercard",,,"Shop Online",,,,,,,,,
1796384,538322,"2020-09-27 03:23:37",Ferguson,https://www.ferguson.com/category?cmpid=md_ntnl_plmb_nat_yp___order_,Randy.Schmidt@ferguson.com,"(701) 258-9700","1201 Airport Rd",Bismarck,ND,58504,"1201 Airport Rd,Bismarck,ND 58504","Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Bath Equipment & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Fixtures, Cabinets & Accessories-Wholesale & Manufacturers, Building Materials, Building Materials-Wholesale & Manufacturers, Hardware Stores, Heating Equipment & Systems-Wholesale, Home Improvements, Industrial Equipment & Supplies-Wholesale, Machinery, Machinery-Rebuild & Repair, Pipe, Pipe Fittings, Piping Contractors, Plumbers, Plumbing Fixtures, Parts & Supplies, Pumps-Wholesale & Manufacturers, Sewer Contractors, Sprinklers-Garden & Lawn, Tools, Utility Companies, Utility Contractors, Valves, Valves-Wholesale & Manufacturers, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Works Contractors, Water Works Equipment & Supplies",,,,46.79174,-100.76207,https://i3.ypcdn.com/blob/90431dea3bbf7b9f83443c42d867363d957232af_100x100_crop.jpg?f832250,"Get the quality pipes, valves and fittings, waterworks, heating and cooling equipment, parts and supplies you need, when you need them.","For more than 60 years, Ferguson has earned a strong reputation among contractors, builders and plumbers across the country. We are the largest distributor of residential and commercial plumbing supplies and PVF in the U.S., and a major supplier of HVAC, waterworks and industrial products and services. Ferguson understands the challenges that contractors face. Our knowledgeable people, on-time delivery and commitment to our customers are just a few of the capabilities that set us apart, and keep you on schedule. Whether your project consists of construction on a commercial building, institutional facility or repair and remodel, we offer quick access to product. We don't just take orders. Our expertise allows us to evaluate your specific project or job to ensure that you always get: В• The right product for your application В• The industry's highest fill rates on stock items В• Short lead times on non-stock products В• Access to hard to find products based on our buying power and sourcing expertise В• On-time delivery to keep your project on track With 1,400 locations nationwide, contractors always have access to our vast distribution network. Depending on the size and scope of your project, we will even bring Ferguson to you with our onsite trailer stocked with the products you need to get the job done. We carry all the best and most-recognized brands, cutting edge technology & inventory management solutions, and much more. To find a Ferguson location near you, visit www.ferguson.com/locations-finder.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"mastercard, amex, visa",,,"Shop Online",,,,,,,,,
1801847,540223,"2020-09-27 03:23:46",Ferguson,https://www.ferguson.com/category?cmpid=md_ntnl_plmb_nat_yp___order_,randall.marshall@ferguson.com,"(205) 621-5520","190 Commerce Dr",Pelham,AL,35124,"190 Commerce Dr,Pelham,AL 35124","Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Advertising Agencies, Advertising Specialties, Bath Equipment & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Fixtures, Cabinets & Accessories-Wholesale & Manufacturers, Building Materials, Building Materials-Wholesale & Manufacturers, General Merchandise-Wholesale, Hardware Stores, Heating Equipment & Systems-Wholesale, Home Improvements, Machinery-Rebuild & Repair, Pipe, Pipe Fittings, Pipe Line Companies, Piping Contractors, Plumbers, Plumbing Fixtures, Parts & Supplies, Sewer Contractors, Tools, Utility Companies, Utility Contractors, Valves, Valves-Wholesale & Manufacturers, Water Companies-Bottled, Bulk, Etc, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Works Contractors, Water Works Equipment & Supplies",,,A+,33.29386,-86.79958,https://i1.ypcdn.com/blob/898a20c3dca33c4bf7ff04ad70a2847369800dc6_100x100_crop.jpg?f832250,"Get the quality pipes, valves and fittings, waterworks, heating and cooling equipment, parts and supplies you need, when you need them.","For more than 60 years, Ferguson has earned a strong reputation among contractors, builders and plumbers across the country. We are the largest distributor of residential and commercial plumbing supplies and PVF in the U.S., and a major supplier of HVAC, waterworks and industrial products and services. Ferguson understands the challenges that contractors face. Our knowledgeable people, on-time delivery and commitment to our customers are just a few of the capabilities that set us apart, and keep you on schedule. Whether your project consists of construction on a commercial building, institutional facility or repair and remodel, we offer quick access to product. We don't just take orders. Our expertise allows us to evaluate your specific project or job to ensure that you always get: В• The right product for your application В• The industry's highest fill rates on stock items В• Short lead times on non-stock products В• Access to hard to find products based on our buying power and sourcing expertise В• On-time delivery to keep your project on track With 1,400 locations nationwide, contractors always have access to our vast distribution network. Depending on the size and scope of your project, we will even bring Ferguson to you with our onsite trailer stocked with the products you need to get the job done. We carry all the best and most-recognized brands, cutting edge technology & inventory management solutions, and much more. To find a Ferguson location near you, visit www.ferguson.com/locations-finder.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"amex, visa, mastercard",,,"Shop Online",,,,,,,,,
1803609,540854,"2020-09-27 03:23:46","Clark Excavation Co",,,"(774) 245-7410",,,,,,"Utility Companies, Erosion Control, Machinery-Rebuild & Repair, Water Utility Companies, Welding Equipment Repair",,,,,,,"If its in the Ground, we DIG it!","Commerical Services include Roads, Sewers, Water Lines, Drainages, Gas, Underground Electric, Full Site Development, Foundations, Etc Residental Services include Title 5 & 6 Septic, Foundations, Fine Grading, Subdivisions, Demolition & Removal, Lot Clearing, Residential Utilities, Etc. Service & Repair - Clark Excavating offers full service Auto and Heavy Equipment repair. All work is performed by trained and certified professionals. (including auto/trucks, heavy trucks & equipment, Diesel/Gas Engines, Hydraulics, Full Service Welding, Metal Fabrication, sand blasting & painting, etc).",,"Phone: (774) 249-2493",,,,,,,,,,,,,,
2166912,675482,"2020-09-27 03:37:23","Margan Equipment Rentals",http://www.marganequipmentrentals.com,info@marganequipmentrentals.com,"(504) 392-5836","1814 Engineers Rd","Belle Chasse",LA,70037,"1814 Engineers Rd,Belle Chasse,LA 70037","Machinery-Rebuild & Repair, Rental Service Stores & Yards",,,,29.84968,-90.02964,,,,"Mon - Fri: 7:00 am - 5:00 pm Sat - Sun: 8:00 am - 12:00 pm",,,,,,http://www.marganequipmentrentals.com,"Services: FamilyResidential Services",,,,,,,,
2275190,705187,"2020-09-27 03:40:21","Diversified Equipment & Supply",http://www.descncrocks.com,info@descncrocks.com,"(704) 545-5198","11223 Blair Rd","Mint Hill",NC,28227,"11223 Blair Rd,Mint Hill,NC 28227","Contractors Equipment Rental, Contractors Equipment & Supplies, General Contractors, Hardware Stores, Industrial Equipment & Supplies, Machinery, Machinery-Rebuild & Repair, Rental Service Stores & Yards, Tool Rental, Woodworking Equipment & Supplies",,,A+,35.2213,-80.63099,https://i4.ypcdn.com/blob/dfda51e6134eaca44f7e9ad09f0dbda33696751d_100x100_crop.jpg?63f80dd,,,"Mon - Fri: 7:30 am - 5:00 pm Sat - Sun Closed",,,,,,http://www.descncrocks.com,"Services: Woodwork",,,,,,,,
2820762,866389,"2020-09-27 03:55:47","Ferguson Waterworks",https://www.ferguson.com/category?cmpid=md_ntnl_plmb_nat_yp___order_,,"(302) 429-5850","2000a Maryland Ave",Wilmington,DE,19805,"2000a Maryland Ave,Wilmington,DE 19805","Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Air Conditioning Contractors & Systems, Air Conditioning Equipment & Systems, Bath Equipment & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Fixtures, Cabinets & Accessories-Wholesale & Manufacturers, Building Materials, Hardware Stores, Heating Contractors & Specialties, Heating Equipment & Systems, Heating Equipment & Systems-Wholesale, Home Improvements, Lighting Fixtures, Machinery-Rebuild & Repair, Pipe, Pipe Fittings, Piping Contractors, Plumbers, Plumbing Fixtures, Parts & Supplies, Sewer Contractors, Tools, Utility Contractors, Valves, Valves-Wholesale & Manufacturers, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Works Contractors, Water Works Equipment & Supplies",,,,39.73291,-75.57815,https://i4.ypcdn.com/blob/90431dea3bbf7b9f83443c42d867363d957232af_100x100_crop.jpg?41e4770,"Get the quality pipes, valves and fittings, waterworks, heating and cooling equipment, parts and supplies you need, when you need them.","For more than 60 years, Ferguson has earned a strong reputation among contractors, builders and plumbers across the country. We are the largest distributor of residential and commercial plumbing supplies and PVF in the U.S., and a major supplier of HVAC, waterworks and industrial products and services. Ferguson understands the challenges that contractors face. Our knowledgeable people, on-time delivery and commitment to our customers are just a few of the capabilities that set us apart, and keep you on schedule. Whether your project consists of construction on a commercial building, institutional facility or repair and remodel, we offer quick access to product. We don't just take orders. Our expertise allows us to evaluate your specific project or job to ensure that you always get: В• The right product for your application В• The industry's highest fill rates on stock items В• Short lead times on non-stock products В• Access to hard to find products based on our buying power and sourcing expertise В• On-time delivery to keep your project on track With 1,400 locations nationwide, contractors always have access to our vast distribution network. Depending on the size and scope of your project, we will even bring Ferguson to you with our onsite trailer stocked with the products you need to get the job done. We carry all the best and most-recognized brands, cutting edge technology & inventory management solutions, and much more. To find a Ferguson location near you, visit www.ferguson.com/locations-finder.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"mastercard, amex, visa",,,"Shop Online",,,,,,,,,
3718390,1207810,"2020-09-27 04:28:05","Ron's Auto Wash Service",,,"(616) 340-6647","2192 Timberlane Dr",Jenison,MI,49428,"2192 Timberlane Dr,Jenison,MI 49428","Machinery-Rebuild & Repair, Automobile Detailing, Car Wash, Car Washing & Polishing Equipment & Supplies",,,,42.89279,-85.83664,,,,,,,,,,,,,,,,,,,
3789833,1235385,"2020-09-27 04:30:30","Joe's Welding Shop",,,"(626) 330-3615","13420 Valley Blvd","La Puente",CA,91746,"13420 Valley Blvd,La Puente,CA 91746","Welders, Fence Repair, Iron Work, Machinery-Rebuild & Repair",,,,34.04841,-117.99524,,,,"Mon - Fri: 8:00 am - 4:30 pm","Secondary Phone: (626) 330-0888",,,,"Joes Welding Shop",,,,,,,,,,
3796190,1236622,"2020-09-27 04:30:32","W W Custom Welding",,,"(903) 849-2012",,,,,,"Welders, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair",,,,,,,,,,,,,,,,,,,,,,,,
3809041,1239087,"2020-09-27 04:30:41","Pacific Welding And Manufacturing",http://www.pacificwelding.net,pacwelding@yahoo.com,"(808) 841-2999","94-095 Leonui St",Waipahu,HI,96797,"94-095 Leonui St,Waipahu,HI 96797","Welders, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair",,,,21.398203,-158.01242,,,"Pacific Welding And Manufacturing offers a wide array of residential and commercial fencing options to fit all decors and budgets. Choose one that best fits your requirements and we'll get it installed in no time. 24-hour emergency service available!","Mon - Fri: 8:00 am - 4:00 pm Sat - Sun Closed","Fax: (808) 671-9222",,"cash, check",,,http://www.pacificwelding.net,,,,,,,,,
3810918,1239464,"2020-09-27 04:30:41","Glen's Welding",http://glenswelding.com,malovets5@gmail.com,"(254) 778-2885","415 S 1st St",Temple,TX,76504,"415 S 1st St,Temple,TX 76504","Welders, Fence-Sales, Service & Contractors, Iron Ornamental Work-Supplies, Iron Work, Machine Shops, Machinery-Rebuild & Repair",5,"3 Reviews",,31.09218,-97.34384,,,,"Mon - Fri: 8:00 am - 4:30 pm Sat - Sun Closed",,,"check, visa, cash, master card",,,http://glenswelding.com,,"Doug M.",07/27/2017,five,"Had a custom welding job done and they did an excellent job ! They performed prompt fabrication and the work was beyond my expectations with a great price. I highly recommend Glens Welding.","Alyssa M.",06/04/2014,five,"Had a fence made by them, wonderful craftsmanship! Owners have great customer service!"
3816994,1240683,"2020-09-27 04:30:46","Rampart Welding Services",,rampart.fenceandaccess@gmail.com,"(713) 349-9764","7001 Rampart St",Houston,TX,77081,"7001 Rampart St,Houston,TX 77081","Welders, Fence-Sales, Service & Contractors, Machine Shops, Machinery-Rebuild & Repair",,,A+,29.70339,-95.48852,,,,,,,,,,,,,,,,,,,
3820088,1241291,"2020-09-27 04:30:54","John's Welding",http://www.johnsqualitywelding.com,johnsweldinglv@hotmail.com,"(702) 384-4404","3522 Parada Cir","North Las Vegas",NV,89032,"3522 Parada Cir,North Las Vegas,NV 89032","Welders, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair, Sheet Metal Work",,,,36.22381,-115.20494,,,"John's Welding has been in business in Las Vegas since 1976. He now specializes in small repairs in aluminum, stainless steel, and steel repairs. John's Quality Welding can also do mobile welding service or you can bring the job to him. He's had a five-star rating in the industry for all those years and does a quality job for everyone. His past record shows he has a solid reputation in his field of expertise.Also having certifications in the welding field, carpenter, millwright and automotive field as a journeyman. John also does gate repairs and portable welding as well as being on call 24/7 for emergency situations.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"amex, cash, discover, master card, visa",,,"http://www.johnsqualitywelding.com https://www.johnsqualitywelding.com",,,,,,,,,
3828162,1242869,"2020-09-27 04:30:57","Lodi Welding Co Inc",http://lodiwelding.com,lodiwelding@hotmail.com,"(908) 852-8367","133 Willow Grove St",Hackettstown,NJ,07840,"133 Willow Grove St,Hackettstown,NJ 07840","Welders, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair, Rails, Railings & Accessories Stairway",,,,40.85097,-74.82304,,,,"Mon - Fri: 9:00 am - 5:00 pm",,,,,,http://lodiwelding.com,,,,,,,,,
3832442,1243710,"2020-09-27 04:31:00","Owens Welding Service",,,"(940) 365-9611","203 Rock Hill Rd",Aubrey,TX,76227,"203 Rock Hill Rd,Aubrey,TX 76227","Welders, Fence-Sales, Service & Contractors, Machine Shops, Machinery-Rebuild & Repair",,,,33.29864,-96.98775,,,,"Mon - Fri: 8:00 am - 5:00 pm",,,,,"Owens Welding Svc Owen's Welding & Fabrication Inc",,,,,,,,,,
3832946,1243801,"2020-09-27 04:31:00","East Alabama Welding",http://www.eastalabamawelding.com,eastalawelding@yahoo.com,"(334) 749-5262","4793 Al Highway 51",Opelika,AL,36804,"4793 Al Highway 51,Opelika,AL 36804","Welders, Fence-Sales, Service & Contractors, Iron Work, Machinery-Rebuild & Repair",,,,32.58769,-85.37068,,,,,,,,,,http://www.eastalabamawelding.com,"Services: Ironwork",,,,,,,,
3833463,1243915,"2020-09-27 04:31:00","Chiapa Welding",http://www.chiapawelding.com,chiapaco@inreach.com,"(661) 324-5404","2018 Pacific St",Bakersfield,CA,93305,"2018 Pacific St,Bakersfield,CA 93305","Welders, Fence-Sales, Service & Contractors, Iron Ornamental Work-Supplies, Machinery-Rebuild & Repair, Stair Builders",,,,35.37916,-118.96958,,,,,,,"amex, discover, master card, visa, all major credit cards",,,http://www.chiapawelding.com,,,,,,,,,
3848801,1246827,"2020-09-27 04:31:15","Vogt Welding & Gate",http://www.vogtwelding.com,jake@vogtwelding.com,"(808) 640-9268",,Keaau,HI,96749,"Keaau,HI 96749","Welders, Building Contractors-Commercial & Industrial, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair, Rails, Railings & Accessories Stairway",1,"1 Review",,,,,,,,"Phone: (808) 966-9591 Primary Phone: (808) 966-9591",,"master card, visa, amex, discover",,,http://www.vogtwelding.com,,"Keko'olani P.",09/30/2016,one,"Well, these people have no remorse for a working family. The drug user, that they send to your home, is not only checking out your household scoping the area, he will send others to rip you off!!! I know first hand...their staff drove through front of my home. Yet they continue to allow this man to drive the company trucks!!! And haven't paid for any damages or even apologized!!! Hey all said should our people be subjected to this type of business owners? Too dunk to realize? Or jus neglectful?",,,,
3858921,1248829,"2020-09-27 04:31:33","Welding Industries",http://hawaiiwelder.com,info@hawaiiwelder.com,"(808) 842-7774","999 Robello Ln",Honolulu,HI,96817,"999 Robello Ln,Honolulu,HI 96817","Welders, Fence-Sales, Service & Contractors, Hardware Stores, Iron Work, Machine Shops, Machinery-Rebuild & Repair, Rails, Railings & Accessories Stairway, Sheet Metal Fabricators, Sheet Metal Work, Stair Builders",,,A+,21.32024,-157.86649,https://i1.ypcdn.com/blob/8bf143dd61e34c7b7db471ea36810af0dbc5cb6b_100x100_crop.jpg?f832250,,"Architectural Manufactures... Gates, Railings, Stairs","Mon - Fri: 8:00 am - 4:30 pm",,,"master card, visa",,,http://hawaiiwelder.com,"Services: Guard Rails, Railings",,,,,,,,
3866571,1250330,"2020-09-27 04:31:40","A & S Ironworks",,,"(832) 545-2448","4203 J St",Houston,TX,77072,"4203 J St,Houston,TX 77072","Machinery-Rebuild & Repair, Fence Repair, Fence-Sales, Service & Contractors, Fence-Wholesale & Manufacturers, Furniture Designers & Custom Builders, Iron Ornamental Work-Supplies, Iron Work, Metal Doors, Metal Specialties, Welders",,,,29.71301,-95.59015,https://i1.ypcdn.com/blob/8ec93d7891d3c17f6be4345b8bcc9db535c0f46a_100x100_crop.jpg?f832250,"No job too big, too small, residential or commercial, we do it all.","We are a Houston based company that does custom wrought iron work, Driveway gates, Ornamental fence, Passage gates, Burglar bars, Air conditioning cages, Automated gate entry systems, on site repairs,Balconies, Stairs and railings, Drawings for HOA approvals. We can consult and guide you through your project from start to finish. Free estimates",,,,"visa, discover, mastercard, all major credit cards, check, debit, amex, insurance",,,,"Specialties: Swimming Pools, Commercial, Business, Residential, Homes",,,,,,,,
3870516,1251082,"2020-09-27 04:31:49","Crossroads Welding",,,"(800) 807-5002","108 E Cummings Ave",Miller,NE,68858,"108 E Cummings Ave,Miller,NE 68858","Welders, Fence-Sales, Service & Contractors, Machine Shops, Machinery-Rebuild & Repair",,,,40.92775,-99.38823,,,,,"Fax Number: (308) 457-2305",,,,"Crossroads Welding Llc Crossroads Welding 1",,,,,,,,,,
3876911,1252338,"2020-09-27 04:31:50","Jpg Welding",,jpgwelding@live.com,"(505) 459-1791","6211 Howe Dr SW",Albuquerque,NM,87105,"6211 Howe Dr SW,Albuquerque,NM 87105","Welders, Fence-Sales, Service & Contractors, Machine Shops, Machinery-Rebuild & Repair",,,,34.9821,-106.71091,,,,"Mon - Fri: 9:00 am - 5:00 pm Sat - Sun: Open 24 Hours",,,,,"Jpg Welding Inc.",,,,,,,,,,
3878260,1252593,"2020-09-27 04:31:50","Rod's Reliable Welding",http://www.rodsreliablewelding.com,rodsreliableweld@bellsouth.net,"(954) 733-7272","1802 NW 38th Ave","Fort Lauderdale",FL,33311,"1802 NW 38th Ave,Fort Lauderdale,FL 33311","Welders, Fence-Sales, Service & Contractors, Iron Work, Machine Shops, Machinery-Rebuild & Repair, Stair Builders","3,5","3 Reviews",A+,26.148321,-80.19955,https://i1.ypcdn.com/blob/7017681133016b540e45cded89ad860f1ab063fa_100x100_crop.jpg?f832250,,,"Mon - Fri: 8:00 am - 5:00 pm","TollFree: (877) 964-3805",,"all major credit cards, amex, discover, visa, mastercard",,,http://www.rodsreliablewelding.com,,"Henry c. M.",06/29/2018,four,"I hired this company to replace two metal poles by my pool. They did an amazing job. I would definitely recommend them.","Peter S.",04/20/2018,one,"I do not recommend this contractor. We hired them to build some gates for our house. Less than 4 years later nearly all the welds on one of the gates have broken. Their quote for repair is almost as much as they charged to build the gate in the first place. They claim it is unreasonable to expect that their welded aluminum gate should last more than 4 years. Disappointing they do not stand behind their work, especially for the money we paid them."
3885653,1254049,"2020-09-27 04:31:58","Gaithersburg Welding",,,"(301) 258-2616","7855 Cessna Ave",Gaithersburg,MD,20879,"7855 Cessna Ave,Gaithersburg,MD 20879","Welders, Fence-Sales, Service & Contractors, Iron Work, Machinery-Rebuild & Repair, Rails, Railings & Accessories Stairway",,,A+,39.17209,-77.15956,,,,"Mon - Fri: 8:00 am - 4:00 pm","Primary Phone: (301) 258-7381 Phone: (301) 258-8109 Primary Phone: (301) 258-8109 Fax: (301) 258-8109",,,,"G & H Welding and Fabrication Inc G & H Welding & Fabrication Inc G & H Welding & Fabrications",,,,,,,,,,
3888699,1254646,"2020-09-27 04:31:58","Gray's Welding",,,"(903) 872-3012","1700 S Business 45",Corsicana,TX,75110,"1700 S Business 45,Corsicana,TX 75110","Welders, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair",,,,32.08113,-96.45371,,,,,,,,,,,,,,,,,,,
3914328,1259588,"2020-09-27 04:32:32","Licata S Mobile Repair",,,"(716) 998-9990","632 Pleasant View Dr",Lancaster,NY,14086,"632 Pleasant View Dr,Lancaster,NY 14086","Welding Equipment Repair, Fence Repair, Machinery-Rebuild & Repair, Material Handling Equipment, Signs-Maintenance & Repair",,,,42.93106,-78.63613,,,,,,,,,"Licata S Mobile Repair Llc",,,,,,,,,,
3931970,1262807,"2020-09-27 04:32:47","General Welding Co Inc",,,"(203) 753-6988","28 Broadway St",Waterbury,CT,06705,"28 Broadway St,Waterbury,CT 06705","Welders, Fence-Sales, Service & Contractors, Machine Shops, Machinery-Rebuild & Repair, Rails, Railings & Accessories Stairway",,,,41.54166,-72.98154,,,,,"Fax: (203) 753-6988",,,,,,,,,,,,,,
3934434,1263284,"2020-09-27 04:32:49","Armitage Welding",http://www.boricuaproduce.com,armitagewelding@sbcglobal.net,"(773) 772-1442","3212 W Armitage Ave",Chicago,IL,60647,"3212 W Armitage Ave,Chicago,IL 60647","Welders, Fence-Sales, Service & Contractors, Machine Shops, Machinery-Rebuild & Repair",,,,41.91747,-87.70791,https://i1.ypcdn.com/blob/888ee495709925816c0849f5b48ca53057183a23_100x100_crop.jpg?f832250,,,"Mon - Fri: 9:30 am - 5:00 pm Sat - Sun Closed","Phone: (773) 799-8031",,"no credit cards",,,http://www.boricuaproduce.com,"Parking: Street",,,,,,,,
3939973,1264297,"2020-09-27 04:32:53","The Wright Way Fabrication & Welding",http://thewrightwayfab.com,thewrightwayfab@msn.com,"(602) 703-1393","21107 Cherokee St",Buckeye,AZ,85326,"21107 Cherokee St,Buckeye,AZ 85326","Welders, Fence-Sales, Service & Contractors, Iron Work, Machine Shops, Machinery-Rebuild & Repair",,,,33.33263,-112.5047,,,"Call Us For All Your Design, Welding and Fabrication Needs,Thank you for considering The Wright Way Fabrication and Welding Inc. We provide design, welding and fabrication services to the residents and businesses of Buckeye, AZ and the surrounding areas. From custom design and fabrication to mobile welding we have what it takes to handle your needs.Give us a call today for more information.","Mon - Fri: 7:00 am - 4:00 pm","Primary Phone: (623) 386-7500 Phone: (623) 386-7500 Fax: (623) 386-7500",,"check, cash",,"Wright Way Fabrication & Wldng The Wright Way Fabrication And Welding Inc. WRIGHT WAY FAB WELD INC The Wright Way Fabrication and Welding The Wright Way Fabrication & Welding Inc",http://thewrightwayfab.com,,,,,,,,,
3945862,1265433,"2020-09-27 04:33:00","Philip's Welding Service",,,"(714) 892-2277","6402 Chapman Ave","Garden Grove",CA,92845,"6402 Chapman Ave,Garden Grove,CA 92845","Welders, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair",,,,33.78801,-118.02119,,,,,,,,,"Philip's Welding Svc Philip's Welding Service Philip's Welding Service",,,,,,,,,,
3945903,1265441,"2020-09-27 04:33:00","Korth & Linke Welding",http://korthandlinkewelding.com,korthandlinkewelding@gmail.com,"(979) 836-9501","705 S Blue Bell Rd",Brenham,TX,77833,"705 S Blue Bell Rd,Brenham,TX 77833","Welders, Fence-Sales, Service & Contractors, Iron Ornamental Work-Supplies, Machine Shops, Machinery-Rebuild & Repair",,,A+,30.16574,-96.38013,,,,,,,,,"Korth & Linke Welding LLC",http://korthandlinkewelding.com,,,,,,,,,
3952561,1266632,"2020-09-27 04:33:02","Best Choice Welding Inc",http://www.bestchoicewelding.com,marvinchambers@msn.com,"(303) 840-9103","11125 Hilltop Rd",Parker,CO,80134,"11125 Hilltop Rd,Parker,CO 80134","Welders, Fence-Sales, Service & Contractors, Machine Shops, Machinery-Rebuild & Repair, Stair Builders",,,,39.44553,-104.67417,,,"We weld just about anything! Give us a call!!Best Choice Welding offers custom in-shop and on site welding services to customers in the Castle Rock, Parker, Denver Metro and Boulder area. Weve proudly been serving since 20 years! We weld anything from aluminum, structural steel and stainless steel.Our skilled welders can repair or fabricate just about anything. Our areas of specialty include: Trailer repairs Hitch installations Handrails Headache racks & flat bedsGreat new if you cant make it to our shop, our mobile service are gladly available to come to your location. Just give us a call.We offer free estimates we're also TIG AWS certified.Call today for an appointment.","Mon - Fri: 8:00 am - 6:00 pm Sat: 9:00 am - 12:00 pm","Phone: (303) 840-8990",,"cash, check",,,"http://www.bestchoicewelding.com http://bestchoiceweldinginc.com",,,,,,,,,
3957407,1267464,"2020-09-27 04:33:11","61 Contracting",,monroepeggins@gmail.com,"(901) 239-6429","3907 E Raines Rd",Memphis,TN,38118,"3907 E Raines Rd,Memphis,TN 38118","Welders, Fence-Sales, Service & Contractors, Iron Work, Machinery-Rebuild & Repair",,,A+,35.03673,-89.93255,,,,,"Primary Phone: (901) 417-7718 Phone: (901) 417-7718",,,,"61 Contracting LLC 61 Welding Shop",,,,,,,,,,
3978645,1271331,"2020-09-27 04:33:21","Blank's Welding LLC",,john@blankswelding.com,"(717) 442-3619","5921 Plank Rd",Narvon,PA,17555,"5921 Plank Rd,Narvon,PA 17555","Welders, Fence-Sales, Service & Contractors, Machinery-Rebuild & Repair",,,,40.03783,-75.96412,,,,"Mon - Fri: 7:00 am - 4:00 pm",,,,,,,,,,,,,,,
4010177,1280335,"2020-09-27 04:34:22","Metro Maintenance Solutions",http://www.mmsga.com,,"(770) 714-7794","PO Box 139",Moreland,GA,30259,"PO Box 139,Moreland,GA 30259","Handyman Services, Lighting Maintenance Service, Machine Guards, Machinery-Rebuild & Repair",,,,33.273438,-84.75656,https://i1.ypcdn.com/blob/40d62e70d1bea0c8c6f2cd6c4f5fa91960233cd2_100x100_crop.jpg?adceb05,Maintenance>Management>Integrated,"Metro Maintenance Solutions is an Industrial, Commercial, & Retail maintenance-management provider serving Atlanta, GA and surrounding areas with a unique blend of expert level services and small, family owned business charm. We provide business with flexible and dynamic maintenance services that fulfill their needs whether they range from an international manufacturing facility all the way down to small retail store.",,,,"visa, discover, mastercard, all major credit cards, check",,,"Single source industrial, commercial, and retail maintenance-management services",,,,,,,,,
4105775,1307215,"2020-09-27 04:37:06","AMP Tree Care Services",http://www.sokul1.wix.com/amptree,Sokul1@aol.com,"(224) 532-9226","3241 Rfd","Long Grove",IL,60047,"3241 Rfd,Long Grove,IL 60047","Electric Equipment Repair & Service, Air Conditioning Equipment & Systems, Air Conditioning Service & Repair, Automation Systems & Equipment, Building Contractors, Building Contractors-Commercial & Industrial, Building Maintenance, Commercial & Industrial Door Sales & Repair, Conveyors & Conveying Equipment, Conveyors & Monorail Systems, Cylinders-Air & Hydraulic, Electrical Engineers, Electronic Engineers, Fans-Industrial & Commercial, Fire Alarm Systems, Fire Escapes, Firewood, Garbage Disposal Equipment Industrial & Commercial, Handyman Services, Hoist Repair, Home Repair & Maintenance, Hydraulic Equipment Repair, Industrial Engineers, Machine Tool Repair & Rebuild, Machinery Cleaning Service, Machinery-Rebuild & Repair, Manufacturing Engineers, Marine Contractors, Mulches, Property Maintenance, Restaurant Equipment-Repair & Service, Sheet Metal Fabricators, Sheet Metal Work, Snow Removal Service, Stump Removal & Grinding, Switches-Electric, Tanks-Removal & Installation, Tanks-Repair, Tree Service, Water Heater Repair, Water Supply Systems, Welders",5,"1 Review",,42.19672,-88.0703,,,,"Mon - Sat: 6:00 am - 11:30 pm Sun: 6:00 am - 12:00 pm",,,"all major credit cards, check, debit, insurance, no credit cards, paypal",,,http://www.sokul1.wix.com/amptree,"Wheelchair Accessible: No","Peter G.","Edited: 01/12/2017",five,"Trees ~Sarah Coleridge The Oak is called the king of trees, The Aspen quivers in the breeze, The Poplar grows up straight and tall, The Peach tree spreads along the wall, The Sycamore gives pleasant shade, The Willow droops in watery glade, The Fir tree useful in timber gives, The Beech amid the forest lives.",,,,
4113799,1309329,"2020-09-27 04:37:11","JC and Sons Handyman Services",,joechida@cfl.rr.com,"(321) 848-3656",,"Satellite Beach",FL,32937,"Satellite Beach,FL 32937","Building Restoration & Preservation, Bathroom Remodeling, Handyman Services, Home Improvements, Machinery-Rebuild & Repair",,,A+,,,,"WE DO YOUR HONEY DO LIST, OR THOSE PROJECTS THAT ARE SOMETIMES OUT OF SIGHT, OUT OF MIND! WE DO EVERYTHING! FROM REPAIRS TO REMODELS! WE HAVE MANY REFERENCES PLEASE DO NOT BE AFRAID TO ASK!","FULL LINE HANDYMAN SERVICES","Mon - Sun: Open 24 Hours",,,check,,,,,,,,,,,,
5718166,1712941,"2020-09-27 05:17:16",Jackson99,http://www.jackson99.com,info@jackson99.com,"(716) 307-6056","1971 michigan ave",olean,NY,14760,"1971 michigan ave,olean,NY 14760","Machinery-Rebuild & Repair, Computer Online Services, Electronic Equipment & Supplies-Repair & Service, Graphic Designers, Web Site Design & Services",,,,42.11986,-78.41356,,,,"Mon - Fri: 3:30 pm - 8:30 pm Sat: 10:00 am - 4:00 pm Sun Closed","TollFree: (855) 873-7539",,"cash, paypal, financing available, check",,,"jackson99 computer and electronics",,,,,,,,,
14387036,1858312,"2020-09-27 05:31:31","Pamco Machine Works Inc",http://pamcomachine.com,sales@pamcomachine.com,"(626) 256-8394","924 S Primrose Ave",Monrovia,CA,91016,"924 S Primrose Ave,Monrovia,CA 91016","Machinery-Rebuild & Repair, Auto Repair & Service, Automobile Machine Shop, Hardware Stores, Industrial Equipment & Supplies, Machine Shops, Machinery",,,,34.14181,-118.00278,,,,,"Phone: (626) 357-8190",,,,,http://pamcomachine.com,,,,,,,,,
14394222,1858840,"2020-09-27 05:31:31",Ferguson,https://www.ferguson.com/category?cmpid=md_ntnl_plmb_nat_yp___order_,Jerry.Mayeaux@ferguson.com,"(337) 625-3300","1631 Swisco Rd",Sulphur,LA,70665,"1631 Swisco Rd,Sulphur,LA 70665","Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Bath Equipment & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Fixtures, Cabinets & Accessories-Wholesale & Manufacturers, Building Materials, Building Materials-Wholesale & Manufacturers, Hardware Stores, Heating Equipment & Systems-Wholesale, Home Improvements, Hose Couplings & Fittings-Wholesale & Manufacturers, Industrial Equipment & Supplies, Machinery-Rebuild & Repair, Pipe, Pipe Fittings, Pipe-Wholesale & Manufacturers, Plumbing Fixtures, Parts & Supplies, Tools, Valves, Valves-Wholesale & Manufacturers, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Works Contractors, Water Works Equipment & Supplies",,,,30.20981,-93.3446,https://i3.ypcdn.com/blob/898a20c3dca33c4bf7ff04ad70a2847369800dc6_100x100_crop.jpg?d9a04b5,"Get the quality pipes, valves and fittings, waterworks, heating and cooling equipment, parts and supplies you need, when you need them.","For more than 60 years, Ferguson has earned a strong reputation among contractors, builders and plumbers across the country. We are the largest distributor of residential and commercial plumbing supplies and PVF in the U.S., and a major supplier of HVAC, waterworks and industrial products and services. Ferguson understands the challenges that contractors face. Our knowledgeable people, on-time delivery and commitment to our customers are just a few of the capabilities that set us apart, and keep you on schedule. Whether your project consists of construction on a commercial building, institutional facility or repair and remodel, we offer quick access to product. We don't just take orders. Our expertise allows us to evaluate your specific project or job to ensure that you always get: В• The right product for your application В• The industry's highest fill rates on stock items В• Short lead times on non-stock products В• Access to hard to find products based on our buying power and sourcing expertise В• On-time delivery to keep your project on track With 1,400 locations nationwide, contractors always have access to our vast distribution network. Depending on the size and scope of your project, we will even bring Ferguson to you with our onsite trailer stocked with the products you need to get the job done. We carry all the best and most-recognized brands, cutting edge technology & inventory management solutions, and much more. To find a Ferguson location near you, visit www.ferguson.com/locations-finder.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"amex, visa, mastercard",,,"Shop Online",,,,,,,,,
14420822,1860778,"2020-09-27 05:31:46","U S Autoclave",http://www.usautoclave.com,kfennel@usautoclave.com,"(419) 224-4441","1200 E Kibby St Bldg 3",Lima,OH,45804,"1200 E Kibby St Bldg 3,Lima,OH 45804","Machinery-Rebuild & Repair, Hardware Stores",,,,40.72859,-84.08448,,,,"Mon - Fri: 8:00 am - 4:00 pm",,,,,"US Autoclave Ltd","http://www.usautoclave.com https://www.usautoclave.com",,,,,,,,,
14448068,1862870,"2020-09-27 05:32:02","Bero Machinery Co",,,"(740) 745-2826","12051 Houdeshell Rd","Saint Louisville",OH,43071,"12051 Houdeshell Rd,Saint Louisville,OH 43071","Machinery-Rebuild & Repair, Hardware Stores, Industrial Equipment & Supplies, Machine Shops, Machinery",,,,40.18001,-82.31027,,,,"Mon - Fri: 8:00 am - 6:00 pm Sat - Sun Closed","Phone: (740) 745-2827 Fax: (740) 745-2827",,"check, cash",,,,,,,,,,,,
14463104,1864017,"2020-09-27 05:32:06","J & B Auto Supply & Hardware Inc.",http://www.jandbautosupply.com,sales@jandbautosupplyandhardware.com,"(936) 760-2012","11635 Highway 105 E",Conroe,TX,77306,"11635 Highway 105 E,Conroe,TX 77306","Automobile Parts & Supplies, Automobile Accessories, Automobile Electric Service, Automotive Alternators & Generators, Electricians, Hardware Stores, Machine Shops, Machinery-Rebuild & Repair",,,,30.32569,-95.39762,,,"J & B has been serving the Montgomery County area since 1983. We offer both auto supply parts and hardware at the same location. Our staff has been with our company for many years as well as served in their related field with an average of 25 years.","Mon - Fri: 7:00 am - 6:30 pm Sat: 7:00 am - 3:00 pm Sun Closed","Fax: (936) 756-8250",,"all major credit cards, check, debit",,,"http://www.jandbautosupply.com http://www.jandbautosupplyandhardware.com http://www.jandbhardware.com",,,,,,,,,
14466508,1864277,"2020-09-27 05:32:06","Sidney Bowles",,,"(337) 896-8586","334 Gendarme Rd",Carencro,LA,70520,"334 Gendarme Rd,Carencro,LA 70520","Machinery-Rebuild & Repair, Hardware Stores, Industrial Equipment Repair",,,,30.359127,-92.058365,,,,,,,,,"Bowles Sidney",,,,,,,,,,
14480318,1865336,"2020-09-27 05:32:09","Ffp Unlimited",,,"(702) 871-1406","4780 W Harmon Ave","Las Vegas",NV,89103,"4780 W Harmon Ave,Las Vegas,NV 89103","Machinery-Rebuild & Repair, Hardware Stores, Industrial Equipment Repair",,,,36.10867,-115.20544,,,,,,,"all major credit cards, amex, master card, visa",,"Ffp Unlimited LLC",,,,,,,,,,
14587658,1873507,"2020-09-27 05:32:54","F T Moore & Sons Inc",,,"(812) 466-3762","3648 E Broadlands Ave","Terre Haute",IN,47805,"3648 E Broadlands Ave,Terre Haute,IN 47805","Machinery-Rebuild & Repair, Hardware Stores, Welders",,,,39.56695,-87.36145,,,,"24 Hour Service",,,,,,,,,,,,,,,
14594845,1874029,"2020-09-27 05:33:01","Bear Teddy Welding",,,"(316) 776-0811","15766 SW Tawakoni Rd","Rose Hill",KS,67133,"15766 SW Tawakoni Rd,Rose Hill,KS 67133","Welders, Hardware Stores, Machinery-Rebuild & Repair",,,,37.5941,-97.05744,,,,,,,,,"Teddy Bear Welding",,,,,,,,,,