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
313548,103994,"2020-09-27 02:40:11","Little Giant Pool & Spa",http://www.littlegiantpool.com,lgps@earthlink.net,"(636) 271-2200","120 N Olive St",Pacific,MO,63069,"120 N Olive St,Pacific,MO 63069","Swimming Pool Dealers, Bus Lines, General Contractors, Spas & Hot Tubs, Spas & Hot Tubs-Repair & Service, Swimming Pool Construction, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,A+,38.48255,-90.73803,https://i2.ypcdn.com/blob/0da1e1f2bf1d156df8d9fd4c2a6d80c292481fc6_100x100_crop.jpg?f9d23e1,,"*Serving Missouri & Illinois Since 1986","Mon - Fri: 8:00 am - 5:00 pm",,,"discover, amex",,,"http://www.littlegiantpool.com http://littlegiantpool.net","Specialties: Customized, Individualized Services: Construction Services General Contracting",,,,,,,,
328965,108942,"2020-09-27 02:40:40","Spence Chemical Supply Co",http://www.spencesupplyco.com,,"(352) 372-2186","2332 NE 17th Ter",Gainesville,FL,32609,"2332 NE 17th Ter,Gainesville,FL 32609","Janitors Equipment & Supplies, Paper Manufacturers, Paper Products, Paper-Wholesale & Manufacturers, Swimming Pool Equipment & Supplies, Vacuum Cleaners-Industrial & Commercial, Vacuum Equipment & Systems",,,,29.67481,-82.30337,,,,"Mon - Fri: 8:00 am - 5:00 pm",,,"mastercard, visa, discover",,"Spence Supply Co",http://www.spencesupplyco.com,,,,,,,,,
331943,109766,"2020-09-27 02:40:50","Chemical Service & Supplies",,,"(419) 625-6006","1000 Maple Ave",Sandusky,OH,44870,"1000 Maple Ave,Sandusky,OH 44870","Paper Products, Chemicals-Wholesale & Manufacturers, Cleaners Supplies, Cleaning Compounds, Cleaning Contractors, Ice Melting Equipment & Supplies, Janitorial Service, Janitors Equipment & Supplies, Janitors Equipment & Supplies-Wholesale & Manufacturers, Paper Manufacturers, Swimming Pool Equipment & Supplies",,,,41.44623,-82.71341,,,,"Mon - Fri: 8:00 am - 5:00 pm",,,"all major credit cards, amex, visa, mastercard",,,,"Specialties: Swimming Pools, Laundry",,,,,,,,
338559,111683,"2020-09-27 02:40:59","Ray Criswell Distributing Co",http://www.criswellclary.com,criswell@suddenlink.com,"(979) 822-4431","2201 S College Ave",Bryan,TX,77801,"2201 S College Ave,Bryan,TX 77801","Janitors Equipment & Supplies-Wholesale & Manufacturers, Paper Manufacturers, Paper Products-Wholesale & Manufacturers, Swimming Pool Equipment & Supplies",,,,30.64848,-96.3647,,,"Ray Criswell Distributing Company has served the people of Brazos Valley since 1946. A born salesman, Ray Criswell began his career selling from the trunk of his automobile while attending Texas A&M.For sixty years, Ray Criswell Distributing Company Has been one of the leading independent businesses in the Bryan/College Station area. Our goal is to continue to provide the same quality merchandise and exceptional customer service to which you have become accustomed over these sixty years.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed","Fax: (979) 822-2332",,,,,http://www.criswellclary.com,,,,,,,,,
339034,111834,"2020-09-27 02:40:59","Razorback Janitors Supply",,,"(870) 535-3696","621 E 5th Ave","Pine Bluff",AR,71601,"621 E 5th Ave,Pine Bluff,AR 71601","Janitors Equipment & Supplies, Paper Manufacturers, Paper Products, Swimming Pool Equipment & Supplies",,,,34.22506,-91.99761,,,,,,,,,,,,,,,,,,,
343953,113292,"2020-09-27 02:41:10",Blankenstein's,http://blankensteins.com,,"(601) 445-5618","503 N Broadway St",Natchez,MS,39120,"503 N Broadway St,Natchez,MS 39120","Swimming Pool Repair & Service, Building Specialties, Food Processing Equipment & Supplies, Ice Making Equipment & Machines, Janitors Equipment & Supplies, Paper Manufacturers, Paper Products, Restaurant Equipment & Supplies, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Water Filtration & Purification Equipment, Water Softening & Conditioning Equipment & Service",,,,31.56448,-91.40375,,"Blankenstein's - a home-town store with big store benefits!",,"Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"all major credit cards, discover",,"Blankenstein's Supplies & Equipment",http://blankensteins.com,"Parking: Free Wheelchair Accessible: Yes",,,,,,,,
352925,116002,"2020-09-27 02:41:29","Chastain Janitorial Supply Co",http://www.chastainjanitorial.com,support@chastainjanitorial.com,"(770) 536-0902","1630 Martin Luther King Jr Blvd",Gainesville,GA,30501,"1630 Martin Luther King Jr Blvd,Gainesville,GA 30501","Paper Products, Carpet & Rug Cleaning Equipment & Supplies, Chemical Cleaning-Industrial, Cleaning Contractors, Floor Machines, Floor Machines-Renting, Hardware Stores, Industrial Cleaning, Janitorial Service, Janitors Equipment & Supplies, Paper Manufacturers, Swimming Pool Equipment & Supplies",,,,34.29136,-83.81801,,,,"Mon - Fri: 8:00 am - 5:30 pm Sat: 8:00 am - 12:30 pm",,,,,,http://www.chastainjanitorial.com,"Specialties: Floors Services: Industrial Cleaning",,,,,,,,
352967,116013,"2020-09-27 02:41:29","SOWEGA Chemical Janitorial & Pool Supply Co",,,"(229) 432-7100","918 W Broad Ave",Albany,GA,31701,"918 W Broad Ave,Albany,GA 31701","Janitors Equipment & Supplies, Chemical Plant Equipment & Supplies, Chemicals, Industrial Equipment & Supplies, Paper Manufacturers, Paper Products, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,31.57641,-84.17167,,,,,"Phone: (229) 942-5669",,,,,,,,,,,,,,
354461,116472,"2020-09-27 02:41:29","Seminole Chemical & Supplies",http://catalog.seminolechemical.com/,todd@robinsonsaltsupply.com,"(800) 278-3784","1825 N Harvey Rd",Seminole,OK,74868,"1825 N Harvey Rd,Seminole,OK 74868","Paper Products, Chemical Cleaning-Industrial, Cleaning Contractors, Industrial Cleaning, Janitors Equipment & Supplies, Paper Manufacturers, Swimming Pool Equipment & Supplies",,,A+,35.23923,-96.65429,,,,"Mon - Fri: 8:00 am - 5:00 pm","Phone: (405) 382-3784",,"amex, master card, visa",,"Seminole Chemical & Supplies Inc","http://catalog.seminolechemical.com http://seminolechemical.com",,,,,,,,,
355783,116904,"2020-09-27 02:41:29","Dibs Chemical & Supply Co Inc",http://dibspoolandspa.com/BYP01/1002/49/index.aspx,michael@dibspoolandspa.com,"(228) 284-4563","542 Pass Rd",Gulfport,MS,39507,"542 Pass Rd,Gulfport,MS 39507","Bar Fixtures & Supplies, Chemicals, Chlorine, Janitors Equipment & Supplies, Paper Manufacturers, Paper Products, Swimming Pool Equipment & Supplies","3,5","3 Reviews",,30.38958,-89.06055,,,"Contact us for more information.","Mon - Fri: 9:00 am - 5:00 pm Sat: 9:00 am - 1:00 pm Sun Closed",,,"visa, mastercard, check",,,"http://dibspoolandspa.com/BYP01/1002/49/index.aspx http://www.dibssupply.com","Parking: Lot Specialties: Swimming Pools","Shannon H.",11/14/2019,five,"Very knowledgeable and a ton of different products for whatever service you have that needs chemicals.","Darren A.",03/22/2013,five,
465940,160193,"2020-09-27 02:45:54","Shark Attack Serivces",,,"(214) 934-4633","303 Sycamore St","Lake Dallas",TX,75065,"303 Sycamore St,Lake Dallas,TX 75065","Audio-Visual Creative Services, Small Appliance Repair, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,33.12052,-97.02593,,,,,,,,,,,,,,,,,,,
979006,318015,"2020-09-27 03:01:44","Southern Stone",http://www.southernnaturalstone.com,,"(800) 408-5979","1100 E Expressway 83",Donna,TX,78537,"1100 E Expressway 83,Donna,TX 78537","Masonry Equipment & Supplies, Building Materials, Landscaping Equipment & Supplies, Stone Natural, Swimming Pool Equipment & Supplies",5,"3 Reviews",A+,26.1817,-98.04995,,"Moving Mountains!","Discover the possibilities of natural stone - with applications ranging from home and commercial construction using thin stone veneer or building stone to stone pool decks, flagstone patios, and landscape materials. Come and see how Southern Stone can help with your stone project. With such a huge selection (we have over 2 ACRES of stone, with over 1200 pallets in stock and ready to deliver), we're bound to have the exact natural, manufactured or paver stone - in stock. We also have a large display area with installed samples of manufactured, natural stone veneer and building stone. This takes the extra risk and guess-work out of choosing. You actually get to see stone walls, flagstone and paver walkways, gardens, outdoor stone furniture, stone arches, stone columns, and more. If you aren't near us in Donna, Texas, don't worry. We can send you samples and arrange delivery. We have many customers we've never met, but will never forget!","Mon - Fri: 8:00 am - 5:00 pm Sat: 10:00 am - 2:00 pm Sun Closed","Phone: (956) 464-5979 Fax: (866) 520-7609",,"all major credit cards, check",,,"Primary Website","Wheelchair Accessible: Yes Specialties: Decks & Patios",valley956,04/10/2008,five,"I would like to point out that it's not every day you find a business much less a company willing to help you out and keep you well informed on your purchase. I have worked in the valley for years and am happily relieved to find Southern Stone. Their ability to be in constant contact with me not only helped me concentrate on other aspects of my business but left me with a feeling of assurance that my purchase was not in vain. I highly would suggest Southern Stone for their ability to assist commercial customers such as myself, but also not forget the very important retail customers, which keep their business growing and mine as well. Thanks.",flower3,04/10/2008,five,"I would like to start by saying that I appreciate the customer service provided by Southern Stone. It wasn't easy for me to choose a stone once I got there, but they assisted with great detail on the cost of the stone, colors of stone, and how it's sold. Since I don't know much about stone I appreciated it very much. I now have a beautiful backyard thanks to Southern Stone!"
988313,320171,"2020-09-27 03:01:53","Fujiwa Tile",http://www.fujiwatiles.com,pts@fujiwatiles.com,"(818) 994-2439","7732 Burnet Ave","Van Nuys",CA,91405,"7732 Burnet Ave,Van Nuys,CA 91405","Tile-Wholesale & Manufacturers, Floor Materials, Granite, Swimming Pool Equipment & Supplies, Tile-Contractors & Dealers",,,,34.21091,-118.46288,https://i1.ypcdn.com/blob/054db2d7ea48834b75e98416c472ba1e5ce08cfb_100x100_crop.jpg?8ad0f92,,"Importer and national Wholesale Distributor of high quality tile and granite coping along with decking for swimming pool, spa and outdoor construction as well as renovations.","Mon - Fri: 7:30 am - 4:30 pm Sat: 8:00 am - 1:00 pm","Fax: (818) 994-0547",,cash,,"Fujiwa Group","http://www.fujiwatiles.com https://www.fujiwatiles.com",,,,,,,,,
990615,320705,"2020-09-27 03:01:53","Gartex Masonry Supply Inc",http://gartexmasonry.com,sales@gartexmasonry.com,"(214) 343-0571","10310 Plano Rd",Dallas,TX,75238,"10310 Plano Rd,Dallas,TX 75238","Masonry Equipment & Supplies, Brick-Clay-Common & Face, Building Contractors, Building Materials, Engraving, Fireplace Equipment, Fireplaces, Heating Equipment & Systems, Masonry Contractors, Paving Contractors, Paving Materials, Pet Stores, Signs, Stone Cast, Stone Natural, Stone Products, Swimming Pool Equipment & Supplies",5,"1 Review",A+,32.88951,-96.69976,,,,,,,"visa, discover, mastercard",,,http://gartexmasonry.com,,ohdoorman,03/15/2012,five,"Very helpful, Quick service",,,,
1000895,323161,"2020-09-27 03:02:10","Green Rebecca",,jerrygreenconcrete@yahoo.com,"(828) 926-1719","76 Morning Dew Dr","Maggie Valley",NC,28751,"76 Morning Dew Dr,Maggie Valley,NC 28751","Sand & Gravel, Building Contractors, Building Specialties, Concrete Contractors, Concrete Equipment & Supplies, Crushed Stone, Foundation Contractors, Masonry Contractors, Stone Natural, Stone Products, Stone-Retail, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,35.52888,-83.08567,,,"Concrete Foundations, Bar-b-que Grills, Greenhouses, Sun rooms Concrete Sawing, Breakout, Concrete Hauling, Swimming Pool Repair, Cutting, Concrete Restoration, Concrete Sealing, FULLY LICENSED & INSURED, OVER 40 YEARS OF EXPERIENCE IN DEMOLITION, CONCRETE PUMPING, BREAKING, CUTTING & SAWING, BLOCK FILL, BASEMENT WALLS, concrete Staining, Concrete",,,,"cash, check, master card, visa",,,,,,,,,,,,
1025221,329021,"2020-09-27 03:02:46","Queen City Stone",http://www.queencitystone.com,parlastone@gmail.com,"(704) 837-7869","2503 Distribution street",Charlotte,NC,28203,"2503 Distribution street,Charlotte,NC 28203","Tile-Wholesale & Manufacturers, Bathroom Remodeling, Kitchen Planning & Remodeling Service, Landscaping Equipment & Supplies, Marble-Natural-Wholesale & Manufacturers, Patio Builders, Stone Natural, Stone Natural-Wholesale & Manufacturers, Stone Products, Stone-Retail, Swimming Pool Equipment & Supplies, Tile-Cleaning, Refinishing & Sealing, Tile-Contractors & Dealers",,,,35.2055,-80.86705,https://i1.ypcdn.com/blob/b854b7dfd4122b3399253ccd8cd97d93809d39be_100x100_crop.jpg?f9d23e1,"Luxurious lifestyle, wholesale prices","Formerly Parla Stone, we have been serving the Charlotte and surrounding areas for over a decade. Our business model is very unique in that we have a boutique style showroom and warehouse in the heart of thriving SouthEnd yet our prices are that of a wholesaler. Two like-minded business partners who share a passion for building materials and construction run the operation. Thus, you as a consumer work directly with an owner rather than just an employee. We're a turn key tile shop meaning that we offer complimentary design services and provide some of the fastest and cleanest installations. Our specialties are natural stone tile, porcelain tile, ceramic tile, natural stone patio paver stones, pool deck paver stones, driveway paver stones, kitchen and bath remodels, floor coverings, and stack stones. We offer free estimates and look forward to working with you in order to turn your dream project into a reality!","Mon - Fri: 9:00 am - 5:00 pm Sat: 10:00 am - 3:00 pm",,,"discover, mastercard, visa, all major credit cards, check, amex",,,http://www.queencitystone.com,,,,,,,,,
1026937,329441,"2020-09-27 03:02:46","Long Island Marble Dusting",http://longislanddust.com,longislanddust@aol.com,"(631) 923-3332","680 E Jericho Tpke","Huntington Station",NY,11746,"680 E Jericho Tpke,Huntington Station,NY 11746","Marble & Terrazzo Cleaning & Service, Masonry Contractors, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,40.83405,-73.38409,,"Long Island Marble Dusting Provides Marble Dusting, Gunite Pool Renovation, Gunite Pool Coping, Gunite Pool Tile & Pool Patios To The Huntington Station, NY Area.",,"Mon - Fri: 9:00 am - 3:00 pm","Primary Phone: (631) 923-3332 Phone: (631) 351-1088",,"amex, discover, master card, visa, cash",,"Long Island Marine Co Long Island Marine Co Inc",http://longislanddust.com,,,,,,,,,
1130337,354739,"2020-09-27 03:05:16","Ajax Supply",http://www.ajaxsupply.com,support@ajaxsupply.com,"(970) 429-4329","0016 Kearns Rd","Snowmass Village",CO,81615,"0016 Kearns Rd,Snowmass Village,CO 81615","Hardware Stores, Battery Supplies, Brooms, Builders Hardware, Fax Service, Keys, Lighting Systems & Equipment, Notaries Public, Office Equipment & Supplies, Paint, Shipping Services, Stationery Stores, Swimming Pool Equipment & Supplies, Variety Stores",,,,39.2114,-106.94548,https://i1.ypcdn.com/blob/0f655dda642b23ce8bf06c349dccebd4f120aad0_100x100_crop.jpg?f9d23e1,,,"Mon - Sun: 9:00 am - 6:00 pm",,,"all major credit cards",,,http://www.ajaxsupply.com,,,,,,,,,
1213875,390406,"2020-09-27 03:08:59","Al's Water Service",http://www.alswaterservices.com,alswater@comcast.net,"(724) 222-9059","2699 Jefferson Ave",Washington,PA,15301,"2699 Jefferson Ave,Washington,PA 15301","Water Companies-Bottled, Bulk, Etc, Air Conditioning Equipment & Systems-Wholesale & Manufacturers, Business Coaches & Consultants, Demolition Contractors, Drilling & Boring Contractors, Excavation Contractors, Filters-Air & Gas, Fire & Water Damage Restoration, Freight Brokers, Grading Contractors, Oil & Gas Exploration & Development, Oil Field Service, Oil Well Drilling, Physicians & Surgeons, Physicians & Surgeons, Urology, Professional Organizations, Rubbish & Garbage Removal & Containers, Swimming Pool Equipment & Supplies, Swimming Pool Water Delivery, Transportation Consultants, Trucking, Trucking-Heavy Hauling, Trucking-Liquid Or Dry Bulk, Utility Companies, Water Consultants, Water Coolers, Fountains & Filters, Water Dealers, Water Softening & Conditioning Equipment & Service, Water Treatment Equipment-Service & Supplies, Water Well Drilling & Pump Contractors",,,A+,40.19692,-80.30062,,"Please Click the More Info button below for Detailed Information.","Al's Water Service offers water for pools and cisterns. We also provide well service, water well drilling, and excavation services. We have a large fleet of trucks available for delivery services. We also offer premium roaring spring bottled water. Emergency Services are available. Call us today for more information.","Mon - Sun: Open 24 Hours","Fax: (724) 222-9180",,"discover, visa, debit, mastercard",,,http://www.alswaterservices.com,"Specialties: Swimming Pools, Tanks, Water",,,,,,,,
1244250,399117,"2020-09-27 03:09:22","Flannery's Drop Box Service, Inc.",http://www.angieslist.com/companylist/us/or/fairview/flannery%27s-drop-box-service-inc-reviews-286639.htm,scottbarbach@ortrash.com,"(503) 669-8002","2430 NW Marine Dr",Troutdale,OR,97060,"2430 NW Marine Dr,Troutdale,OR 97060","Rubbish & Garbage Removal & Containers, Architects & Builders Services, Architectural Support Services, Building Contractors, Building Specialties, Children's Instructional Play Programs, Concrete Contractors, Construction Site-Clean-Up, Contractors Equipment & Supplies, Educational Services, Foundation Contractors, Garbage & Rubbish Removal Contractors Equipment, Garbage Collection, General Contractors, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Masonry Contractors, Patio Builders, Recycling Equipment & Services, Spas & Hot Tubs, Stone Cutting, Stoneware, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Tutoring, Waste Recycling & Disposal Service & Equipment, Youth Organizations & Centers",,,,45.547,-122.41123,https://i2.ypcdn.com/blob/838ac99ecbe2bc82e16351e51071c73b89dbe59b_100x100_crop.jpg?f9d23e1,,"Whether your project is residential, commercial or industrial, we can help you find the perfect option to stay within budget and eliminate the hassles of material disposal. In addition to receiving the fastest same-day service around, you can also take advantage of our exclusive additional disposal discounts for composition roofing.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"amex, check, discover, master card, visa, cash, debit, diners club",,,http://www.angieslist.com/companylist/us/or/fairview/flannery%27s-drop-box-service-inc-reviews-286639.htm,,,,,,,,,
1273630,407766,"2020-09-27 03:09:57","Clayton & Lambert Manufacturing Corporation",http://www.claytonlambert.com,info@claytonlambert.com,"(502) 222-1411","3813 W Highway 146","La Grange",KY,40031,"3813 W Highway 146,La Grange,KY 40031","Swimming Pool Manufacturers & Distributors, Barn Equipment, Bins & Hoppers, Contract Manufacturing, Metal Cutting, Metal Tanks, Roofing Equipment & Supply-Wholesale & Manufacturers, Sheds, Sheet Metal Fabricators, Sheet Metal Work-Manufacturers, Steel Fabricators, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers, Welders",,,,38.38568,-85.432,https://i3.ypcdn.com/blob/712df0e6f44595743524a3e858280239488d7e77_100x100_crop.jpg?63f80dd,,,"Mon - Fri: 7:30 am - 4:30 pm","TollFree: (800) 626-5819 TollFree: (800) 626-5819",,,,"Clayton & Lambert Mfg. Co.","http://www.claytonlambert.com https://claytonlambert.com","Specialties: Stainless Steel",,,,,,,,
1354357,430752,"2020-09-27 03:12:14","All-Star Fence Company",https://api.superpages.com/xml/search?SRC=ypintfeed&subaffiliate=DXC&PGID=e02.7182.8182845904523&SPGID=1583655450365.f953f81f&ADID=5894347&DEST=http%3A%2F%2Fallstarfencelv.mydex.com%2FdH5NQh-Ejc4&C=steel&T=Las%20Vegas&S=NV&PH=(702)%20979-1151&FL=url&TL=off&position=22&PS=30&PI=1&Results=FEED_CLCK&uid=f953f81f-fc40-427d-9170-63608fab1b3e&REF=&IP=172.104.191.106&UserAgent=Mozilla%2F5.0%20(Windows%20NT%2010.0%3B%20Win64%3B%20x64)%20AppleWebKit%2F537.36%20(KHTML%2C%20like%20Gecko)%20Chrome%2F70.0.3538.110%20Safari%2F537.36,lisa@allstarfencelv.com,"(702) 979-1151","4845 W Reno Ave","Las Vegas",NV,89118,"4845 W Reno Ave,Las Vegas,NV 89118","Fence-Sales, Service & Contractors, Building Contractors, Building Specialties, Fence Repair, Gates & Accessories, Metal Tanks, Metal Tubing, Steel Erectors, Steel Processing, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Vinyl Fences, Welders",,,,36.09675,-115.20666,https://i4.ypcdn.com/blob/25a68d0cfcb54905ca35c130e2644b92b63d323c_100x100_crop.jpg?63f80dd,"Serving Southern Nevada Since 2003.","All Star Fence Company of Las Vegas, NV has been providing comprehensive fencing services for commercial, industrial and residential customers throughout Southern Nevada since 2003. We handle everything from home fencing installation to custom fencing and even event and crowd control fences. Our fencing solutions are limitless. Our fences include: В• Wood fences В• Vinyl fences В• Chain link fencing В• Iron fences В• Dog kennels В• Security and construction rental fencing В• Fence gates В• Crowd control fencing Whether your focus is more aesthetic or top security-minded, we are well-equipped, skilled and experienced to fulfill your request. All-Star Fence has been a reputable source for fencing and gates in southern Nevada for over a decade. We offer a complete range of solutions for general contractors, wholesale industries, casinos, state and county agencies and other government agencies. Call All Star Fence Company today for more information.","Mon - Fri: 7:00 am - 4:00 pm",,,"mastercard, check, discover, amex, visa",,,http://www.allstarfencelv.com,"Specialties: Commercial, Business, Residential, Homes Services: Ironwork, Pool Enclosures",,,,,,,,
1587136,495009,"2020-09-27 03:19:11","Blue Escapes Pool & Spa",http://www.blue-escapes.com,,"(972) 294-6950","1321 Precision Dr Ste 400",Plano,TX,75074,"1321 Precision Dr Ste 400,Plano,TX 75074","Swimming Pool Construction, Building Specialties, Deck Cleaning & Treatment, Home Improvements, Home Repair & Maintenance, Private Swimming Pools, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",5,"1 Review",A+,33.01434,-96.69477,https://i3.ypcdn.com/blob/60511e337e011d9653223a5e3050aae0b2cc6022_100x100_crop.jpg?f832250,"We Have over 37 Years Experience In The Swimming Pool Industry. We Can Solve Your Swimming Pool Problem - Guaranteed. * Certified Pool Operator's License ** Certified Building Professional/Certified Service Professional - APSP","We provide a full range of swimming pool maintenance. Repair. & renovation services. We install internet purchased equipment. WIFI control systems. & provide DO it yourself training with a educational DVD with OUR ""pool school"". We are licensed with the state of texas TICL 658 & insured through the independent pool & SPA service association. Certified CPO. APSP CTP. Water hydraulics certified. Stain removal specialist & pool water chemistry certified. We have the answer for complex pool problems.","Mon - Fri: 8:00 am - 6:00 pm Sat: 9:00 am - 1:00 pm","Cell/Text: (214) 402-5457 TollFree: (855) 648-9590",,"debit, check, all major credit cards, financing available, insurance, amex, mastercard, visa, discover",,"Blue Escapes Pool &amp.amp. Spa","http://www.blue-escapes.com http://www.blueescapespools.com","Parking: Lot, Free, Private","Terri P.",03/31/2017,five,"Blue Escapes Pool and Spa is not your normal pool company! I consider myself an expert on pool companies because I have met close to a dozen pool companies! I had a very bad experience with the VIP Pools who re-plastered my pool a few years ago. I have had to hire a new company to correct VIP Pools issues. So hence, the parade of pool companies! Bob, the owner of Blue Escapes Pool and Spa, reviewed my pool with confidence and a high level of expertise. All the bids came in about the same price but it was BobВ’s approach that won me over. Once the work begun, Bob was over almost every day taking pictures of the progress and addressing with his crew any issues he saw. I have NEVER seen the amount of steps and detail related to pool repair, tile and stone replacement. Juan and his crew worked on the pool almost every day, most times working until dark. Most of their process was detail that is not seen in the final product but promotes durability В– waterproofing at every step. visiting 5+ Stone Yards to find rock that did not flake away. brushing down the pool surface, applying an acid wash and final brush-down. replacing pool jets that were the wrong size. applying Deck-O-Seal after stone install. Then when done, they cleaned off my patio furniture and pool area, returning when the pool was filled with water to apply start-up chemicals and make sure the equipment worked correctly. They spent more time on the areas I was not paying them for to assure the end result was a beautifully updated pool that functions better than when they began their work! Another applause is on their communication: They leverage an on-line system in which daily status are sent to the client. And Leta, BobВ’s ever-efficient assistant, would call or Bob, knocking on my backdoor, with an update. I was always part of the process. If only you could see my new pool! It is a beautiful! And I know it will have a long life thru Bob and his crewВ’s care. NOT your normal Pool Company!",,,,
1587854,495114,"2020-09-27 03:19:11","Monarch Pools",http://www.monarchpools.com,retailstore@monarchpools.com,"(303) 309-2729","2211 S Leyden St",Denver,CO,80222,"2211 S Leyden St,Denver,CO 80222","Spas & Hot Tubs, Building Specialties, Cabinet Makers, Cabinets, Home Improvements, Home Repair & Maintenance, Spas & Hot Tubs-Rentals, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,39.67708,-104.91628,,"Building Quality Pools In Colorado Since 1958.","Monarch Swimming Pools, Inc. in Denver, CO, has built custom swimming pools, spas and water features since 1958. We serve both commercial and residential customers. Our retail store is open Monday through Friday year round and Saturdays during the summer. A pool built by Monarch is a luxury retreat where you can surround yourself with your favorite people or be alone. Enjoy being mesmerized by your pool's sparkling magic. Its ever changing colors, reflections and sounds create a vibrant oasis by day and a special romantic atmosphere at night. A Monarch pool is like having an exotic vacation, every day. Our factory-trained technicians are ready to put your pool in operating order, and keep it there. We can take care of simple repairs and entire equipment upgrades. With us doing the work, all you have to do is enjoy your backyard oasis. We offer: Gunite/Shotcrete Swimming Pools Outdoor Water Features Pool Maintenance & Repairs Indoor & Outdoor Construction Water Analysis Automatic Safety Covers BioGuard Chemicals & Accessories We are proud to be members of the prestigious Master Pools Guild for over 45 years. The Guild is respected throughout the industry, nationally and internationally for its continual promotion of quality, ethics and innovation in pool building. Call today and learn how we can put a pool in your yard!","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"amex, check, discover, master card, visa, cash",,,http://www.monarchpools.com,"Parking: Lot",,,,,,,,
1624508,501103,"2020-09-27 03:19:40","Silverhawk Services",https://m.facebook.com/Silverhawkserviceswa-159255784626644,silverhawkdavid@gmail.com,"(206) 395-2455","531 NE 79th St",Seattle,WA,98115,"531 NE 79th St,Seattle,WA 98115","Swimming Pool Construction, Bathroom Remodeling, Building Contractors, Building Specialties, Cabinet Makers, Cabinets, Fire & Water Damage Restoration, General Contractors, Home Improvements, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Painting Contractors, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Water Damage Restoration",,,,47.68585,-122.32149,,"General Contractor SILVES*835KH. Licensed bond insured. Inside and out side painting remodels and pool painting. Clean and do not leave job sight looking like a job site. We work with you to do the best job the way you like it the best.","Silverhawk Services is a painting and restoration contractor serving homeowners and businesses in the Seattle Metro area, and Snohomish County. We pride our company on reliability, great communication, integrity, and quality work. We are experts in our trade and will do our best to keep you as educated as we can on your particular task or project. We take pride in doing every job right the first time, and if you choose Silverhawk Services, you can rest assured that your satisfaction is our #1 priority. Service Area: Seattle Metro Snohomish County Quick Facts: Credit Cards Accepted Materials Free Estimates Business Hours: Monday Friday : 9 am 7 Pm Sat Sun: 10 am 7 pm EMERGENCY 24 HOUR SERVICE AVAILABLE (additional charges apply) Discounts: Seniors & Military 10% Services and Expertise in: Interior Painting Exterior Painting Swimming Pool Restoration & Painting Fire Damage Restoration (Including Insurance Claims) Remodeling Kitchen Cabinet Refinishing We are licensed, bonded and insured, and free estimates are gladly provided. Before scheduling your next project, be sure to give us a call. Youll be happy you did!","Mon - Sun: Open 24 Hours",,,,,,https://m.facebook.com/Silverhawkserviceswa-159255784626644,,,,,,,,,
1630420,502111,"2020-09-27 03:19:43","Memphis Fence Co",http://www.memphisfence.com,contact@memphisfence.com,"(901) 278-9710","1380 N Willett St",Memphis,TN,38108,"1380 N Willett St,Memphis,TN 38108","Home Improvements, Building Specialties, Cabinet Makers, Cabinets, Fence Materials, Fence Repair, Fence-Sales, Service & Contractors, Gates & Accessories, Home Repair & Maintenance, Landscape Designers & Consultants, Landscaping & Lawn Services, Ornamental Metal Work, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",2,"1 Review",A+,35.17672,-90.00548,,"THE RIGHT CHOICE!","Memphis Fence Company is a National Award Winning Fence Contractor. We are licensed in Tennessee, Mississippi, and Arkansas. Memphis Fence Company offers pricing and installation for clear cedar, chain link and vinyl-coated chainlink, cedar split rail, aluminum and ornamental iron. We have been bringing the highest level of service to the Mid-South area for over 30 years.","Mon - Sat: 8:00 am - 5:00 pm",,,"all major credit cards, amex, discover, mastercard, visa",,,http://www.memphisfence.com,"Specialties: Commercial, Business, Industrial, Residential, Special Events, Homes Parking: Lot",jerry.daniel.528,04/11/2013,two,,,,,
1639395,503584,"2020-09-27 03:19:49","Four Seasons Grounds Care Inc",http://www.fourseasonsgc.com,info@fourseasonsgc.com,"(570) 842-3230","2085 Hamlin Hwy",Moscow,PA,18444,"2085 Hamlin Hwy,Moscow,PA 18444","Holiday Lights & Decorations, Asphalt Paving & Sealcoating, Concrete Blocks & Shapes, Concrete Contractors, Concrete Staining Services, Containers, Excavation Contractors, Fence Materials, Fertilizers, Firewood, Home Improvements, Hydroseeding, Ice Melting Equipment & Supplies, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Mulches, Nurseries-Plants & Trees, Paving Contractors, Ready Mixed Concrete, Real Estate Agents, Retaining Walls, Salt, Snow Removal Service, Spas & Hot Tubs, Sprinklers-Garden & Lawn, Stamped & Decorative Concrete, Stone Products, Street Cleaning, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Topsoil, Tree Service, Trucking",5,"4 Reviews",,41.38856,-75.44751,https://i3.ypcdn.com/blob/394108deef7308c22496b4722074f7f5c2fdb494_100x100_crop.jpg?f832250,,,"Mon - Fri: 8:00 am - 6:00 pm Sat: 8:00 am - 12:00 pm","Phone: (570) 689-5296 Fax: (570) 689-5296",,"check, visa",,,http://www.fourseasonsgc.com,"Specialties: Tree Removal Services: DrivewaysPatiosStamped ConcreteWalkways","John W.",08/29/2018,five,"Highly recommend! Excellent company to deal with! Installed our inground swimming pool and beautiful stamped concrete! Within budget! Coordinated our landscaping and pool house! Enjoying our paradise!","Lieslie B.",07/12/2018,five,"Highly Recommend! Guys did an amazing Job! Designer Pool Company and Four Seasons Grounds Care installed our inground swimming pool, fence, concrete decking and landscaping!"
1663671,507645,"2020-09-27 03:20:30","Ceramic Concepts",http://ceramic-concepts.com,info@ceramic-concepts.com,"(323) 953-0604","974 Everett St","Los Angeles",CA,90026,"974 Everett St,Los Angeles,CA 90026","Decorative Ceramic Products, Bathroom Fixtures, Cabinets & Accessories, Counter Tops, Fountains Garden, Display, Etc, Garden Ornaments, Home Decor, Home Improvements, Sauna Equipment & Supplies, Spas & Hot Tubs, Swimming Pool Equipment & Supplies, Tile-Wholesale & Manufacturers",,,A+,34.06925,-118.24847,,,,"Mon - Thu: 9:00 am - 5:00 pm Fri - Sat Closed Sun: 9:00 am - 5:00 pm","Studio phone number: (323) 953-0604",,"check, paypal",,,"HAND PAINTED TILE ART: Decorative Ceramic Tiles",,,,,,,,,
1664370,507780,"2020-09-27 03:20:30","Metro Gas Installers",http://www.metrogasinstallers.com,mike@metrogasinstallers.com,"(612) 470-0432","685 141 Ln NW",Andover,MN,55304,"685 141 Ln NW,Andover,MN 55304","Home Improvements, Building Specialties, Cabinet Makers, Cabinets, Fireplace Equipment, Fireplaces, Generators, Generators-Electric-Service & Repair, Heating Equipment & Systems, Home Repair & Maintenance, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,45.227875,-93.28296,https://i1.ypcdn.com/blob/112fe2a0a3682ba3db74d10b89fc15b81fc13d4a_100x100_crop.jpg?f832250,"Our Gas Never Stinks.","Metro Gas Installers has been in business for over 30 years. We provide installation services to natural gas appliances, pool heaters, stoves, dryers, grills, garage heaters, generators, fire places, and outdoor fire pits. We are licensed, bonded, and insured. Give us a call today!","Mon - Fri: 7:00 am - 9:00 pm Sat - Sun Closed",,,"all major credit cards",,,http://www.metrogasinstallers.com,,,,,,,,,
1665407,507945,"2020-09-27 03:20:30","Hammerhead Pool Services Inc",http://hammerheadpoolservices.com,toddhhpsinc@gmail.com,"(919) 878-7622","5621 Departure Dr Ste 106",Raleigh,NC,27616,"5621 Departure Dr Ste 106,Raleigh,NC 27616","Swimming Pool Repair & Service, Cleaning Contractors, Educational Consultants, Home Improvements, Home Repair & Maintenance, Moving Services-Labor & Materials, Shopping Centers & Malls, Spas & Hot Tubs, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers, Swimming Pool Management",,,A+,35.86043,-78.5928,https://i3.ypcdn.com/blob/3c10c9e6e663b33a873b02ab7f66f57d672a81d7_100x100_crop.jpg?f832250,"To be the most trusted and respected pool management company in the Triangle area by providing an entire spectrum of pool care services and delivering uncompromising service to all our clients.","Hammerhead Pool Services has over 40 years of combined experience. We can provide a full range of maintenance, renovation, repair and staffing services. Hammerhead offers everything you will need in preparing and maintaining your pool in a pristine condition. Our certified staff will ensure that your pool is properly maintained throughout the swimming season. Our pools are in constant compliance with all regulations and that all pools are properly winterized. Our renovation and repair division can offer assessments and equipment repair on all ranges of pool motors, pumps, salt systems, filters and plumbing repairs. With free estimates and a 100% 1 year warranty on all workmanship, we are confident in meeting all of our customerВ’s needs. We strive to provide a positive work environment, where committed individuals can fulfill their potential and in turn deliver unmatched quality service to our clients.","Mon - Fri: 8:00 am - 5:00 pm","Primary Phone: (919) 676-4472 Phone: (919) 676-4472",,"amex, discover, master card, visa, mastercard, all major credit cards",,"Hammerhead Pool Services, Inc. Hammerhead Pool Services Hammerhead Pool Senrices Inc",http://hammerheadpoolservices.com,,,,,,,,,
1705457,514564,"2020-09-27 03:21:06","APG Pools Inc",http://www.apgpools.com/index.html,poolguyinc@comcast.net,"(847) 381-2857","27818 W Flynn Creek Dr",Barrington,IL,60010,"27818 W Flynn Creek Dr,Barrington,IL 60010","Home Improvements, Awnings & Canopies, Building Contractors, Building Restoration & Preservation, Building Specialties, Cabinet Makers, Cabinets, Furniture Stores, Home Repair & Maintenance, Patio & Outdoor Furniture, Screen Enclosures, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,A+,42.18197,-88.17679,,,"APG Pools Inc is a full service swimming pool company. We will open your pool in the spring, keep your pool clean and clear all summer with our weekly service program, and winterize your pool in the fall. We are also experts in pool restoration, heater repair, gas line installation, custom winter covers, electronic leak location and leak repair, custom spa installation, automatic covers, and pump repair and installation. If you elect to have us maintain your pool for you we offer once a week service and twice a week service. With us taking care of your pool all you will have to do is swim. We use Taylor test kits that always give us accurate test results and balance the water using our chemicals. This way you will never have to go to the store to buy chemicals for your pool. Call us for more information.","Mon - Fri: 8:30 am - 5:30 pm Sat - Sun Closed",,,"visa, master card, cash, debit",,,http://www.apgpools.com/index.html,,,,,,,,,
1721642,517293,"2020-09-27 03:21:21","My Ds Pools",http://www.mydspools.com,daniel@mydspools.com,"(619) 761-1107",,,,,,"Home Improvements, Cleaning Contractors, Environmental & Ecological Products & Services, Home Repair & Maintenance, Moving Services-Labor & Materials, Pumps-Service & Repair, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",4,"1 Review",,,,,,"MY DS pools is a Family owned and operated business. We serve the majority of locations in the SAN diego area. We are specialists in residential and commercial swimming pools. Providing a TOP quality Pool and Spa Service","Mon - Sun: Open 24 Hours",,,"all major credit cards, visa, amex, mastercard, discover, cash, check, apple pay",,,http://www.mydspools.com,,"Amir S.",05/12/2015,four,"Professionalism is alive and well.",,,,
1732583,519619,"2020-09-27 03:21:55","Grate Grills, Parts, Pool Supplies & More",http://www.grategrills.com,sales@grategrills.com,"(813) 855-8831","3684 Tampa Rd",Oldsmar,FL,34677,"3684 Tampa Rd,Oldsmar,FL 34677","Gas Companies, Barbecue Grills & Supplies, Patio & Outdoor Furniture, Propane & Natural Gas, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Utility Companies",,,A+,28.04402,-82.68191,https://i1.ypcdn.com/blob/08bc06e25c75cf41704d6d1fa51d08cb5a65771a_100x100_crop.jpg?f832250,"Let a professional help you choose the perfect grill!","Tampa Bays source for BBQ Grills, replacement grill parts, swimming pool supplies, pool equipment & much more!!!","Mon - Fri: 9:00 am - 7:00 pm Sat: 9:00 am - 6:00 pm Sun: 11:00 am - 4:00 pm","Fax: (813) 855-8706",,"cash, all major credit cards, debit",,"Grate Grills & More, Inc.",http://www.grategrills.com,"Parking: Self Wheelchair Accessible: Yes",,,,,,,,
1735940,520500,"2020-09-27 03:22:04","Home Gas Corp",http://www.homegascorp.com,sales@homegascorp.com,"(786) 796-6638","1060 SW 27th Ave",Miami,FL,33135,"1060 SW 27th Ave,Miami,FL 33135","Barbecue Grills & Supplies, Contractors Equipment & Supplies, Electric Equipment & Supplies, Electric Generators, Gas Companies, Generators, Major Appliances, Propane & Natural Gas, Propane & Natural Gas-Equipment & Supplies, Range & Oven Dealers, Swimming Pool Equipment & Supplies, Utility Companies, Water Heaters","2,5","3 Reviews",A,25.7627,-80.23904,https://i3.ypcdn.com/blob/46088a88b190e13cd3828b3f378f6704a95210c3_100x100_crop.jpg?f832250,"Miami's Propane Specialist Since 1949","Serving the South Florida area since 1949 and going stronger than ever, Home Gas is one of South Florida's oldest and most reliable propane and gas appliance distributors. Under the same ownership and in the same location, Home Gas is committed to doing everything in our power to create and maintain satisfied customers. Specializing in residential and commercial propane delivery, our employees are experienced and knowledgeable and are dedicated to first-rate customer service. From refilling your tanks, at our location or yours, to installing and repairing your gas appliances, Home Gas is a one-stop shop for all your propane needs.","Mon - Fri: 8:00 am - 5:00 pm",,,"amex, discover, visa, mastercard, check, debit",,,http://www.homegascorp.com,,"Jolene J.",01/31/2016,one,"*******Rude workers******* Place an order for refill and the worker got mad because I couldn't understand her speaking Spanglish. I ask to speak to a manager she refused, so hung up and called again to be told that we refilled order was schedule 1/29/2015 (bare in mind they claim the only come out on Friday for refills in my area homestead) this was the Wednesday of that week. So come Sunday 2/1/2016 I get up to cook dinner and give my children a bath and there is no gas.So I guess my order was never place. Out of 10 for customer service I give them a 0",zachgo,08/03/2011,five,"I have dealt with numerous propane companies in the past, but only recently have I finally found a company that can adequately meet my needs. I own two above-ground tanks and have recently purchased a tankless waterheater and stove from this establishment. They shipped, delivered, and installed my stove and water heater exactly as communicated to me in the original estimate, and refill my tanks upon my request, on time, every time. I would definitely recommend this company to anyone looking to switch propane companies, or to switch from natural gas to propane. Their service is by far better than any service I reveived from other companies I have hired in the past."
1740716,521776,"2020-09-27 03:22:08","Clearwater Gas System",http://www.clearwatergas.com,lisa.brown@clearwatergas.com,"(727) 298-3540","711 Maple St",Clearwater,FL,33755,"711 Maple St,Clearwater,FL 33755","Gas Companies, Hardware Stores, Major Appliances, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Utility Companies",,,,27.97164,-82.79638,,,"Clearwater Gas System (CGS) is owned and operated as an enterprise utility by the City of Clearwater and operates over 800 miles of underground gas main and handles the supply and distribution of both Natural and Propane (LP) gas throughout northern Pinellas County and western Pasco County. As a ""full service"" gas utility, CGS provides gas appliance sales and service, construction and maintenance of underground gas mains and service lines, and 24 hour response to any gas emergency call within the service area. Clearwater Gas System is regulated for safety by the Florida Public Service Commission and the Federal Department of Transportation. CGS has been serving customers in the Clearwater area for over 75 years (since 1923) when operations were begun with a manufactured gas plant operation. In 1959, when natural gas transmission lines were extended to peninsular Florida, CGS discontinued the manufacturing of gas and began receiving piped natural gas from Florida Gas Transmission. Since 1923, CGS has provided clean, safe, reliable, economical gas service to the Florida Suncoast Community that we are privileged to serve. At a time when the utility business is marked by corporate mergers, and outsourcing of many customer support functions, CGS is proud to be a vibrant, community-based, full-service energy provider. We offer a basic line of gas appliances for sale, and we have a complete service and repair department staffed by trained technicians to maintain residential and commercial gas equipment. Clearwater Gas System prides itself in being a competitive and public service - minded utility, making economical and environmentally-friendly gas available in our community for many homes and businesses in our service area, with special focus on the residential customers who make up nearly 77% of our customer base.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed","Phone: (727) 562-4980 Fax: (727) 562-4989",,"visa, mastercard, check",,,http://www.clearwatergas.com,,,,,,,,,
1741963,522107,"2020-09-27 03:22:13","Air-Ref Co",http://www.airref.com,info@air-ref.com,"(561) 276-0245","2703 N Old Dixie Hwy","Delray Beach",FL,33483,"2703 N Old Dixie Hwy,Delray Beach,FL 33483","Utility Companies, Air Conditioning Contractors & Systems, Air Conditioning Service & Repair, Air Quality-Indoor, Electric Companies, Electricians, Heating Contractors & Specialties, Ice Machines-Repair & Service, Refrigeration Equipment-Commercial & Industrial, Swimming Pool Equipment & Supplies",4,"5 Reviews",A+,26.49055,-80.06557,https://i3.ypcdn.com/blob/f38999aa6d7f35f01314ee350bb493fa34f94b4f_100x100_crop.jpg?f832250,,"Air-Ref Co. has been specializing in residential and commercial air-conditioning and refrigeration systems since 1984. We use only the most reliable, high quality, energy efficient equipment available. Manufacturers' recommendations, code requirements and federal laws are only our minimum standards. Air-Ref Co. also offers a Full Service Electrical Division with over 35 years experience. Our fully stocked trucks are ready to service your electrical needs today. Air-Ref Co. takes special care to protect your home or business during installation. All installation and service technicians are factory trained. Air-Ref Co. provides white glove clean, trouble-free installations. Air-Ref has been specializing in residential and commercial air-conditioning and refrigeration systems since 1984. We use only the most reliable, high quality, energy efficient equipment available. Manufacturers' recommendations, code requirements and federal laws are only our minimum standards. Air-Ref also o ffers a Full Service Electrical Division with over 35 years experience. Our fully stocked trucks are ready to service your electrical needs","Mon - Fri: 8:00 am - 4:30 pm Sat: 8:00 am - 1:30 pm Sun Closed",,,"check, cash, debit, all major credit cards, financing available",,,"Air Conditioning Repair and Sales","Services: Landscape Lighting","Susan S.",05/11/2016,five,"I have been using Air-Ref for about 3 yrs. My home came with an old air conditioner which has given me nothing but problems from day one. I just bought a new Carrier unit from them. The service was excellent. Carl the salesman understood what I was looking to buy and what my price range was. They were very professional with the installation from start to finish. I have the new unit for at least 3 weeks now and I am very happy!","Jenna B.",05/07/2014,five,"Great Company! They did a maintenance for my older system the tech didn't try to sell me anything i didn't need. Once its time to change my AC, I will call them!"
1752231,524832,"2020-09-27 03:22:24","TRS Pools",http://www.trsincpools.com,trs.sanders@gmail.com,"(585) 964-9130","1930 Sweden Walker Rd",Hilton,NY,14468,"1930 Sweden Walker Rd,Hilton,NY 14468","Utility Companies, Chemicals, Gas Companies, Propane & Natural Gas, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Equipment & Supplies",,,,43.28365,-77.86649,,"For All Your Swimming Pool Needs! Call TRS Today!",,"Mon - Thu: 9:00 am - 7:00 pm Fri: 9:00 am - 6:00 pm Sat: 9:00 am - 5:00 pm Sun: 10:00 am - 4:00 pm",,,"all major credit cards",,,http://www.trsincpools.com,"Services: Pool Supplies. Replacement Liners. Chemicals. Above Ground Pool Sales. Propane Refills.",,,,,,,,
1753011,525050,"2020-09-27 03:22:27","Hine Pool Water",http://www.hinepoolwater.net,info@hinepoolwater.net,"(203) 903-1216",,,,,,"Water Dealers, Beverages, Swimming Pool Equipment & Supplies, Swimming Pool Water Delivery, Utility Companies, Water Companies-Bottled, Bulk, Etc, Water Utility Companies",,,,,,,"Since 1970","Hine Pool Water offers supply of water for various usages and water storage tanks to construction sites, residential and commercial pools and homeowners in the Greater New Haven, CT area including Westchester County, NY. We offer contract and emergency water supply and always prompt professional service and supply at competitive prices.","Mon - Sun: Open 24 Hours",,,cash,,,http://www.hinepoolwater.net,,,,,,,,,
1761996,527552,"2020-09-27 03:22:35","Flagala Hardware",http://www.flagala.net,flagala@comcast.net,"(850) 234-2141","9700 Front Beach Rd","Panama City Beach",FL,32407,"9700 Front Beach Rd,Panama City Beach,FL 32407","Beer & Ale, Beer Homebrewing Equipment & Supplies, Building Materials, Gas Companies, Hardware Stores, Liquor Stores, Plumbing Fixtures, Parts & Supplies, Propane & Natural Gas, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Utility Companies",,,,30.18023,-85.79652,https://i1.ypcdn.com/blob/d50f70647efa2660a0cdf426fea4dca1c281c1c8_100x100_crop.jpg?f832250,"Small enough to know you, Large enough to serve you.","Hardware for your home, electrical parts, plumbing fittings, speacial commercial discounts, keys cut, pool cleaning service, pool chemical and parts, homebrew supplies, UHaul rentals, LP Gas","Mon - Fri: 7:00 am - 6:00 pm Sat: 8:00 am - 4:00 pm Sun: 9:00 am - 3:00 pm","Office: (850) 636-3560 Our Main Number: (850) 234-6550 Front Desk: (850) 234-6532 Our Fax: (850) 235-4000",,"debit, visa, master card, amex, discover, check, paypal, cash, travelers checks",,,"Flagala HARDWARE","Parking: Lot, Private",,,,,,,,
1777020,532140,"2020-09-27 03:23:01","Gladieux Do It Best Home Center",http://www.doitbest.com,brandon@gladieuxhomecenter.com,"(419) 693-0601","5120 Navarre Ave",Oregon,OH,43616,"5120 Navarre Ave,Oregon,OH 43616","Floor Materials, Building Materials, Carpet & Rug Dealers, Garden Centers, Gas Companies, Hardware Stores, Hobby & Model Shops, Home Improvements, Home Repair & Maintenance, Interior Designers & Decorators, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Lawn Mowers, Lawn Mowers-Sharpening & Repairing, Lumber, Moving Services-Labor & Materials, Paint, Pet Stores, Propane & Natural Gas, Rental Service Stores & Yards, Shopping Centers & Malls, Swimming Pool Equipment & Supplies, Topsoil, Utility Companies, Wood Products",,,A+,41.63605,-83.42497,https://i1.ypcdn.com/blob/d50f70647efa2660a0cdf426fea4dca1c281c1c8_100x100_crop.jpg?f832250,"Quality Products and Service Since 1938","In 1938 Gladieux Home Center started by offering quality coal and great service. Today the coal is gone but the tradition of quality is stronger than ever. Our 22,000 square foot facility is so much more than a hardware store or lumber yard. We now offer dog food, outdoor power equipment, snowthrowers, pool chemicals, propane, and a full Interior Design experience with professional consultations and all of the products to back up the service. We offer Floor coverings, Furniture, Cabinets, Countertops, Blinds, Custom Draperies, Upholstery, Paint and anything else that will make your house a В“homeВ”, and we offer it all in the same friendly and approachable manner that has made us a success for over 70 years. We might even say, that from a lump of coal, we have developed into quite a diamond. Stop in and see for yourself!","Mon - Fri: 8:00 am - 6:00 pm Sat: 8:00 am - 5:00 pm Sun: 10:00 am - 4:00 pm","Fax: (419) 693-3337",,"mastercard, visa, amex, discover, check, cash, financing available",,"Gladieux Lumber spacebygladiex Gladieux Do-It Best Home Center Gladieux Lumber and Supply Co Inc Interior Design Toledo Gladieux Home Center","Our Warehouse luxury vinyl flooring We are a Benjamin Moore Dealer chainsaw, trimmers, blowers",,,,,,,,,
2211308,687587,"2020-09-27 03:38:41","Hudson Rental & Sales",http://www.hudsonrentalandsales.com,,"(765) 284-9928","1020 N Dr Martin Luther King Jr Blvd",Muncie,IN,47303,"1020 N Dr Martin Luther King Jr Blvd,Muncie,IN 47303","Rental Service Stores & Yards, Construction & Building Equipment, Contractors Equipment & Supplies, Contractors Equipment Rental, Industrial Equipment & Supplies, Portable Toilets, Swimming Pool Equipment & Supplies, Tool Rental, Tools",,,,40.20265,-85.37381,,"BIG or small, We Rent It All !",,"Mon - Fri: 7:30 am - 5:00 pm Sat: 7:30 am - 12:00 pm Sun Closed","Phone: (765) 212-3635 TollFree: (800) 499-0233",,"check, all major credit cards",,,http://www.hudsonrentalandsales.com,"Specialties: Electrical Equipment Services: Portable Restrooms, Construction Equipment - Backhoes, Trenchers, Bobcats, Scissor Lifts, Bucket Lifts, Forklifts, Concrete Saws Home Owner Tools-Drain Cleaning Equipment, Floor Sanders, Floor Scrubbers and more",,,,,,,,
2218125,689411,"2020-09-27 03:38:47","Hudson Rentals",http://hudsonrental.net,hudsonrental@aol.com,"(765) 644-4556","5105 S Madison Ave",Anderson,IN,46013,"5105 S Madison Ave,Anderson,IN 46013","Rental Service Stores & Yards, Construction & Building Equipment, Contractors Equipment & Supplies, Contractors Equipment Rental, Forklifts & Trucks, Industrial Equipment & Supplies, Portable Toilets, Scaffolding & Aerial Lifts, Swimming Pool Equipment & Supplies",,,,40.06288,-85.69305,https://i4.ypcdn.com/blob/027b3b34bba804aa5c65ffd8c1c36adb41538cae_100x100_crop.jpg?63f80dd,,,"Mon - Fri: 7:30 am - 5:00 pm Sat: 7:30 am - 4:00 pm Sun Closed",,,"cash, check, discover, amex, master card, visa",,"Anderson Rent-All",http://hudsonrental.net,,,,,,,,,
2227297,692010,"2020-09-27 03:38:58","At Home Recreation Inc",http://www.athomerecreation.net,manahawkin@athomerecreation.net,"(609) 978-8631","712 E Bay Ave",Manahawkin,NJ,08050,"712 E Bay Ave,Manahawkin,NJ 08050","Billiard Equipment & Supplies, Patio & Outdoor Furniture, Patio Covers & Enclosures, Patio Equipment & Supplies, Private Swimming Pools, Rental Service Stores & Yards, Spas & Hot Tubs, Spas & Hot Tubs-Repair & Service, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Equipment & Supplies",,,,39.68524,-74.23598,,,,"Mon - Fri: 9:00 am - 8:00 pm Sat: 9:00 am - 6:00 pm Sun: 9:00 am - 5:00 pm","Phone: (609) 978-8645 Phone: (609) 607-6101",,"all major credit cards, check, financing available, amex, discover, mastercard, visa",,,http://www.athomerecreation.net,"Wheelchair Accessible: Yes",,,,,,,,
2241208,695778,"2020-09-27 03:39:16","Hudson Rental & Sales",http://www.hudsontoolrental.com,hudsonrental@aol.com,"(765) 405-5584","206 Spring St","New Castle",IN,47362,"206 Spring St,New Castle,IN 47362","Rental Service Stores & Yards, Campgrounds & Recreational Vehicle Parks, Camping Equipment Rental, Construction & Building Equipment, Lodging, Portable Toilets, Swimming Pool Equipment & Supplies, Tool Rental, Tools, Truck Rental",5,"1 Review",,39.93351,-85.38095,,"Call Us To Rent Almost Anything",,"Mon - Fri: 7:30 am - 5:00 pm Sat: 7:30 am - 4:00 pm Sun Closed","Fax: (765) 529-3789",,"check, all major credit cards",,,"http://www.hudsontoolrental.com http://www.hudsonrentalandsales.com http://www.hudsonrentalandsales.net http://hudsonrental.net","Services: Tool & Equipment Rental","Ray F.",07/15/2014,five,"Friendly knowledgeable & reasonable! Items in excellent operating condition, they go over everything with you and if they don't happen to have what you need, they will go out of their way to get it for you. They got me a part for my pool filter faster than I could have, drove over an hr round trip to get it and didn't charge me an extra penny to do so!!! Been going there for years(Anderson) and will continue to do so!",,,,
2290976,712335,"2020-09-27 03:40:56","Kimberton Fire Company",http://kimbertonfire.org,,"(610) 935-1388","61 Firehouse Lane",Kimberton,PA,19442,"61 Firehouse Lane,Kimberton,PA 19442","Fire Departments, Swimming Pool Equipment & Supplies, Water Companies-Bottled, Bulk, Etc",,,,40.284443,-75.87042,,,,"Mon - Sun: Open 24 Hours",,,,,,http://kimbertonfire.org,,,,,,,,,
2468441,768127,"2020-09-27 03:45:48","RPM Construction & Pools",http://www.rpmconstructionpools.com,patricia@rpmconstructionpools.com,"(812) 431-2054","2939 Bromm Rd",Evansville,IN,47720,"2939 Bromm Rd,Evansville,IN 47720","Kitchen Planning & Remodeling Service, Bathroom Remodeling, Building Contractors, Building Specialties, General Contractors, Home Improvements, Home Repair & Maintenance, Ponds, Lakes & Water Gardens Construction, Private Swimming Pools, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,A+,38.08609,-87.6075,https://i2.ypcdn.com/blob/eafb32b390a5d113447b11c6297be628608b34b8_100x100_crop.jpg?8ad0f92,,,"Mon - Fri: 6:00 am - 6:00 pm Sat: 7:00 am - 5:00 pm Sun Closed","MobilePhone: (812) 431-2054",,"check, cash",,,Pools,,,,,,,,,
2471595,768584,"2020-09-27 03:45:48","R.I.G. Roofing & Construction Inc",http://rigroofing.com,james@rigroofing.com,"(863) 216-7793","355 5th St SW","Winter Haven",FL,33880,"355 5th St SW,Winter Haven,FL 33880","Kitchen Planning & Remodeling Service, Altering & Remodeling Contractors, Building Contractors, Building Contractors-Commercial & Industrial, Building Materials, Building Specialties, General Contractors, Home Improvements, Home Repair & Maintenance, Real Estate Developers, Roofing Contractors, Roofing Contractors-Commercial & Industrial, Roofing Equipment & Supplies, Siding Materials, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",5,"1 Review",,28.01776,-81.73253,,"Central Flordia's Shingles Best Roofer!","RIG is proud to provide a high quality roof installation and roof repairs in the Polk County, Florida area. When our highly trained employees take on your project you can trust that your roof is in the best hands State Certified Contractor license #В’s CCC13297175, CBC1257644, CPC1458155","Mon - Fri: 9:00 am - 5:00 pm","Phone: (863) 557-3363",,"check, amex, discover, debit, insurance, cash",,,http://rigroofing.com,"Services: Gutter Cover Installation, Roof Repair","James C.",08/31/2016,five,"Fast service, and they took the time to explain everything to us, we visited their showroom to pick out colors and wow they really have the process streamlined. We would recommend this company to anyone who cares about having the quality of the big box stores and that personal touch of a locally owned and operated business.",,,,
2751201,851153,"2020-09-27 03:54:28","Executive Pool Service & Repair",http://executivepoolrepair.com,justin@norcalpoolandspas.com,"(530) 245-0790","6936 Danyeur Road",Redding,CA,96001,"6936 Danyeur Road,Redding,CA 96001","Lighting Fixtures, Building Specialties, Lamps & Shades, Spas & Hot Tubs-Repair & Service, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,40.51565,-122.37875,https://i4.ypcdn.com/blob/f00bf4f2f2c19f6b482eb568194a0546d1468131_100x100_crop.jpg?41e4770,,"Executive Pool was founded in 1984 on the basis of customer service. The most important aspect of Executive Pool is the strong, reliable, fair, and knowledgeable pool service company that responds to each customer with the utmost respect. Being honest and reliable is something we value at Executive Pool. We work extremely hard to be at appointments on time and understand that a phone call goes a long way if we are running late. Executive Pool is licensed and certified to work on all types of pool equipment. We also offer many services to keep your pool beautiful and operating properly. Executive Pool is the premier Redding pool service and repair company. We specialize in vinyl liner replacement, salt water installations, residential pool service, commercial pool service, pool equipment repair, and pool service in Redding and the surrounding areas. Our Mission is to serve our customers pool and spa needs, always delivering quality service and the best solutions. We have local references available and guarantee your complete satisfaction. Whether you need vinyl liner replacement, weekly maintenance, or pool repair please give us a call for a free estimate.Thank you for your consideration and we look forward hearing from you! Call us at 530-245-0790","Mon - Fri: 7:30 am - 5:00 pm Sat: 7:30 am - 12:00 pm Sun Closed",,,"cash, check, master card, visa",,,http://executivepoolrepair.com,,,,,,,,,
2754260,851797,"2020-09-27 03:54:28","LED Pool Lights",http://www.ledpoollights.net,info@ledpoollights.net,"(407) 350-2922","PO Box",Longwood,FL,32779,"PO Box,Longwood,FL 32779","Swimming Pool Designing & Consulting, Lighting Consultants & Designers, Lighting Systems & Equipment, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers",,,,28.70015,-81.34751,,,,"Mon - Fri: 9:00 am - 5:00 pm",,,"debit, check, paypal, visa, master card, discover",,,"Swimming Pool and Spa LED Lighting",,,,,,,,,
2756173,852204,"2020-09-27 03:54:36","Keys Supply Inc",http://www.keyssupply.com/,keyssupply@AOL.COM,"(786) 438-0219","88900 Overseas Hwy",Tavernier,FL,33070,"88900 Overseas Hwy,Tavernier,FL 33070","Lighting Fixtures, Boat Equipment & Supplies, Electric Equipment & Supplies, Electric Equipment & Supplies-Wholesale & Manufacturers, Marine Equipment & Supplies, Plumbing Fixtures, Parts & Supplies, Swimming Pool Equipment & Supplies",,,,24.98114,-80.54853,,,,"Mon - Fri: 7:30 am - 5:00 pm Sat: 8:00 am - 1:00 pm",,,,,,"http://www.keyssupply.com http://www.hblkeys.com","Specialties: Electrical Equipment, Sprinklers & Irrigation, Pool & Spa",,,,,,,,