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
1767890,529351,"2020-09-27 03:22:47","McElhaney Plumbing & Hardware Inc",http://www.realpagessites.com,,"(601) 909-4957","501 W Laurel Ave",Hattiesburg,MS,39401,"501 W Laurel Ave,Hattiesburg,MS 39401","Sprinklers-Garden & Lawn, Bolts & Nuts, Building Contractors, Gas Companies, Hardware Stores, Heating Equipment & Systems, Irrigation Systems & Equipment, Major Appliance Parts, Nursery & Growers Equipment & Supplies, Plumbers, Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Plumbing Fixtures, Parts & Supplies, Propane & Natural Gas, Pumps, Sewer Cleaners & Repairers, Sewer Contractors, Sprinklers-Garden & Lawn, Installation & Service, Utility Companies, Water Filtration & Purification Equipment, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Well Drilling & Pump Contractors",,,A+,31.32305,-89.2913,,,"Since 1926 Plumbing and Hardware, Inc. Plumbing Fixtures & Parts Supply, Licensed & Bonded Plumbing Repair & Service, Gas Installation * Repairs Sewer Grinder Systems, Irrigation Systems Expert. Accept all major credit cards","Mon - Fri: 8:00 am - 5:00 pm",,,"discover, visa, mastercard, all major credit cards",,,"http://www.realpagessites.com http://mcelhaneyplumbing.com http://support.realpages.com","Services: Sewer Main Clearing",,,,,,,,
1780447,533168,"2020-09-27 03:23:01","E-Scapes Land Design",http://www.escapeslanddesign.com,escapeslanddesign@gmail.com,"(623) 341-7722","5527 W Saint John Rd",Glendale,AZ,85308,"5527 W Saint John Rd,Glendale,AZ 85308","Arborists, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Fertilizing Services, Fix-It Shops, Florists, Garden Centers, Landscape Designers & Consultants, Landscaping & Lawn Services, Lighting Fixtures, Masonry Contractors, Masonry Contractors-Commercial & Industrial, Patio Builders, Personal Services & Assistants, Retaining Walls, Sprinklers-Garden & Lawn, Tile-Contractors & Dealers, Tree Service, Utility Companies, Weed Control Service",,,,33.64609,-112.17852,,,"E-Scapes Land Design is not just your average landscaper. We not only have the expertise to design and install the backyard of your dreams at an affordable price, but we also maintain it for you year around to ensure its beauty for your everyday enjoyment. We also offer yard maintenance for those who have established their landscaping but want to ensure their investment lasts a lifetime.","Mon - Fri: 6:00 am - 6:00 pm Sat: 6:00 am - 5:00 pm Sun Closed",,,"cash, check",,,"http://www.escapeslanddesign.com http://ethicalaz.com/escapeslanddesign","Parking: Lot, Free Wheelchair Accessible: Yes",,,,,,,,
1786068,534912,"2020-09-27 03:23:11","McElhaney Plumbing & Hardware Inc",,,"(601) 582-3571","501 W Laurel Ave",Hattiesburg,MS,39401,"501 W Laurel Ave,Hattiesburg,MS 39401","Utility Companies, Bolts & Nuts, Building Contractors, Gas Companies, Hardware Stores, Heating Equipment & Systems, Irrigation Systems & Equipment, Major Appliance Parts, Nursery & Growers Equipment & Supplies, Plumbers, Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Plumbing Fixtures, Parts & Supplies, Propane & Natural Gas, Pumps, Sewer Cleaners & Repairers, Sewer Contractors, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service, Water Filtration & Purification Equipment, Water Heaters, Water Well Drilling & Pump Contractors",,,,31.32305,-89.2913,,,,,,,,,,,,,,,,,,,
1796393,538322,"2020-09-27 03:23:37",Ferguson,https://www.ferguson.com/category?cmpid=md_ntnl_plmb_nat_yp___order_,Randy.Schmidt@ferguson.com,"(701) 258-9700","1201 Airport Rd",Bismarck,ND,58504,"1201 Airport Rd,Bismarck,ND 58504","Plumbing Fixtures Parts & Supplies-Wholesale & Manufacturers, Bath Equipment & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Fixtures, Cabinets & Accessories-Wholesale & Manufacturers, Building Materials, Building Materials-Wholesale & Manufacturers, Hardware Stores, Heating Equipment & Systems-Wholesale, Home Improvements, Industrial Equipment & Supplies-Wholesale, Machinery, Machinery-Rebuild & Repair, Pipe, Pipe Fittings, Piping Contractors, Plumbers, Plumbing Fixtures, Parts & Supplies, Pumps-Wholesale & Manufacturers, Sewer Contractors, Sprinklers-Garden & Lawn, Tools, Utility Companies, Utility Contractors, Valves, Valves-Wholesale & Manufacturers, Water Heaters, Water Treatment Equipment-Service & Supplies, Water Works Contractors, Water Works Equipment & Supplies",,,,46.79174,-100.76207,https://i3.ypcdn.com/blob/90431dea3bbf7b9f83443c42d867363d957232af_100x100_crop.jpg?f832250,"Get the quality pipes, valves and fittings, waterworks, heating and cooling equipment, parts and supplies you need, when you need them.","For more than 60 years, Ferguson has earned a strong reputation among contractors, builders and plumbers across the country. We are the largest distributor of residential and commercial plumbing supplies and PVF in the U.S., and a major supplier of HVAC, waterworks and industrial products and services. Ferguson understands the challenges that contractors face. Our knowledgeable people, on-time delivery and commitment to our customers are just a few of the capabilities that set us apart, and keep you on schedule. Whether your project consists of construction on a commercial building, institutional facility or repair and remodel, we offer quick access to product. We don't just take orders. Our expertise allows us to evaluate your specific project or job to ensure that you always get: В• The right product for your application В• The industry's highest fill rates on stock items В• Short lead times on non-stock products В• Access to hard to find products based on our buying power and sourcing expertise В• On-time delivery to keep your project on track With 1,400 locations nationwide, contractors always have access to our vast distribution network. Depending on the size and scope of your project, we will even bring Ferguson to you with our onsite trailer stocked with the products you need to get the job done. We carry all the best and most-recognized brands, cutting edge technology & inventory management solutions, and much more. To find a Ferguson location near you, visit www.ferguson.com/locations-finder.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"mastercard, amex, visa",,,"Shop Online",,,,,,,,,
1800726,539835,"2020-09-27 03:23:41","Cunningham A/C & Heat",http://www.cunninghamoil.com,hughd@cunninghamoil.com,"(386) 253-7621","400 Carswell Ave","Daytona Beach",FL,32117,"400 Carswell Ave,Daytona Beach,FL 32117","Air Conditioning Service & Repair, Air Conditioning Contractors & Systems, Fuel Oils, Gas Companies, Propane & Natural Gas, Propane & Natural Gas-Equipment & Supplies, Sprinklers-Garden & Lawn, Utility Companies",5,"11 Reviews",,29.23278,-81.03712,,"Family Owned and Operated Since 1928","Cunningham Oil is a family-owned company that provides gasoline and oil for service stations and homes. The company services and installs air conditioning and heating systems and electric and gas pumps. It employs more than 60 staff members. Cunningham Oil serves residential and commercial customers in Daytona Beach, Port Orange and Flagler county in Florida. The company develops maintenance plans and offers duct cleaning solutions. In addition, it provides a variety of diesel, kerosene and lubricants. Cunningham Oil operates a filling station and sells gas grills. The company also offers a range of leasing options for tanks. It governs an air conditioning division. Air Duct Cleaning Moss Removal","Mon - Sun: Open 24 Hours",,,"check, cash",,,"http://www.cunninghamoil.com https://cunninghamoil.com http://cunningham.com","Parking: Lot Emergency Service: Yes Services: Heating, Air Conditioning, Service & Repair, Installation Free Estimates: Yes","Lori R.",02/14/2015,five,"I have used Cunningham for many years now can't say enough about what a great company they are. I have always been pleased and would recommend them to anyone. They are definitely the best around! Great, trusted service every time!","Richard P.",02/12/2015,five,"Excellent company they fixed my a/c very quickly thank to joe he knew what was wrong and fixed it right away"
2126797,657201,"2020-09-27 03:35:22","Agassiz Landscape Group",http://www.algflag.com,alg@algflag.com,"(928) 225-2227","210 W Benton Ave",Flagstaff,AZ,86001,"210 W Benton Ave,Flagstaff,AZ 86001","Patio Builders, Antiques, Building Construction Consultants, Building Contractors, Cabinet Makers, Cabinets, Collectibles, Concrete Contractors, Construction Consultants, Deck Builders, Electric Equipment & Supplies, Foundation Contractors, General Contractors, Home Decor, Home Improvements, Home Repair & Maintenance, Landscape Contractors, Landscaping & Lawn Services, Lighting Consultants & Designers, Lighting Fixtures, Masonry Contractors, Snow Removal Service, Sports Cards & Memorabilia, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",,,,35.19588,-111.65328,,,"Agassiz Landscape Group specializes in custom residential design-and-build projects, offering our clients an unmatched level of service and craftsmanship. Your house is far more than a shelter. it is a place for relaxation, entertaining, solitude, and a place for self expression. We offer a number of services including: -Design -Retaining walls -Sprinkler-systems -Outdoor kitchens -BBQs -Plantings(including Xeriscaping/low-water usage) -Patios, Drive-ways, and Walk-ways(pavers and flagstone) -Water features and lighting -Snow removal -New construction -Installation -Grounds Maintenance","Mon - Thu: 8:00 am - 4:00 pm Fri: 8:00 am - 12:00 pm Sat - Sun Closed",,,"cash, discover, amex, visa, check, master card",,,http://www.algflag.com,,,,,,,,,
2177523,678327,"2020-09-27 03:37:37","Del-Mar Rental & Landscape Supply",http://del-mar.ws,contact@del-mar.ws,"(530) 534-7053","3312 Oro Bangor Hwy",Oroville,CA,95966,"3312 Oro Bangor Hwy,Oroville,CA 95966","Landscaping Equipment & Supplies, Building Materials, Electricians, Hardware Stores, Landscaping & Lawn Services, Lawn & Garden Equipment & Supplies, Ready Mixed Concrete, Rental Service Stores & Yards, Sand & Gravel, Sprinklers-Garden & Lawn, Tools, Topsoil",,,,39.48008,-121.52993,,,,"Mon - Fri: 8:00 am - 5:00 pm",,,"discover, master card, visa, check",,,http://del-mar.ws,,,,,,,,,
2179894,678950,"2020-09-27 03:37:37","Willitts Equipment Co. Inc.",,ken@willittspump.com,"(559) 594-5020","30548 Road 196",Exeter,CA,93221,"30548 Road 196,Exeter,CA 93221","Rental Service Stores & Yards, Building Specialties, Irrigation Systems & Equipment, Nursery & Growers Equipment & Supplies, Plumbing Fixtures, Parts & Supplies, Pumps, Pumps-Service & Repair, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service, Water Well Drilling & Pump Contractors, Water Well Drilling Equipment & Supplies, Water Well Plugging & Abandonment Service",,,A+,36.3431,-119.13333,https://i4.ypcdn.com/blob/49b4139d55918ce61c8b81e0e6970c83c59f1d6b_100x100_crop.jpg?63f80dd,"See our website for more details!","We carry a large inventory of products including, pumps, electrical motors up to 200 hp, electrical pump panels up to 200 hp, column pipe, tube and shaft and all domestic pumps and related products",,,,,,,,,,,,,,,,
2189649,681610,"2020-09-27 03:38:00","GRASS 2 ROCKS",,grass2rocks@hotmail.com,"(702) 504-0998","po box 335101","north las vegas",NV,89033,"po box 335101,north las vegas,NV 89033","Landscape Designers & Consultants, Landscaping & Lawn Services, Rental Service Stores & Yards, Sprinklers-Garden & Lawn, Tree Service",,,,36.3231,-115.1214,,"Change your GRASS 2 ROCKS and save water, its a desert here in Vegas.","Good Desert Rock Landscape Service for a low price.","Sat: 8:00 am - 6:00 pm Sun: 10:00 am - 4:00 pm","Cell Phone: (702) 504-0998",,"debit, check, cash",,,,,,,,,,,,
2192249,682303,"2020-09-27 03:38:05","Performance Lawns",http://www.performancelawns.com,,"(785) 243-4055","1513 E 7th St",Concordia,KS,66901,"1513 E 7th St,Concordia,KS 66901","Irrigation Systems & Equipment, Architects, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Lawn Maintenance, Personal Services & Assistants, Rental Service Stores & Yards, Sod & Sodding Service, Sprinklers-Garden & Lawn",,,,39.57041,-97.6382,,,,,"Phone: (785) 818-4056",,,,,http://www.performancelawns.com,"Services: Install Sod, Lawn Maintenance",,,,,,,,
2238592,695069,"2020-09-27 03:39:16","B & G Power Equipment",,bgpowerequipment@att.net,"(806) 665-2366","120 S Hobart St",Pampa,TX,79065,"120 S Hobart St,Pampa,TX 79065","Landscaping Equipment & Supplies, Contractors Equipment & Supplies, Garden Centers, Generators, Hardware Stores, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Lawn & Garden Equipment & Supplies, Lawn Mowers, Nurseries-Plants & Trees, Rental Service Stores & Yards, Sand & Gravel, Sprinklers-Garden & Lawn",,,,35.52962,-100.97232,,,"B & G Equipment Sells and Rents Power Equipment in Pampa, TX Area.","Mon - Fri: 7:00 am - 6:00 pm Sat: 7:00 am - 1:00 pm Sun Closed",,,"amex, discover, master card, visa",,,,,,,,,,,,
2245704,697018,"2020-09-27 03:39:32",Trim-A-Lawn,http://www.pensacolamower.com,,"(850) 453-3167","1405 Gulf Beach Hwy",Pensacola,FL,32507,"1405 Gulf Beach Hwy,Pensacola,FL 32507","Lawn Mowers, Lawn & Garden Equipment & Supplies Renting, Lawn Mowers-Sharpening & Repairing, Rental Service Stores & Yards, Sprinklers-Garden & Lawn",,,A+,30.38595,-87.29271,,"Expert Professionals. Carrying all Major Brands.",,,,,"mastercard, visa, discover, all major credit cards, check, debit, financing available",,,http://www.pensacolamower.com,"Services: Lawn Mower Sharpening",,,,,,,,
2276516,705534,"2020-09-27 03:40:21","Fifth West Rental & Repair",,gt@brigham.net,"(435) 465-2038","75 N 500 W","Brigham City",UT,84302,"75 N 500 W,Brigham City,UT 84302","Rental Service Stores & Yards, Beds & Bedroom Sets, Furniture Stores, Lawn Mowers-Sharpening & Repairing, Sprinklers-Garden & Lawn",5,"1 Review",,41.51235,-112.02397,,"Power Equipment Rentals for Home Owners & Contractors","Power Equipment: Sales - Service - Parts - Rentals. Yes we Rent to home owners & contractors. Call today or come on in We offer Honda Power Equipment Products for sale or rent Generators Pumps Lawnmowers Tillers Trimmers Snow blowers Additional brands include: Hustler Power Turf Equipment. Toro - You can count on it! Dolmar Outdoor Power Equipment. Shindaiwa Additional Rentals Include Backhoes Trenchers Concrete tools Power Rakes & Aerators Power tools & More We gladly service and repair brands that we stock and sell. Ask about our warranties.","Mon - Fri: 8:00 am - 5:30 pm Sat: 8:00 am - 5:00 pm Sun Closed",,,"discover, paypal, debit, amex, all major credit cards",,,,"Parking: Free Wheelchair Accessible: Yes Services: Lawn Mower Sharpening, Lawn Mower Repair","Mary ann D.",10/28/2014,five,"5th West Rental installed a sprinkling system for me a couple years ago. It's awesome. I was so impressed with how hard they worked and the timetable they used to install it. They not only install it but they winterize it and blow out all the water in the lines. They are also willing to start it up and check out the system to make it work correctly in the spring. I'm so happy with them!",,,,
2465516,767718,"2020-09-27 03:45:39","Juan de Jesus",https://www.juandejesusinc.com,pueblaconstruction@ymail.com,"(310) 720-6833",,,,,,"Kitchen Planning & Remodeling Service, Altering & Remodeling Contractors, Building Contractors, Concrete Contractors, Excavation Contractors, Fertilizing Services, Gardeners, General Contractors, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Lawn Maintenance, Mulches, Patio Builders, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service, Tree Service",,,,,,,"Juan De Jesus Inc. Landscaping Expert","Juan De Jesus Inc. Landscaping Expert understands that a beautiful lawn doesnt happen by itself. It needs to be regularly mowed, watered and fertilized. If you need quality commercial or residential landscaping services, count on us!","Mon - Sat: 7:00 am - 7:00 pm",,,check,,"Juan De Jesus Inc. Landscaping Expert Juan De Jesus Inc Juan De Jesus Inc. Landscaping Experts",https://www.juandejesusinc.com,,,,,,,,,
2480387,769828,"2020-09-27 03:45:54","Merrell Plumbing Inc",https://www.merrellplumbing.com/,Mhowell@merrellplumbing.com,"(937) 435-1222","35 Marco Ln",Dayton,OH,45458,"35 Marco Ln,Dayton,OH 45458","Plumbers, Bathroom Remodeling, Drainage Contractors, Gas Lines-Installation & Repairing, Irrigation Systems & Equipment, Kitchen Planning & Remodeling Service, Plumbing-Drain & Sewer Cleaning, Sprinklers-Garden & Lawn, Installation & Service, Water Heater Repair, Water Heaters, Water Softening & Conditioning Equipment & Service",,,,39.6079,-84.15923,,,"Merrell Plumbing has been in business since 1976. Our goal is satisfied customers and prompt service. We specialize in repairs. Our highly trained staff can handle any situation. No job is too large or too small.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"all major credit cards",,,"https://www.merrellplumbing.com http://www.merrellplumbing.com",,,,,,,,,
2488903,771020,"2020-09-27 03:46:01","Lowe's Home Improvement",http://www.lowes.com,customercare@lowes.com,"(770) 220-0153","4950 Peachtree Blvd",Atlanta,GA,30341,"4950 Peachtree Blvd,Atlanta,GA 30341","Home Centers, Air Conditioning Equipment & Systems, Appliance Installation, Barbecue Grills & Supplies, Bathroom Fixtures, Cabinets & Accessories, Bathroom Remodeling, Building Contractors, Building Materials, Cabinet Makers Equipment & Supplies, Cabinets, Carpet & Rug Dealers, Counter Tops, Deck Builders, Dishwashing Machines Household Dealers, Door & Window Screens, Doors, Frames, & Accessories, Draperies, Curtains & Window Treatments, Draperies, Curtains, Blinds & Shades Installation, Fans-Ventilating & Exhaust, Fence Materials, Fence-Sales, Service & Contractors, Floor Materials, Flooring Contractors, Flooring Installation Equipment & Supplies, Garage Cabinets & Organizers, Garage Doors & Openers, Garden Centers, General Contractors, Glass Doors, Guards-Door & Window, Gutters & Downspouts, Hand Tools, Hardware Stores, Heating Equipment & Systems, Heating, Ventilating & Air Conditioning Engineers, Home Improvements, Household Fans, Industrial Equipment & Supplies, Insulation Contractors, Insulation Materials, Kitchen Cabinets & Equipment-Household, Kitchen Planning & Remodeling Service, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Lawn & Garden Furnishings, Lawn Mowers, Lighting Consultants & Designers, Lighting Contractors, Lighting Fixtures, Lighting Systems & Equipment, Lumber, Machine Tools, Major Appliances, Medicine Cabinets, Metal Doors, Microwave Ovens, Paint, Patio & Outdoor Furniture, Playground Equipment, Plumbing Fixtures, Parts & Supplies, Range & Oven Dealers, Range Hoods & Canopies, Refrigerators & Freezers-Dealers, Roofing Contractors, Roofing Equipment & Supplies, Roofing Services Consultants, Sheds, Shower Doors & Enclosures, Siding Contractors, Siding Materials, Small Appliances, Sprinklers-Garden & Lawn, Storm Windows & Doors, Tile-Contractors & Dealers, Tool & Utility Sheds, Tools, Ventilating Contractors, Ventilating Equipment, Vinyl Fences, Vinyl Windows & Doors, Water Heaters, Window Cleaning Equipment & Supplies, Window Shades-Equipment & Supplies, Windows, Wood Doors","4,5","2 Reviews",,33.88502,-84.31744,https://i1.ypcdn.com/blob/bb8e1ca6d942600f7bae59068563a1727cb8fdaf_100x100_crop.jpg?8ad0f92,"Never Stop Improving","Lowe's Home Improvement offers everyday low prices on all quality hardware products and construction needs. Find great deals on paint, patio furniture, home d?cor, tools, hardwood flooring, carpeting, appliances, plumbing essentials, decking, grills, lumber, kitchen remodeling necessities, outdoor equipment, gardening equipment, bathroom decorating needs, and more. Whether you are a beginner starting a DIY project or a professional, LoweВ’s is your headquarters for all building materials. Shop online at www.lowes.com or at your Chamblee, GA LoweВ’s store today to discover how easy it is to start improving your home and yard today.","Mon - Sat: 6:00 am - 9:00 pm Sun: 8:00 am - 8:00 pm","Fax: (770) 220-2573 Customer Care: (800) 445-6937 Products and Sales: (877) 465-6937",,"amex, discover, master card, visa, check, cash",,,Website,"Parking: Lot, Private Bike Parking: No Specialties: easy returns, free delivery, free haul away, Lowe's gift cards, easy exchanges, free shipping","David P.",11/29/2015,four,"Very organized store with helpful staff that you have come to expect from Lowe's Home Improvement stores.","Deborah C.",11/20/2015,five,"I would highly recommend them for the purchase and installation of doors!I had a door installed by this Lowe's after months of frustration with independent contractors and handymen. Lowe's made it so simple. They were extremely helpful, from David in the store to Eric who did the actual installation. They explained everything to me, they worked with me to get what I wanted and they gave me a very good price. I only wish I'd gone to them in the first place!!!"
2712249,842597,"2020-09-27 03:53:46","Distinctive Landscaping Design LLC",http://distinctivelandscapedesignllc.com,distinctive0329@sblglobal.net,"(573) 734-1213","2452 Highway N",Bismarck,MO,63624,"2452 Highway N,Bismarck,MO 63624","Sprinklers-Garden & Lawn, Installation & Service, Drainage Contractors, Excavation Contractors, Irrigation Systems & Equipment, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Lighting Contractors, Nurseries-Plants & Trees, Nursery & Growers Equipment & Supplies, Patio Builders, Ponds, Lakes & Water Gardens Construction, Retaining Walls, Sprinklers-Garden & Lawn, Tree Service",,,,37.769863,-90.620735,https://i4.ypcdn.com/blob/87db30deb5fb77cf56cecea55b228fd4ae1fd125_100x100_crop.jpg?41e4770,"Incredible Landscape Design and Installation","We're your one-stop shop for enhancing your landscapes and hardscapes. Our experts will perform all of your designs, installations and upgrades. All you have to do is select your design and wait for your incredible landscape to come to life! If you need new trees to put the final touches on your landscape's beautiful design, then come explore our professional tree nursery. We'll also make sure that your landscape's beauty lasts by installing a reliable irrigation system. You only get high-quality service from us. With over 20 years of experience, our landscaping experts will do the job right. to ensure that this happens, our owner personally comes out to every site to supervise and even perform work himself! If you aren't 100% satisfied, let us know. Your satisfaction is GUARANTEED, so we'll make adjustments to make you happy! Call us today for your FREE estimate. 573-734-1213","Mon - Sun: Open 24 Hours","Phone: (573) 518-4222",,cash,,,http://distinctivelandscapedesignllc.com,"Specialties: Trees",,,,,,,,
2712341,842609,"2020-09-27 03:53:46","WaterSavers Turf",http://www.watersaversturf.biz,concordstore@watersaversinc.com,"(925) 691-9115","4025a Nelson Ave",Concord,CA,94520,"4025a Nelson Ave,Concord,CA 94520","Irrigation Systems & Equipment, Artificial Grass, Gardeners, Landscape Contractors, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Lighting Fixtures, Nursery & Growers Equipment & Supplies, Sod & Sodding Service, Sprinklers-Garden & Lawn",,,,38.00724,-122.04567,https://i4.ypcdn.com/blob/ad5d8088ba5de1e7ff92139df775c5057c3a15e2_100x100_crop.jpg?41e4770,"Your Path To A Greener Tomorrow","We are a full-service artificial grass supplier and carry over 60 types of turf for landscaping, putting greens, sports and pet areas. Our product line includes a many colors and face weights to work with your project and budget. You will find our prices to be very competitive. We pride ourselves on our excellent customer service and are here to help you find the best solution for your lawn replacement","Mon - Fri: 6:30 am - 4:00 pm Sat: 7:00 am - 11:00 am Sun Closed","Fax: (925) 691-1987",,"visa, mastercard, amex, discover, all major credit cards",,"Watersavers Irrigation",http://www.watersaversturf.biz,,,,,,,,,
2712529,842654,"2020-09-27 03:53:46","Scharmer Sprinklers & Landscape",http://www.scharmerssprinklers.com,info@scharmersprinklers.com,"(925) 934-6958","2717 N Main St Ste B","Walnut Creek",CA,94597,"2717 N Main St Ste B,Walnut Creek,CA 94597","Landscape Designers & Consultants, Irrigation Systems & Equipment, Landscape Contractors, Lighting Consultants & Designers, Sprinklers-Garden & Lawn, Installation & Service",,,,37.92266,-122.06463,,,,"Mon - Fri: 8:00 am - 4:00 pm","Phone: (925) 278-2910 Phone: (925) 934-6935 Fax: (925) 934-6935",,"amex, master card, visa, all major credit cards",,"Scharmer Sprinklers & Landscp",http://www.scharmerssprinklers.com,,,,,,,,,
2713623,842864,"2020-09-27 03:53:46","Essentials Landscaping",http://essentialslandscaping.com,essentialslandscaping@gmail.com,"(208) 914-1111","Po Box 967",Eagle,ID,83616,"Po Box 967,Eagle,ID 83616","Landscape Contractors, Landscaping & Lawn Services, Lighting Contractors, Ponds, Lakes & Water Gardens Construction, Sprinklers-Garden & Lawn",,,,43.70688,-116.36197,,,,,,,,,,http://essentialslandscaping.com,,,,,,,,,
2714798,843114,"2020-09-27 03:53:54","Don John Landscaping",http://donjohnlandscaping.com,,"(707) 224-9427","3724 Linda Vista Ave",Napa,CA,94558,"3724 Linda Vista Ave,Napa,CA 94558","Landscape Designers & Consultants, Concrete Contractors, Deck Builders, Gardeners, Irrigation Systems & Equipment, Landscape Contractors, Landscaping & Lawn Services, Lighting Consultants & Designers, Sod & Sodding Service, Sprinklers-Garden & Lawn",,,A+,38.32385,-122.32123,,,"Founded in 1976, Don John Landscaping is a full-service general contractor in California. The company offers landscape design and project management solutions. Don John Landscaping provides installation and design services for concrete patios, sodded lawns, irrigation systems, low-maintenance gardens, waterfalls, ponds, fences, decks and lighting systems. The company has been recognized by the California Landscape Contractors Association.",,,,,,,http://donjohnlandscaping.com,,,,,,,,,
2715530,843267,"2020-09-27 03:53:54","Grant Landscape & Design",http://www.grantlandscapes.com,,"(406) 549-9166","123 W Central Ave",Missoula,MT,59801,"123 W Central Ave,Missoula,MT 59801","Landscape Designers & Consultants, Basement Contractors, Erosion Control, Landscape Contractors, Landscaping & Lawn Services, Lighting Consultants & Designers, Retaining Walls, Sprinklers-Garden & Lawn, Installation & Service, Tree Service",,,,46.85043,-113.99888,,,,,,,,,,"http://www.grantlandscapes.com http://grantlandscapeanddesign.com",,,,,,,,,
2715571,843275,"2020-09-27 03:53:54","Windmill Services LLC",http://www.windmillservices.net,windmillservices@aol.com,"(803) 513-3662","2760 Crooked Pine Ln",Elgin,SC,29045,"2760 Crooked Pine Ln,Elgin,SC 29045","Landscaping & Lawn Services, Building Construction Consultants, Construction Consultants, Irrigation Consultants, Irrigation Systems & Equipment, Landscape Contractors, Lawn Maintenance, Lighting Consultants & Designers, Nursery & Growers Equipment & Supplies, Sprinklers-Garden & Lawn",,,,34.15085,-80.80809,,,,,,,,,,http://www.windmillservices.net,,,,,,,,,
2715915,843350,"2020-09-27 03:53:54","4 Seasons Solutions",http://4seasonssolutions.com,4seasons.solutions@gmail.com,"(281) 865-2787",,Houston,TX,77071,"Houston,TX 77071","Drainage Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Lighting Consultants & Designers, Sprinklers-Garden & Lawn, Installation & Service",,,,,,,,,"Mon - Fri: 9:00 am - 5:00 pm",,,"all major credit cards",,,"Sprinkler Repair &amp.amp.amp.amp.amp.amp. Installation",,,,,,,,,
2715950,843356,"2020-09-27 03:53:54","Anything Green",http://sprinklerfixit.com,jay@sprinklerfixit.com,"(512) 869-8121",,Georgetown,TX,78628,"Georgetown,TX 78628","Landscape Contractors, Irrigation Systems & Equipment, Landscaping & Lawn Services, Lighting Consultants & Designers, Lighting Contractors, Lighting Maintenance Service, Sprinklers-Garden & Lawn",,,A+,,,,,"Anything green provides quality sprinkler repair service and outdoor landscape lighting. Licensed and insured L. I. 0006974.","Mon - Fri: 8:00 am - 5:30 pm","Phone: (512) 677-0053",,"all major credit cards, paypal",,,http://sprinklerfixit.com,,,,,,,,,
2716105,843390,"2020-09-27 03:53:54","Tepe Services",http://tepeservices.com,info@tepeservices.com,"(513) 941-4500","7021 Cleves Warsaw Pike",Cincinnati,OH,45233,"7021 Cleves Warsaw Pike,Cincinnati,OH 45233","Landscape Designers & Consultants, Gardeners, Landscape Contractors, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn Maintenance, Lighting Consultants & Designers, Snow Removal Service, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",,,A+,39.12322,-84.68166,https://i4.ypcdn.com/blob/051ecc097b2deff78a53b45d428fb898c129758b_100x100_crop.jpg?41e4770,"Family-owned landscaping company serving Cincinnati since 1980","Tepe Landscaping in Cincinnati provides full service landscape, lighting and sprinkler services for residential and commercial locations in the Greater Cincinnati area.","Mon - Fri: 8:30 am - 5:00 pm Sat - Sun Closed","Primary Phone: (513) 941-5927 Fax: (513) 941-5927",,"cash, check, amex, master card, visa",,,http://tepeservices.com,,,,,,,,,
2716355,843450,"2020-09-27 03:53:54","Spartan Irrigation Inc/ArborLawn Inc",http://www.arborlawn.com,,"(800) 331-1746",,,,,,"Sprinklers-Garden & Lawn, Installation & Service, Irrigation Consultants, Irrigation Systems & Equipment, Landscaping Equipment & Supplies, Lighting Fixtures, Sprinklers-Garden & Lawn",,,,,,,,"Serving All of Michigan Irrigation-Sprinklers Service & Installation","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed","Local Number Lansing: (517) 882-1826",,"debit, amex, check, mastercard, discover, visa",,,"ArborLawn Website http://www.spartanirrigation.com",,,,,,,,,
2716795,843547,"2020-09-27 03:53:54","Austex Sprinklers",http://www.austexsprinklers.com,phil@austexsprinklers.com,"(512) 721-8564","13611 Immanuel Rd",Pflugerville,TX,78660,"13611 Immanuel Rd,Pflugerville,TX 78660","Drainage Contractors, Backflow Prevention Devices & Services, Lighting Contractors, Sod & Sodding Service, Sprinklers-Garden & Lawn, Installation & Service",,,,30.40201,-97.63011,,,,"Mon - Wed: 8:30 am - 5:00 pm Thu: 8:00 am - 5:00 pm Fri: 8:30 am - 5:00 pm",,,"all major credit cards",,,http://www.austexsprinklers.com,,,,,,,,,
2717051,843602,"2020-09-27 03:53:54","Sprinkler Repair LLC",http://www.sprinklerdoctors.com,sprinklerrepairaz@gmail.com,"(602) 367-6965","4413 W Altadena Ave",Glendale,AZ,85304,"4413 W Altadena Ave,Glendale,AZ 85304","Sprinklers-Garden & Lawn, Irrigation Systems & Equipment, Landscape Contractors, Lighting Contractors, Sprinklers-Garden & Lawn, Installation & Service",,,,33.59139,-112.15406,,,,"Mon - Sun: 7:00 am - 6:00 pm",,,"all major credit cards",,,http://www.sprinklerdoctors.com,,,,,,,,,
2717830,843767,"2020-09-27 03:53:54","P3 Irrigation Service Co.",,p3irrigation@yahoo.com,"(248) 773-2867","15743 Grayfield",Redford,MI,48239,"15743 Grayfield,Redford,MI 48239","Drainage Contractors, Irrigation Systems & Equipment, Lighting Contractors, Ponds, Lakes & Water Gardens Construction, Sprinklers-Garden & Lawn, Installation & Service",,,,42.375553,-83.28895,https://i4.ypcdn.com/blob/de944e694545507204f43fdfdce54a6a42ecaed5_100x100_crop.jpg?41e4770,,,"Mon - Fri: 9:00 am - 5:00 pm Sat - Sun Closed",,,,,,,,,,,,,,,
2718076,843824,"2020-09-27 03:53:54","Classic Lawns & Gardens Ii",https://api.superpages.com/xml/search?SRC=ypintfeed&subaffiliate=DXC&PGID=e02.7182.8182845904523&SPGID=1583346316796.f926c10a&ADID=12152699&DEST=http%3A%2F%2Fclassiclawnsandgardensinc1.mydex.com%2F0sJouZ3EYyE&C=Lighting&T=Kennett%20Square&S=PA&PH=(484)%20604-0471&FL=url&TL=off&position=2&PS=30&PI=1&Results=FEED_CLCK&uid=f926c10a-0c2d-4621-b243-f13c2e07a90a&REF=&IP=14.139.189.213&UserAgent=Mozilla%2F5.0%20(X11%3B%20Ubuntu%3B%20Linux%20x86_64%3B%20rv%3A62.0)%20Gecko%2F20100101%20Firefox%2F62.0,classic@classiclg.com,"(484) 604-0471","990 W Cypress St","Kennett Square",PA,19348,"990 W Cypress St,Kennett Square,PA 19348","Landscape Designers & Consultants, Farm Equipment, Farm Equipment Parts & Repair, Farming Service, Farms, Garden Centers, Greenhouses, Landscape Contractors, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Lighting Fixtures, Nursery & Growers Equipment & Supplies, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",,,,39.83987,-75.74157,,"Since 1991, We Have Been Creating Unique, Elegant And Sustainable Landscapes","Classic Lawns & Gardens is your single source for a complete range of custom residential landscape design and installation services.","Mon - Fri: 8:30 am - 4:30 pm","Phone: (610) 444-5548",,"mastercard, visa, check, debit",,"Classic Lawns & Gardens Inc","http://classiclawnsandgardensinc1.com http://classiclawnsandgardensinc.com","Services: Landscape Designers, Lawn Maintenance, Landscape Lighting",,,,,,,,
2718523,843919,"2020-09-27 03:53:54","Wild Irishman Tree & Landscape",http://www.denverlandscapedesign.net,,"(303) 233-1302","2833 Utica St",Denver,CO,80212,"2833 Utica St,Denver,CO 80212","Landscape Designers & Consultants, Arborists, Building Specialties, Deck Builders, Fence-Sales, Service & Contractors, Garden Centers, General Contractors, Home Builders, Landscape Contractors, Landscaping & Lawn Services, Lawn Maintenance, Lighting Consultants & Designers, Masonry Contractors, Masonry Contractors-Commercial & Industrial, Patio & Outdoor Furniture, Patio Builders, Retaining Walls, Sod & Sodding Service, Sprinklers-Garden & Lawn, Installation & Service, Tree Service",2,"5 Reviews",,39.758,-105.04596,https://i3.ypcdn.com/blob/dde8bc20f52012fffdc20023c58e1d25a3b07f01_100x100_crop.jpg?d9a04b5,"Denver Landscaping Experts Who Work Hard To Beautify Your Home Through Landscape Design","About Wild Irishman Tree & Landscape IncHonesty, Integrity, CommittmentDuane O'Hara, President of the Wild Irishman Tree and Landscape Inc., in Denver has been providinglandscaping services in Denver and the surrounding metro areas since 1999. At Wild Irishman we pride ourselves on our success at all levels from small residential to large commercial projects. Wild Irishman offers design ideas by Pro-Landscape.This allows us to photograph your present landscape, and layout a design showing what your house will look like before and after the project.Duane prides himself on the fact that the Wild Irishman does all the work themselves. To ensure the quality of theirwork and to make sure their customers are 100% satisfied the Wild Irishman does not employee any subcontractors.Our team is experienced, we our own our equipment and our honesty, integrity and commitment to our customerservice ensures we will meet all your expectations.Greenscaping Denver with sustainable xeriscape-friendly landscape design and installation. We specialize in the installation of beautiful, sustainable and functional urban landscape designs.Wild Irishman is a turn key landscape design installation and garden service that creates a functionallandscaping plan for our customers. With over 15 years experience in the Denver Metro area, Duane O'Hara, President of Wild Irishman Tree and Landscape creates and inspires landscapes that are beautiful and pesticide free.Our Denver landscapes and gardens span from formal to informal, private to public spaces incorporating budgetary needs, personal features, kitchens, and more, all beautiful, all sustainable.Whether you would like a patio, retaining wall, landscape design, irrigation, snowplowing, paint striping or pressure washing, we're here to help so call us today.","Mon - Fri: 8:00 am - 5:00 pm","Phone: (303) 323-0828",,"amex, discover, master card, visa, all major credit cards",,"Wild Irishman Tree and Landscape Wild Irishman Tree & Landscape, Inc.","http://www.denverlandscapedesign.net http://www.wildirishman.com",,"Kay K.",07/26/2016,two,"The project is very pretty, but professionalism lacked. Would not show up when scheduled and would not return calls. I they could get their act together they would be a Great company.","Duane O.",12/04/2014,five,"Wild Irishman did my landscape this past summer. I had an old Denver Bungalo that required the removal of a bunch of old Junipers-you know those stinky bushes. Duane and his crew came in and scraped out yard down to the dirt. He then designed a beautiful CAD drawing was beyond our expectations and our budget, his numbers are real competitive with other landscape design companies. We chose Wild Irishman because Duane reassured us that he would be on the job, and to make sure everything we agreed on was going to be completed in a timely manner. The project turned out great, on time, and under our budget...I would recommend to all my friends and family."
2718830,843993,"2020-09-27 03:53:54","Lawns Unlimited Ltd",https://www.lawnsunlimited.com,info@lawnsunlimited.com,"(302) 645-5296","15089 Coastal Hwy",Milton,DE,19968,"15089 Coastal Hwy,Milton,DE 19968","Landscape Designers & Consultants, Landscaping Equipment & Supplies, Lighting Consultants & Designers, Sprinklers-Garden & Lawn",,,A+,38.77869,-75.23036,,,,"Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed","Phone: (302) 644-8425 Fax: (302) 645-5276",,"all major credit cards, visa, discover, mastercard, check, debit, amex, company card",,,"https://www.lawnsunlimited.com Facebook Angies List",,,,,,,,,
2719677,844161,"2020-09-27 03:53:55",Acacia,,,"(859) 684-0877","1067 N Main St",Nicholasville,KY,40356,"1067 N Main St,Nicholasville,KY 40356","Retaining Walls, Irrigation Systems & Equipment, Landscape Contractors, Lighting Contractors, Sprinklers-Garden & Lawn, Installation & Service",,,,37.90219,-84.56393,,"Our best compliment is your referral to family, friends, and colleagues!","We are a full spectrum irrigation, landscaping, and hardscape company. Our intention is to meet and exceed all your expectations!","Mon - Fri: 7:30 am - 9:00 pm Sat: 9:00 am - 3:00 pm Sun Closed","Phone: (859) 559-8208",,"visa, master card, discover, check, insurance",,"Acacia Hardscapes Acacia Irrigation",,,,,,,,,,
2719744,844177,"2020-09-27 03:53:55",Eco-Systems,http://eco-systemsonline.com,ecosystemschris@gmail.com,"(203) 403-6729","110 N Salem Rd",Ridgefield,CT,06877,"110 N Salem Rd,Ridgefield,CT 06877","Sprinklers-Garden & Lawn, Installation & Service, Building Contractors, Electric Companies, Electricians, Irrigation Consultants, Irrigation Systems & Equipment, Landscape Designers & Consultants, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lighting Contractors, Lighting Maintenance Service, Nursery & Growers Equipment & Supplies, Sprinklers-Garden & Lawn",,,A+,41.29486,-73.50384,https://i4.ypcdn.com/blob/f56ffd88af2cc630c9145415d08e7e564ac76f25_100x100_crop.jpg?41e4770,"It's your eco-system","CALL OR EMAIL FOR A FREE ESTIMATE ON ALL SERVICES","Mon - Fri: 7:00 am - 7:00 pm Sat - Sun Closed",,,"mastercard, cash, visa, discover, check",,"Eco Systems Inc",http://eco-systemsonline.com,,,,,,,,,
2720212,844285,"2020-09-27 03:53:55","Wolf Creek Co",http://www.wolfcreekcompany.com/locations/cincinnati,bmartin@wolfcreekcompany.com,"(513) 489-8455","11956 Tramway Dr",Cincinnati,OH,45241,"11956 Tramway Dr,Cincinnati,OH 45241","Irrigation Systems & Equipment, Garden Centers, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lighting Fixtures, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",,,,39.29396,-84.40438,https://i3.ypcdn.com/blob/30bc9b39f89e80469eae94f759043bbf6346da93_100x100_crop.jpg?41e4770,,,"Mon - Fri: 8:00 am - 5:00 pm","TollFree: (800) 488-7305",,"financing available",,"Wolf Creek Company Wolf Creek Co, Inc.","http://www.wolfcreekcompany.com/locations/cincinnati http://wolfcreekcompany.com",,,,,,,,,
2720272,844301,"2020-09-27 03:53:55","Allen Outdoor Solutions Inc.",http://www.allenoutdoorstl.com,george@allenoutdoorstl.com,"(314) 647-4800","4400 Saint Vincent Ave","Saint Louis",MO,63119,"4400 Saint Vincent Ave,Saint Louis,MO 63119","Landscape Designers & Consultants, Irrigation Systems & Equipment, Landscape Contractors, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Lawn Maintenance, Lighting Fixtures, Nursery & Growers Equipment & Supplies, Snow Removal Service, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service","3,5","6 Reviews",A+,38.59303,-90.32085,https://i4.ypcdn.com/blob/c29621b13d274f9df12964d904261889307977b0_100x100_crop.jpg?41e4770,"If you can imagine it, we can build it.","A St. Louis irrigation, landscaping, and lawn care company specializing in sprinkler systems, drainage systems, landscape lighting. retaining walls, tree service, mulching, leaf removal and plumbing.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"debit, financing available, all major credit cards, check",,,http://www.allenoutdoorstl.com,"Bike Parking: No Price Range : Average Services: Install Retaining Walls, Landscape Lighting, Landscape Designers, Tree Consultants, Concrete Foundation Installation, Concrete Stamping, Fertilize Lawns, Fountain Installation, Install Sod, Lawn Maintenance, Pond Installation, Sprinkler Installation, Sprinkler Repair","Jo D.","Edited: 01/23/2017",five,"Had an issue after a service call. Expressed my frustration and received a call from Steve Allen wanting to fix my frustration. He took care of the issue. I appreciate his commitment to running a good company and his concern for customer satisfaction.","Byron S.",06/15/2016,one,"Should be irritation not irrigation they were into 5 weeks on a job they told us would be one week. They put down the wrong pavers and wanted to charge us $6000 to correct. We had to hire another contractor to finish the job. They put two 80 foot ruts in our lawn. Reported them to the BBB who didn't like their response and want to litigate the case. Allen hired an attorney who offered us 60 cents on the dollar to settle and wanted us to take our reviews off the web. If they did the right thing and just refunded a portion of the deposit, they wouldn't need an attorney, would they?"
2720438,844330,"2020-09-27 03:53:55","English Garden Landscape & Installation",https://www.englishgardenlandscaping.com,rjckson@hotmail.com,"(843) 412-9194",,Charleston,SC,29412,"Charleston,SC 29412","Landscape Designers & Consultants, Irrigation Consultants, Irrigation Systems & Equipment, Landscape Contractors, Landscaping & Lawn Services, Lighting Systems & Equipment, Nursery & Growers Equipment & Supplies, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",5,"3 Reviews",,,,https://i3.ypcdn.com/blob/50d7d46318005ef86ca52d46fd794819d6f6b647_100x100_crop.jpg?d9a04b5,,,"Mon - Fri: 9:00 am - 5:00 pm Sat - Sun: 10:00 am - 5:00 pm",,,check,,"English Garden Landscape and Design English Garden Landscape Design","Details on our website",,"Bob J.",09/30/2016,five,"My irrigation system quit working. I called and they came out next day to take a look at it and give me an evaluation of the system. Very knowledgeable, didn't rush the service call, and actually gave me several options for repair. VERY affordable and presented me with a written estimate, got the work done within two days and all is great. I highly recommend English Garden Landscape & Installation. I live in Dunes West and this company is the best!","Willow lake A.",05/14/2014,five,"We hired English Garden to revamp and design flower beds for our apartment community that was mostly concrete parking. The suggestions, care and work provided were awesome. The results were fantastic."
2721074,844471,"2020-09-27 03:53:55","Green-Way Irrigation & Outdoor Lighting",http://www.green-wayirrigation.com,office@green-wayirrigation.com,"(201) 447-9343",,"Midland Park",NJ,07432,"Midland Park,NJ 07432","Irrigation Systems & Equipment, Lighting Consultants & Designers, Lighting Contractors, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",,,,,,,,,"Mon - Fri: 8:00 am - 5:00 pm",,,,,,http://www.green-wayirrigation.com,,,,,,,,,
2721381,844541,"2020-09-27 03:53:55","R&O Landscape Services",http://www.randolandscape.com,rpneira@hotmail.com,"(817) 944-4592","9721 Forney Trail","Fort Worth",TX,76244,"9721 Forney Trail,Fort Worth,TX 76244","Landscaping & Lawn Services, Holiday Lights & Decorations, Landscape Contractors, Lawn Maintenance, Lighting Contractors, Masonry Contractors, Sprinklers-Garden & Lawn, Installation & Service",,,A+,32.91601,-97.29156,,,,"Mon - Sat: 7:00 am - 7:00 am Sun Closed",,,"all major credit cards, cash, check, invoicing available",,,"Primary Website",,,,,,,,,
2721510,844571,"2020-09-27 03:53:55","Hawkeye Irrigation",http://www.hawkeyeirrigation.com,ty@hawkeyeirrigation.com,"(618) 887-9440","220 N Duncan St",Marine,IL,62061,"220 N Duncan St,Marine,IL 62061","Sprinklers-Garden & Lawn, Insect Control Devices, Irrigation Consultants, Irrigation Systems & Equipment, Lawn Maintenance, Lighting Systems & Equipment, Sprinklers-Garden & Lawn, Installation & Service",,,,38.78882,-89.77819,,,,"Mon - Thu: 7:00 am - 4:00 pm","Phone: (618) 505-3593 Phone: (618) 659-0440",,paypal,,,http://www.hawkeyeirrigation.com,"Parking: Lot Specialties: Fountains",,,,,,,,
2721776,844622,"2020-09-27 03:53:55","Paul Viers Landscaping",http://www.paulvierslandscaping.com,,"(323) 206-6470","114 N Gramercy Pl","Los Angeles",CA,90004,"114 N Gramercy Pl,Los Angeles,CA 90004","Landscape Designers & Consultants, Gardeners, Irrigation Systems & Equipment, Landscaping & Lawn Services, Lighting Fixtures, Sprinklers-Garden & Lawn, Installation & Service",,,,34.073456,-118.31249,https://i3.ypcdn.com/blob/92a6d10ee0bee7036fc0bbdb79631023d08a9f32_100x100_crop.jpg?d9a04b5,"Make the worid beautiful one garden at a time",,"Mon - Sat: 9:00 am - 5:00 pm Sun Closed",,,check,,,"My Website",,,,,,,,,
2722612,844788,"2020-09-27 03:53:55",Bayscapes,http://www.bayscapesva.com,bayscapes804@gmail.com,"(804) 693-9606","11454 Goodes Ln",Saluda,VA,23149,"11454 Goodes Ln,Saluda,VA 23149","Landscape Designers & Consultants, Irrigation Systems & Equipment, Landscape Contractors, Landscaping Equipment & Supplies, Lighting Consultants & Designers, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",,,,37.52922,-76.6324,,,,"Mon - Fri: 8:00 am - 5:00 pm Sat - Sun: Open 24 Hours","Phone: (804) 694-7522",,,,,http://www.bayscapesva.com,,,,,,,,,
2722846,844835,"2020-09-27 03:53:55","Summer Rain Sprinkler Systems Inc",http://www.hunterindustries.com,info@summerrainsprinklers.com,"(203) 629-8050","288 Valley Rd","Cos Cob",CT,06807,"288 Valley Rd,Cos Cob,CT 06807","Sprinklers-Garden & Lawn, Installation & Service, Irrigation Systems & Equipment, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lighting Fixtures, Sprinklers-Garden & Lawn",,,,41.05721,-73.58343,,,,"Mon - Fri: 7:00 am - 6:00 pm",,,,,,"http://www.hunterindustries.com http://www.summerrainsprinklers.com","Services: Landscape Lighting, Sprinkler Installation",,,,,,,,
2723306,844945,"2020-09-27 03:53:55","Gardens of Babylon",http://gardensofbabylon.com,matt@gardensofbabylon.com,"(615) 244-8949","900 Rosa L Parks Blvd Ste 101",Nashville,TN,37208,"900 Rosa L Parks Blvd Ste 101,Nashville,TN 37208","Garden Centers, Clothing Stores, Florists, Florists Supplies, Garden Ornaments, Gift Baskets, Gift Shops, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn & Garden Furnishings, Lighting Fixtures, Sprinklers-Garden & Lawn, T-Shirts",4,"9 Reviews",,36.16998,-86.78915,https://i3.ypcdn.com/blob/7c8dd426a3bce114ddad5a93cc96e87cc10f1565_100x100_crop.jpg?d9a04b5,,"Gardens of Babylon Landscapes is Nashville's largest family-owned garden center and landscape company specializing in natural products and services. Since 2003, we've enjoyed inspiring and educating a greener community, and building a brand our customers can trust. Our knowledge of landscaping, passion for sustainable living, and down-to-earth personal service combine to make us the top resource for local residents and businesses needing help with smarter and healthier landscapes. Whether you need helpful advice from a garden center associate, or want to hire a trusted, creative landscape design, capable of installing and maintaining large scale commercial and residential properties...look no further.","Mon - Sun: 9:00 am - 5:00 pm",,,"paypal, cash, jcb, amex, visa, master card, discover",,,http://gardensofbabylon.com,"Parking: Lot, Private Wheelchair Accessible: Yes Price Range : Average Bike Parking: Yes","M E.",12/28/2016,three,"This garden center puts a greater emphasis on native and hard-to-find plants than big box stores, as well as providing a high quality soil amendments for our Tennessee clay! However, when I ordered several native shrubs, it took a while for them to locate them at other wholesale nurseries which delayed their planting to the drought days of summer. As a result, few flourished. I wish they had been more up front about the timing when I ordered.","Mrs. A.",10/15/2016,four,"Their selection is limited, which is understandable given its location in downtown Nashville, but there's enough variety (and a wonderful selection of house plants) that makes up for this."
2723793,845056,"2020-09-27 03:54:03","Groundscapes Inc",http://www.groundscapesne.com,Nick@groundscapesne.com,"(402) 397-5930","12234 Roberts Rd","La Vista",NE,68128,"12234 Roberts Rd,La Vista,NE 68128","Landscape Designers & Consultants, Arborists, Garden Centers, Home Centers, Irrigation Systems & Equipment, Landscape Contractors, Landscaping & Lawn Services, Lawn Maintenance, Lighting Fixtures, Masonry Contractors, Patio Builders, Ponds, Lakes & Water Gardens Construction, Snow Removal Service, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service, Tree Service","3,5","3 Reviews",A+,41.16865,-96.10628,,,"Groundscapes was founded in 2002 by husband and wife team, Nick & Lori Heimann. We are a Landscape Design-Build company that provides a wide variety of landscaping services to the Omaha Metro Area. At Groundscapes we pride ourselves on having the knowledge and skills to handle all of your home landscape needs. We've groomed our abilities over the past 20 years to create team of landscape professionals that can tackle any project. We have built our reputation on our commitment to providing quality service and by focusing on creating outdoor spaces that will last a lifetime and beyond.","Mon - Fri: 9:00 am - 5:00 pm",,,"visa, amex, cash, check, discover, master card, debit, all major credit cards, financing available",,,http://www.groundscapesne.com,,"Orion G.",03/07/2016,five,"Excellent service, guys. I love the landscaping work and design you've done. I highly recommend this team.","Tyler B.",08/25/2015,five,"Their work speaks for itself!!!"
2723831,845059,"2020-09-27 03:54:03","Arizona Rainmakers Landscape",http://azrainmakers.com,azrainmaker@msn.com,"(623) 377-9903","28320 N 177th Ave",Surprise,AZ,85387,"28320 N 177th Ave,Surprise,AZ 85387","Landscape Contractors, Building Construction Consultants, Construction Consultants, Gardeners, Landscaping & Lawn Services, Lighting Consultants & Designers, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service",,,A+,33.74066,-112.4428,,"Over 21 Years Of Experience In The Valley. Free estimates.","With more than 20 years of experience, Arizona Rainmakers is a landscape and irrigation contractor people trust in the greater Phoenix area. We are family owned and operated and we have an A+ rating as an Accredited Business with the Better Business Bureau. We are a leader in Southwest landscape and irrigation service and repairs. Whether you need us to custom-design and build a landscape for you or provide you with expert advice and recommend supplies for your landscape or irrigation projects, we are at your service. Arizona Rainmakers can help with a variety of irrigation and landscaping projects, including: В• Flagstone В• Barbecues В• Rockscapes В• Irrigation systems В• Waterfalls В• And more We are licensed, bonded and insured for your protection. Call Arizona Rainmakers for a free estimate today. Visit us online for photo galleries with samples of out work.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"amex, master card, visa",,,http://azrainmakers.com,"Services: Lawn Maintenance",,,,,,,,
2723850,845062,"2020-09-27 03:54:03","Cougar Irrigation, LLC",http://www.cougarirrigation.com,service@cougarirrigation.com,"(512) 769-2351","3800 N Lamar Blvd",Austin,TX,78756,"3800 N Lamar Blvd,Austin,TX 78756","Sod & Sodding Service, Irrigation Systems & Equipment, Landscape Contractors, Lighting Systems & Equipment, Sprinklers-Garden & Lawn, Installation & Service",,,A+,30.30585,-97.74292,,"Head to Head the best systems are Cougars!","High Quality and High Effeciency Irrigation Systems.","Mon - Fri: 7:45 am - 4:30 pm Sat: 7:45 am - 1:15 pm Sun Closed",,,"amex, check, discover, master card, paypal, visa",,,"Irrigation Systems Repair and Maintenance",,,,,,,,,
2724219,845152,"2020-09-27 03:54:03","West End Services",http://www.westendservices.com,mail@westendservices.com,"(858) 573-0842","8260 Engineer Rd","San Diego",CA,92111,"8260 Engineer Rd,San Diego,CA 92111","Landscaping & Lawn Services, General Contractors, Irrigation Systems & Equipment, Landscape Contractors, Lighting Consultants & Designers, Painting Contractors, Retaining Walls, Sprinklers-Garden & Lawn",1,"1 Review",,32.82509,-117.14789,,,"West End Services is a multi-service company like no other service provider in San Diego. Because of the wide array of services offered, West End Services is uniquely able to provide services normally provided by multiple contractors. This structure allows for cost effective and efficient completion of projects, as well as streamlined outdoor maintenance of commercial properties. With knowledge of all aspects of a property's outdoor systems, West End Services is able to quickly diagnose and resolve repairs, make appropriate upgrades, and offer the very best recommendations to maintain an attractive property for owners, tenants and managers. West End Services specializes in cost effective packages that can transform a tired looking commercial property into a property that has excellent curb appeal and tenant demand while maximizing and commanding the highest rent possible from the space, ""Building Your Equity."" West End Services has three divisions: West End Services Blue ( which includes Advanced Sprinkler and Drainage Repair ( ASDR ) and Advanced Backflow Service ) which provides complete irrigation and backflow services, West End Services Green providing complete commercial landscape maintenance services, West End Services Black which provides complimentary asphalt and concrete maintenance to our Green division customers.","Mon - Fri: 8:00 am - 4:00 pm Sat - Sun Closed","Primary Phone: (858) 271-1808 Phone: (858) 271-1808 Fax: (858) 573-0843 TollFree: (866) 782-7473",,"debit, all major credit cards, mastercard, visa, amex, discover",,"West End Svc","http://www.westendservices.com http://www.westendservices.com/cgi-sys/suspendedpage.cgi","Wheelchair Accessible: Yes Parking: Lot, Free",crondon,06/12/2012,one,"horrible customer service didnt help me at all and my lawn looks like crap",,,,
2724276,845172,"2020-09-27 03:54:03","Rain-N-Shine Irrigation & Landscape Lighting",,Rain-N-Shine@hotmail.com,"(205) 987-4770","Birmingham 35244",Birmingham,AL,35244,"Birmingham 35244,Birmingham,AL 35244","Landscape Designers & Consultants, Irrigation Systems & Equipment, Landscape Contractors, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Lighting Fixtures, Sprinklers-Garden & Lawn",5,"1 Review",A+,33.3733,-86.8104,,,,"Mon - Fri: 7:30 am - 4:00 pm",,,"visa, discover, mastercard, all major credit cards",,,,,iv4856,07/27/2006,five,"I have finally found a company that does what they say for a very reasonable charge! Would definety use again!",,,,