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
313541,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",,,,,,,,
343952,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",,,,,,,,
743288,255521,"2020-09-27 02:55:30","Capital City Builders",,mfleniken@gmail.com,"(512) 632-3561","Po Box 4108","Cedar Park",TX,78630,"Po Box 4108,Cedar Park,TX 78630","Home Builders, Altering & Remodeling Contractors, Bathroom Remodeling, Construction Consultants, Gazebos, General Contractors, Kitchen Planning & Remodeling Service, Parking Stations & Garages-Construction, Swimming Pool Dealers",,,A+,30.505,-97.82,,,,,,,,,"Capital City Builders, LLC",,,,,,,,,,
902904,300482,"2020-09-27 03:00:01","Boston Athletic Club",http://www.bostonathleticclub.com,membershipinfo@bostonathleticclub.com,"(617) 269-4300","653 Summer St",Boston,MA,02210,"653 Summer St,Boston,MA 02210","Gymnasiums, Children's Instructional Play Programs, Exercise & Physical Fitness Programs, Nutritionists, Swimming Pool Dealers",5,"4 Reviews",,42.34418,-71.03916,https://i2.ypcdn.com/blob/14ef9aabd8bc36813dd3c096728b5226c0e8c093_100x100_crop.jpg?8ad0f92,,,"Mon - Thu: 5:30 am - 11:00 pm Fri: 5:30 am - 9:00 pm Sat - Sun: 7:00 am - 7:00 pm","Primary Phone: (617) 269-7141 Fax: (617) 269-4300 Fax: (617) 269-9743",,"discover, atm, debit, visa, master card, amex, cash, check",,"Boston Athletic Club, Inc. Athlete's Advantage","http://www.bostonathleticclub.com https://www.bostonathleticclub.com",,"Melissa Run Club",03/04/2010,five,"I am a member of BAC now, great equipment, clean, helpful staff & training. I noticed that they seem to keep up with the latest trends, they are hot on the trail of the new workout machines, they have great groups and clubs to join, wonderful !!! I am very happy here and will stay here. Very social & fun as well. I have made so many great friends at BAC, we all socialize after workouts, we run together, lunch together, great place ! I highly recommend BAC !!",camille_claudel,11/09/2007,five,"The BAC offers a variety of sports and group exercise classes to keep you in shape and enthused about it. It has the unique advantage of FREE parking and plenty of it, which is rare in this city. It also has wonderful services such as physical therapy, massage, restaurant, hair salon, etc. Check out their website. Also, the best personal trainer in Boston works here - TERRY WALSH. If you're looking to get in shape, stay in shape and be totally blown away by a wealth of knowledge and range of exercises, treat yourself to sessions with Terry. It will change your attitude and your life. The BAC is the best!"
959141,313482,"2020-09-27 03:01:14","Classic Tile & Plaster",,,"(817) 310-8041","340 W Northwest Hwy",Grapevine,TX,76051,"340 W Northwest Hwy,Grapevine,TX 76051","Swimming Pool Repair & Service, Building Specialties, Granite, Patio Builders, Plastering Contractors, Spas & Hot Tubs-Repair & Service, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Tile-Contractors & Dealers",3,"2 Reviews",,32.94118,-97.08082,,"Free Site Inspection & Site Evaluation","* Contact us for More Information * Payment Methods: American Express, Discover, Check, Master Card, Visa","Mon - Sat: Open 24 Hours",,,,,,,,buyerx3,04/12/2011,one,"We hired Classic Tile to redo our pool with Pebble Sheen, new deck-o-seal, a new pump and booster and repair work to our pump in March of 2011. The customer service and professionalism was great until they recieved their last installment from us. Once they were paid, the service and professionallism was HORRIBLE. They forgot some deck-o-seal work and needed to repair a couple sections that were of poor quality. The section forgotten (but already paid for) was completed after weeks of calling and prodding, but the repairs were NEVER completed as they told us that the deck-o-seal work was not under warrantee (even though they had just completed the work within the last couple weeks). Also, we had to call several times to have the new pool sweep delivered and installed, which was done improperly. They had to be called over and over to fix this. Again, not fixed properly, we had to hire a different pool contractor to fix it. Also, they were paid to fix our pump and this work was also neglected. We called this company every few days asking simply for a date that they planned on fixing the remaining issues, and, they continually promised it would be the """"next day."""" However, the next day would come and go without any word from them. After 3 weeks of this, we finally called a different contractor to complete their incomple work. Although our pool looks great now, it's the little things and follow-up that would tell us whether or not to recommend a company's services to others. Classic Tile and Plaster is NOT a recommendable company. They are a classic case of """"take the money and run"""" leaving a mess to be cleaned up by others. So, BUYER BEWARE!! If you are unfortunate enough to have already contracted with them, please do NOT pay them in full until ALL the work is completed.",imaghost,12/10/2010,five,"I recently used Classic for a replaster and a waterfall addition to the south side of the deep section of my pool. Turned out great, would use again."
973092,316624,"2020-09-27 03:01:28","Hi-Tech Pools & Pavers",http://www.hi-techpoolsandpavers.com,mike@hitechpoolrenovations.com,"(772) 770-4420","856 23rd Ave","Vero Beach",FL,32960,"856 23rd Ave,Vero Beach,FL 32960","Tile-Cleaning, Refinishing & Sealing, Building Contractors, Driveway Contractors, Marble-Natural, Paving Contractors, Swimming Pool Dealers, Swimming Pool Repair & Service",,,,27.61779,-80.40901,,,"Hi-Tech Pools & Pavers has been servicing Indian River, North St. Lucie and Southern Brevard Counties since 1996. We have successfully completed 100 + Commercial and over 1000 Residential projects. At Hi-Tech Pools & Pavers, we understand that each project is unique and specific to your tastes, lifestyle and budget. Our goal is to transform your restoration vision into a reality. We do an extensive consultation up front. Then we provide viable solutions to create an affordable contemporary look that will last. Hi-Tech Pools & Pavers is committed to the philosophy the customer comes first. While we pay strict attention to every detail during your project and are readily available to any questions or concerns you may have during as well as beyond completion. We hope to build a life long relationship no matter how big or small the project is. We also believe in exceeding client's expectations.","Fri: 8:00 am - 12:00 pm Sat: 9:00 am - 12:00 pm",,,,,"Hi Tech Pools And Pavers","http://www.hi-techpoolsandpavers.com http://www.hitechpoolrenovations.com","Parking: Street",,,,,,,,
1020894,327987,"2020-09-27 03:02:37","Natural Stone Gallery",,naturalstonegallery1101@yahoo.com,"(956) 787-0405","1101 W Ferguson St Ste C",Pharr,TX,78577,"1101 W Ferguson St Ste C,Pharr,TX 78577","Swimming Pool Dealers, Stone Natural, Tile-Contractors & Dealers, Tile-Wholesale & Manufacturers",,,,26.2135,-98.19779,,,,"Mon - Fri: 8:00 am - 5:00 pm Sat: 8:00 am - 3:00 pm Sun Closed","Phone: (956) 787-0517 Phone: (956) 787-0803 Phone: (956) 787-4405",,"mastercard, discover, visa, amex",,,,"Parking: Lot, Free",,,,,,,,
1023260,328574,"2020-09-27 03:02:38","Hughes Pool & Stone Supply",http://www.hughespools.com,,"(828) 837-6222","103 N Church St",Murphy,NC,28906,"103 N Church St,Murphy,NC 28906","Swimming Pool Dealers, Mulches, Spas & Hot Tubs, Stone Natural",,,,35.08813,-84.03562,,,,"Mon - Fri: 8:30 am - 5:00 pm Sat - Sun: 8:30 am - 12:00 pm","Fax: (828) 837-8819",,"all major credit cards, cash, check, debit",,"HUGHES POOL -STONE-MULCH SUPPLY",http://www.hughespools.com,,,,,,,,,
1225386,393665,"2020-09-27 03:09:05","Matchbox Hauling",http://matchboxhauling.com,kenjr@matchboxhauling.com,"(866) 920-4337","3120 S Big Bend Blvd","Saint Louis",MO,63143,"3120 S Big Bend Blvd,Saint Louis,MO 63143","Rubbish & Garbage Removal & Containers, Contractors Equipment & Supplies, Garbage & Rubbish Removal Contractors Equipment, Garbage Collection, Garbage Disposal Equipment Industrial & Commercial, Garbage Disposals, Kitchen Accessories, Major Appliances, Swimming Pool Dealers, Trash Containers & Dumpsters, Waste Recycling & Disposal Service & Equipment, Water Treatment Equipment-Service & Supplies",,,,38.60807,-90.32361,https://i1.ypcdn.com/blob/a01b0b55738bbcecad8622835e8f46f47ee132b7_100x100_crop.jpg?f9d23e1,"For all your waste disposal needs.","Since 1999, Matchbox Hauling is a locally owned waste hauling company, providing temporary dumpster service and permanent scheduled waste service to homeowners, contractors, and other industries. We focus on providing waste solutions to our customer problems, no matter their size. We use hook lift style trucks, which provide 100% control of the container during loading and unloading. Call us now for more information!","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed","Fax: (314) 645-8844",,"discover, visa, paypal",,,http://matchboxhauling.com,"Specialties: Wheels, Trash, Garbage, Yards",,,,,,,,
1273629,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",,,,,,,,
1300153,415242,"2020-09-27 03:10:42","Associated Pool Builders",http://www.associatedpool.com,,"(701) 258-6012","2121 Lovett Ave",Bismarck,ND,58504,"2121 Lovett Ave,Bismarck,ND 58504","Swimming Pool Construction, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Specialties, Construction Consultants, Garages-Building & Repairing, General Contractors, Home Builders, Home Centers, Metal Buildings, Plumbers, Real Estate Developers, Spas & Hot Tubs, Steel Erectors, Swimming Pool Dealers",,,A+,46.79288,-100.75812,,,"At Associated Pool Builders, we've been offering quality pools and hot tubs since 1959. Serving the residential and commercial market with hot tubs and whirlpools, swimming pools and any accessory you may need. We Proudly offer the Following Services to the upper Midwest: -Commercial Swimming Pool Construction -Concrete Swimming Pool Construction -Gunite Swimming Pool Construction -Indoor Swimming Pool Construction -New Swimming Pool Construction -Commercial and Residential Hot Tubs -Swimming Pool and Hot Tub chemicals and accessories. -Builders of Distinctive Pools Distinctive designs, quality materials and experienced staff will help you create a convenient, healthy, delightful gathering place for family and friends.","Mon - Fri: 8:00 am - 5:00 pm","Fax: (701) 224-9729",,"visa, discover, mastercard, all major credit cards, financing available",,"Associated Builders Inc",http://www.associatedpool.com,"Specialties: Hotels / Motels",,,,,,,,
1319516,420775,"2020-09-27 03:11:07",Double-E-Rebar,,doubleerebar@yahoo.com,"(832) 386-8544","6018 Moonmist Dr",Houston,TX,77081,"6018 Moonmist Dr,Houston,TX 77081","Deck Builders, Lake & Pond Construction, Steel Detailers Structural, Swimming Pool Construction, Swimming Pool Dealers","2,5","2 Reviews",,29.71122,-95.48784,,"Many years of experience and offer best deals possible to all customers","We provide any service which involves steel(rebar) in any project Residential or commercial. We do our best to provide quality workmanship on any and every project. We like to offer the best deals possible to every customer.","Mon - Sun: 8:00 am - 5:00 pm",,,,,,,,"Mike T.","Edited: 10/02/2016",one,"Complete joke doubt they are in business anymore but just in case they are DO NOT HIRE THESE CLOWNS FOR ANYTHING. The only other post on here is the guy that runs this crap show and it is exactly that. He tries to do things at such a low cost it will end up costing more in the end, work will drage on for months becaus he won't pay his workers. I wouldn't hire this guy to watch my plants grow AVOID AT ALL COSTS.",elmer6018,03/25/2010,four,"They provided good workmanship and got the job done. It looked impossible to get done but they pulled it off."
1324701,422234,"2020-09-27 03:11:18","Cope Brothers Construction",http://www.copebros.com,copeconstruction@optilink.us,"(706) 226-0989","1007 Richards St",Dalton,GA,30721,"1007 Richards St,Dalton,GA 30721","General Contractors, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Home Builders, Metal Buildings, Steel Erectors, Swimming Pool Construction, Swimming Pool Dealers",,,A+,34.7631,-84.9518,,,,"Mon - Sun: 8:00 am - 4:30 pm","Phone: (706) 226-9772 Fax: (706) 226-9772 Fax Number: (706) 226-9772",,"cash, check, debit, master card, visa",,,http://www.copebros.com,,,,,,,,,
1354898,430905,"2020-09-27 03:12:14","Home Center Construction Inc",http://www.hccgeneralcontractors.com,hcc@hccgeneralcontractors.com,"(620) 231-0992","420 W Atkinson Rd",Pittsburg,KS,66762,"420 W Atkinson Rd,Pittsburg,KS 66762","General Contractors, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Specialties, Cabinet Makers, Cabinets, Concrete Contractors, Deck Builders, Home Builders, Home Centers, Kitchen Cabinets & Equipment-Household, Kitchen Cabinets-Refinishing, Refacing & Resurfacing, Metal Buildings, Steel Erectors, Swimming Pool Construction, Swimming Pool Dealers",,,,37.44052,-94.70968,,,,,"Phone: (620) 231-6962 Fax: (620) 231-6962",,,,,http://www.hccgeneralcontractors.com,"Specialties: Cabinetry, Cabinets, Buildings",,,,,,,,
1584874,494633,"2020-09-27 03:19:10","Advanced Construction & Remodeling",http://www.thevillagesremodelingandpools.com,advancedcompanies@yahoo.com,"(352) 391-5525","505 Sunbelt Rd Ste 5","Lady Lake",FL,32159,"505 Sunbelt Rd Ste 5,Lady Lake,FL 32159","Home Builders, Altering & Remodeling Contractors, Building Contractors-Commercial & Industrial, Construction Consultants, General Contractors, Home Improvements, Real Estate Developers, Swimming Pool Dealers",,,A+,28.92757,-81.93912,,,,,"Phone: (352) 205-4270 Primary Phone: (352) 205-4270",,,,"Advanced Construction & Remodeling Llc Advanced Construction Rmdlng",http://www.thevillagesremodelingandpools.com,,,,,,,,,
1587134,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!",,,,
1587852,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",,,,,,,,
1588820,495278,"2020-09-27 03:19:11","Roberts Construction Company of El Paso Inc",http://www.josephhomesep.com,xescobedoc@gmail.com,"(915) 584-3868","521 Belvidere St","El Paso",TX,79912,"521 Belvidere St,El Paso,TX 79912","Home Builders, Altering & Remodeling Contractors, Building Contractors-Commercial & Industrial, Construction Consultants, General Contractors, Home Improvements, Real Estate Developers, Swimming Pool Dealers",,,A+,31.84645,-106.55837,,,,,"Phone: (915) 356-4012 TollFree: (800) 222-1222",,,,"Escobedo Construction Roberts Construction, Inc.",http://www.josephhomesep.com,,,,,,,,,
1592039,495771,"2020-09-27 03:19:11","Emerald Hearth, Spa & Patio",http://www.emeraldpool.com,mediarep@laycorp.com,"(541) 688-1090","1885 Highway 99 N",Eugene,OR,97402,"1885 Highway 99 N,Eugene,OR 97402","Home Improvements, Awnings & Canopies, Bathroom Remodeling, Building Contractors, Building Specialties, Cabinet Makers, Cabinets, Fireplace Equipment, Furniture Stores, General Contractors, Heating Equipment & Systems, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Major Appliances, Patio & Outdoor Furniture, Patio Equipment & Supplies, Plumbing Fixtures, Parts & Supplies, Screen Enclosures, Small Appliances, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Repair & Service","2,5","8 Reviews",,44.08226,-123.15246,,"Locally Owned For 59 Years.","Locally Owned For 59 Years. Since 1955, Emerald Hearth, Spa & Patio has been a Eugene, OR leader in the sales, installation, maintenance, service, and repair of heating sources for the inside of your home and recreational items for the outside of your home. Our outdoor products include a wide range of hot tubs, pools, patio furniture, grills, and related accessories. Our indoor products include fireplaces, heating stoves, and hearths. Below are just some of our top-of-the-line products: In- and above-ground spas and hot tubs. In- and above-ground swimming pools. Pool and spa chemicals. Patio furniture, Barbecues and grills. Wood, gas, and pellet stoves. Wood, gas, and electric fireplaces. Hearths. We've been keeping you warm in winter, and helping you have fun outdoors in summer for nearly 60 years. Our professional staff are factory-trained and certified. Our products are cost-effective, energy-efficient, and environmentally friendly. Are you ready to relax in your spa or in front of your fireplace? Then call Emerald Hearth, Spa & Patio today!","Mon - Sat: 9:00 am - 6:00 pm Sun: 11:00 am - 4:00 pm",,,"amex, cash, master card, discover, visa",,,http://www.emeraldpool.com,"Parking: Lot, Free",june.gordonstrome,09/06/2013,one,"Worse service manager in town he is a rude crude disgusting man named Pat. He is not good for this company he talks down to people and is disgusting. If I was the comptroller at this store I would fire him in a second I would never allow this in the companies I have run!","un satisfied",06/06/2011,one,"We bought a new spa from emerald 1 yr ago we have had nothing but problems with it. I have complained to the owner and still havent been able to get anything taken care of. STAY AWAY FROM THIS BUSINESS we finally hired another business on w11th to fix the problems we highly recomend them OVER emerald pool & patio"
1620465,500474,"2020-09-27 03:19:30","Manny's Pool Plaster & Remodeling",http://mannyspoolplasterandremodeling.com,Mannyspools@gmail.com,"(951) 351-2466","6942 Ed Perkic St Ste C",Riverside,CA,92504,"6942 Ed Perkic St Ste C,Riverside,CA 92504","Swimming Pool Repair & Service, Building Specialties, Home Improvements, Home Repair & Maintenance, Plastering Contractors, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting",5,"3 Reviews",,33.96257,-117.44506,https://i3.ypcdn.com/blob/424d138872719a3100eece91b019af3723d7a431_100x100_crop.jpg?f832250,,"We have been in business since 2006, but don't let that defy you. Our employees have 15-20 years' experience in the industry. We do business throughout all counties near Riverside, CA. We carry the best materials on the market, offering exceptional quality. We do everything from pool repairs to new pool construction. It is our goal to leave you completely satisfied with the results. Manny's Pool Plaster & Pool Remodeling is a dedicated organization seeking to please our customers, needs and wishes. No job is too big nor too small, regardless of the size of the job we are here to help you!","Mon - Fri: 7:00 am - 7:00 pm Sat: 7:00 am - 12:00 pm",,,"all major credit cards",,,http://mannyspoolplasterandremodeling.com,,richwessels,08/14/2013,five,"These guys did a great job re plastering my 25 year old spa. They showed up on time and and did a great job for a very reasonable price. I've had so many issues with other pool company's over the last year while trying to get my spa fixed. These guys are great. I won't use anyone else","Sanjay S.",03/21/2013,five,"I have a ~50 year old pool that was in pretty rough shape. It probably hadn't been re-plastered in 20 years and had a cracked skimmer that was causing water leakage in my pool. Got several estimates, but ended up getting a great deal (~20% less than other estimates) from Manny. They fixed the skimmer, demoed the old plaster, and re-plastered over three days. The pool looks brand new! Would definitely recommend to anyone looking to re-haul their pool."
1639394,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!"
1650882,505523,"2020-09-27 03:20:10","HRA Home Improvement Company",http://www.hrahomeimprovement.com,,"(615) 410-7924","910g Ridgely Rd",Murfreesboro,TN,37129,"910g Ridgely Rd,Murfreesboro,TN 37129","General Contractors, Altering & Remodeling Contractors, Bathroom Remodeling, Building Contractors, Cabinets, Doors, Frames, & Accessories, Fire & Water Damage Restoration, Gutters & Downspouts, Handyman Services, Home Builders, Home Design & Planning, Home Improvements, Kitchen Planning & Remodeling Service, Masonry Contractors, Patio Builders, Roof Cleaning, Roofing Contractors, Roofing Services Consultants, Shutters, Siding Contractors, Sunrooms & Solariums, Swimming Pool Dealers, Windows-Repair, Replacement & Installation",,,A+,35.85105,-86.40277,,,,"Mon - Fri: 7:00 am - 12:00 am Sat: 8:00 am - 5:00 pm","Phone: (615) 603-7221",,,,"Hra Holding HRA Home Improvement, Inc.","http://www.hrahomeimprovement.com http://www.hrahomeimprovement.net",,,,,,,,,
1665405,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,,,,,,,,,
1689934,512002,"2020-09-27 03:20:51","Ashlyn, Inc",http://www.ashlyninc.com,ashlyninc@gmail.com,"(410) 760-0394",,Severn,MD,21144,"Severn,MD 21144","Home Improvements, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,,,,,"Specializing in Inground Vinyl Liner Pools and Home Improvements","Ashlyn is a family owned & operated business since 1997. Ashlyn specializes in Inground Vinyl Liner Replacements and Constructing new Inground Vinyl Liner Pools. Ashlyn is a fully licensed (MHIC#51143) and insured General Contractor. Ashlyn Pools, our retail store, is located on Mountain Rd in Pasadena, MD next to the Lake Shore Fire Department. The store is open from May-Oct during the swimming pool season.","Mon - Sun: 8:00 am - 8:00 pm",,,,,,http://www.ashlyninc.com,,,,,,,,,
1705456,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,,,,,,,,,
1721641,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.",,,,
1728690,518638,"2020-09-27 03:21:48","Funks Drilling Inc",http://funksdrilling.com,water@funksdrilling.com,"(717) 776-3181","30 Myers Rd",Newville,PA,17241,"30 Myers Rd,Newville,PA 17241","Pumps-Service & Repair, Building Contractors, Building Materials, Construction & Building Equipment, Construction Engineers, Drilling & Boring Contractors, Environmental & Ecological Consultants, Environmental & Ecological Products & Services, Gas Companies, Glass Bending, Drilling, Grinding, Etc, Heating, Ventilating & Air Conditioning Engineers, Plumbing Fixtures, Parts & Supplies, Professional Engineers, Pumping Contractors, Pumps, Pumps-Renting, Swimming Pool Dealers, Utility Companies, Water Treatment Equipment-Service & Supplies, Water Well Drilling & Pump Contractors",,,,40.17835,-77.49373,,"Your Complete Water Source Since 1962.","Funks Drilling, Inc. is a water well drilling and water treatment company serving Cumberland and Perry counties in Pennsylvania. Do you know what is in your water? With our help, you can discover what is in your water and we can help install a source of pure water. Our Water Right conditioning system effectively removes hardness, iron, sulfur, unpleasant tastes, odors and any other minerals infecting your water. Our drilling services include residential, commercial, agricultural and geothermal drilling. We have more than 40 years in the business, giving us the experience you need for quality drilling and water treatment services. Our specialties include: В• Well drilling В• Water well service В• Water testing В• Pump sales, installation and service В• Locating service В• UV purification With our locating services, we can find buried wells, septic tanks and other underground utilities. We not only provide excellence in repair and installation, but we also sell the industry's most trusted brands. Our Aermotor, Grundfos and Berkeley pumps come with a free three to five-year warranty. We have been and will continue to be your complete water source! Call Funks Drilling now for your free water test.","Mon - Tue: 8:00 am - 4:00 pm Wed: 7:30 am - 4:00 pm Thu - Fri: 8:00 am - 4:00 pm Sat - Sun Closed","TollFree: (855) 553-1742",,"check, cash, discover, master card, visa, debit",,,http://funksdrilling.com,"Specialties: Driveways, Ponds Parking: Self",,,,,,,,
1740715,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,,,,,,,,,
1752230,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.",,,,,,,,
1753536,525182,"2020-09-27 03:22:27","Len's Ace Hardware",http://www.lensacehardware.com,addison@lensacehardware.com,"(630) 343-0465","272 W Lake St",Bloomingdale,IL,60108,"272 W Lake St,Bloomingdale,IL 60108","Rental Service Stores & Yards, Building Materials, Gas Companies, Hardware Stores, Lawn & Garden Equipment & Supplies, Propane & Natural Gas, Saws, Snow Removal Service, Swimming Pool Dealers, Tools, Utility Companies",,,A+,41.96415,-88.09898,https://i3.ypcdn.com/blob/be9466bbccf2305938be538d228abdc62d717a6b_100x100_crop.jpg?f832250,"Len's Ace - The helpful place","Len's Ace Hardware is open 7 days a week for our customer's convenience. Offering you four locations to choose from, we're serious about our service! We serve the west and northwest suburbs of Chicago and the town of Roselle, IL. With the ability to offer you over 30 services, we can take care of a wide variety of home improvement needs. These services include: В• Custom paint matching and mixing В• Window and screen repair В• Key cutting В• Lock rekeying and keyed alike В• Pipe cutting and threading Len's Ace Hardware has you covered from the top of your home to the accessories in your yard. pool equipment, Weber grills, mowers, and snow blowers. We also offer you over 500 rental items from party supplies to tool rentals. Len's Ace offers you the Ace Rewards program and the Ace Kid's Club. Call us today for all your hardware questions!","Mon - Fri: 7:00 am - 9:00 pm Sat: 8:00 am - 8:00 pm Sun: 8:00 am - 6:00 pm","Fax: (630) 523-5486",,"amex, check, debit, discover, master card, visa, cash",,,http://www.lensacehardware.com,,,,,,,,,
1794537,537698,"2020-09-27 03:23:33","Coastal Exterminating Co Inc",http://coastalexterminating.net,coastallp@yahoo.com,"(281) 471-1430","812 S 8th St","La Porte",TX,77571,"812 S 8th St,La Porte,TX 77571","Swimming Pool Dealers, Bee Control & Removal Service, Pest Control Services, Pest Control Services-Commercial & Industrial, Utility Companies",,,,29.65569,-95.02777,,,,,,,"discover, visa, mastercard",,,http://coastalexterminating.net,"Services: Bee Removal",,,,,,,,
2227296,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",,,,,,,,
2372703,754472,"2020-09-27 03:44:23","Red Rock Contractors",http://www.buildredrock.com,benh@buildredrock.com,"(480) 539-0111","7255 E Hampton Ave Ste 117",Mesa,AZ,85209,"7255 E Hampton Ave Ste 117,Mesa,AZ 85209","General Contractors, Altering & Remodeling Contractors, Basement Contractors, Bathroom Remodeling, Building Contractors, Building Contractors-Commercial & Industrial, Construction Consultants, Excavation Contractors, Home Builders, Home Design & Planning, Home Improvements, Kitchen Planning & Remodeling Service, Landscape Contractors, Landscape Designers & Consultants, Masonry Contractors, Masonry Contractors-Commercial & Industrial, Patio Builders, Swimming Pool Construction, Swimming Pool Dealers, Tree Service",,,,33.38844,-111.67526,,,,"Mon - Thu: 7:00 am - 5:00 pm Fri: 7:00 am - 12:00 pm","Phone: (480) 832-8900 Phone: (480) 926-9260 Primary Phone: (480) 832-8900",,"no credit cards",,,http://www.buildredrock.com,,,,,,,,,
2385942,756314,"2020-09-27 03:44:34","Custom Built Pools",http://jbernsconstructionandpools.com,kimguy0430@aol.com,"(863) 665-1851","4725 Us Highway 92 E",Lakeland,FL,33801,"4725 Us Highway 92 E,Lakeland,FL 33801","General Contractors, Altering & Remodeling Contractors, Bathroom Remodeling, Building Contractors, Construction Consultants, Doors, Frames, & Accessories, Home Builders, Kitchen Planning & Remodeling Service, Patio Builders, Real Estate Developers, Sunrooms & Solariums, Swimming Pool Construction, Swimming Pool Dealers",,,,28.0471,-81.86305,,,,"Mon - Sun: Open 24 Hours",,,"all major credit cards, amex, check, diners club, discover, insurance, master card, paypal, visa",,"John Berns Construction & Custom Built",http://jbernsconstructionandpools.com,,,,,,,,,
2398181,758093,"2020-09-27 03:44:38","South Shore Construction Services, Inc.",http://southshoreconstructioninc.com/about-us,southshoreconstruction@cfl.rr.com,"(407) 574-2424","13506 Summerport Village Pkwy Ste 1806",Windermere,FL,34786,"13506 Summerport Village Pkwy Ste 1806,Windermere,FL 34786","General Contractors, Altering & Remodeling Contractors, Bathroom Remodeling, Construction Consultants, Flooring Contractors, Home Improvements, Kitchen Planning & Remodeling Service, Swimming Pool Dealers",,,A+,28.47795,-81.58465,,,,"Mon - Fri: 9:00 am - 6:00 pm",,,"no credit cards",,,http://southshoreconstructioninc.com/about-us,,,,,,,,,
2412399,760117,"2020-09-27 03:44:48","Dig Build Inc",http://www.digbuild.com,,"(401) 641-5553","81 Cherry Hill Rd",Johnston,RI,02919,"81 Cherry Hill Rd,Johnston,RI 02919","Home Builders, Altering & Remodeling Contractors, Bathroom Remodeling, Building Contractors, Concrete Contractors, Construction Consultants, Deck Builders, Demolition Contractors, Doors, Frames, & Accessories, Excavation Contractors, Foundation Contractors, General Contractors, Home Improvements, Kitchen Planning & Remodeling Service, Masonry Contractors, Masonry Contractors-Commercial & Industrial, Patio Builders, Roofing Contractors, Septic Tanks & Systems, Siding Contractors, Swimming Pool Dealers, Windows",,,A+,41.83539,-71.48856,,,,,,,,,,http://www.digbuild.com,,,,,,,,,
2414678,760455,"2020-09-27 03:44:48","Joel Koetje General Contractor, Inc",,joel_koetje@yahoo.com,"(808) 337-2800","4471-B Mamo Rd",Kekaha,HI,96752,"4471-B Mamo Rd,Kekaha,HI 96752","General Contractors, Altering & Remodeling Contractors, Bathroom Remodeling, Kitchen Planning & Remodeling Service, Swimming Pool Dealers",,,A+,21.961056,-159.69836,,,,,,,,,,,,,,,,,,,
2415306,760543,"2020-09-27 03:44:48","L & L Builders",,LBLcatholic@sbcglobal.net,"(501) 888-7376","3311 Vicki Dr",Bryant,AR,72022,"3311 Vicki Dr,Bryant,AR 72022","General Contractors, Altering & Remodeling Contractors, Basement Contractors, Bathroom Remodeling, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Specialties, Carpenters, Concrete Contractors, Construction Consultants, Construction Management, Demolition Contractors, Drainage Contractors, Drywall Contractors, Fireplaces, Flooring Contractors, Home Builders, Insulation Contractors, Kitchen Planning & Remodeling Service, Landscape Contractors, Masonry Contractors, Masonry Contractors-Commercial & Industrial, Painting Contractors, Plastering Contractors, Real Estate Developers, Roofing Contractors, Roofing Services Consultants, Siding Contractors, Skylights, Storm Shelters, Sunrooms & Solariums, Swimming Pool Dealers, Tile-Contractors & Dealers, Waterproofing Contractors, Windows-Repair, Replacement & Installation",,,A+,34.62543,-92.51528,,,,"Mon - Sat: 9:00 am - 5:00 pm","Phone: (501) 847-7376 Primary Phone: (501) 847-7376",,"cash, check",,,,"Specialties: Bathrooms, Roofing, Kitchens",,,,,,,,
2435176,763393,"2020-09-27 03:45:10","AAA Construction",,,"(760) 409-8384",,,,,,"Altering & Remodeling Contractors, Air Conditioning Contractors & Systems, Bathroom Remodeling, Building Contractors, General Contractors, Kitchen Planning & Remodeling Service, Swimming Pool Construction, Swimming Pool Dealers",5,"1 Review",,,,,"See our website for more details!","If your house is falling apart around you and you donВ’t know what to do, give us a call. We can repair your home and keep everyone in it happy.","Mon - Fri: 8:00 am - 6:00 pm",,,,,,,,"Shawn G.",02/11/2015,five,"Awesome company!!! Call them for all your remodeling",,,,
2442196,764413,"2020-09-27 03:45:19","Primo Construction",http://www.primoconstruct.com,primoconstruction@qwestoffice.net,"(303) 758-8101","3226 S Ash St",Denver,CO,80222,"3226 S Ash St,Denver,CO 80222","General Contractors, Altering & Remodeling Contractors, Basement Contractors, Bathroom Remodeling, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Specialties, Fire & Water Damage Restoration, Garages-Building & Repairing, Home Builders, Home Design & Planning, Kitchen Planning & Remodeling Service, Patio Builders, Swimming Pool Dealers",5,"1 Review",A+,39.65758,-104.93826,,,,,,,,,,http://www.primoconstruct.com,"Specialties: Decks, Basements, Bathrooms, Garages, Kitchens Services: Basement Remodeling, Bathroom Remodeling, Kitchen Remodeling","YPMobile User",04/16/2013,five,,,,,
2442317,764428,"2020-09-27 03:45:19","Adam's Construction",,adam@builtbyadam.com,"(386) 752-4202","341 SW Ring Ct","Lake City",FL,32025,"341 SW Ring Ct,Lake City,FL 32025","Home Builders, Bathroom Remodeling, Building Contractors, Construction Consultants, General Contractors, Home Design & Planning, Home Improvements, Kitchen Planning & Remodeling Service, Swimming Pool Dealers",,,A+,30.12356,-82.65637,,,,,,,,,,,,,,,,,,,
2464869,767633,"2020-09-27 03:45:39","Vay Construction Co INC",http://www.vayconstruction.com,,"(301) 371-8399","3448 Kaetzel Rd",Rohrersville,MD,21779,"3448 Kaetzel Rd,Rohrersville,MD 21779","Home Builders, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Construction Consultants, Deck Builders, Garages-Building & Repairing, General Contractors, Home Improvements, Kitchen Planning & Remodeling Service, Roofing Contractors, Swimming Pool Construction, Swimming Pool Dealers, Windows, Windows-Repair, Replacement & Installation",,,A+,39.4099,-77.66315,,,,,,,,,"V A Y Construction Company",http://www.vayconstruction.com,,,,,,,,,
2476798,769332,"2020-09-27 03:45:54","GGL & Sons Construction Inc",http://fullhousecare.com,george@gglconstruction.com,"(561) 866-1718",,"Boca Raton",FL,33431,"Boca Raton,FL 33431","General Contractors, Architects & Builders Services, Bathroom Remodeling, Building Construction Consultants, Building Contractors, Carpenters, Construction Consultants, Construction Estimates, Construction Management, Deck Cleaning & Treatment, Demolition Contractors, Dock Builders, Doors, Frames, & Accessories, Electric Contractors-Commercial & Industrial, Flooring Contractors, Gutters & Downspouts, Handyman Services, Home Builders, Insulation Contractors, Kitchen Planning & Remodeling Service, Painting Contractors, Paving Contractors, Plumbers, Real Estate Developers, Roofing Contractors, Roofing Contractors-Commercial & Industrial, Roofing Services Consultants, Siding Contractors, Swimming Pool Dealers, Timber-Frame Homes, Waterproofing Contractors, Windows-Repair, Replacement & Installation",4,"1 Review",A+,,,,,,,,,,,,http://fullhousecare.com,,darther,04/02/2010,four,"The owner is on every job. Very professional, a pleasure to do business with.",,,,
2487422,770818,"2020-09-27 03:45:55","Lone Star Builders Inc",,,"(301) 791-7305","16247 Broadfording Rd",Hagerstown,MD,21740,"16247 Broadfording Rd,Hagerstown,MD 21740","General Contractors, Altering & Remodeling Contractors, Bathroom Remodeling, Building Contractors, Concrete Contractors, Deck Builders, Door Repair, Drywall Contractors, Gazebos, Kitchen Planning & Remodeling Service, Masonry Contractors, Masonry Contractors-Commercial & Industrial, Painting Contractors, Patio Builders, Real Estate Developers, Stair Builders, Swimming Pool Dealers, Tile-Contractors & Dealers",,,,39.68658,-77.80778,,,,,,,,,"Lonestar Builers",,,,,,,,,,
2497984,772298,"2020-09-27 03:46:08","Dan Walker Construction",,,"(615) 415-4966","On File With BBB",Nashville,TN,37221,"On File With BBB,Nashville,TN 37221","Home Builders, Altering & Remodeling Contractors, Bathroom Remodeling, Building Construction Consultants, Building Contractors, Buildings-Pole & Post Frame, Carpenters, Construction Consultants, Deck Builders, Doors, Frames, & Accessories, Drywall Contractors, Electric Contractors-Commercial & Industrial, Fire & Water Damage Restoration, Gazebos, General Contractors, Home Improvements, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Painting Contractors, Patio Builders, Roofing Contractors, Siding Contractors, Sunrooms & Solariums, Swimming Pool Dealers, Windows",,,A+,36.16402,-86.77946,,,,"Mon - Fri: 8:00 am - 5:00 pm",,,,,,,,,,,,,,,
2514988,774729,"2020-09-27 03:46:21","Classic Construction",http://www.classicconstruction.com,accounting@classicconstruction.com,"(972) 437-0909","406 S Yale Dr",Garland,TX,75042,"406 S Yale Dr,Garland,TX 75042","General Contractors, Bathroom Remodeling, Building Contractors-Commercial & Industrial, Construction Consultants, Demolition Contractors, Disaster Recovery & Relief, Fence-Sales, Service & Contractors, Fire & Water Damage Restoration, Flooring Contractors, Foundation Contractors, Home Builders, Home Improvements, Kitchen Planning & Remodeling Service, Masonry Contractors, Painting Contractors, Roofing Contractors, Roofing Contractors-Commercial & Industrial, Roofing Services Consultants, Siding Contractors, Swimming Pool Dealers, Water Damage Restoration",,,A+,32.91025,-96.6919,,,"Classic Construction is a family owned, full-service Dallas general contractor offering professional experience handling insurance claims and catastrophic losses as well as 24-hour emergency care. If you've been affected by a catastrophe, you can count on us to make things right again.","Mon - Sun: Open 24 Hours","Phone: (469) 209-0860 Phone: (972) 272-9415 TollFree: (800) 686-1138",,"paypal, all major credit cards, cash, check, debit",,"Classic Construction & Restoration, Inc Classic Construction & Restoration Incorporated Classic Construction & Restoration","http://www.classicconstruction.com https://classicconstruction.com",,,,,,,,,
2521273,775661,"2020-09-27 03:46:23","Ahern Construction Corp",,,"(805) 494-7979","1204 E Thousand Oaks Blvd","Thousand Oaks",CA,91362,"1204 E Thousand Oaks Blvd,Thousand Oaks,CA 91362","General Contractors, Bathroom Remodeling, Building Contractors-Commercial & Industrial, Building Specialties, Construction Management, Handyman Services, Home Builders, Kitchen Planning & Remodeling Service, Real Estate Developers, Swimming Pool Dealers",,,,34.17839,-118.85784,,,,"Mon - Fri: 7:00 am - 6:00 pm Sat: 7:00 am - 2:00 pm","Fax: (805) 494-3103",,,,"Althar Construction Inc",,,,,,,,,,
2579502,796491,"2020-09-27 03:48:18","Smart Price Car & Truck Rental",http://www.smartpricecarrental.com,robbtaylor@shamrockmm.com,"(801) 850-3002","203 N 2000 W","Pleasant Grove",UT,84062,"203 N 2000 W,Pleasant Grove,UT 84062","Car Rental, Child Care, Day Care Centers & Nurseries, Educational Services, Swimming Pool Dealers, Test Preparation",,,,40.36557,-111.76948,,,"Smart Price Car and Truck rental is a full service automotive rental company that provides excellent customer service. Whether you need a fun car for a weekend get a way or a truck for work or moving, we have you covered! Wide variety of cars and trucks to choose from. Call Today!","Mon - Fri: 9:00 am - 5:00 pm Sat - Sun Closed",,,,,,http://www.smartpricecarrental.com,,,,,,,,,
2726421,845644,"2020-09-27 03:54:03","Andy Gagnon Landscapes Inc.",http://www.andygagnonlandscapes.com,aglndscp@att.net,"(530) 666-0668","555 Kentucky Ave",Woodland,CA,95695,"555 Kentucky Ave,Woodland,CA 95695","Landscape Designers & Consultants, Building Construction Consultants, Building Contractors, Concrete Contractors, Construction Consultants, Irrigation Systems & Equipment, Landscape Contractors, Landscaping & Lawn Services, Lighting Consultants & Designers, Nursery & Growers Equipment & Supplies, Swimming Pool Dealers, Swimming Pool Repair & Service",,,,38.69251,-121.77369,,,"Andy Gagnon Landscapes, Inc dba Cricket Pools is an award winning and full service design/build landscape and swimming pool company. With both the office and the equipment yard in Woodland, we can be found working in the Woodland, Davis, Winters, Dixon, W. Sacramento, N. Natomas, Vacaville, and Esparto communities. Andy Gagnon is a licensed and insured Landscape contractor. he grew up in Davis and now resides in Woodland. With a degree in Environmental Planning and Management from the University of California at Davis, Andy is very familiar with the needs of this area's horticulture. Andy started the business 40 years ago working in landscape in Yolo County and has been expanding ever since. In 1997, Andy took over the well-known ""Cricket Pools, "" (from former owner, Wendell Range). As always, we have designers available to bring your vision of paradise to life and our office staff is always friendly and helpful. Please come by and see us, or call our office. From designs to demolition, irrigation to lighting, planting to patios, woodwork to water features, and swimming pools to swim spas, we can provide complete design and installation. If you would like to hear more about us please give us a call or click on the link provided to learn more about Andy Gagnon Landscapes, Inc dba Cricket Pools. We look forward to working with you.","Mon - Fri: 8:00 am - 4:00 pm Sat - Sun Closed",,,"visa, discover, check, mastercard",,,http://www.andygagnonlandscapes.com,"Services: pools&nbsp.&nbsp.landscapes&nbsp.&nbsp.designs",,,,,,,,
2751200,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,,,,,,,,,