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
1726442,518070,"2020-09-27 03:21:47","Sherwin-Williams Paint Store - Sheboygan",http://www.sherwin-williams.com,yourname@address.com,"(920) 452-3713","1704 Erie Ave",Sheboygan,WI,53081,"1704 Erie Ave,Sheboygan,WI 53081","Paint, Automobile Body Shop Equipment & Supplies, Home Improvements, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Painters Equipment & Supplies, Painting Contractors, Spray Painting & Finishing, Spraying Equipment, Spraying Equipment-Renting, Wall Coatings, Wallpapers & Wallcoverings, Wallpapers & Wallcoverings-Installation",,,,43.75648,-87.72819,https://i1.ypcdn.com/blob/7bfc0efd632821fef79dec4e7480e3d83ab68e83_100x100_crop.jpg?f832250,,"Sherwin-Williams Paint Store of Sheboygan, WI has exceptional quality paint supplies, wallpaper, stains and sealer to bring your ideas to life. Painting Questions? Ask Sherwin-Williams.","Mon - Fri: 7:00 am - 7:00 pm Sat: 8:00 am - 6:00 pm Sun: 10:00 am - 6:00 pm",,,"cash, check, debit, discover, amex, diners club, master card, visa",,,"http://www.sherwin-williams.com http://www.sherwin-williams.com/store-locator/paint-store/Sheboygan/WI/3197 Web Site http://sherwin.com","Specialties: Stain",,,,,,,,
1746646,523334,"2020-09-27 03:22:21","Smith Ace Hardware",http://acehardware.com,sherman@smithace.comcastbiz.net,"(423) 562-7738","116 E Central Ave","La Follette",TN,37766,"116 E Central Ave,La Follette,TN 37766","Paint Manufacturing Equipment & Supplies, Building Materials, Construction & Building Equipment, Electric Equipment & Supplies, Gas Companies, Hardware Stores, License Services, Paint, Pipe Cutting & Threading, Piping Contractors, Plumbing Fixtures, Parts & Supplies, Propane & Natural Gas, Utility Companies",5,"1 Review",,36.38098,-84.12174,https://i3.ypcdn.com/blob/e51b38a9aa552821b35acc24cf05063fc41ae6c6_100x100_crop.jpg?f832250,"The helpful place","As your local Ace Hardware, our store is a member of the largest retailer-owned hardware cooperative in the industry. Ace Hardware began as a small chain of stores in 1924 and has grown to include more than 4,600 stores in 50 states","Mon - Fri: 7:30 am - 6:00 pm Sat: 7:30 am - 5:30 pm Sun Closed",,,"amex, check, debit, discover, master card, visa",,,http://acehardware.com,"Parking: Lot",ddodds,09/25/2009,five,"The products are better, the store is bigger but the service is still the same: GOOD AND FRIENDLY",,,,
2182790,679776,"2020-09-27 03:37:42","Gator Paint And Decorating Inc",http://gatorpaint.net,g8trpaint@bellsouth.net,"(352) 505-9464","5220 NW 34th Blvd",Gainesville,FL,32605,"5220 NW 34th Blvd,Gainesville,FL 32605","Paint Manufacturing Equipment & Supplies, Chemicals, Cleaners Supplies, Cleaning Contractors, Cleaning Systems-Pressure, Chemical, Etc, Construction & Building Equipment, Contractors Equipment & Supplies, Paint, Paint-Wholesale & Manufacturers, Painters Equipment & Supplies, Power Washing, Pressure Cleaning Equipment & Supplies, Pressure Washing Equipment & Services, Rental Service Stores & Yards, Water Pressure Cleaning",,,,29.678457,-82.36794,,"Paint is _ALL_ we do","Locally owned and operated for over 30 years, Gator Paint has been serving Gainesville and the surrounding area since 1983. Combining painting experience with paint knowledge, our staff will guide you through any paint project - big or small. We are proud to sell quality paint at an affordable price and are committed to giving you the BEST customer service in the indusrty. Come by or contact us to today for expert advice and color matching.","Mon - Fri: 7:00 am - 5:30 pm Sat: 8:00 am - 12:00 pm Sun Closed",,,"visa, mastercard, cash, check, discover",,,http://gatorpaint.net,"Price Range : Average",,,,,,,,
2718993,844029,"2020-09-27 03:53:55","Hazuga's True Value Hardware",http://www.truevalue.com,kimstuttgen1@yahoo.com,"(715) 644-3375","207 North Broadway Street",Stanley,WI,54768,"207 North Broadway Street,Stanley,WI 54768","Hardware Stores, Air Conditioning Equipment & Systems, Bath Equipment & Supplies, Heating Equipment & Systems, Household Fans, Kitchen Accessories, Lawn & Garden Equipment & Supplies, Lighting Fixtures, Lighting Systems & Equipment, Major Appliances, Paint Manufacturing Equipment & Supplies, Painters Equipment & Supplies, Party Supply Rental, Patio & Outdoor Furniture, Storm Window & Door Repair, Tool Rental, Tool Repair & Parts, Tools",,,,44.9611,-90.9381,https://i4.ypcdn.com/blob/fd4f6cf96f387f2dc4fd4988eebe59bf1e2044ff_100x100_crop.jpg?41e4770,"True Value - Start Right, Start Here","Hazuga's True Value Hardware, in Stanley, WI, is the area's leading hardware store serving Stanley, Boyd, Cadott, Cornell, Chippewa Falls, Lake Hallie and surrounding areas for over 39 years. We specialize in lawn mowers, appliances, hardware, paint, farm supplies, fencing, party rentals and much more. For all your hardware needs, visit Hazuga's True Value Hardware in Stanley.","Mon - Fri: 7:00 am - 7:00 pm Sat: 8:00 am - 5:00 pm Sun: 9:00 am - 3:00 pm","Fax: (715) 644-5083",,"discover, visa, mastercard, amex, cash",,,"Primary Website Facebook",,,,,,,,,
4162822,1321043,"2020-09-27 04:38:14","P&B Services",,,"(857) 312-3935","121 Trefton Dr",Braintree,MA,02184,"121 Trefton Dr,Braintree,MA 02184","Gutters & Downspouts, Carpenters, Paint Manufacturing Equipment & Supplies, Painting Contractors-Commercial & Industrial, Power Washing",,,,42.23149,-70.96504,,,,"Mon - Fri: 9:00 am - 5:00 pm Sat: 10:00 am - 4:00 pm",,,,,,,,,,,,,,,
4170448,1322864,"2020-09-27 04:38:18","The Paint Mart",http://pensacolapaintmart.com,paintmart1@gmail.com,"(850) 438-2399","2525 W Fairfield Dr",Pensacola,FL,32505,"2525 W Fairfield Dr,Pensacola,FL 32505","Carpenters, Chemicals, Coatings-Protective, Construction & Building Equipment, Contractors Equipment & Supplies, Paint, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Painters Equipment & Supplies, Wood Preserving, Woodworking",,,A+,30.44446,-87.24603,https://i2.ypcdn.com/blob/e1085312997ecea1079d13affb462711f9667c82_100x100_crop.jpg?8ad0f92,"Call Us Today! 850-438-2399","The Paint Mart Features:* Quality products* Expert advice* Color matching","Mon - Fri: 7:00 am - 5:00 pm Sat: 8:00 am - 1:00 pm",,,"cash, check",,"Paint Mart or The Paint Mart",http://pensacolapaintmart.com,,,,,,,,,
4784315,1477646,"2020-09-27 04:53:26","Oman & Son Builders Supply",http://www.omanandson.com,troy@omanandson.com,"(360) 642-2385","612 Washington Ave S","Long Beach",WA,98631,"612 Washington Ave S,Long Beach,WA 98631","Hardware Stores, Building Materials, Cabinets, Construction & Building Equipment, Home Repair & Maintenance, Lumber-Wholesale, Paint Manufacturing Equipment & Supplies, Roofing Equipment & Supplies",,,A+,46.34808,-124.05235,https://i2.ypcdn.com/blob/de718a4ecef29bd372b8775ef1358b2cc373f93f_100x100_crop.jpg?e66d351,,"Since 1943, we have been dedicated to serving the Long Beach Peninsula and Southwest Washington with quality building materials and exceptional customer service. With over 25,000 items in stock, there is a lot to choose from at our store locations in Long Beach and Ocean Park, Washington. Do not forget about our great in-store specials and convenient, free delivery!","Mon - Fri: 7:30 am - 5:00 pm Sat: 8:00 am - 5:00 pm Sun: 9:00 am - 1:00 pm",,,"master card, visa, cash, check, debit",,,http://www.omanandson.com,,,,,,,,,
14405059,1859616,"2020-09-27 05:31:42","Environmental Paint Solutions",,,"(855) 339-2679","6940 Tremont Rd",Dixon,CA,95620,"6940 Tremont Rd,Dixon,CA 95620","Chemicals, Construction & Building Equipment, Contractors Equipment & Supplies, Environmental & Ecological Consultants, Environmental & Ecological Products & Services, Hardware Stores, Paint, Paint Manufacturing Equipment & Supplies, Painters Equipment & Supplies, Painting Contractors",5,"1 Review",,38.49605,-121.79858,,,,"Mon - Fri: 8:00 am - 5:00 pm Sat: 8:00 am - 1:00 pm",,,,,,,,"Dave n kristen B.",04/20/2015,five,"Helpful. Friendly. Reasonable prices and good paint knowledge. I will use them again.",,,,
14422631,1860927,"2020-09-27 05:31:46","Complete Paint & Supplies",http://www.completepaintandsupplies.com,jones@copyplus.com,"(231) 526-1458","1030 State St Ste 12","Harbor Springs",MI,49740,"1030 State St Ste 12,Harbor Springs,MI 49740","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint",,,,45.43881,-84.99024,,,,"SA 09:00-13:00","Phone: (231) 242-4460 Phone: (231) 526-1460 Fax: (231) 242-4460 Fax: (231) 526-1460 TollFree: (888) 260-9754 TollFree: (877) 632-9389",,"discover, master card, visa, all major credit cards, amex",,"Complete Paint And Supplies",http://www.completepaintandsupplies.com,,,,,,,,,
14425317,1861141,"2020-09-27 05:31:51","Cemsac Chem Co",http://www.cemsac.com,,"(636) 391-2600","212 Clarkson Executive Park",Ellisville,MO,63011,"212 Clarkson Executive Park,Ellisville,MO 63011","Paint Manufacturing Equipment & Supplies, Hardware Stores, Industrial Equipment & Supplies, Paint",,,,38.59867,-90.58584,https://i4.ypcdn.com/blob/f5f25f89de7969adcb2e7c49eb169fde6ec331e2_100x100_crop.jpg?41e4770,,,,,,,,"Cemsac Chemical Co",http://www.cemsac.com,,,,,,,,,
14430052,1861490,"2020-09-27 05:31:51","Prelude Inc",,,"(772) 210-6586","7749 SW Ellipse Way",Stuart,FL,34997,"7749 SW Ellipse Way,Stuart,FL 34997","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,27.11163,-80.26615,,,,,,,,,,,,,,,,,,,
14437955,1862082,"2020-09-27 05:32:01","Cash And Carry Building Supply",http://cashandcarrybuildingsupply.com,admin@cashancarry.com,"(662) 328-5776","1120 Gardner Blvd",Columbus,MS,39702,"1120 Gardner Blvd,Columbus,MS 39702","Building Materials, Construction & Building Equipment, Hardware Stores, Lumber, Paint, Paint Manufacturing Equipment & Supplies, Tools, Wood Products",,,A+,33.50354,-88.38861,https://i4.ypcdn.com/blob/e3f31a6b69ff305c2044a9a57f1d3c118290f82a_100x100_crop.jpg?41e4770,,,"Mon - Fri: 7:00 am - 5:00 pm",,,,,,http://cashandcarrybuildingsupply.com,"Parking: Lot",,,,,,,,
14451566,1863132,"2020-09-27 05:32:02","Perfection Pittsburg Paint",,,"(509) 586-1195","1617 S Washington St",Kennewick,WA,99337,"1617 S Washington St,Kennewick,WA 99337","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint, Paint-Wholesale & Manufacturers",,,,46.19273,-119.11658,,,,"Mon - Fri: 7:00 am - 5:00 pm",,,,,,,,,,,,,,,
14459286,1863730,"2020-09-27 05:32:02","W G Cannon Paint Company Inc",,cannon@cannonpaint.com,"(828) 754-5376","1015 Zacks Fork Rd",Lenoir,NC,28645,"1015 Zacks Fork Rd,Lenoir,NC 28645","Paint, Hardware Stores, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers",,,,35.94034,-81.52805,,,,"Mon - Fri: 7:00 am - 4:00 pm","Phone: (828) 754-2164 Phone: (828) 754-2165 Fax Number: (828) 754-2165 Fax: (828) 754-2165",,,,"Cannon Paint Co Inc",,,,,,,,,,
14462801,1863993,"2020-09-27 05:32:03",Brandster,,info@brandster.com,"(772) 934-6320","1744 NW Federal Hwy",Stuart,FL,34994,"1744 NW Federal Hwy,Stuart,FL 34994","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,27.22678,-80.26621,,,"Shop our huge selection of Breezesta outdoor furniture for lowest price possible. We offers wide range of colors that allow your customers to match their furniture requirements. Call 800-357-5044.","Mon - Sun: 9:30 am - 5:30 pm",,,"amex, discover, master card, visa",,,,,,,,,,,,
14471716,1864687,"2020-09-27 05:32:06","Glidden Professional Paint Center",http://www.gliddenprofessional.com,,"(605) 332-5545","1204 W 41st St","Sioux Falls",SD,57105,"1204 W 41st St,Sioux Falls,SD 57105","Paint, Hardware Stores, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Wallpapers & Wallcoverings",,,,43.51496,-96.74023,,,,,,,,,,"http://www.gliddenprofessional.com https://www.gliddenprofessional.com",,,,,,,,,
14480229,1865330,"2020-09-27 05:32:09","San Jose Color Wholesale",,,"(408) 293-5694","725 N 10th St Ste 100","San Jose",CA,95112,"725 N 10th St Ste 100,San Jose,CA 95112","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint-Wholesale & Manufacturers",5,"1 Review",,37.35411,-121.89112,https://i4.ypcdn.com/blob/101acf23d4227699e7e8916b5c4e80ac7285a270_100x100_crop.jpg?41e4770,,,,,,,,,,,"Eric D.",03/15/2019,five,"Business has moved. San Jose Color 1939 Monterey Road #13 San Jose, CA 95112 408-293-5694 Great place to go to buy automotive paint and supplies. Great prices and great quality products.",,,,
14532248,1869298,"2020-09-27 05:32:29","Hacienda Home Centers",https://www.haciendahomecenters.com,esphacienda@hhcnm.com,"(505) 753-2131","430 S Riverside Dr",Espanola,NM,87532,"430 S Riverside Dr,Espanola,NM 87532","Hardware Stores, Air Conditioning Equipment & Systems, Building Materials, Electrical Discharge Machines & Supplies, Garden Centers, Keys, Lawn & Garden Equipment & Supplies, Lumber Carriers, Paint Manufacturing Equipment & Supplies, Plumbing Fixtures, Parts & Supplies, Stoves-Wood, Coal, Pellet, Etc-Retail, Tools",5,"1 Review",,35.98825,-106.06484,https://i3.ypcdn.com/blob/d50f70647efa2660a0cdf426fea4dca1c281c1c8_100x100_crop.jpg?d9a04b5,,"Welcome to Hacienda Home Center! We're proud to be Espanola's family-owned home center. Located at 430 South Riverside Drive in Espanola, New Mexico, we serve the communities throughout Rio Arriba and Santa Fe County including the nearby areas of Santa Cruz, Santa Clara Pueblo and Santa Clara Indian Reservation, Sombrillo, Hernandez, La Puebla, Chimayo, and El Valle De Arroyo Seco. We are a full service home center specializing in building materials, all your general hardware needs, and much more. Most of our 67,000 items are available to order online, with FREE Ship-to-Store! We pride ourselves on providing the Espanola community with a variety of services as well, so feel free to stop in!","Mon - Fri: 7:30 am - 6:00 pm Sat: 8:00 am - 5:00 pm Sun Closed","Fax: (505) 747-8351 TollFree: (855) 828-9792",,"amex, check, discover, visa, company card, cash, apple pay, invoicing available, all major credit cards, mastercard",,"Do It Best","Primary Website",,"Alyson M.",04/02/2018,five,"Awesome Store! This place has awesome employees, customer service is spot on! They'll help you from the moment you walk in until you're ready to pay at the register. Not like other places where the sales people run and hide from you.",,,,
14533426,1869384,"2020-09-27 05:32:29","Gemini Coatings",http://gemini-coatings.com,,"(775) 358-0108","1291 Spice Islands Dr",Sparks,NV,89431,"1291 Spice Islands Dr,Sparks,NV 89431","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint-Wholesale & Manufacturers",,,,39.51646,-119.72234,,,,,"Phone: (775) 323-4749 Fax: (775) 323-9343",,,,"Gemini Coatings INC",http://gemini-coatings.com,,,,,,,,,
14539611,1869857,"2020-09-27 05:32:29","Landmark Paint & Supply Company",https://www.ppgpaints.com/store-locator/us/texas/carrollton-paint-stores/landmark-paint-and-supply-33813,,"(214) 905-3436","3200 Commander Dr Ste 108",Carrollton,TX,75006,"3200 Commander Dr Ste 108,Carrollton,TX 75006","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint",,,,32.97774,-96.84995,https://i3.ypcdn.com/blob/05c3b6b18c0d381f5d63d1aa1d8189cbad502029_100x100_crop.jpg?d9a04b5,,,,,,,,"Landmark Paint and Supply Company",https://www.ppgpaints.com/store-locator/us/texas/carrollton-paint-stores/landmark-paint-and-supply-33813,,,,,,,,,
14542532,1870063,"2020-09-27 05:32:34","Dunn Pro Paint Center",http://benjaminmoore.com,,"(440) 534-5150","8141 Tyler Blvd",Mentor,OH,44060,"8141 Tyler Blvd,Mentor,OH 44060","Paint, Hardware Stores, Home Centers, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers",,,,41.683,-81.34855,,,,,,,,,,http://benjaminmoore.com,,,,,,,,,
14545248,1870284,"2020-09-27 05:32:34","Pittsburgh Coatings & Paint Inc.",http://www.ppgpaintpalmbeach.com,,"(561) 881-7433","1959 W 9th St","Riviera Beach",FL,33404,"1959 W 9th St,Riviera Beach,FL 33404","Chemicals, Building Contractors-Commercial & Industrial, Construction & Building Equipment, Contractors Equipment & Supplies, Hardware Stores, Paint, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Painters Equipment & Supplies, Painting Contractors-Commercial & Industrial, Pressure Cleaning Equipment & Supplies, Pressure Washing Equipment & Services",,,,26.77065,-80.08842,https://i3.ypcdn.com/blob/a99d83ef49b94fab33e0d903c061bcb2aa340b86_100x100_crop.jpg?d9a04b5,"Over 100 Years of Paint and Stain Experience!","To provide service and quality paint at reasonable prices to the public and trade through stocking a large selection of top brand tools, paints, and primers from national and regional paint companies. Open to the public and exporting to the islands and beyond.","Mon - Fri: 7:00 am - 5:00 pm Sat: 8:00 am - 12:00 pm Sun Closed",,,"mastercard, visa, amex",,"PPG Pittsburgh Paints","http://www.ppgpaintpalmbeach.com Find A Location Near You",,,,,,,,,
14553230,1870888,"2020-09-27 05:32:35","D & F Distributing Inc",http://www.dfdist.com,info@dfdist.com,"(214) 520-1334","2501 Oak Lawn Ave Ste 820",Dallas,TX,75219,"2501 Oak Lawn Ave Ste 820,Dallas,TX 75219","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,32.805,-96.81433,,,,"Mon - Fri: 7:30 am - 5:00 pm",,,,,,http://www.dfdist.com,,,,,,,,,
14580340,1872923,"2020-09-27 05:32:50","Lanning Paints",http://www.wisebuyingmall.com/lanningpaints,alanning@bellsouth.net,"(502) 245-0630","11608 Shelbyville Rd",Louisville,KY,40243,"11608 Shelbyville Rd,Louisville,KY 40243","Paint, Coatings-Protective, Concrete Restoration, Sealing & Cleaning, Construction & Building Equipment, Hardware Stores, Ladders, Paint Manufacturing Equipment & Supplies, Painters Equipment & Supplies",5,"1 Review",A+,38.24569,-85.54109,,,"Contact us for more information.","Mon - Fri: 8:00 am - 6:00 pm Sat: 8:00 am - 12:00 pm",,,"amex, discover, master card, visa, all major credit cards",,,"http://www.wisebuyingmall.com/lanningpaints http://wisebuyingmall.com http://lanningpaints.com http://lanningpaints.wisebuyingmall.com","Parking: Lot",jane7,05/30/2013,five,"Great place to buy high quality paint from a family owned business. The people are very nice & they can match any color. Much less expensive than buying from other places.",,,,
14586453,1873407,"2020-09-27 05:32:54","El Rancho Foods",,customercare@billmelater.com,"(201) 386-2316","30 Mall Dr W","Jersey City",NJ,07310,"30 Mall Dr W,Jersey City,NJ 07310","Paint Manufacturing Equipment & Supplies, Hardware Stores, Industrial Equipment & Supplies, Paint-Wholesale & Manufacturers",,,,40.72605,-74.03799,https://i3.ypcdn.com/blob/b52d4ab9bdc03c9916853af25ded836c6e379336_100x100_crop.jpg?41e4770,,,"Mon - Sat: 10:00 am - 9:30 pm Sun: 11:00 am - 7:00 pm",,,,,,,,,,,,,,,
14603425,1874670,"2020-09-27 05:33:01","Maple Heights Hardware Supply",http://www.truevalue.com,mhhardwareinc@aol.com,"(216) 662-0300","16460 Broadway Ave","Maple Heights",OH,44137,"16460 Broadway Ave,Maple Heights,OH 44137","Paint Manufacturing Equipment & Supplies, Hardware Stores, Industrial Equipment & Supplies, Industrial, Technical & Trade Schools, Window Cleaning",1,"1 Review",,41.41184,-81.56581,https://i4.ypcdn.com/blob/fd4f6cf96f387f2dc4fd4988eebe59bf1e2044ff_100x100_crop.jpg?41e4770,,,"Mon - Fri: 8:30 am - 6:00 pm Sat: 8:30 am - 5:30 pm",,,"amex, discover, master card, visa",,,"http://www.truevalue.com http://www.truevalue.com/mapleheightshardware http://mapleheightshardware.com",,Workingmom2010,02/09/2012,one,"I had a run of the mill door key made at this store by a young man who was very nice. When I tried to use the key it got stuck in the lock. My father was able to get the key out of the lock by spraying it with wd40 and a lot of patience. I took the key back to get it remade. The person behind the counter insisted that the key was made correctly and was totally rude. He kept trying to tell me that the lock was installed incorrectly. The original key fit perfectly and my father has been installing locks in his properties for over 30 years. Personally, I've installed locks in my properties for at least 10 years. I asked him to just go ahead and remake the key. Heck I even had the lock with me to test it out. The guy insisted that they have been making keys for years and that there was nothing wrong with the key. Anyway, I asked for the manager and he told me that he was the OWNER. I told him that dealing with him (as the owner) was worst than dealing with one of his sales people. I should have been treated better and he should not have acted as though I didn't know how to use a simple key to open a run of the mill lock. I took my business elsewhere and guess what I DID NOT HAVE ANY PROBLEMS WITH THE KEY MADE AT SOUTHGATE LOCK AND KEY. I WILL NEVER EVER SPEND MY HARD EARNED MONEY IN THAT STORE AGAIN. I go out of the way to shop local because I'm also a business owner but this experience was absolutely TERRIBLE!",,,,
14620399,1875955,"2020-09-27 05:33:12","Soltz Paint",http://www.soltzpaint.com,contact@soltzpaint.com,"(609) 463-4563","11 E Shell Bay Ave","Cape May Court House",NJ,08210,"11 E Shell Bay Ave,Cape May Court House,NJ 08210","Paint, Hardware Stores, Interior Designers & Decorators, Ladders, Paint Manufacturing Equipment & Supplies, Painting Contractors",,,,39.06663,-74.8309,,,"At Soltz Paint, we provide expert color consultation services. Our consultant will visit you in the comfort of your home with over 3,000 color options to use in discovering the perfect colors for your next renovation or decorating project. We work with your existing d?cor and will provide you with 4"" x 4"" samples that will allow you to live with your color choices to ensure youВ’ve selected the best colors for your decorating needs. It's critical that our designer gets to see your lighting, style, and existing d?cor when selecting colors and its our in-home service that has made this program such as success. Our consultant can also offer some great advice on faux finishes, wallpaper, window treatments, and custom fabrics.","Mon - Fri: 7:00 am - 5:00 pm Sat: 7:30 am - 1:00 pm",,,,,,http://www.soltzpaint.com,,,,,,,,,
14663823,1879278,"2020-09-27 05:33:36","Harrison Paint Company",http://www.benjaminmoore.com,,"(330) 244-8700","4926 Portage St NW","North Canton",OH,44720,"4926 Portage St NW,North Canton,OH 44720","Paint, Hardware Stores, Home Improvements, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Wallpapers & Wallcoverings",,,,40.87837,-81.43969,,,,"Mon - Fri: 7:30 am - 6:00 pm","Fax: (330) 244-8701 TollFree: (800) 721-5755",,"amex, visa, discover, mastercard",,,http://www.benjaminmoore.com,"Parking: Lot, Private Bike Parking: Yes Wheelchair Accessible: Yes Price Range : Average Pets Allowed: Yes",,,,,,,,
14674058,1880081,"2020-09-27 05:33:38","Glen Rock Paint & Hardware",http://www.roundshardware.com,gene.paolucci@benjaminmoore.com,"(201) 444-1654","200 Rock Rd","Glen Rock",NJ,07452,"200 Rock Rd,Glen Rock,NJ 07452","Paint Manufacturing Equipment & Supplies, Garden Centers, Hardware Stores, Paint",,,,40.96232,-74.13232,,,,,,,"all major credit cards, amex, discover, master card, visa",,"Glen Rock Paint And Hardware","http://www.roundshardware.com http://truevalue.com","Parking: Lot Pets Allowed: Yes By Appointment Only: Yes",,,,,,,,
14692473,1881464,"2020-09-27 05:33:47",Mos,http://mos.com,mos@chorp.com,"(520) 377-0199","250 W Produce Row",Nogales,AZ,85621,"250 W Produce Row,Nogales,AZ 85621","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,31.37989,-110.94047,,,,,,,,,,http://mos.com,,,,,,,,,
14703219,1882296,"2020-09-27 05:33:56","Summit True Value Hardware",http://www.truevalue.com/summittruevalue,truevaluelocations@yahoo.com,"(908) 273-1170","107 Park Ave",Summit,NJ,07901,"107 Park Ave,Summit,NJ 07901","Hardware Stores, Garden Centers, Lawn & Garden Equipment & Supplies, Paint Manufacturing Equipment & Supplies, Painters Equipment & Supplies, Plumbing Fixtures, Parts & Supplies, Tools",,,,40.71336,-74.34967,https://i4.ypcdn.com/blob/fd4f6cf96f387f2dc4fd4988eebe59bf1e2044ff_100x100_crop.jpg?41e4770,,"Your local True Value Hardware store offers the tools, products, and expert advice for all of your project needs. Find the right products to help you complete your weekend projects.","Mon - Sat: 7:00 am - 6:00 pm Sun: 9:00 am - 1:00 pm",,,"mastercard, visa, discover",,,http://www.truevalue.com/summittruevalue,,,,,,,,,
14735951,1884830,"2020-09-27 05:34:05","Cardinal Industrial Finishes",http://www.cardinalpaint.com,kenny@cardinalpaint.com.hk,"(408) 452-8522","890 Commercial St","San Jose",CA,95112,"890 Commercial St,San Jose,CA 95112","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint-Wholesale & Manufacturers",,,,37.36581,-121.8886,,,,,,,"all major credit cards",,,http://www.cardinalpaint.com,,,,,,,,,
14738826,1885034,"2020-09-27 05:34:10","Truckee Paint Mart",http://www.renopaintmart.com,,"(530) 587-7285","10929 Industrial Way",Truckee,CA,96161,"10929 Industrial Way,Truckee,CA 96161","Paint, Hardware Stores, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Spraying Equipment, Wallpapers & Wallcoverings",,,,39.33781,-120.18286,,,,"Mon - Fri: 6:30 am - 6:00 pm Sat: 8:00 am - 4:00 pm","Phone: (775) 826-2900 Phone: (530) 587-7534 Primary Phone: (530) 587-7534 TollFree: (888) 883-7779",,"all major credit cards",,"Reno Paint Mart Inc Reno Paint Mart","http://www.renopaintmart.com https://renopaintmart.com",,,,,,,,,
14748058,1885683,"2020-09-27 05:34:11","Padco Inc",http://www.padco.com,,"(612) 378-7270","2220 Elm St SE",Minneapolis,MN,55414,"2220 Elm St SE,Minneapolis,MN 55414","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,A+,44.98418,-93.22024,,,,"Mon - Fri: 7:30 am - 4:30 pm","Phone: (612) 378-9388 TollFree: (800) 328-5513",,"all major credit cards, amex, master card, visa",,,http://www.padco.com,,,,,,,,,
14758777,1886480,"2020-09-27 05:34:15",Carboline,http://carboline.com,,"(734) 525-2824","32820 Capitol St",Livonia,MI,48150,"32820 Capitol St,Livonia,MI 48150","Paint Manufacturing Equipment & Supplies, Coatings-Protective, Hardware Stores, Paint",,,,42.37353,-83.3661,,,,,,,"all major credit cards",,"Carboline Co.",http://carboline.com,,,,,,,,,
14763250,1886823,"2020-09-27 05:34:15","DMI Home Supply",http://www.dmihomesupply.com,info@dmihomesupply.com,"(610) 649-9595","2541 Haverford Rd",Ardmore,PA,19003,"2541 Haverford Rd,Ardmore,PA 19003","Builders Hardware, Building Materials, Hardware Stores, Home Centers, Lawn & Garden Equipment & Supplies, Lumber, Paint, Paint Manufacturing Equipment & Supplies, Party Planning, Party Supply Rental, Plumbing Fixtures, Parts & Supplies, Tents-Rental, Tool Rental, Tools, Wood Products",,,A+,39.9956,-75.30044,https://i3.ypcdn.com/blob/fd4f6cf96f387f2dc4fd4988eebe59bf1e2044ff_100x100_crop.jpg?d9a04b5,,"Since 1982, DMI's staff of career professionals has focused on prompt personalized service. Family owned and operated, DMI has grown over the past three decades to over 20,000 square feet of retail space. We offer the old time shopping experience which simply cannot be found in the big chain stores. We are large enough to satisfy all your home repair needs, yet small enough to care. With our rental division, we have the tools, supplies, and knowledge to help you with any project from a leaky faucet to a new addition. * Party Rentals * Lumber * Paint * Hardware * Locks * Batteries * Mailboxes * Doorknobs & Handle sets * Structural Hardware * Cabinet Hardware * Nuts * Bolts * Screws * Fasteners * Lawn & Garden Rentals * Party Rentals * Chairs * Tables * Moon Bounce * Tents Construction * Construction Rental * Generators * Pneumatic Tools * Painting * Power Washing * Heating & Ventilation * Floor Care * Plumbing Weber Grills","Mon - Sat: 7:30 am - 6:00 pm Sun: 10:00 am - 3:00 pm",,,"check, debit, cash, all major credit cards",,,http://www.dmihomesupply.com,,,,,,,,,
14767600,1887161,"2020-09-27 05:34:19","TJ Moore Lumber Yard",http://www.acehardware.com,acesm@sbcglobal.net,"(830) 261-4617","2400 E Main St",Uvalde,TX,78801,"2400 E Main St,Uvalde,TX 78801","Hardware Stores, Building Materials, Construction & Building Equipment, Doors, Frames, & Accessories, Home Centers, Lumber, Paint, Paint Manufacturing Equipment & Supplies, Plumbing Fixtures, Parts & Supplies, Wood Products",,,,29.22374,-99.7632,,"THE HELPFUL PLACE","WEBER * CRAFTSMAN * CLARK + KENSINGTON * DeWALT * SCOTTS * BLACK & DECKER * WERNER * RUBBERMAID * MOEN * KOHLER Helpful articles * how-tos * videos & more Ace Rewards * Free Shipping * Product Rebates * Shop Online * Facebook * Twitter * Youtube","Mon - Fri: 7:30 am - 6:00 pm Sat: 8:00 am - 5:00 pm",,,"mastercard, amex, company card, debit, discover, travelers checks, visa",,,"http://www.acehardware.com http://tjmoorelumber.com",,,,,,,,,
14771534,1887445,"2020-09-27 05:34:19","Faurecia Automotive Seating",http://www.faurecia.com,,"(662) 846-5252","907 Delta Council Dr",Cleveland,MS,38732,"907 Delta Council Dr,Cleveland,MS 38732","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint-Wholesale & Manufacturers",1,"1 Review",,33.76009,-90.70431,,,"Faurecia Automotive Seating is a part of Faurecia, which is one of the leading providers of automobile engineering solutions and related components in the world. The company offers interior equipment , vehicle seating products and exhaust systems. It works with a team of more than 60,000 staff members. The company maintains over 190 manufacturing sites and nearly 25 research and development centers in approximately 25 countries. It serves clients in the automotive market. The company designs, engineers and produces a range of central consoles and instrument and door panels. It also offers online services for its customers. Faurecia s customers include Ford Motor Company, Honda Motor Company, Toyota Motor Corporation and Nissan Motor Company.",,"Phone: (662) 846-5792 Phone: (662) 846-1852 Primary Phone: (662) 846-1852 Fax: (662) 846-1286",,,,,"http://www.faurecia.com https://www.faurecia.com/en http://www.faurecia.com/en",,yatish65,09/21/2010,one,"To whom it may concern, Faurcia has invited me for programming position in Cleveland Mississippi. During the interview they asked me to fix their long variable program. I spent about an hour to fix their program and few hours for city tour with QC Supervisor. Because of horrible place to work I did reject their telephone offer. Initially they promised me to reimburse total travel expenses. I have waited for more than three months then I have contacted VP, CEO and HR manager about this kind of Unprofessionalism through emails but no one bothered to contact me for my travel expenses.",,,,
14773680,1887595,"2020-09-27 05:34:19","3b Hardware Supply",,,"(806) 892-2626","103 W 10th St",Idalou,TX,79329,"103 W 10th St,Idalou,TX 79329","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,33.65823,-101.68052,,,,,,,,,,,,,,,,,,,
14778378,1887915,"2020-09-27 05:34:19","Trio Paint",,Triopaint.john@yahoo.com,"(810) 742-5491","G4172 S Saginaw St",Burton,MI,48529,"G4172 S Saginaw St,Burton,MI 48529","Paint, Blinds-Venetian, Vertical, Etc-Repair & Cleaning, Hardware Stores, Home Improvements, Linoleum, Paint Manufacturing Equipment & Supplies, Painters Equipment & Supplies, Wallpapers & Wallcoverings",,,,42.96961,-83.67246,,,"Have you been considering a facelift for your home? A fresh paint job or stain renewal may just be the thing. Trio Paint is a retail paint store located in the Burton & Davison, MI area. We have an extensive paint selection to meet the needs of homeowners and paint contractors alike. Browse our assortment of interior and exterior paint, along with a variety of interior and exterior stains to find a product for any job. Whether you're doing it yourself or having someone else do it for you, our experts are here to help. EXPERIENCE YOU CAN TRUST Trio Paint is a locally owned and operated company dedicated to providing the highest quality paint selection to homeowners and contractors in the Burton & Davison, MI area. We've served the community for over 50 years, and Trio Paint looks forward to continuing to be your local hometown expert for all of your painting needs in the years to come. You can count on us to provide expert assistance in your search for the right products for your next job. Rely on us for: Interior Paint Exterior Paint Deck Stain Interior Stain Stain Matching Paint Matching Window Coverings Floor Coverings Get started on your next paint or stain project! Contact Trio Paint in the Burton & Davison, MI area, for more information about our productsВ—or for paint adviceВ—by calling 810-742-5491 today.","Mon - Sat: 9:00 am - 6:00 pm","Phone: (810) 736-2230",,"discover, master card, visa, amex, all major credit cards, mastercard",,,,,,,,,,,,
14786119,1888496,"2020-09-27 05:34:21","Pioneer Paint",http://www.pioneerpaintcompany.com,john@pioneerpaintcompany.com,"(661) 322-3514","4620 Easton Dr",Bakersfield,CA,93309,"4620 Easton Dr,Bakersfield,CA 93309","Hardware Stores, Chemicals, Construction & Building Equipment, Contractors Equipment & Supplies, Paint, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Painters Equipment & Supplies, Spraying Equipment",,,A+,35.36885,-119.05427,,,"Bionet Esthetics is a manufacturer and wholesaler of esthetic products and supplies. The company offers SkinTherapeutic medical grade skin care products and Specialty Compounding chemical acid peeling agents. Founded in 2001, it distributes body care products for individuals. Bionet Esthetics provides a variety of esthetician equipment and furniture. The company offers a range of lactic, glycolic, blended and salicylic acid peels. It provides products for problems related to hyperpigmentation. Bionet Esthetics assists patients and clients with postoperation healing and rehabilitation services. It also offers products that reduce appearance of fine lines and regulates sebaceous gland activities. The company provides private labeling services. Bionet Esthetics additionally offers cellular turnover and acne treatments.","Mon - Fri: 7:00 am - 5:00 pm Sat: 8:00 am - 1:00 pm",,,,,,http://www.pioneerpaintcompany.com,"Parking: Lot",,,,,,,,
14797348,1889349,"2020-09-27 05:34:23","Miami Home Centers True Value Hardware & Benjamin Moore Paint",http://miamihomecenters.com,info@miamihomecenters.com,"(305) 531-0836","545 Arthur Godfrey Rd","Miami Beach",FL,33140,"545 Arthur Godfrey Rd,Miami Beach,FL 33140","Hardware Stores, Building Materials, Lawn & Garden Equipment & Supplies, Paint, Paint Manufacturing Equipment & Supplies, Painters Equipment & Supplies, Painting Contractors-Commercial & Industrial",,,,25.81414,-80.13018,https://i3.ypcdn.com/blob/fd4f6cf96f387f2dc4fd4988eebe59bf1e2044ff_100x100_crop.jpg?d9a04b5,"Our service and selection makes a difference","Local Home Improvement store, specializing in Benjamin Moore Paints, True Value Hardware distributor, and Kitchen and Batch Remodeler.","Mon - Fri: 7:30 am - 6:00 pm Sat: 8:30 am - 5:00 pm Sun: 9:00 am - 4:00 pm",,,"jcb, diners club, all major credit cards",,,http://miamihomecenters.com,,,,,,,,,
14798446,1889430,"2020-09-27 05:34:23","Dunn-Edwards Paints",http://www.dunnedwards.com,,"(619) 222-0591","3191 Sports Arena Blvd","San Diego",CA,92110,"3191 Sports Arena Blvd,San Diego,CA 92110","Paint Manufacturing Equipment & Supplies, Hardware Stores, Paint, Paint-Wholesale & Manufacturers",,,,32.7518,-117.20703,https://i3.ypcdn.com/blob/d8740eacf0cff6e4f71867a0c5c1d58d13b79a3c_100x100_crop.jpg?d9a04b5,,,"Mon - Sat: 6:30 am - 5:00 pm Sun: 10:00 am - 3:00 pm","Phone: (619) 222-0012 Primary Phone: (619) 222-0012 TollFree: (888) 337-2468",,"visa, discover, mastercard, insurance, amex",,"Dunn-Edwards Paints - San Diego","http://www.dunnedwards.com https://www.dunnedwards.com/directory/store-list/san-diego-010",,,,,,,,,
14815356,1890671,"2020-09-27 05:34:26","Lansdowne Paint & Hardware",,,"(410) 247-0460","1949 Lansdowne Rd",Halethorpe,MD,21227,"1949 Lansdowne Rd,Halethorpe,MD 21227","Paint, Hardware Stores, Paint Manufacturing Equipment & Supplies",,,,39.25191,-76.66535,https://i4.ypcdn.com/blob/c5fe051f8fd16834ed313f97a01cba9147a306f0_100x100_crop.jpg?41e4770,,,"Mon - Fri: 8:00 am - 4:00 pm Sat - Sun Closed","Phone: (410) 536-9247",,,,,,"Parking: Lot",,,,,,,,
14838706,1892383,"2020-09-27 05:34:30","Micromatic Spring",http://www.micromaticspring.com,info@micromaticspring.com,"(630) 607-0141","45 N Church St",Addison,IL,60101,"45 N Church St,Addison,IL 60101","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,41.9287,-87.99022,https://i4.ypcdn.com/blob/274b90119582814a1971a7ed5403eb779d554347_100x100_crop.jpg?41e4770,,,,"Phone: (630) 607-0140 Phone: (847) 671-3452 Phone: (847) 671-6600 Primary Phone: (847) 671-6600 Primary Phone: (630) 607-0140",,,,"Micromatic Spring & Stamping Micromatic Spring & Stamping Co., Inc.",http://www.micromaticspring.com,,,,,,,,,
14872384,1894907,"2020-09-27 05:34:35",Patchington,http://www.patchington.com,stuart@patchington.com,"(772) 286-3748","3762 SE Ocean Blvd",Stuart,FL,34996,"3762 SE Ocean Blvd,Stuart,FL 34996","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,27.20286,-80.20084,,,,"Mon - Sat: 9:30 am - 5:30 pm Sun: 11:00 am - 4:00 pm","TollFree: (800) 771-2200",,"master card, visa, paypal, amex, discover",,,"http://www.patchington.com https://www.patchington.com",,,,,,,,,
14899251,1896901,"2020-09-27 05:34:46","Ennis Paint Inc",,,"(661) 328-0503","201 Union Ave",Bakersfield,CA,93307,"201 Union Ave,Bakersfield,CA 93307","Paint Manufacturing Equipment & Supplies, Hardware Stores",,,,35.35742,-119.00326,,,,,,,,,,,,,,,,,,,
14909227,1897638,"2020-09-27 05:34:56","Andy's Automotive Paint & Supplies",,AndysPaint@SBCglobal.net,"(559) 625-1662","2424 E Main St",Visalia,CA,93292,"2424 E Main St,Visalia,CA 93292","Automobile Body Shop Equipment & Supplies, Auto Repair & Service, Automobile Body Repairing & Painting, Automobile Body Shop Equipment & Supply-Wholesale & Manufacturers, Automobile Repairing & Service-Equipment & Supplies, Construction & Building Equipment, Contractors Equipment & Supplies, Faux Painting & Finishing, Hardware Stores, Paint, Paint Manufacturing Equipment & Supplies, Painters Equipment & Supplies, Painting Contractors",,,A+,36.32995,-119.26697,,"Complete Line of Painting Equipment and Supplies,All Under one Roof. Great Prices,","Aotomotive Paint Supply Store","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed","TollFree: (800) 400-5900",,"debit, check, cash, all major credit cards",,"Andy's Automotive Paint & Supply Inc.",,"Services: Faux Finishes",,,,,,,,
15964857,2004422,"2020-09-27 05:45:28",Sherwin-Williams,http://www.sherwin-williams.com,yourname@address.com,"(217) 544-9835","1730 S 6th St",Springfield,IL,62703,"1730 S 6th St,Springfield,IL 62703","Paint, Automobile Body Shop Equipment & Supplies, Interior Designers & Decorators, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Painters Equipment & Supplies, Painting Contractors, Spraying Equipment, Spraying Equipment-Renting, Wall Coatings, Wallpapers & Wallcoverings, Wallpapers & Wallcoverings-Installation",,,,39.78301,-89.64795,https://i1.ypcdn.com/blob/7bfc0efd632821fef79dec4e7480e3d83ab68e83_100x100_crop.jpg?f832250,,"Sherwin-Williams Paint Store of Springfield, IL has exceptional quality paint supplies, wallpaper, stains and sealer to bring your ideas to life. Painting Questions? Ask Sherwin-Williams.","Mon - Fri: 7:00 am - 7:00 pm Sat: 8:00 am - 6:00 pm Sun: 10:00 am - 6:00 pm","Phone: (217) 544-3219 Fax: (217) 544-3219",,"amex, cash, check, debit, discover, master card, visa, company card, diners club",,"Sherwin-Williams Paint Store",http://www.sherwin-williams.com,,,,,,,,,
15964875,2004426,"2020-09-27 05:45:28","Sherwin-Williams Paint Store - Stillwater",http://www.sherwin-williams.com,,"(651) 430-2351","14450 60th St N",Stillwater,MN,55082,"14450 60th St N,Stillwater,MN 55082","Paint, Automobile Body Shop Equipment & Supplies, Home Improvements, Interior Designers & Decorators, Paint Manufacturing Equipment & Supplies, Paint-Wholesale & Manufacturers, Painters Equipment & Supplies, Painting Contractors, Spray Painting & Finishing, Spraying Equipment, Spraying Equipment-Renting, Wall Coatings, Wallpapers & Wallcoverings, Wallpapers & Wallcoverings-Installation",,,,45.0366,-92.81375,https://i1.ypcdn.com/blob/7bfc0efd632821fef79dec4e7480e3d83ab68e83_100x100_crop.jpg?f832250,,"Sherwin-Williams Paint Store of Stillwater, MN has exceptional quality paint supplies, wallpaper, stains and sealer to bring your ideas to life. Painting Questions? Ask Sherwin-Williams.","Mon - Fri: 7:00 am - 7:00 pm Sat: 8:00 am - 6:00 pm Sun: 10:00 am - 6:00 pm",,,"discover, debit, visa, check, cash, amex, master card, all major credit cards",,,"http://www.sherwin-williams.com Web Site http://www.sherwin-williams.com/store-locator/paint-store/Stillwater/MN/3051","Price Range : Average Bike Parking: Yes",,,,,,,,