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
313547,103994,"2020-09-27 02:40:11","Little Giant Pool & Spa",http://www.littlegiantpool.com,lgps@earthlink.net,"(636) 271-2200","120 N Olive St",Pacific,MO,63069,"120 N Olive St,Pacific,MO 63069","Swimming Pool Dealers, Bus Lines, General Contractors, Spas & Hot Tubs, Spas & Hot Tubs-Repair & Service, Swimming Pool Construction, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,A+,38.48255,-90.73803,https://i2.ypcdn.com/blob/0da1e1f2bf1d156df8d9fd4c2a6d80c292481fc6_100x100_crop.jpg?f9d23e1,,"*Serving Missouri & Illinois Since 1986","Mon - Fri: 8:00 am - 5:00 pm",,,"discover, amex",,,"http://www.littlegiantpool.com http://littlegiantpool.net","Specialties: Customized, Individualized Services: Construction Services General Contracting",,,,,,,,
408160,138533,"2020-09-27 02:43:46","Lee's General Contracting",http://www.leesgeneralcontracting.com,,"(203) 515-0385",,Norwalk,CT,06855,"Norwalk,CT 06855","Building Restoration & Preservation, Bathroom Remodeling, Building Construction Consultants, Building Designers, Condominiums, Construction Management, Kitchen Planning & Remodeling Service, Swimming Pool Designing & Consulting, Windows-Repair, Replacement & Installation",,,,,,,,,"Mon: 7:00 am - 7:00 pm Tue - Thu: Open 24 Hours Fri: 7:00 am - 7:00 pm Sat - Sun: 9:30 am - 5:30 pm","Phone: (203) 847-8947 Fax: (203) 354-9498",,,,,http://www.leesgeneralcontracting.com,,,,,,,,,
448608,154880,"2020-09-27 02:45:21","Rock Hard Creations",,rockhardcreations44@gmail.com,"(704) 221-7344","8875 Erbach Ln","Mount Pleasant",NC,28124,"8875 Erbach Ln,Mount Pleasant,NC 28124","Kitchen Cabinets & Equipment-Household, Apartments, Architects & Builders Services, Architectural Supplies, Building Contractors, Building Contractors-Commercial & Industrial, Building Materials, Building Specialties, Commercial Real Estate, Concrete Equipment & Supplies, Condominiums, Construction & Building Equipment, Construction Consultants, Contractors Equipment & Supplies, Home Repair & Maintenance, Land Companies, Landscaping & Lawn Services, Modular Homes, Buildings & Offices, Paving Materials, Property Maintenance, Real Estate Agents, Real Estate Auctioneers, Real Estate Buyer Brokers, Real Estate Developers, Rooming Houses, Swimming Pool Designing & Consulting, Townhouses",,,,35.38397,-80.42609,,,"Rock Hard Creations Custom Countertops specializes in kitchen countertops, along with bathroom vanities, outdoor kitchen countertops. Our GFRC products are very unique and different . Prices are very affordable compared to marble and granite tops, Contact us today for prices Casey Summerlin 704-221-7344","Mon - Sun: 7:00 am - 10:00 pm",,,"check, cash",,,,,,,,,,,,
465939,160193,"2020-09-27 02:45:54","Shark Attack Serivces",,,"(214) 934-4633","303 Sycamore St","Lake Dallas",TX,75065,"303 Sycamore St,Lake Dallas,TX 75065","Audio-Visual Creative Services, Small Appliance Repair, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,33.12052,-97.02593,,,,,,,,,,,,,,,,,,,
951972,311876,"2020-09-27 03:01:01",Gappsi,http://gappsi.com,giuseppe@gappsi.com,"(631) 670-6868","1015 W Jericho Tpke",Smithtown,NY,11787,"1015 W Jericho Tpke,Smithtown,NY 11787","Patio Builders, Basement Contractors, Bathroom Remodeling, Crushed Stone, Driveway Contractors, Kitchen Planning & Remodeling Service, Landscape Contractors, Landscape Designers & Consultants, Masonry Contractors, Patio & Outdoor Furniture, Paving Contractors, Private Swimming Pools, Roofing Contractors, Siding Contractors, Stone Natural, Stone Products, Swimming Pool Construction, Swimming Pool Designing & Consulting, Windows, Windows-Repair, Replacement & Installation",,,A+,40.84749,-73.25253,,"Creators of Functional and Distinctive Pools & Landscapes","Gappsi Pools is a Swimming Pool Design and Construction Company. Our parent company Gappsi is a landscape construction design and builds company that creates functional outdoor living spaces. We provide our customers with professional and knowledgeable advice by leading our customers to make wise investments by avoiding unnecessary expenses. Our philosophy is to give you the most for your money. The Gappsi organization is backed by well experienced knowledgeable personnel with specialized talents within their field. This cohesive alliance of talents have been delivering the most distinctive and recognizable creations of beautiful designs of travertine, granite, pavingstones, patios, pool patios & copings, driveways, walkways retaining walls, stone veneer, steps, landscapes, water features, outdoor lighting and swimming pools. We invite you to experience our state of the art design center and meet with our design staff. We are confident that you will find the product and service that fits your lifestyle. We can also provide the following products and services: * Design and Installation of In-Ground Swimming Pools * Pool Patios & Copings * Installation of Travertine & All Brands of Paving Stones * Patios * Driveways * Walkways * Retaining Walls * Steps * Landscaping Design & Installation * Water Features * Outdoor Lighting All Natural Paving Stones from the Gappsi Natural Stone Collection are available for retail purchase at our Design Center","Mon - Sat: 9:00 am - 5:00 pm",,,"all major credit cards",,,http://gappsi.com,"Parking: Lot",,,,,,,,
959142,313482,"2020-09-27 03:01:14","Classic Tile & Plaster",,,"(817) 310-8041","340 W Northwest Hwy",Grapevine,TX,76051,"340 W Northwest Hwy,Grapevine,TX 76051","Swimming Pool Repair & Service, Building Specialties, Granite, Patio Builders, Plastering Contractors, Spas & Hot Tubs-Repair & Service, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Tile-Contractors & Dealers",3,"2 Reviews",,32.94118,-97.08082,,"Free Site Inspection & Site Evaluation","* Contact us for More Information * Payment Methods: American Express, Discover, Check, Master Card, Visa","Mon - Sat: Open 24 Hours",,,,,,,,buyerx3,04/12/2011,one,"We hired Classic Tile to redo our pool with Pebble Sheen, new deck-o-seal, a new pump and booster and repair work to our pump in March of 2011. The customer service and professionalism was great until they recieved their last installment from us. Once they were paid, the service and professionallism was HORRIBLE. They forgot some deck-o-seal work and needed to repair a couple sections that were of poor quality. The section forgotten (but already paid for) was completed after weeks of calling and prodding, but the repairs were NEVER completed as they told us that the deck-o-seal work was not under warrantee (even though they had just completed the work within the last couple weeks). Also, we had to call several times to have the new pool sweep delivered and installed, which was done improperly. They had to be called over and over to fix this. Again, not fixed properly, we had to hire a different pool contractor to fix it. Also, they were paid to fix our pump and this work was also neglected. We called this company every few days asking simply for a date that they planned on fixing the remaining issues, and, they continually promised it would be the """"next day."""" However, the next day would come and go without any word from them. After 3 weeks of this, we finally called a different contractor to complete their incomple work. Although our pool looks great now, it's the little things and follow-up that would tell us whether or not to recommend a company's services to others. Classic Tile and Plaster is NOT a recommendable company. They are a classic case of """"take the money and run"""" leaving a mess to be cleaned up by others. So, BUYER BEWARE!! If you are unfortunate enough to have already contracted with them, please do NOT pay them in full until ALL the work is completed.",imaghost,12/10/2010,five,"I recently used Classic for a replaster and a waterfall addition to the south side of the deep section of my pool. Turned out great, would use again."
971741,316307,"2020-09-27 03:01:28","Yardco Rock & Stone",http://yardcorocks.com,sales@yardcorocks.com,"(561) 433-4148","7729 Lawrence Rd","Boynton Beach",FL,33436,"7729 Lawrence Rd,Boynton Beach,FL 33436","Stone Natural, Architects & Builders Services, Architectural Supplies, Building Contractors, Building Specialties, Crushed Stone, Flagstone, Floor Materials, Floor Materials-Wholesale & Manufacturers, Glass-Beveled, Carved, Etched, Ornamental, Etc, Interior Decorators & Designers Supply Wholesalers & Manufacturers, Landscape Designers & Consultants, Lead Products, Lime & Limestone, Masonry Equipment & Supplies, Quarries, Sand & Gravel, Slate, Stone Natural-Wholesale & Manufacturers, Stone Products, Stone-Retail, Swimming Pool Designing & Consulting",,,,26.56107,-80.10679,https://i1.ypcdn.com/blob/7231f2b89c92330d5e51f20b05851c720aa6a363_100x100_crop.jpg?f9d23e1,,,"Mon - Sat: 8:00 am - 5:00 pm",,,"master card, amex, visa, discover, mastercard, all major credit cards",,,http://yardcorocks.com,"Parking: On Site, Free",,,,,,,,
996172,322039,"2020-09-27 03:02:00","JACK'S TILE & STONE INC",http://www.jackstileandstone.com/,jackstileandstone@hawaii.rr.com,"(808) 478-1950","1338 Akalani Loop",Kailua,HI,96734,"1338 Akalani Loop,Kailua,HI 96734","Stone Natural, Bathroom Remodeling, Flooring Contractors, Home Improvements, Home Repair & Maintenance, Swimming Pool Designing & Consulting, Tile-Contractors & Dealers",,,,21.37227,-157.73216,,,"25 Years in Business",,,,"amex, cash, check, discover, master card, visa",,,http://www.jackstileandstone.com,,,,,,,,,
1006375,324448,"2020-09-27 03:02:20","Waterline pool restoration",,,"(561) 282-7027","120 Windsor Rd W",Jupiter,FL,33469,"120 Windsor Rd W,Jupiter,FL 33469","Deck Builders, Deck Cleaning & Treatment, Marble & Terrazzo Cleaning & Service, Swimming Pool Designing & Consulting, Tile-Cleaning, Refinishing & Sealing",5,"1 Review",,26.95544,-80.09695,,,,"Mon - Sat: 8:00 am - 5:00 pm",,,,,,,,"Julie W.",08/07/2015,five,"I am so happy with the quality of personal service that we had from Mark at Waterline pools. I am overwhelmed with the detail and time that was spent restoring and sealing our marble deck and tile . Thank you again Mark for such attention to detail. Best of luck with your excellent crew. See you next summer. John and Judy.. Admirals Cove Jupiter",,,,
1037750,332101,"2020-09-27 03:03:05","Cantera Stone of Miami Fl",http://www.canteravolcanic.com,info@canteravolcanic.com,"(305) 964-5919","20527 Old Cutler Road #103","Cutler Bay",FL,33189,"20527 Old Cutler Road #103,Cutler Bay,FL 33189","Stone Natural, Stone Natural-Wholesale & Manufacturers, Stone Products, Swimming Pool Designing & Consulting, Tile-Wholesale & Manufacturers",,,,25.57635,-80.33856,,"Lava Stone & Volcanic Stone Flooring Tiles","We are a direct stone supplier of Lava stone, Basalt, Volcanic stone, Cantera stone to architects, designers, contractors and home owners. Outdoor Anti-Slip flooring tiles, Interior/Exterior wall tiles.","Mon - Fri: 8:00 am - 4:00 am Sat - Sun Closed",,,,,,http://www.canteravolcanic.com,,,,,,,,,
1234668,396310,"2020-09-27 03:09:19","Sullivan Lawn Svc",http://sullivanlawnservices.com,info@sullivanlawnservices.com,"(860) 577-2869","8 Piney Br",Ivoryton,CT,06442,"8 Piney Br,Ivoryton,CT 06442","Landscape Contractors, Building Contractors, Concrete & Pumice Bricks, Drainage Contractors, Excavation Contractors, Fertilizing Services, Foundation Contractors, Hydroseeding, Irrigation Systems & Equipment, Land Planning Services, Landscape Designers & Consultants, Landscaping & Lawn Services, Masonry Contractors, Patio Builders, Rubbish & Garbage Removal & Containers, Sprinklers-Garden & Lawn, Installation & Service, Swimming Pool Construction, Swimming Pool Designing & Consulting, Trash Containers & Dumpsters, Tree Service",5,"1 Review",A+,41.33165,-72.43933,https://i2.ypcdn.com/blob/3ac27066cceefcd0068f935046dd201d7b08ae75_100x100_crop.jpg?f9d23e1,"Specializing in New Lawn Installation & Decorative Masonry","Specializing In: New Lawn Installation & Decorative Masonry * Serving the Shoreline Since 1996 * Residential - Commercial - Condominium * One Call Does It All! * Fully Licensed & Insured","Mon - Fri: 8:00 am - 5:00 pm Sat: 8:00 am - 12:00 pm",,,,,"Sullivan Lawn Services Sullivan Lawn Services LLC",http://sullivanlawnservices.com,"Services: Lawn Maintenance","Donna C.",04/26/2018,five,"Eric Sullivan and his team were so great to work with and took our initial vision to a whole new level!",,,,
1587135,495009,"2020-09-27 03:19:11","Blue Escapes Pool & Spa",http://www.blue-escapes.com,,"(972) 294-6950","1321 Precision Dr Ste 400",Plano,TX,75074,"1321 Precision Dr Ste 400,Plano,TX 75074","Swimming Pool Construction, Building Specialties, Deck Cleaning & Treatment, Home Improvements, Home Repair & Maintenance, Private Swimming Pools, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",5,"1 Review",A+,33.01434,-96.69477,https://i3.ypcdn.com/blob/60511e337e011d9653223a5e3050aae0b2cc6022_100x100_crop.jpg?f832250,"We Have over 37 Years Experience In The Swimming Pool Industry. We Can Solve Your Swimming Pool Problem - Guaranteed. * Certified Pool Operator's License ** Certified Building Professional/Certified Service Professional - APSP","We provide a full range of swimming pool maintenance. Repair. & renovation services. We install internet purchased equipment. WIFI control systems. & provide DO it yourself training with a educational DVD with OUR ""pool school"". We are licensed with the state of texas TICL 658 & insured through the independent pool & SPA service association. Certified CPO. APSP CTP. Water hydraulics certified. Stain removal specialist & pool water chemistry certified. We have the answer for complex pool problems.","Mon - Fri: 8:00 am - 6:00 pm Sat: 9:00 am - 1:00 pm","Cell/Text: (214) 402-5457 TollFree: (855) 648-9590",,"debit, check, all major credit cards, financing available, insurance, amex, mastercard, visa, discover",,"Blue Escapes Pool &amp.amp. Spa","http://www.blue-escapes.com http://www.blueescapespools.com","Parking: Lot, Free, Private","Terri P.",03/31/2017,five,"Blue Escapes Pool and Spa is not your normal pool company! I consider myself an expert on pool companies because I have met close to a dozen pool companies! I had a very bad experience with the VIP Pools who re-plastered my pool a few years ago. I have had to hire a new company to correct VIP Pools issues. So hence, the parade of pool companies! Bob, the owner of Blue Escapes Pool and Spa, reviewed my pool with confidence and a high level of expertise. All the bids came in about the same price but it was BobВ’s approach that won me over. Once the work begun, Bob was over almost every day taking pictures of the progress and addressing with his crew any issues he saw. I have NEVER seen the amount of steps and detail related to pool repair, tile and stone replacement. Juan and his crew worked on the pool almost every day, most times working until dark. Most of their process was detail that is not seen in the final product but promotes durability В– waterproofing at every step. visiting 5+ Stone Yards to find rock that did not flake away. brushing down the pool surface, applying an acid wash and final brush-down. replacing pool jets that were the wrong size. applying Deck-O-Seal after stone install. Then when done, they cleaned off my patio furniture and pool area, returning when the pool was filled with water to apply start-up chemicals and make sure the equipment worked correctly. They spent more time on the areas I was not paying them for to assure the end result was a beautifully updated pool that functions better than when they began their work! Another applause is on their communication: They leverage an on-line system in which daily status are sent to the client. And Leta, BobВ’s ever-efficient assistant, would call or Bob, knocking on my backdoor, with an update. I was always part of the process. If only you could see my new pool! It is a beautiful! And I know it will have a long life thru Bob and his crewВ’s care. NOT your normal Pool Company!",,,,
1587853,495114,"2020-09-27 03:19:11","Monarch Pools",http://www.monarchpools.com,retailstore@monarchpools.com,"(303) 309-2729","2211 S Leyden St",Denver,CO,80222,"2211 S Leyden St,Denver,CO 80222","Spas & Hot Tubs, Building Specialties, Cabinet Makers, Cabinets, Home Improvements, Home Repair & Maintenance, Spas & Hot Tubs-Rentals, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,39.67708,-104.91628,,"Building Quality Pools In Colorado Since 1958.","Monarch Swimming Pools, Inc. in Denver, CO, has built custom swimming pools, spas and water features since 1958. We serve both commercial and residential customers. Our retail store is open Monday through Friday year round and Saturdays during the summer. A pool built by Monarch is a luxury retreat where you can surround yourself with your favorite people or be alone. Enjoy being mesmerized by your pool's sparkling magic. Its ever changing colors, reflections and sounds create a vibrant oasis by day and a special romantic atmosphere at night. A Monarch pool is like having an exotic vacation, every day. Our factory-trained technicians are ready to put your pool in operating order, and keep it there. We can take care of simple repairs and entire equipment upgrades. With us doing the work, all you have to do is enjoy your backyard oasis. We offer: Gunite/Shotcrete Swimming Pools Outdoor Water Features Pool Maintenance & Repairs Indoor & Outdoor Construction Water Analysis Automatic Safety Covers BioGuard Chemicals & Accessories We are proud to be members of the prestigious Master Pools Guild for over 45 years. The Guild is respected throughout the industry, nationally and internationally for its continual promotion of quality, ethics and innovation in pool building. Call today and learn how we can put a pool in your yard!","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"amex, check, discover, master card, visa, cash",,,http://www.monarchpools.com,"Parking: Lot",,,,,,,,
1620466,500474,"2020-09-27 03:19:30","Manny's Pool Plaster & Remodeling",http://mannyspoolplasterandremodeling.com,Mannyspools@gmail.com,"(951) 351-2466","6942 Ed Perkic St Ste C",Riverside,CA,92504,"6942 Ed Perkic St Ste C,Riverside,CA 92504","Swimming Pool Repair & Service, Building Specialties, Home Improvements, Home Repair & Maintenance, Plastering Contractors, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting",5,"3 Reviews",,33.96257,-117.44506,https://i3.ypcdn.com/blob/424d138872719a3100eece91b019af3723d7a431_100x100_crop.jpg?f832250,,"We have been in business since 2006, but don't let that defy you. Our employees have 15-20 years' experience in the industry. We do business throughout all counties near Riverside, CA. We carry the best materials on the market, offering exceptional quality. We do everything from pool repairs to new pool construction. It is our goal to leave you completely satisfied with the results. Manny's Pool Plaster & Pool Remodeling is a dedicated organization seeking to please our customers, needs and wishes. No job is too big nor too small, regardless of the size of the job we are here to help you!","Mon - Fri: 7:00 am - 7:00 pm Sat: 7:00 am - 12:00 pm",,,"all major credit cards",,,http://mannyspoolplasterandremodeling.com,,richwessels,08/14/2013,five,"These guys did a great job re plastering my 25 year old spa. They showed up on time and and did a great job for a very reasonable price. I've had so many issues with other pool company's over the last year while trying to get my spa fixed. These guys are great. I won't use anyone else","Sanjay S.",03/21/2013,five,"I have a ~50 year old pool that was in pretty rough shape. It probably hadn't been re-plastered in 20 years and had a cracked skimmer that was causing water leakage in my pool. Got several estimates, but ended up getting a great deal (~20% less than other estimates) from Manny. They fixed the skimmer, demoed the old plaster, and re-plastered over three days. The pool looks brand new! Would definitely recommend to anyone looking to re-haul their pool."
1665406,507945,"2020-09-27 03:20:30","Hammerhead Pool Services Inc",http://hammerheadpoolservices.com,toddhhpsinc@gmail.com,"(919) 878-7622","5621 Departure Dr Ste 106",Raleigh,NC,27616,"5621 Departure Dr Ste 106,Raleigh,NC 27616","Swimming Pool Repair & Service, Cleaning Contractors, Educational Consultants, Home Improvements, Home Repair & Maintenance, Moving Services-Labor & Materials, Shopping Centers & Malls, Spas & Hot Tubs, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers, Swimming Pool Management",,,A+,35.86043,-78.5928,https://i3.ypcdn.com/blob/3c10c9e6e663b33a873b02ab7f66f57d672a81d7_100x100_crop.jpg?f832250,"To be the most trusted and respected pool management company in the Triangle area by providing an entire spectrum of pool care services and delivering uncompromising service to all our clients.","Hammerhead Pool Services has over 40 years of combined experience. We can provide a full range of maintenance, renovation, repair and staffing services. Hammerhead offers everything you will need in preparing and maintaining your pool in a pristine condition. Our certified staff will ensure that your pool is properly maintained throughout the swimming season. Our pools are in constant compliance with all regulations and that all pools are properly winterized. Our renovation and repair division can offer assessments and equipment repair on all ranges of pool motors, pumps, salt systems, filters and plumbing repairs. With free estimates and a 100% 1 year warranty on all workmanship, we are confident in meeting all of our customerВ’s needs. We strive to provide a positive work environment, where committed individuals can fulfill their potential and in turn deliver unmatched quality service to our clients.","Mon - Fri: 8:00 am - 5:00 pm","Primary Phone: (919) 676-4472 Phone: (919) 676-4472",,"amex, discover, master card, visa, mastercard, all major credit cards",,"Hammerhead Pool Services, Inc. Hammerhead Pool Services Hammerhead Pool Senrices Inc",http://hammerheadpoolservices.com,,,,,,,,,
1689935,512002,"2020-09-27 03:20:51","Ashlyn, Inc",http://www.ashlyninc.com,ashlyninc@gmail.com,"(410) 760-0394",,Severn,MD,21144,"Severn,MD 21144","Home Improvements, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,,,,,"Specializing in Inground Vinyl Liner Pools and Home Improvements","Ashlyn is a family owned & operated business since 1997. Ashlyn specializes in Inground Vinyl Liner Replacements and Constructing new Inground Vinyl Liner Pools. Ashlyn is a fully licensed (MHIC#51143) and insured General Contractor. Ashlyn Pools, our retail store, is located on Mountain Rd in Pasadena, MD next to the Lake Shore Fire Department. The store is open from May-Oct during the swimming pool season.","Mon - Sun: 8:00 am - 8:00 pm",,,,,,http://www.ashlyninc.com,,,,,,,,,
2380480,755572,"2020-09-27 03:44:29","Great Outdoors Designs",http://greatoutdoorsdesigns.com,info@greatoutdoorsdesigns.com,"(516) 279-2414","122 Sunset Ave",Selden,NY,11784,"122 Sunset Ave,Selden,NY 11784","Kitchen Planning & Remodeling Service, Driveway Contractors, Landscape Designers & Consultants, Patio Builders, Swimming Pool Designing & Consulting",,,,40.85574,-73.04134,https://i1.ypcdn.com/blob/cfb925c5df9d900fcbcd46061d3a539f8e84fb48_100x100_crop.jpg?8ad0f92,,,"Mon - Sat: 8:00 am - 6:00 pm Sun Closed",,,"visa, master card, discover, check",,,http://greatoutdoorsdesigns.com,,,,,,,,,
2435458,763438,"2020-09-27 03:45:10","Cisney & O'Donnell Builders and Remodelers",http://www.cisneypools.com,info@cisneyodonnell.com,"(814) 643-4968","11923 William Penn Highway",Huntingdon,PA,16652,"11923 William Penn Highway,Huntingdon,PA 16652","Swimming Pool Designing & Consulting, Bathroom Remodeling, General Contractors, Kitchen Planning & Remodeling Service, Swimming Pool Repair & Service",,,A+,40.44525,-77.95049,,,,"Mon - Fri: 9:00 am - 5:00 pm Sat: 9:00 am - 12:00 pm",,,"financing available",,,"http://www.cisneypools.com http://www.cisneyremodeling.com","Services: Window Repair, Window Replacement",,,,,,,,
2722987,844864,"2020-09-27 03:53:55","Outdoor Craftsmen",http://outdoorcraftsmen.com,info@outdoorcraftsmen.com,"(303) 828-0408","1503 State Highway 52",Erie,CO,80516,"1503 State Highway 52,Erie,CO 80516","Landscape Designers & Consultants, Landscape Contractors, Landscaping & Lawn Services, Lighting Contractors, Swimming Pool Designing & Consulting",,,A+,40.0884,-105.02678,https://i4.ypcdn.com/blob/b1715e8fed620596ce5604cc45a159ce5bd06fa1_100x100_crop.jpg?41e4770,"Outdoor Craftsmen is a landscape design and landscape architecture company specializing in uniquely","Outdoor Craftsmen is a landscape design and landscape architecture company specializing in uniquely tailored residential landscaping that is built to bring your ideal outdoor living experience to fruition. Serving the Boulder, Colorado community, our team of landscape designers, craftsmen, artisans and landscape contractors bring more than just landscape installation to your home or business, with years of experience in the Colorado alpine environment, we are able to provide xeriscape, hardscape, and low maintenance landscapes to your homeВ’s exterior. From luxury outdoor living spaces - including custom built outdoor kitchens and outdoor fireplaces - to natural swimming pools and decks, we take a contemplative approach to every detail of the outdoor environments we build. Let us help you with a landscape makeover to bring attainable luxury to your outdoor living.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,,,,http://outdoorcraftsmen.com,"Parking: Lot Services: Landscape Designers",,,,,,,,
2754257,851797,"2020-09-27 03:54:28","LED Pool Lights",http://www.ledpoollights.net,info@ledpoollights.net,"(407) 350-2922","PO Box",Longwood,FL,32779,"PO Box,Longwood,FL 32779","Swimming Pool Designing & Consulting, Lighting Consultants & Designers, Lighting Systems & Equipment, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers",,,,28.70015,-81.34751,,,,"Mon - Fri: 9:00 am - 5:00 pm",,,"debit, check, paypal, visa, master card, discover",,,"Swimming Pool and Spa LED Lighting",,,,,,,,,
2757487,852488,"2020-09-27 03:54:36","Brass Brick Homes",http://brassbrick.com,aislinn@brassbrick.com,"(405) 657-7999","2921 NW 188th St",Edmond,OK,73012,"2921 NW 188th St,Edmond,OK 73012","Home Builders, Architectural Designers, Bathroom Fixtures, Cabinets & Accessories, Building Contractors, Flooring Contractors, Interior Designers & Decorators, Lighting Fixtures, Patio Builders, Real Estate Developers, Residential Designers, Swimming Pool Designing & Consulting",,,,35.652832,-97.478096,https://i3.ypcdn.com/blob/137b8bb03bda5b468cffbc8beef87df5770a9203_100x100_crop.jpg?d9a04b5,"at Brass Brick Homes we make the new home buying experience fun, easy, and straightforward.","Are you looking for a home-building experience that is like no other? At Brass Brick Custom Homes, weВ’re focusing on a new way to build homes. We want this to be an experience of a lifetime for youВ… building your dream home. You can now use our new online building management system that will allow you to sit back and relax, while keeping track of your dream homeВ’s progress 24/7 from your computer or smart phone. We offer un-matched quality and customization. many unique and award winning floor plans. and a professional designer on staff to guide you through the entire process. Everything we do is with a singular purpose: В“As followers of Jesus Christ, to Serve each family for which we build their dream home. to Serve our talented tradesmen whose skill makes it possible. and to Serve our community in such a way that makes a meaningful difference.В” We would love the opportunity to price your custom dream home on your own lot or in one of our neighborhood communities in which we build. You own floor plan or one of our custom plansВ… weВ’ll build it for you. If you would like to learn more about how Brass Brick Custom Homes is innovating the home building experience, call us or stop by one of our models and visit with our staff. We canВ’t wait to meet you.","Fri - Sun: 1:00 pm - 6:00 pm","Office Line:: (405) 285-9451 Fax: (405) 285-2167",,check,,,http://brassbrick.com,,,,,,,,,
2760188,853053,"2020-09-27 03:54:37","Texas Nativescapes",http://www.texasnativescapes.com,paulmrowan@gmail.com,"(940) 765-2760","3507 Sagebrush Dr",Denton,TX,76209,"3507 Sagebrush Dr,Denton,TX 76209","Landscape Contractors, Altering & Remodeling Contractors, Architects & Builders Services, Building Construction Consultants, Concrete Contractors, Concrete Staining Services, Deck Builders, Drainage Contractors, Fence-Sales, Service & Contractors, Fountains Garden, Display, Etc, Gardeners, Gates & Accessories, Greenhouse Builders & Equipment, Irrigation Systems & Equipment, Landscape Designers & Consultants, Lighting Consultants & Designers, Masonry Contractors, Painting Contractors, Patio & Outdoor Furniture, Patio Builders, Planter Boxes, Plants, Spas & Hot Tubs, Stone Products, Swimming Pool Construction, Swimming Pool Designing & Consulting, Tile-Contractors & Dealers",,,,33.25211,-97.12496,https://i4.ypcdn.com/blob/9d8e237eea1dd01096f46d8450fc2ce573a9cc43_100x100_crop.jpg?41e4770,"Discover your native roots... ""The art of nature, creativity and innovation""...","We are a professional creative collective of landscape and garden designers, landscapers, horticulturist and specialized builders passionate about nature and creating exquisite outdoor living spaces. Serving clients throughout Texas | Austin-San Antonio | Dallas-Fort Worth Metroplex | Houston 940.765.2760","Mon - Fri: 8:00 am - 6:00 am Sat: 9:00 am - 3:00 am Sun Closed",,,,,,http://www.texasnativescapes.com,,,,,,,,,
2764559,854040,"2020-09-27 03:54:37","A & E Design Landscape Contractors",http://aedlc.com,info@aedesign-md.com,"(443) 562-2000","14320 Jarrettsville Pike",Phoenix,MD,21131,"14320 Jarrettsville Pike,Phoenix,MD 21131","Landscape Designers & Consultants, Architects & Builders Services, Building Contractors, Building Specialties, Drainage Contractors, Landscape Contractors, Landscaping & Lawn Services, Lighting Consultants & Designers, Nurseries-Plants & Trees, Patio & Outdoor Furniture, Patio Builders, Swimming Pool Designing & Consulting, Tree Service",5,"1 Review",,39.51969,-76.55961,https://i3.ypcdn.com/blob/bfd900cd94bc1769877d26811e70b943097eb67b_100x100_crop.jpg?41e4770,,,"Mon - Sun: 9:00 am - 5:00 pm",,,"all major credit cards",,,http://aedlc.com,,"Drew C.",03/04/2018,five,"Very talented and honest company that took our ideas and greatly expanded our imagination for the better!",,,,
2766036,854356,"2020-09-27 03:54:38","Karen Linder Interior Designs",http://www.karenlinderinteriordesigns.com,karen@klinteriordesigns.com,"(503) 515-4745",,Portland,OR,97224,"Portland,OR 97224","Interior Designers & Decorators, Architectural Designers, Automobile-Custom Designed & Replica, Building Designers, Catalog Designers & Compilers, Closets Designing & Remodeling, Color Consultants, Computer Network Design & Systems, Computer System Designers & Consultants, Data Systems-Consultants & Designers, Designers-Industrial & Commercial, Designing Engineers, Display Designers & Producers, Embroidery Design Punching, Fashion Designers, Floral Design Instruction, Foundation Design Engineers, Fur Designers, Furniture Designers & Custom Builders, Graphic Designers, Home Design & Planning, Interior Decorators & Designers Supplies, Interior Decorators & Designers Supply Wholesalers & Manufacturers, Interior Design Schools, Jewelry Designers, Landscape Designers & Consultants, Lighting Consultants & Designers, Machine Tool Designers & Consultants, Maps-Designers, Publishers & Distributors, Package Design & Development, Plants-Interior Design & Maintenance, Product Design, Development & Marketing, Residential Designers, Restaurant Design & Planning, Specially Designed Machinery, Swimming Pool Designing & Consulting, Tool Designers, Web Site Design & Services",5,"5 Reviews",A+,,,https://i3.ypcdn.com/blob/a21f43cab10f19570d4e488db0fbf668446ee1fe_100x100_crop.jpg?d9a04b5,"Discover Your Home Done Your Way","Karen Linder has built her design practice upon the values of relationship, listening, and collaboration. She believes a home or workspace should be a clear reflection of those who live and work within it. Asking questions, understanding values, and discovering individual preferences are important elements of the collaborative process. Interior design is exciting, adventurous, and filled with possibilities! ItВ’s about the challenge, the discovery, the artistry, and the В“aha!В” moment when the perfect design solution reveals itself. We invite you to embrace the possibilitiesВ…","Mon - Sun: 9:00 am - 6:00 pm","Phone: (503) 968-2909",,"cash, check, amex, invoicing available, master card, visa, all major credit cards",,,http://www.karenlinderinteriordesigns.com,,"Jane LMT",05/07/2011,five,"Karen Linder is an experienced designer with an eye for detail, style and color. She immediately can get the В‘feelВ’ of a space and can turn a ho-hum room into an inviting and warm place to relax and enjoy. She has innovative ideas that are timely and distinctive. She listens to her clientsВ’ ideas and desires to arrive at an end result that looks and feels fantastic! Not only is she an expert in color and how it can effect the mood and tone of the entire area. She is a master at bringing all aspects of design together and creating an area, entire home, or office into a tasteful and beautiful setting. Karen is at the top of my list of Interior Designers to recommend!","Paul S.",05/05/2011,five,"I hired Karen Linder Designs to help me improve the impact and aesthetics of my photographic studio. This wasnВ’t an easy task, since two of us share the studio and we have different tastes and budgets. She provided not just color consultations, but literally moved furniture in ways that remain in place today. Karen also provides counsel on what to add to a room to make it feel more comfortable to a clientele with diverse tastes В– not an easy job. Since she helped me with my studio, IВ’ve had the opportunity to see and be impressed by 2 of KarenВ’s other projects where she had really proud clients. I enjoy KarenВ’s personality tremendously and respect the way she lives her life В– dedicated to hard work and health and making tremendous improvements in peoplesВ’ living and/or work space."
2781811,857900,"2020-09-27 03:54:53","Online DesignScapes LLC",http://onlinedesignscapes.com,,"(252) 648-8880","109 Cottage Row","Morehead City",NC,28557,"109 Cottage Row,Morehead City,NC 28557","Kitchen Planning & Remodeling Service, Landscape Designers & Consultants, Lighting Consultants & Designers, Patio Builders, Swimming Pool Designing & Consulting",,,A+,34.7346,-76.82881,https://i3.ypcdn.com/blob/2b788cdb478e94d7b4f67b0af958ab1aa4b988ac_100x100_crop.jpg?d9a04b5,,,"Mon - Fri: 9:00 am - 5:00 pm",,,,,,http://onlinedesignscapes.com,,,,,,,,,
3787583,1234932,"2020-09-27 04:30:25","Essig Pools Inc",http://www.essigpools.com,,"(305) 949-0000","1800 NE 151st St","North Miami Beach",FL,33162,"1800 NE 151st St,North Miami Beach,FL 33162","Swimming Pool Repair & Service, Fence Materials, Fence-Sales, Service & Contractors, Spas & Hot Tubs, Spas & Hot Tubs-Repair & Service, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting","3,5","2 Reviews",,25.91465,-80.16333,https://i1.ypcdn.com/blob/23df498357ccc9f1487d283dfc1b64d4ffe833c6_100x100_crop.jpg?f832250,,,"Mon - Fri: 8:30 am - 5:00 pm Sat: 9:00 am - 3:00 pm",,,"all major credit cards, amex, diners club, discover, master card, visa",,,http://www.essigpools.com,"Parking: Lot, Free Specialties: Aprons Wheelchair Accessible: Yes","Vicky D.",09/27/2016,two,"never again !!! it s been 8 years and the problems just continue ...rust spots coming out of bottom of pool , my diamond brite looked like it needed to be redone after the first year it was done !!! and no it s not fertilizer spots because i don t use fertiliser. Electrical board and cell keep failing and pipes breaking. im done with them please do your homework !!! they charge a fortune to repair and dont know how to repair , they just change the whole thing and make you pay a huge bill !!!",4rigby,11/26/2007,five,"What a pleasure to do business with Essig Pools. I found the sales people friendly and easy to do business with. They listened to my ideas and worked within my budget. I would higly recommend them to anyone looking to get a pool."
3794911,1236390,"2020-09-27 04:30:32","Cohen, Joel M",http://www.cohen-pensacolaattorney.com,jcohenlaw@aol.com,"(850) 434-5524","201 East Government",Pensacola,FL,32502,"201 East Government,Pensacola,FL 32502","Swimming Pool Repair & Service, Building Specialties, Fence Repair, Fence-Sales, Service & Contractors, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Designing & Consulting",5,"7 Reviews",,30.40954,-87.21142,https://i1.ypcdn.com/blob/3f8e623d8fc3cb64d9c1b28b0fbf05f733b5aa58_100x100_crop.jpg?f832250,"Getting You Back on Track","Transplanted to Northwest Florida through the United States Air Force in 1964, I have grown my roots in the South. I received my B.S. in Business from Troy State University in 1970, then completed law school at Cumberland School of Law in 1973. I am married and have raised four children who have attended public schools in both Escambia and Santa Rosa counties. After admission to the Florida Bar in 1973, I was enrolled to practice in the United States District Court and Bankruptcy Court in 1974. I served on the Board of Directors of the Escambia-Santa Rosa Bar Association, was a certified Civil and Family Law Mediator. I began my legal career as an Assistant Public Defender representing my clients in the criminal justice system. Most of my career as an attorney however, has been devoted to assisting families and businesses in the private sector. I pride myself in personally responding to your needs, providing you with personal attention and remaining accessible to serve your legal needs. No golf games, no extended vacations. It is you, my client who is the focus of my Pensacola-based law practice.","Mon - Fri: 9:00 am - 5:00 pm Sat - Sun Closed",,,,,,http://www.cohen-pensacolaattorney.com,,"John V.",09/28/2018,five,"Mr Cohen handed my bankruptcy case so well I barely had to lift a finger except to sign a few papers. He explained the process to me which gave me the confidence to proceed and it worked out just as he said. The pressure is gone (no calls or letters) what a relief-the man is a miracle worker and I advise anyone with credit card debt to call (or email) Mr Cohen.","Lee anna M.",09/26/2018,five,"Mr Cohen was a blessing because he was willing to work with me even though I wasnВ’t able to pay the full retainer upfront. He was willing to do partial payments that I could afford. He helped me reaffirm my car and fought Ford on what my car was truly worth. Ford was trying to overestimate my vehicle during the reaffirmation process. He was patient and very kind hearted. He was maintained his professionalism even while dealing with a loss of a loved one in his family. He took care of me and my family."
3795750,1236544,"2020-09-27 04:30:32","Matt's Water Pool Services",http://www.mattswater.com,mattswater@gmail.com,"(214) 566-2394","312 N Main St",Corsicana,TX,75110,"312 N Main St,Corsicana,TX 75110","Swimming Pool Repair & Service, Fence-Sales, Service & Contractors, Spas & Hot Tubs, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies",,,A+,32.09516,-96.46672,,,,,,,,,"Matt's Water Pool Services LLC","http://www.mattswater.com https://mattswater.com",,,,,,,,,
3817380,1240750,"2020-09-27 04:30:46","Noel Ramirez construction",https://sales.yellowpages.com/san-antonio-tx/mip/noel-ramirez-construction-548488304?lid=1002003469000,ramirez.noel79@yahoo.com,"(210) 742-6986",,"San Antonio",TX,78240,"San Antonio,TX 78240","Concrete Contractors, Basement Contractors, Concrete & Pumice Bricks, Concrete Blocks & Shapes, Concrete Restoration, Sealing & Cleaning, Concrete Staining Services, Fence Repair, Masonry Contractors, Patio Builders, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,,,,https://i1.ypcdn.com/blob/d9600811ff5a7f2aff7dd92c1c86a5949d25ec8d_100x100_crop.jpg?f832250,"We offer a wide variety of services to the San Antonio area from new concrete construction to repairs.","DECORATIVE CONCRETE - Whether your current concrete surface area is new or old we can beautify your surface with many of our services and products. Our specialty is decorative concrete overlays, stains, scoring and stained overlays. Decorative concrete coatings are a great alternative to natural stone, brick, tile and other surfaces due its quality curb appeal, durability and affordability. We will work with you to create a custom design that suits your taste and will enhance the looks of your property for years to come.","Mon - Fri: 9:00 am - 5:00 pm Sat: 6:00 am - 4:00 pm Sun Closed",,,"discover, master card, visa, cash",,"Noel Concrete Contractors",https://sales.yellowpages.com/san-antonio-tx/mip/noel-ramirez-construction-548488304?lid=1002003469000,,,,,,,,,
3834741,1244156,"2020-09-27 04:31:06","Aqua Leisure Pools and Spas",http://www.aqualeisurepoolsandspas.com,nepsinfo@aol.com,"(570) 822-1188","185 Wilkes-Barre Boulevard","Wilkes Barre",PA,18702,"185 Wilkes-Barre Boulevard,Wilkes Barre,PA 18702","Swimming Pool Repair & Service, Fence-Sales, Service & Contractors, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers",2,"9 Reviews",,41.239243,-75.883514,https://i1.ypcdn.com/blob/f30dac1d87b956f19163f2572686ee34b2b18155_100x100_crop.jpg?f832250,,,"Mon - Fri: 10:00 am - 8:00 pm Sat: 10:00 am - 6:00 pm Sun: Open 24 Hours",,,"cash, check, discover, financing available, master card, visa",,,http://www.aqualeisurepoolsandspas.com,"Services: Carport Construction","Sandy T.",08/26/2019,five,"My husband and I have been going to Aqua Leisure Pool and Spa for years. The staff is very helpful and knowledgeable. Products are always in stock with reasonable pricing. We would like to thank the staff for bailing us out of more than one issue we had with our pool and hot tub!!!","Len P.",07/23/2019,five,"My wife and I were very pleased with Aqua Leisure Pools and Spas from start to finish. They were very professional in explaining the whole process and within 1.5 weeks our fiberglass pool was in the ground and ready for swimming. Another crew came to clean the pool and get us on track with the proper chemicals, etc.. We couldn't be happier and I would recommend them to family and friends... Great job.."
3836462,1244485,"2020-09-27 04:31:06","KD Poolscapes",http://www.kdpoolscapes.com,kdpools@aol.com,"(262) 835-4353","11932 120th St",Franksville,WI,53126,"11932 120th St,Franksville,WI 53126","Fence-Sales, Service & Contractors, Building Specialties, Sauna Equipment & Supplies, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,A+,42.81638,-88.06617,,"With the philosophy of ""One"". You'll deal with ""One"" contractor. You'll have ""one"" price. Built ""One"" pool at a time. Welcome to the Land of AHHHHH's!","We don't just build pools. With true turn-key design build services, we can assure you a pleasant building experience resulting in a ""poolscape"" your family will enjoy for years to come. We won't cut corners on the aspects of your pool you can't see. and you will find our construction methods are unmatched in the industry. We're passionate about what we do. and we look forward to working with you to develop your families own personalized ""Land of Ahhh's. Together. with our designers and skilled craftsmen we can take you there. Take the plunge with a builder you can trust!","Mon - Fri: 7:00 am - 7:00 pm Sat: 7:00 am - 1:00 pm Sun: 9:00 am - 1:00 pm",,,"check, cash, financing available, visa, master card, amex",,,http://www.kdpoolscapes.com,,,,,,,,,
3839460,1245068,"2020-09-27 04:31:11","R Cruz Concrete",http://www.rcruzconcrete.com,,"(888) 986-7278","18845 Van Buren Blvd Ste 9a",Riverside,CA,92508,"18845 Van Buren Blvd Ste 9a,Riverside,CA 92508","Swimming Pool Designing & Consulting, Concrete Contractors, Fence-Sales, Service & Contractors, Masonry Contractors-Commercial & Industrial, Swimming Pool Construction",,,,33.88706,-117.3344,https://i1.ypcdn.com/blob/62138acc33e9028790d35794c3842a61dcb6bcd1_100x100_crop.jpg?f832250,,"Concrete Contractor","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed","8889867278: (951) 780-4200 8889867278: (951) 780-4210",,"debit, check, all major credit cards",,,"Main URL","Parking: Self, On Site, Free Wheelchair Accessible: Yes",,,,,,,,
3847831,1246648,"2020-09-27 04:31:15","Putnam Swimming Pool",http://www.putnampools.com,info@putnampools.com,"(203) 348-0512","7 Depinedo Ave",Stamford,CT,06902,"7 Depinedo Ave,Stamford,CT 06902","Swimming Pool Repair & Service, Fence Materials, Fence-Sales, Service & Contractors, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers",,,A+,41.05065,-73.55857,,,"Licensed and insured swimming pool maintenance and cleaning service to Fairfield County, CT and Westchester County, NY.","Mon - Fri: 9:00 am - 5:00 pm",,,"all major credit cards",,,http://www.putnampools.com,,,,,,,,,
3848365,1246758,"2020-09-27 04:31:15","Robert's Pool Service",http://www.robertspoolservice.com,rps@robertspoolservice.com,"(972) 436-0360","455 S Railroad St",Lewisville,TX,75057,"455 S Railroad St,Lewisville,TX 75057","Swimming Pool Repair & Service, Fence-Sales, Service & Contractors, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Designing & Consulting",3,"2 Reviews",,33.04326,-96.98439,,,,"Mon - Sun: 8:00 am - 5:00 pm",,,"visa, discover, mastercard, amex",,,http://www.robertspoolservice.com,,jennifer-83,03/12/2013,five,"Sterling and his employees are knowledgeable and and very competent. They've done a great job at our pool for years.",kevin_greer,10/25/2006,one,"They installed a multivalve for my DE filter about 1.5 years ago. They recently came out to clean the DE filter. Before they came the multivalve was fine, after they left it was leaking. They refused to admit that they broke it and they want to charge me $400 for them to replace a multivalve that was not even 2 years old. I will never use them again and I would not recommend them to anyone."
3852282,1247492,"2020-09-27 04:31:24","Hydroscape Inc.",http://www.hydroscapeinc.com,,"(215) 499-4856","56 S Main St",Yardley,PA,19067,"56 S Main St,Yardley,PA 19067","Landscape Designers & Consultants, Fence-Sales, Service & Contractors, Lake & Pond Construction, Landscape Contractors, Patio Builders, Sprinklers-Garden & Lawn, Installation & Service, Swimming Pool Designing & Consulting",,,,40.24128,-74.83719,,"Swimming Pools, Landscape, Patio & Pavers, and Fence Work in Bucks County & Montgomery County PA","At Hydroscape, Inc. we specialize in Swimming Pools, Landscaping, Patio & Pavers, Fence and Drainage Work in Bucks County PA and Montgomery County PA, and nearby South Jersey and Central Jersey areas. We serve both Residential and Commercial customers. Customer Satisfaction is Job One, and we have an excellent track record in ensuring that our customers are satisfied with our products and services. We take care of your Swimming Pools, Landscape, Hardscape, Fence and Drainage work right the first time, with no shortcuts. We are responsive, and from the first call to the completed job, we will be there when you need us. Our combination of quality workmanship, products and service cannot be matched. See our Testimonials page or ask to speak with past customers. We have been providing Landscaping, Hardscaping and Waterscape Services since 2003. As an local owner-operated firm, we live, work, and take great pride in Bucks County, PA.",,,,"cash, check, financing available",,,http://www.hydroscapeinc.com,,,,,,,,,
3852561,1247547,"2020-09-27 04:31:24","Ace Pool Services",http://www.acepoolservices.com,acepoolservices@yahoo.com,"(936) 448-4208","13921 Highway 105 W",Conroe,TX,77304,"13921 Highway 105 W,Conroe,TX 77304","Swimming Pool Repair & Service, Fence Materials, Fence-Sales, Service & Contractors, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies",,,,30.34728,-95.57285,,,,,,,,,,http://www.acepoolservices.com,,,,,,,,,
3858260,1248686,"2020-09-27 04:31:33","Rondo Pools",http://www.rondopools.com,office@poolsbyrondo.com,"(615) 200-7220","1400 W Main St",Franklin,TN,37064,"1400 W Main St,Franklin,TN 37064","Swimming Pool Repair & Service, Deck Builders, Fence-Sales, Service & Contractors, Spas & Hot Tubs, Spas & Hot Tubs-Repair & Service, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies",,,A+,35.91324,-86.88739,,,,"Mon - Fri: 8:00 am - 6:00 pm Sat: 9:00 am - 6:00 pm",,,,,"Rondo Pools, LLC",http://www.rondopools.com,,,,,,,,,
3873490,1251663,"2020-09-27 04:31:49","Advanced Sprinkler & Landscape Inc ASL Pools & Spas",http://www.aslpoolsandlandscape.com,info@aslpoolsandlandscape.com,"(405) 455-5296","618 Crescent Cir","Oklahoma City",OK,73110,"618 Crescent Cir,Oklahoma City,OK 73110","Swimming Pool Designing & Consulting, Building Contractors, Building Specialties, Concrete Contractors, Fence-Sales, Service & Contractors, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Sprinklers-Garden & Lawn, Sprinklers-Garden & Lawn, Installation & Service, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Repair & Service",,,A+,35.47354,-97.40782,https://i1.ypcdn.com/blob/afc1aa135d57e2020348be9daba78e126673d932_100x100_crop.jpg?f832250,"We can transform your backyard or common area into a paradise.","Swimming Pools, Automatic Irrigation Systems, Wood Decks, Waterfalls & Fountains, Underground Drainage Systems, Concrete or Rock/Flagstone Sidewalks, Patios, Driveways & Flower Beds, Fence Installation & Repair, and Dirt & Grading Work.","Mon - Fri: 9:00 am - 5:00 pm",,,cash,,,http://www.aslpoolsandlandscape.com,"Services: Landscape Lighting",,,,,,,,
3897410,1256319,"2020-09-27 04:32:07","Quality Irrigation & Landscapes",http://www.qualitycompaniesinc.com,sales@qualitycompaniesinc.com,"(229) 245-9554","4609 Bemiss Rd",Valdosta,GA,31605,"4609 Bemiss Rd,Valdosta,GA 31605","Landscape Designers & Consultants, Drainage Contractors, Fence-Sales, Service & Contractors, Grading Contractors, Irrigation Systems & Equipment, Landscape Contractors, Landscaping & Lawn Services, Patio Builders, Sod & Sodding Service, Sprinklers-Garden & Lawn, Installation & Service, Swimming Pool Construction, Swimming Pool Designing & Consulting",,,,30.92824,-83.2456,,"Everything Outdoors with Quality Landscapes","Quality Landscapes is a full service landscape company for Everything Outdoors-- serving South Georgia since 1995. We do residential & commercial landscaping, irrigation, sodding, seeding, grading and clearing, pools & patios, concrete services, and more. We are a turnkey landscape construction meeting your needs with Everything Outdoors to make your outdoor space your oasis.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"all major credit cards, amex, check, debit, discover, mastercard, financing available, visa",,,http://www.qualitycompaniesinc.com,,,,,,,,,
3906150,1258027,"2020-09-27 04:32:21","Y.E.S. Contractors",https://www.yescontractorsnj.com,office@yesnj.biz,"(732) 475-4334",,,,,,"Swimming Pool Repair & Service, Fence-Sales, Service & Contractors, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies",,,A+,,,https://i1.ypcdn.com/blob/9620d6e6306500632a42d9547b80ff3741c96fb1_100x100_crop.jpg?f832250,,"Y.E.S. Contractors is a leading provider of pool and outdoor lighting services in Wall Township and throughout The Jersey Shore.","Mon - Fri: 9:00 am - 5:00 pm Sat - Sun Closed",,,"all major credit cards",,,https://www.yescontractorsnj.com/,,,,,,,,,
3959086,1267776,"2020-09-27 04:33:11","Dominion Pool & Spa",http://www.dominionpoolandspa.com,info@dominionpoolandspa.com,"(434) 836-5100","10432 U S Highway 29",Blairs,VA,24527,"10432 U S Highway 29,Blairs,VA 24527","Swimming Pool Repair & Service, Fence Materials, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting",,,,36.74887,-79.37985,,,,"Mon - Thu: 7:00 am - 5:30 pm",,,"financing available",,"Dominion Pool and Spa",http://www.dominionpoolandspa.com,"Parking: Lot",,,,,,,,
3962474,1268392,"2020-09-27 04:33:16","Stephenson Fence and Pool Co Inc",http://www.stephensonfenceandpool.com,stephensonpool@gmail.com,"(919) 552-2717",,,,,,"Fence-Sales, Service & Contractors, Fence Repair, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,A+,,,,"Since 1985","Stephenson Fence, Pool & Grading Co. Inc offers construction options and pool repair services to homeowners within a 40 mile radius of Fuquay Varina, North Carolina. Our owner, Ronnie Stephenson, guarantees all the workmanship provided by our team. If you want us to repair your pool liner or install a backyard kitchen, we can provide exceptional results without breaking your budget. Our owner is an ""old farm boy"" who started in the industry more than 30 years ago when his father-in-law invited him to go into the fencing business with him. Since then, he has branched out into all types of pool construction, design, and repair. Schedule your free estimate today to find out how we can transform your outdoor space for a summer full of relaxation and fun. We are insured in case of accidents or property damage, but you'll never have to worry when we are on the job because we are meticulous in everything we do. Above & Below Ground Pools - Installs and Construction.","Mon - Fri: 8:00 am - 5:00 pm",,,"cash, check",,,http://www.stephensonfenceandpool.com,,,,,,,,,
3974696,1270626,"2020-09-27 04:33:20","Contemporary Pools Inc",http://www.contemporarypools.com,info@contemporarypools.com,"(239) 549-2300","3802 Skyline Blvd","Cape Coral",FL,33914,"3802 Skyline Blvd,Cape Coral,FL 33914","Swimming Pool Repair & Service, Fence Materials, Fence-Sales, Service & Contractors, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies",3,"2 Reviews",A+,26.58154,-81.99141,,,,"Mon - Thu: 8:00 am - 5:00 pm Fri: 8:00 am - 4:00 pm","Primary Phone: (239) 204-3566 Primary Phone: (239) 240-8610 Primary Phone: (239) 214-8221 Phone: (239) 935-5887 Phone: (239) 205-7665 Phone: (239) 204-4484 Primary Phone: (239) 205-7665 Fax: (239) 214-8221 Fax: (239) 549-2611",,"cash, check",,"Contemporary Pool Service Inc Contermporary Pools Inc.","http://www.contemporarypools.com http://contemporarypools2.com https://www.contemporarypools.com","Services: Leak Detection","Nicolle W.",10/14/2016,five,"They built my pool quicker than expected. They were professional and explained everything very thoroughly. I highly recommend them. Ask for Danny, he was great.",Naeastwoodjr,11/01/2011,one,"BE VERY CAUTIOUS WHEN DEALING WITH THIS COMPANY! They give out contradictory warranties, have horrible customer service skills (owners wife), poorly trained pool maintenance staff, and all while the owner himself is non-responsive but told he has a """"temper"""" by staff. My advise: Shop elsewhere and ask to see all warranty info up front and especially potential paver issues / warranty."
4113370,1309231,"2020-09-27 04:37:11","Boorsma Pools",,,"(616) 799-6313","12470 Winter Pines Ct",Sparta,MI,49345,"12470 Winter Pines Ct,Sparta,MI 49345","Handyman Services, Private Swimming Pools, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers, Swimming Pool Repair & Service",,,,43.19083,-85.67651,,,,,,,,,,,,,,,,,,,
4148586,1317775,"2020-09-27 04:37:46","Agape Tile LLC",http://www.agapetile.com,agapetile@earthlink.net,"(239) 454-8453","18635 Coconut Rd","Fort Myers",FL,33967,"18635 Coconut Rd,Fort Myers,FL 33967","Kitchen Planning & Remodeling Service, Automation Systems & Equipment, Bathroom Remodeling, Building Specialties, Carpenters, Counter Tops, Flooring Contractors, Glass-Wholesale & Manufacturers, Glassware-Wholesale & Manufacturers, Home Improvements, Home Repair & Maintenance, Manufacturing Engineers, Mechanical Engineers, Murals, Oil & Gas Exploration & Development, Professional Engineers, Spas & Hot Tubs, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Equipment & Supplies, Swimming Pool Equipment & Supplies-Wholesale & Manufacturers, Swimming Pool Manufacturers & Distributors, Swimming Pool Repair & Service, Tile-Cleaning, Refinishing & Sealing, Tile-Contractors & Dealers, Tile-Wholesale & Manufacturers",4,"4 Reviews",,26.46407,-81.8272,https://i1.ypcdn.com/blob/506ddc268f92df9019809d30f4dc6fb83fb43b8a_100x100_crop.jpg?8ad0f92,"YOUR CUSTOM DESIGN SPECIALISTS Since 1984. WE SPECIALIZE IN CUSTOM SWIMMING POOLS AND SPAS AND ALSO RESIDENTIAL & COMMERCIAL MURALS IN GLASS, STONE, CERAMIC, GEMSTONE & SEASHELL","Agape Tile LLC is an artistic consulting and design company. We have specialized in aquatic design for over 27 years and have been creating murals for residential and commercial installations for over 34 years. We provide you with custom design options for swimming pool and spa interiors and exteriors and pool environs in a timely manner and at an affordable price. Our custom waterlines are typically delivered in two to three weeks. Simple murals in glass have a similar delivery point. Detailed hand cut murals may take four weeks to arrive. For all tile pools, please call us well ahead of your desired installation date. At Agape Tile we turn ideas into reality and transform concepts into completed magnificent installations. Materials used for your custom swimming pool and spa are glass, stone, ceramic, gemstone or seashell. Agape Tile offers a large selection of standard swimming pool murals, medallions and waterlines which may be customized by size and color in hand-cut stone, hand-cut and un-cut glass. Our pools have been featured on HGTV and publicized in Pool and Spa News, Aquascapes, Aqua, Pool and Spa Living, Luxe and Watershapes Magazines. A few of our prestigious customers include the Hilton, YMCA of America, Radisson, Holiday Inn, Westin, Comfort Inn, Ryan Hughes Design Build, Grand Timber Lodge and many private residential pools throughout America and the Caribbean. Should you need field tile, we are distributors for Bisazza (discount offered), Vidrepur, Aim, Kolorines and Mosai and Co. Ceramic lines offered are Fujiwa, National Pool Tile, Dal Tile and Artistry in Mosaics. For shell and gemstone, we are the U.S. Distributor for Mactan Fine Shell and Aqua Imperial Shell and Semi-Precious Gemstone.","Hours Appointment Only Hours Sat 9:00 am - 5:00 pm Regular Hours Mon - Fri: 9:00 am - 5:00 pm","FL Cell Number: (239) 222-1847 North Carolina Office: (828) 334-3747",,"mastercard, company card, discover, cash, check, visa",,,"http://www.agapetile.com https://www.agapetile.com GALLERY",,"Nancy H.",04/21/2018,five,"""This family company is run by great people who really do care about the customer! If trust matters to you, and you appreciate fair pricing along with it, you are at the right ...""morebusiness!""less","Nancy H.",04/21/2018,five,"This family company is run by great people who really do care about the customer! If trust matters to you, and you appreciate fair pricing along with it, you are at the right business!"
5239282,1549039,"2020-09-27 05:00:25","Wallace Landscape Associates",http://www.wallacelandscape.com,wallace@wlai.net,"(610) 444-6161","1244 Baltimore Pike","Chadds Ford",PA,19317,"1244 Baltimore Pike,Chadds Ford,PA 19317","Landscape Designers & Consultants, Architects, Landscape Contractors, Swimming Pool Designing & Consulting",,,,39.87818,-75.5521,,,"Wallace Associates, Inc consists of an award winning team of registered landscape architects with a reputation for talent, creativity, flexibility and scope, to efficiently manage residential landscape architect design and installation projects. Each of our designers, builders and horticulturalists are respected in their discipline, to deliver outstanding results.","Mon - Fri: 8:00 am - 8:00 pm",,,"cash only",,,http://www.wallacelandscape.com,"Parking: Lot",,,,,,,,
5244331,1551176,"2020-09-27 05:00:39","Green O' Aces Pools & Landscape",http://poolsandlandscapevegas.com,info@greenoaces.com,"(702) 682-7051","9300 Provence Garden Ln","Las Vegas",NV,89145,"9300 Provence Garden Ln,Las Vegas,NV 89145","Landscape Designers & Consultants, Architects & Builders Services, Landscaping & Lawn Services, Spas & Hot Tubs-Repair & Service, Swimming Pool Dealers, Swimming Pool Designing & Consulting, Swimming Pool Repair & Service",,,A+,36.16246,-115.29875,,,,,"Phone: (702) 876-7746",,"all major credit cards",,,http://poolsandlandscapevegas.com,,,,,,,,,
5257532,1556763,"2020-09-27 05:00:51","Intex Design & Construction Inc",http://www.intexdandc.com,info@IntexDandC.com,"(213) 465-3134","15021 Ventura Blvd Suite 520","Sherman Oaks",CA,91403,"15021 Ventura Blvd Suite 520,Sherman Oaks,CA 91403","Architects & Builders Services, Building Contractors, Landscape Designers & Consultants, Swimming Pool Dealers, Swimming Pool Designing & Consulting",,,,34.15298,-118.46039,https://i3.ypcdn.com/blob/d0f645099361d8a1948f4efa2a05c63a7575e721_100x100_crop.jpg?adceb05,,,"Mon - Fri: 9:00 am - 5:00 pm","Phone: (626) 233-0674",,,,,"http://www.intexdandc.com https://www.facebook.com/pages/Intex-Design-Construction-Inc/535625033177288","Parking: Street Wheelchair Accessible: Yes Services: Swimming Pools / Backyards /Interior/ Kitchen Remodels / Driveways / BBQ / Fire Pits / Driveways / Pool Resurfacing / Pool Remodeling / Flooring",,,,,,,,
5284531,1568528,"2020-09-27 05:01:33","MH3 Design Group LLC",,mark@mh3designgroup.com,"(763) 400-3944","11425 47th Ave N",Minneapolis,MN,55442,"11425 47th Ave N,Minneapolis,MN 55442","Architects & Builders Services, Landscape Designers & Consultants, Swimming Pool Designing & Consulting",,,A+,45.0403,-93.42504,,,,"Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"check, cash",,,,,,,,,,,,
5298263,1574357,"2020-09-27 05:02:04","B.E.Schaefer Custom Hones",http://homecontractorssanantoniotx.com,,"(210) 334-8794","9927 Red Ascot","San Antonio",TX,78254,"9927 Red Ascot,San Antonio,TX 78254","Architects & Builders Services, Building Construction Consultants, General Contractors, Home Builders, Swimming Pool Designing & Consulting",,,,29.51702,-98.73056,,,,,,,,,,http://homecontractorssanantoniotx.com,,,,,,,,,