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
5304638,1577096,"2020-09-27 05:02:18","Natural Environments",http://www.naturalenvironments.com,rzander@naturalenvironments.com,"(214) 357-5855","2669 Myrtle Springs Ave Ste 104",Dallas,TX,75220,"2669 Myrtle Springs Ave Ste 104,Dallas,TX 75220","Altering & Remodeling Contractors, Architects, Architects & Builders Services, Architectural & Construction Specifications, Building Contractors, Deck Builders, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Lawn Maintenance, Patio Builders, Sprinklers-Garden & Lawn, Swimming Pool Construction, Swimming Pool Designing & Consulting, Tree Service",5,"1 Review",A+,32.8689,-96.88522,,,,"Mon - Sat: 9:00 am - 5:00 pm",,,"no credit cards",,,http://www.naturalenvironments.com,,"S M.",06/13/2012,five,"Ron Zander has worked for me on numerous projects over the years and I know I can always count on him for a great outcome. He's an amazing landscape designer who owns and operates the landscape architectural company, Natural Environments. He always dreams up the most imaginative and cost effective solutions. He fixed the drainage on one of my properties that was prone to flooding and was always damp in the rainy season in 2007 and it's been great ever since! He recently created the plan and supervised the reconstruction of my pool and later re-did my entire back yard. This was a big project and he completed it in 6 weeks and on budget. In fact, I ended up able to get a beautiful stone covered spa that we never expected would fit. I felt strongly enough about my work with him that I wanted to post this and I highly recommend him!",,,,
5369649,1605217,"2020-09-27 05:05:24","Outdoor Solutions",,outdoorsolutionsms@gmail.com,"(601) 906-7600","814 Depot Dr Ste B",Brandon,MS,39042,"814 Depot Dr Ste B,Brandon,MS 39042","Landscape Designers & Consultants, Architects, Landscape Contractors, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,32.303802,-89.96403,https://i2.ypcdn.com/blob/904e8124ed4c3d742d33e322bae7deba938b344b_100x100_crop.jpg?adceb05,,,"Mon - Fri: 8:00 am - 5:00 pm","Fax: (601) 706-4316",,"check, all major credit cards",,,,,,,,,,,,
5520563,1651265,"2020-09-27 05:11:30","Desert Glass Pools, Inc.",http://desertglasspools.com,,"(760) 895-8787",,"Indian Wells",CA,92210,"Indian Wells,CA 92210","Tile-Contractors & Dealers, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,A+,,,https://i1.ypcdn.com/blob/fc04ef8c58eac8e242da64987e25618f1a1eaa52_100x100_crop.jpg?8ad0f92,"Desert Glass Pools, Inc.","Desert Glass Pools, Inc.",,,,"check, cash",,,desertglasspools.com,,,,,,,,,
5524464,1652470,"2020-09-27 05:11:33","Acme Pool Construction Inc.",http://www.acmepoolgr.com,contact@acmepoolgr.com,"(616) 677-7665","13745 Ironwood Dr NW","Grand Rapids",MI,49534,"13745 Ironwood Dr NW,Grand Rapids,MI 49534","Tile-Contractors & Dealers, Building Specialties, Home Centers, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,A+,43.01809,-85.79054,https://i1.ypcdn.com/blob/f880e0888e064a473c0e1b9613071ced81e29d3b_100x100_crop.jpg?8ad0f92,"For Good People, Great Products, and Expert Advice!!!","Specializing in building custom shotcrete/concrete free form pools & spas. From something simply relaxing to completely astonishing!","Mon - Fri: 10:00 am - 5:00 pm Sat - Sun Closed",,,"check, debit, discover, visa, mastercard",,"Acme Pool Construction Inc",http://www.acmepoolgr.com,,,,,,,,,
5539374,1656818,"2020-09-27 05:12:02","Above and Beyond Pool Remodeling",http://aboveandbeyondpoolremodeling.com,abovebeyondpools@outlook.com,"(480) 360-1281","815 E Harwell Rd",Gilbert,AZ,85234,"815 E Harwell Rd,Gilbert,AZ 85234","Swimming Pool Construction, Building Specialties, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service, Tile-Cleaning, Refinishing & Sealing, Tile-Contractors & Dealers",5,"5 Reviews",,33.3767,-111.77288,https://i1.ypcdn.com/blob/4349f99c63cdcecb04653274efc45e4b8f094e9e_100x100_crop.jpg?8ad0f92,"""Success is a bi product of helping others""",,"Mon - Fri: 8:00 am - 4:00 pm",,,"check, financing available, no credit cards",,"Above & Beyond Pool Remodeling",http://aboveandbeyondpoolremodeling.com,,"Melanie M.",03/01/2017,five,"Above and Beyond Pool Remodeling has been a pleasure to work with. I was referred to them by a family member. I wanted to add a fire pit outside in my backyard with a seating area. They came to give me an estimate on what I wanted. They helped me with the designed and location of the fire pit area since I really wasnВ’t too sure what I wanted. They were not pushy and listened to my ideas before they gave a suggestion to the design. Their estimate was reasonable when I compared it to other estimates I had. They schedule a day to start the work and finished on time. I love the end result. It was exactly what I had wanted. I would definitely use them again if I decided to do anything else to my yard.","Kali W.",01/14/2017,five,"Above & Beyond Pool Remodeling renovated our swimming pool right before the Christmas holiday (2016). Their team was efficient, friendly, very clean and of course respectful of our home and family while working onsite. We could NOT have chosen a better team of individuals to give our backyard and swimming pool the ""face lift"" it needed. This company is highly skilled and professional in their respective trade and anyone reading this would be crazy to not hire them!"
5591224,1670971,"2020-09-27 05:13:09","Padilla Pools",http://www.padillapools.com,info@padillapools.com,"(408) 279-2629","304 W Hedding St","San Jose",CA,95110,"304 W Hedding St,San Jose,CA 95110","Gutters & Downspouts, Building Specialties, Gutters & Downspouts Cleaning, Roofing Contractors, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service, Tile-Contractors & Dealers",,,A+,37.34904,-121.91084,https://i1.ypcdn.com/blob/c021539fa7e88555e7ece7687704edc43bafc92d_100x100_crop.jpg?8ad0f92,"""Installing All The Latest Materials and Equipment""",,"Mon - Fri: 8:00 am - 4:00 pm","Phone: (408) 279-4877",,,,,http://www.padillapools.com,"Parking: Lot, Private Wheelchair Accessible: Yes Specialties: Quartz, Pebbles",,,,,,,,
16013550,2025888,"2020-09-27 05:47:27","Lucas Lagoons Inc",http://lucaslagoons.com,info@lucaslagoons.com,"(941) 366-7700","809 Faith Ave",Osprey,FL,34229,"809 Faith Ave,Osprey,FL 34229","Landscape Designers & Consultants, Interior Designers & Decorators, Landscape Contractors, Swimming Pool Dealers, Swimming Pool Designing & Consulting",,,,27.18996,-82.47615,,,"Lucas Lagoons has been building timeless outdoor creations, from concept to completion, one client at a time for over twenty years. We will ensure your lagoon style swimming pool, tropical paradise, grotto waterfall, and residential or commercial water feature is an outdoor masterpiece designed to last a lifetime.","Mon - Fri: 9:00 am - 5:00 pm","Phone: (941) 800-4395 Primary Phone: (941) 800-4395 Phone: (941) 882-3934",,"all major credit cards, check, debit",,"Lucas Lagons","http://lucaslagoons.com https://lucaslagoons.com",,,,,,,,,
19486672,2847578,"2020-09-27 07:08:57","P&P Septic & Excavating Contractor",https://pandpexcavating.com,paull@csinet.net,"(219) 898-3033",,"La Porte",IN,46350,"La Porte,IN 46350","Excavation Contractors, Driveway Contractors, Septic Tanks & Systems, Septic Tanks & Systems-Wholesale & Manufacturers, Stump Removal & Grinding, Swimming Pool Construction, Swimming Pool Designing & Consulting, Tree Service, Trenching & Underground Services, Woodworking",,,,,,https://i1.ypcdn.com/blob/499e544f9256f541abd0c9d788c8ad1a78360994_100x100_crop.jpg?8ad0f92,"Delivering Quality Service To The La Porte Area Since 1968","P&P Septic & Excavating Contractor, in La Porte, IN, is the area's leading excavating company serving La Porte and surrounding areas. We offer excavating, gravel driveways, in ground pool digging and grading, telehandling, backhoe work, tree and stump removal, skid steer work with tracks, brush clearing, mowing, storm clean up, post hole digging and trenching, small woodworking projects, septic system work and much more. We are also state certified for septic systems. For more information, contact P&P Septic & Excavating Contractor in La Porte.","Mon - Sun: 8:00 am - 7:00 pm",,,"cash, check",,,"Primary Website",,,,,,,,,
19527136,2860728,"2020-09-27 07:10:22","Backyard Pools LLC",http://backyardpoolsllc.com,chris@backyardpoolsllc.com,"(336) 209-3777",,"High Point",NC,27265,"High Point,NC 27265","Sauna Equipment & Supplies, Building Specialties, Spas & Hot Tubs, Spas & Hot Tubs-Repair & Service, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service, Tree Service",,,A,,,,"Turn your Traditional Backyard into Something to talk about","*Inground Pools Fiberglass Pools *Above Ground Pools *Vinyl Liner Replacements *Renovations & Repair *And Much More","Mon - Fri: 8:00 am - 6:00 pm Sat: 8:00 am - 12:00 pm Sun Closed",,,"master card, visa, check, cash, financing available",,,http://backyardpoolsllc.com,,,,,,,,,
19539656,2864799,"2020-09-27 07:10:48","BDS Lawn & Landscape",http://www.bdslandscape.com,,"(706) 676-5535",,Rome,GA,30161,"Rome,GA 30161","Landscape Contractors, Concrete Contractors, Drainage Contractors, Grading Contractors, Irrigation Systems & Equipment, Landscape Designers & Consultants, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn Maintenance, Masonry Contractors, Patio Builders, Retaining Walls, Stamped & Decorative Concrete, Stump Removal & Grinding, Swimming Pool Construction, Swimming Pool Designing & Consulting, Tree Service",,,,,,,"We beautify your property with superior landscape design and installation.","BDS Landscape is your one stop solution for all your landscaping needs! We beautify your property with full service landscape design & installation, commercial and residential service, outdoor living spaces, patios, walkways and retaining walls, sodding, seeding and aeration, irrigation system installation and repair, tree and stump removal, tree trimming, grading, hauling and bobcat work. Call us today for a free estimate!","Mon - Fri: 8:00 am - 5:00 pm",,,,,,http://www.bdslandscape.com,,,,,,,,,
20347233,3091563,"2020-09-27 07:32:36","Aquashapes International",http://www.aquashapesinternational.com,info@aquashapesinternational.com,"(561) 818-8835",,"Palm City",FL,34990,"Palm City,FL 34990","Fountains Garden, Display, Etc, Landscape Designers & Consultants, Ponds, Lakes & Water Gardens Construction, Swimming Pool Designing & Consulting, Tropical Fish",,,,,,,"Service Above Self. Come Home to your Vacation!","- Designing & Building beautiful environments since 1979. - Commercial and Residential. - Well trained crew of world class craftsmen working together for over 12 years. - International Experience. - Biologically Balanced Swimming Pools. - Competitive Pricing. Superior Work.",,,,check,,,"Aquashapes Website",,,,,,,,,
20348247,3091851,"2020-09-27 07:32:36","Quality Pools & Patios",http://www.qualitypoolsandpatios.com,pools@qualitypoolsandpatios.com,"(229) 245-9554","4609 Bemiss Rd",Valdosta,GA,31605,"4609 Bemiss Rd,Valdosta,GA 31605","Swimming Pool Construction, Building Specialties, Concrete Contractors, Landscape Designers & Consultants, Swimming Pool Designing & Consulting",,,,30.92824,-83.2456,https://i2.ypcdn.com/blob/d08206ab57b5a9e020a27e7faf3cdb684d5b8f50_100x100_crop.jpg?8ad0f92,,"Quality Pools & Patios is a turnkey pool contractor specializing in total outdoor pool and landscape construction. From Swimming Pools to Palm Trees, We do it all.","Mon - Fri: 9:00 am - 5:00 pm",,,"financing available",,,http://www.qualitypoolsandpatios.com,,,,,,,,,
20351330,3092741,"2020-09-27 07:32:45","Design Pools of East Texas",,,"(903) 962-5236","230 W Beachwood Loop",Trinidad,TX,75163,"230 W Beachwood Loop,Trinidad,TX 75163","Swimming Pool Designing & Consulting, Landscape Designers & Consultants, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Repair & Service",,,A+,32.23804,-96.12906,,,,"Mon - Sun: 7:00 am - 5:00 pm",,,,,,,,,,,,,,,
20353321,3093272,"2020-09-27 07:32:49","Clear Image Pool & Home Restoration Services",,clearimage89@yahoo.com,"(602) 810-5963","PO Box 50791",Mesa,AZ,85208,"PO Box 50791,Mesa,AZ 85208","Swimming Pool Repair & Service, Electricians, Fire & Water Damage Restoration, General Contractors, Landscape Contractors, Landscape Designers & Consultants, Painting Contractors, Plumbers, Roofing Contractors, Roofing Services Consultants, Swimming Pool Construction, Swimming Pool Designing & Consulting, Swimming Pool Management",,,,33.398415,-111.6513,,,,"Mon - Sun: Open 24 Hours",,,,,,,,,,,,,,,
20356889,3094283,"2020-09-27 07:32:58","Starwood Masonry Inc",,mconstruction501@verizon.net,"(215) 688-0000",,,,,,"Landscape Designers & Consultants, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,,,,,,,"Mon - Sun: Open 24 Hours",,,,,,,,,,,,,,,
20357206,3094377,"2020-09-27 07:32:58","Rusk Pools LLC",https://www.ruskpools.com,matt@ruskllc.com,"(973) 875-8883","126a South St",Morristown,NJ,07960,"126a South St,Morristown,NJ 07960","Landscape Contractors, Landscape Designers & Consultants, Masonry Contractors, Patio Builders, Swimming Pool Construction, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,,40.79325,-74.47732,,,,,,,,,,"https://www.ruskpools.com http://www.angieslist.com/companylist/us/nj/sussex/erik-enterprises-reviews-3762374.htm http://ruskllc.com http://www.tvspj.com",,,,,,,,,
20357562,3094473,"2020-09-27 07:32:58","Selective Designs",http://www.georgiapools.com,info@selectivedesigns.com,"(770) 631-1550","105 Depot Ct Ste A","Peachtree City",GA,30269,"105 Depot Ct Ste A,Peachtree City,GA 30269","Landscape Designers & Consultants, Landscape Contractors, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Designing & Consulting",3,"2 Reviews",A+,33.43805,-84.60657,,,,"Mon - Fri: 9:00 am - 5:00 pm Sat Closed",,,visa,,"Selective Designs, L.L.C. Selective Holdings Inc. Selective Designs Landscaping","http://www.georgiapools.com http://selectivedesigns.com","Parking: Lot Wheelchair Accessible: Yes",croberts313,03/16/2012,one,"they did ok work",Nelms,05/20/2009,five,"The designers are so creative and have such an eye for detail. They created such a relaxing and enjoyable living area for us. We will use them again and again in the future! The girls in the office are wonderful too!"
20359513,3095039,"2020-09-27 07:33:04","Alderete Pools",http://www.alderetepools.com,aps@alderetepools.com,"(949) 492-7289",,"San Clemente",CA,92672,"San Clemente,CA 92672","Landscape Designers & Consultants, Masonry Contractors, Solar Energy Equipment & Systems-Dealers, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,A+,,,https://i2.ypcdn.com/blob/07501e8c854c9f31f3f9d3b7e6e9bdc159d9d3e2_100x100_crop.jpg?8ad0f92,"Custom-tailored, luxurious designs with award winning results have been our specialty for 30 years.",,"Mon - Sat: 9:00 am - 5:00 pm Sun Closed","Fax: (949) 361-8894 TollFree: (800) 492-7289",,"debit, all major credit cards, check, financing available, travelers checks",,,http://www.alderetepools.com,,,,,,,,,
20370444,3098130,"2020-09-27 07:33:29","Outdoor Artisans",,,"(913) 608-7892",,Lenexa,KS,66215,"Lenexa,KS 66215","Stamped & Decorative Concrete, Landscape Contractors, Landscape Designers & Consultants, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,,,,"Why hire just any company? When you can hire true Artisans.",,"Mon - Fri: 8:00 am - 5:00 pm Sat - Sun: 9:00 am - 3:00 pm",,,"all major credit cards, check, financing available",,"Artisan Outdoors Artisan Pools",,,,,,,,,,
20371660,3098481,"2020-09-27 07:33:29","KDC Associates",http://www.kdcassociates.com/,info@your-web-domain.com,"(432) 686-8001","4400 N Big Spring St",Midland,TX,79705,"4400 N Big Spring St,Midland,TX 79705","Landscape Designers & Consultants, Environmental & Ecological Consultants, Irrigation Consultants, Land Companies, Land Planning Services, Landscape Contractors, Landscaping & Lawn Services, Swimming Pool Designing & Consulting",,,A+,32.0421,-102.08525,,,,"Mon - Fri: 8:00 am - 5:00 pm",,,,,,http://www.kdcassociates.com,"Services: Landscape Designers",,,,,,,,
20373230,3098944,"2020-09-27 07:33:30","Backyard Escapes",,,"(201) 327-3427","80 West St","Midland Park",NJ,07432,"80 West St,Midland Park,NJ 07432","Landscape Designers & Consultants, Patio Builders, Swimming Pool Designing & Consulting",,,,40.99428,-74.14951,,,,,,,,,,,,,,,,,,,
20373293,3098963,"2020-09-27 07:33:30","Rusk Pools",http://ruskllc.com/services,matt@ruskllc.com,"(973) 903-8990",,Morristown,NJ,07960,"Morristown,NJ 07960","Landscaping & Lawn Services, Landscape Contractors, Landscape Designers & Consultants, Masonry Contractors, Patio Builders, Retaining Walls, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,,,,,"Family owned and operated. quality craftmanship","Mon - Sun: Open 24 Hours",,,cash,,,http://ruskllc.com/services,,,,,,,,,
20376578,3099889,"2020-09-27 07:33:37","Firlit Landscape Design",http://www.firlitdesign.com,spf@firlitdesign.com,"(585) 663-2330",,Rochester,NY,14612,"Rochester,NY 14612","Landscape Designers & Consultants, Home Design & Planning, Landscape Contractors, Landscaping & Lawn Services, Patio Builders, Residential Designers, Swimming Pool Designing & Consulting",,,,,,https://i1.ypcdn.com/blob/b5879f89f8a8b66996af7da84dce949a6633f58b_100x100_crop.jpg?8ad0f92,"Taking pride in our work and our comitment to excellence are the underlying principles that drive us to produce the quality work we do.","Firlit Landscape Design is a full service design and construction company capable of providing a variety of services. With over 15 years of educational, design, and installation experience, you can be assured that your project will not only look good on paper, but it will also be installed properly with the highest craftsmanship.",,,,,,,http://www.firlitdesign.com,"Services: Consultation, Landscape Design, Plantings, Walkways, Patios, Pool Projects, Retaining Walls, Steps, Water Features, Lighting, Special Features.",,,,,,,,
20378631,3100470,"2020-09-27 07:33:48","Midwest Outdoor Concepts",http://www.midwestoutdoorconcepts.com,joehatfield84@gmail.com,"(479) 619-7251","24455 Honey Creek Rd","Sulphur Springs",AR,72768,"24455 Honey Creek Rd,Sulphur Springs,AR 72768","Swimming Pool Designing & Consulting, General Contractors, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Swimming Pool Repair & Service",,,,36.47831,-94.57105,,,,"Mon - Sat: 7:00 am - 5:00 pm Sun Closed",,,"cash, check, visa, debit, mastercard, discover",,,"Primary Website",,,,,,,,,
20383208,3101776,"2020-09-27 07:33:58","Downunda Pools",http://www.downundapools.com,swim@downundapools.com,"(281) 236-4344",,,,,,"Landscape Designers & Consultants, Landscape Contractors, Patio Builders, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,A+,,,https://i2.ypcdn.com/blob/6d5a5e220f4d70bb955454eb2922db37f3fab352_100x100_crop.jpg?8ad0f92,,,"Mon - Fri: 9:00 am - 5:00 pm Sat: 10:00 am - 4:00 pm Sun Closed",,,"check, financing available",,,"swimming pool and landscape design","Services: Landscape Designers",,,,,,,,
20383409,3101833,"2020-09-27 07:33:58","Crystal Cove Pools",http://www.crystalcovepools.com,crystalcovepools@gmail.com,"(949) 706-0495",,"San Clemente",CA,92673,"San Clemente,CA 92673","Landscape Designers & Consultants, Private Swimming Pools, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,,,,,,,,,,,,"Orange County Swimming Pool Builder",,,,,,,,,
20384568,3102174,"2020-09-27 07:34:08","Bushwackers Landscaping",https://www.bushwackerslandscaping.com,chad@bushwackerslandscaping.com,"(704) 463-0174","44543 Hwy 52 N",Richfield,NC,28137,"44543 Hwy 52 N,Richfield,NC 28137","Landscape Designers & Consultants, Gardeners, General Contractors, Irrigation Systems & Equipment, Landscape Contractors, Lawn Maintenance, Patio Builders, Swimming Pool Designing & Consulting",,,A+,35.47496,-80.2728,,,"Turn to the experts at Bushwackers Landscaping for all your landscaping and lawn care needs. We are a full service design, installation and landscaping maintenance company specializing in design services for landscaping, hardscapes and water features. We serve residential and commercial clients as well as homeowner's associations. Bushwackers Landscaping believes in providing each client high quality and exceptional service through the relationships we build and the personal attention we give each landscaping project.","Mon - Fri: 8:00 am - 4:00 pm",,,"master card, visa",,,https://www.bushwackerslandscaping.com,,,,,,,,,
20385366,3102394,"2020-09-27 07:34:08",Liquidscapes,http://www.liquidscapes.net,howard@liquidscapes.net,"(908) 752-9650",,,,,,"Deck Builders, Landscape Contractors, Landscape Designers & Consultants, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,,,,,,"Mon - Fri: 7:00 am - 6:00 pm Sat: 9:00 am - 5:00 pm",,,,,,http://www.liquidscapes.net,,,,,,,,,
20386680,3102777,"2020-09-27 07:34:08","Landesign, Design & Build Inc",http://www.houzz.com/pro/fugate2140,michaelfugate@me.com,"(859) 983-9272","203 Southport Drive",Lexington,KY,40503,"203 Southport Drive,Lexington,KY 40503","Landscape Designers & Consultants, Landscape Contractors, Landscaping & Lawn Services, Patio Builders, Swimming Pool Designing & Consulting",,,,38.02299,-84.52611,https://i1.ypcdn.com/blob/953ca17bf8ab9e4584822dbfa283ab823326e87f_100x100_crop.jpg?8ad0f92,,"Site planning, garden design and installation. Patio, walls and stone features.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,cash,,,"portfolio current",,,,,,,,,
20387654,3103052,"2020-09-27 07:34:10","nuView Pools & Landscape",https://nuviewoutdoor.com,info@nuviewoutdoor.com,"(480) 758-3100","1176 E Warner Rd #211",Gilbert,AZ,85296,"1176 E Warner Rd #211,Gilbert,AZ 85296","Swimming Pool Designing & Consulting, Landscape Contractors, Landscape Designers & Consultants, Swimming Pool Construction",,,,33.33691,-111.76492,,"Bring a nuView to Your Home",,"Mon - Fri: 8:00 am - 6:00 pm Sat - Sun Closed",,,"visa, mastercard, all major credit cards, amex, discover, cash, check, financing available",,,"Primary Website Contact",,,,,,,,,
20392215,3104356,"2020-09-27 07:34:12","Grotto Pool Designs",http://grottopools.com,jason@grottopools.com,"(405) 919-3014",,,,,,"Swimming Pool Designing & Consulting, Landscape Designers & Consultants, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,A,,,https://i1.ypcdn.com/blob/e1b945675330fa1f26f4571779baae76c364f5e1_100x100_crop.jpg?8ad0f92,,"Grotto Pool Designs Provides Custom-Designed Pools, Custom Hot Tub\Spa, Pool Remodel, Pool Enclosures, Saltwater Conversions, Pool Covers, Pool Inspection and Pool Services and Repairs to the Newcastle, OK area.","M-Sa 9am-7pm, Su Closed (After-hours appointments are available.)","MobilePhone: (405) 919-3014",,"amex, cash, check, discover, master card, visa",,,http://grottopools.com/,,,,,,,,,
20392256,3104368,"2020-09-27 07:34:12","Green Scene Landscaping and Pools",http://www.greenscenelandscape.com,marie@greenscenelandscape.com,"(818) 280-0420","21220 Devonshire St Ste 102",Chatsworth,CA,91311,"21220 Devonshire St Ste 102,Chatsworth,CA 91311","Landscape Designers & Consultants, Concrete Contractors, Landscape Contractors, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,A+,34.25695,-118.59448,https://i1.ypcdn.com/blob/bd4e58fa6d0c8cfb69d215d275c71bf0589d3af7_100x100_crop.jpg?8ad0f92,,"The Green Scene Landscaping and Pools is an award winning landscape design and construction firm specializing in swimming pools and spas, outdoor kitchens, outdoor fire features, shade covers, landscaping, hardscape, ponds, water features, and outdoor rooms.","Mon - Fri: 8:30 am - 5:00 pm Sat: 9:00 am - 12:00 pm Sun Closed","Fax: (818) 280-0424 TollFree: (800) 675-5296",,"amex, discover, master card, visa",,,"Photo galleries, videos, and FAQs","Services: Landscape Designers",,,,,,,,
20393884,3104835,"2020-09-27 07:34:12","Gardens, Inc.",http://gardensservices.com,,"(626) 421-3658","2222 Foothill Blvd.,E-194","La Canada Flintridge",CA,91011,"2222 Foothill Blvd.,E-194,La Canada Flintridge,CA 91011","Landscape Designers & Consultants, Swimming Pool Designing & Consulting",,,,34.21601,-118.22559,https://i1.ypcdn.com/blob/62b9d7184524595d8054a1906aebc0e779a578b2_100x100_crop.jpg?8ad0f92,"Quality Work at Affordable Prices!","Our company was founded in 1995 and quickly earned a solid reputation as a uniquely creative organization that takes pride in every project it undertakes. Our award winning work can be seen at upscale home and commercial properties throughout Southern California. Our awards include 1st place unlimited pond and waterfall installation 5 years in a row, special effects with best use of unique materials, 1st place large commercial landscape installation and the buff heights award.","Mon - Sun: 6:00 am - 6:00 pm",,,"all major credit cards, check, cash, money order",,,Website,,,,,,,,,
20394913,3105147,"2020-09-27 07:34:15","Wolbers-Possehn Pools Ponds & Landscapes",http://www.wpdesigns.us,tina@wppoolscapes.com,"(616) 527-9190","1276 N State Rd",Ionia,MI,48846,"1276 N State Rd,Ionia,MI 48846","Swimming Pool Equipment & Supplies, Building Specialties, Chlorine, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Spas & Hot Tubs, Spas & Hot Tubs-Repair & Service, Spas & Hot Tubs-Wholesale & Manufacturers, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers, Swimming Pool Repair & Service",,,A+,43.006,-85.07497,,,,"Mon: 9:00 am - 5:30 pm Fri: 9:00 am - 5:30 pm Sat: 9:00 am - 12:00 pm",,,"amex, master card, visa",,,http://www.wpdesigns.us,,,,,,,,,
20401676,3107078,"2020-09-27 07:34:34","MB&Z Landscaping",http://www.mblandscapinginc.com,moteri@comcast.net,"(609) 868-6149",,,,,,"Landscape Designers & Consultants, Landscape Contractors, Landscaping & Lawn Services, Ponds, Lakes & Water Gardens Construction, Swimming Pool Designing & Consulting",,,,,,,"MB&Z's customer wants the very best in design & quality craftsmanship.",,,,,,,,http://www.mblandscapinginc.com,,,,,,,,,
20401686,3107081,"2020-09-27 07:34:34",GreatX-scapes,,bobbyalexiogreatxscapes@gmail.com,"(619) 729-0581",,,,,,"Landscape Designers & Consultants, Ponds, Lakes & Water Gardens Construction, Swimming Pool Construction, Swimming Pool Designing & Consulting",5,"1 Review",,,,,,,,,,,,,,,mttconway,07/29/2011,five,"very professional, great work, my house could be in homes and garden now !!!!!",,,,
20401854,3107129,"2020-09-27 07:34:34","Kelly Pools",,kellypoolspgh@gmail.com,"(412) 417-4064","323 Brandywine Dr",Irwin,PA,15642,"323 Brandywine Dr,Irwin,PA 15642","Landscape Designers & Consultants, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Management",,,A+,40.35072,-79.66866,,,,"Mon - Fri: 4:00 pm - 9:00 pm Sat - Sun: 7:00 am - 5:00 pm","4124174064: (412) 417-4064",,"check, all major credit cards, financing available, debit",,,,,,,,,,,,
20407854,3108840,"2020-09-27 07:34:40","Zierden Waterfalls Company",,zierdenwaterfalls@gmail.com,"(916) 420-0654",,Sacramento,CA,95829,"Sacramento,CA 95829","Fountains Garden, Display, Etc, Designing Engineers, Landscape Contractors, Landscape Designers & Consultants, Swimming Pool Designing & Consulting",,,,,,,"If you can imagine it, I'm sure we can build it! Thank you in advance, Ron Zierden ~ZIERDEN WATERFALLS~ We love to create and make your dreams a reality!","The options are endless. Most of the new homes in the area have small backyards and a steep grade. Big or small, grades are no problem! We have created breathtaking illusions with grades. some have reminded me of fresh spring sun melting the winter snow away from the mountains. We proudly encourage our new customers to ask for referrals from businesses and home owners we have worked with over the years. We have received numerous awards for outstanding workmanship and inventive, cutting edge designs. We want to design and create a new vacation just step away in your own backyard, your own natural paradise with a waterfall wonderland.",,,,,,,,,,,,,,,,
20408602,3109059,"2020-09-27 07:34:47","Yuba River Swimming Holes and Pools",http://www.yubariverswimmingholes.com,jillkill@yahoo.com,"(530) 852-1888",,"Grass Valley",CA,95949,"Grass Valley,CA 95949","Landscape Designers & Consultants, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,,,,,,,,,,,,,http://www.yubariverswimmingholes.com,,,,,,,,,
20410184,3109518,"2020-09-27 07:34:47","Mosquito Posse",,info@mosquitoposse.com,"(402) 996-0770",,Omaha,NE,68136,"Omaha,NE 68136","Landscape Designers & Consultants, Pest Control Services, Playground Equipment, Swimming Pool Designing & Consulting, Wedding Planning & Consultants",,,A+,,,,,,"Mon - Fri: 8:30 am - 6:00 pm Sat: 9:00 am - 5:00 pm Sun: 10:00 am - 5:00 pm",,,"visa, master card, amex, check",,,,,,,,,,,,
20412748,3110242,"2020-09-27 07:34:51","Green Island Design & Maintenance",http://www.greenislanddesign.com,Info@greenislanddesign.com,"(631) 235-3953","597 Old Country Rd","Deer Park",NY,11729,"597 Old Country Rd,Deer Park,NY 11729","Landscape Designers & Consultants, Landscape Contractors, Masonry Contractors, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,40.7793,-73.31688,,,,"Mon - Sat: 8:00 am - 6:00 pm Sun Closed","Phone: (631) 266-1800",,"all major credit cards, amex, carte blanche, company card, diners club, discover, jcb, mastercard, visa",,"Green Island Design",http://www.greenislanddesign.com,,,,,,,,,
20413560,3110468,"2020-09-27 07:34:51","Lidyoff Landscape Development Co.",http://www.lidyofflandscape.com,sharon@lidyofflandscape.com,"(559) 276-1090",,Fresno,CA,93722,"Fresno,CA 93722","Landscape Designers & Consultants, Building Specialties, Golf Course Construction, Lake & Pond Construction, Landscape Contractors, Landscaping & Lawn Services, Ponds, Lakes & Water Gardens Construction, Private Golf Courses, Swimming Pool Designing & Consulting",,,,,,,,"Lidyoff Landscape Development CO. (559) 276-1090, 4460 W. Shaw Ave. # 112 Fresno, CA 93722 is a leading Landscaping Contractor Specializing in Commercial Landscaping, Residential landscaping, Golf Greens, Putting Greens, Public Works, Irrigation, WaterFall Construction, Outdoor Kitchens, Outdoor Entertainment Centers, Pond Development, Land Development & drainage serving the Fresno & Central California since 1965. Our work also includes residential golf course design and construction.The Lidyoff team of highly skilled craftsman will work closely with the architects, engineers and developers to create and construct an outdoor living environment that is best suited to fit the theme of the project. Most important, we will counsel with you to put the finishing touch on your present home and or next project.","Mon - Fri: 9:00 am - 5:00 pm","TollFree: (800) 871-1090",,"check, paypal",,,http://www.lidyofflandscape.com,"Services: Landscape Designers",,,,,,,,
20414031,3110600,"2020-09-27 07:34:51","Pool Garden and Beyond",http://www.poolgardenandbeyond.com,,"(949) 244-6501","4098 Brook Hills Rd",Fallbrook,CA,92028,"4098 Brook Hills Rd,Fallbrook,CA 92028","Landscape Designers & Consultants, Gardeners, Sprinklers-Garden & Lawn, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",5,"1 Review",,33.31439,-117.21326,,,,,,,,,,http://www.poolgardenandbeyond.com,,"Christian L.",01/02/2017,five,"Used them for landscaping for the past 2 years. The work is excellent and they come every week. Lawn Plan, Aeration, Irrigation, Sprinklers, Disease Control, Fertilization, Fire Ant Control, Grub Control, Insect Control, Lime Application, Natural/Organic Lawn Care, Nuisance Pest Control, Seeding...",,,,
20415847,3111098,"2020-09-27 07:34:56","Ocean Blue Pools and Landscaping",,ben@bhibuilders.com,"(760) 803-9747","810 Los Vallecitos Blvd","San Marcos",CA,92069,"810 Los Vallecitos Blvd,San Marcos,CA 92069","Landscape Designers & Consultants, Landscape Contractors, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,A+,33.13962,-117.18028,,,"Full Service Pool and Landscape Contractor",,,,check,,,,,,,,,,,,
20419410,3112102,"2020-09-27 07:35:00","Savannah Pool Services Unlimited, LLC",http://www.savpools.com,Pool.Irrigation.Services@outlook.com,"(912) 220-0273","7613 Lynes Ct",Savannah,GA,31406,"7613 Lynes Ct,Savannah,GA 31406","Landscape Designers & Consultants, Building Contractors, Building Specialties, Concrete Contractors, Concrete Equipment & Supplies, Deck Builders, Electric Contractors-Commercial & Industrial, Electricians, Environmental Engineers, General Contractors, Irrigation Consultants, Irrigation Engineers, Irrigation Systems & Equipment, Irrigation Systems & Equipment-Wholesale & Manufacturers, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Marine Contractors, Masonry Contractors, Nursery & Growers Equipment & Supplies, Patio Builders, Private Swimming Pools, Professional Engineers, Public Swimming Pools, Seawalls, Sod & Sodding Service, Spas & Hot Tubs, Sports Instruction, Springs-Wholesale & Manufacturers, Sprinkler Supervisory Systems, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service, Stamped & Decorative Concrete, Stone Cutting, Stoneware, Swimming Instruction, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers, Swimming Pool Management, Swimming Pool Manufacturers & Distributors, Swimming Pool Repair & Service, Water Consultants, Water Filtration & Purification Equipment, Water Jet Cutting, Water Parks & Slides, Water Supply Systems, Water Treatment Equip Service & Supply-Wholesale, Water Treatment Equipment-Service & Supplies, Water Well Drilling & Pump Contractors",5,"3 Reviews",,31.98408,-81.0622,https://i2.ypcdn.com/blob/790c45144e1faec0b6f089ce4ac7fcf37e895baf_100x100_crop.jpg?8ad0f92,"""Where quality work & customer satisfaction runs deep""","SPS Unlimited, LLC specializes in the construction of custom built residential & commercial swimming pools. Savannah Pools also offers a variety of other services. Pool Maintenance, pool renovations, Landscaping & Property Grading & renovating, Patio & deck construction.","Mon - Fri: 9:00 am - 5:00 pm Sat: 10:00 am - 2:00 pm",,,"check, paypal, cash, all major credit cards",,,"http://www.savpools.com http://facebook.com/tidewaterGa",,"William F.",08/25/2016,five,"These guys were very professional, experienced & great to do business with. The quality of work they put out is incredible. They were very meticulous & took a lot of pride in the work they did. The total cost wasn't extremely cheap but it wasn't over priced. It was fairly priced, especially for the quality of work they put out.","Bill J.",10/22/2014,five,"Very professional & excellent work!!! Very happy with the job that was done, it couldn't have been done any better. Response time was fast, they delivered (if not OVER delivered) on everything I wanted & the price was more than fair compared to other pool companies I've used here in savannah! These guys were honest, reliable & definitely very knowledgeable! Will definitely call this company back for future work!"
20420084,3112292,"2020-09-27 07:35:00","Precision Contracting Inc.",http://precisioncontracting.net,precisioncontracting@earthlink.net,"(949) 642-6664","2709 Orange Ave Suite D","Santa Ana",CA,92707,"2709 Orange Ave Suite D,Santa Ana,CA 92707","Landscape Designers & Consultants, Concrete Contractors, Demolition Contractors, General Contractors, Landscape Contractors, Swimming Pool Designing & Consulting",,,,33.70984,-117.865845,,"Precision Contracting Inc. has been a owner operated company since 1995 with attention to detail. We do every aspect of construction from general contracting to pool design, and installation. Please visit our website to see some of our work.",,,"Fax: (949) 642-6665",,"paypal, check, insurance",,,http://precisioncontracting.net,,,,,,,,,
20420756,3112489,"2020-09-27 07:35:00","Artesian Custom Pools",http://www.poolsbyartesian.com,,"(215) 340-0433","3641 Knolls Bend Ct",Doylestown,PA,18902,"3641 Knolls Bend Ct,Doylestown,PA 18902","Swimming Pool Designing & Consulting, Landscape Designers & Consultants, Swimming Pool Construction",1,"4 Reviews",,40.3361,-75.09806,,,,"Mon - Fri: 7:30 am - 5:00 pm Sat: 9:00 am - 3:00 pm","Phone: (215) 736-0700 Phone: (215) 340-0416",,"cash only",,"Artesian Custom Pools and Renovations",http://www.poolsbyartesian.com,"Services: Landscape Designers",JCA189,06/05/2012,one,"It is difficult to put into words how bad our experience with Artesian, and specifically the owner Bob W, has been. Having dealt with pool builders before, our expectations were not high. So we set the bar low -- and still Bob never came close to hitting it. He took on work he had no idea how to do, failed to take responsibility for his errors and mistakes, was frequently rude, literally yelled at us for requesting a status update, and has questionable business practices. His much touted years of experience in the pool business have honed his skills in bullying his clients, rather than building pools. Between poor workmanship, the wrong color pebble finish, and damage to surrounding areas, it was a horrible experience from start to finish. In the end, we were just happy to have the saga end. We will live with the pool color. We will get the damage and mistakes addressed on our own. And we will hope the tile and plaster don't fail prematurely.",alderm,05/15/2012,one,"Using Artesian pools in Doylestown / Philadelphia PA was the worst mistake I think I have made in a very long time. Many local В‘pool peopleВ’ told me not to use the owner and I should have listened. I did not because the price was right however in the end I was wrong. The owner was extremely unprofessional, nasty and just outright rude to my wife and me. He promised that we would not have any issues and that his customer service was the best. If we did have any issues (because they will happen) or concerns that he would take care of them or at least address them in a timely manner. Well that was NOT the case. The owner would ignore my emails, calls and texts about any of my concerns. I even had to go purchase replacement steps for my own pool since he did not have the time to get them. Also the company that I purchased the steps from almost didnВ’t sell them to me because of him and his reputation in the locale area. Also I had to schedule my own pool water delivery since he was no help. In addition I could not schedule my delivery since I was never told me when his crew would be showing up. I never knew when his team would show up or leave. After my pool was completed he did not even come to see it or tell me how to take care of it. I spent a lot of money and yet he never showed up or even called. Again I would not recommend this company to anyone. Regardless of the price, the extra money spent would have been well worth itВ… DO NOT USE HIM OR HIS COMPANY!!!"
20421384,3112663,"2020-09-27 07:35:00","Liquid Design of Maryland",,,"(240) 388-0422",,Derwood,MD,20855,"Derwood,MD 20855","Landscape Designers & Consultants, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Designing & Consulting",,,,,,,"Liquid Design of Maryland can transform your dry landscape into a thriving aquascape complete with rockery, waterfalls, tunnels and running water, including an in ground pool and spa. From design and consulting to smooth transition and constructions phases to completed backyard water oasis, Liquid Design of Maryland is your luxury swimming pool designer in all of Maryland.",,,,,,,,,,,,,,,,,
20422138,3112882,"2020-09-27 07:35:00","Coronado Design Group",http://designcoronado.com,arqcoronado@aol.com,"(760) 408-0972",,"Cathedral City",CA,92234,"Cathedral City,CA 92234","Landscape Designers & Consultants, Residential Designers, Swimming Pool Designing & Consulting",5,"1 Review",,,,https://i1.ypcdn.com/blob/d6b751878b83415c403f2efb5e54521a38c86355_100x100_crop.jpg?8ad0f92,,"Coronado Design Group digs deep into the needs of our clients. We ensure to provide the best service and design possible.","Mon - Sun: 7:00 am - 8:00 pm",,,check,,,"Main Website",,fernando12,03/11/2012,five,"Ramon does GREAT work! I had my house designed and built by him and it is amazing to me how much detail was put into the design. He listened to my needs and surpassed them all! Thanks Ramon!",,,,
20423103,3113151,"2020-09-27 07:35:03","David Lee Landscape Inc.",,,"(714) 993-3953","4801 Rose Dr","Yorba Linda",CA,92886,"4801 Rose Dr,Yorba Linda,CA 92886","Landscape Designers & Consultants, Landscape Contractors, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,33.891,-117.84218,,"Let One Contractor Do It All!","Landscape and Pool Construction - CA Lic# 408897, Family owned business. Service Orange County for over 30 years. Free estimates Licensed for Landscape and Swimming Pool Construction.",,,,,,,,"Specialties: Fireplaces Services: Landscape Designers",,,,,,,,