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
313546,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",,,,,,,,
343951,113292,"2020-09-27 02:41:10",Blankenstein's,http://blankensteins.com,,"(601) 445-5618","503 N Broadway St",Natchez,MS,39120,"503 N Broadway St,Natchez,MS 39120","Swimming Pool Repair & Service, Building Specialties, Food Processing Equipment & Supplies, Ice Making Equipment & Machines, Janitors Equipment & Supplies, Paper Manufacturers, Paper Products, Restaurant Equipment & Supplies, Swimming Pool Construction, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Water Filtration & Purification Equipment, Water Softening & Conditioning Equipment & Service",,,,31.56448,-91.40375,,"Blankenstein's - a home-town store with big store benefits!",,"Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"all major credit cards, discover",,"Blankenstein's Supplies & Equipment",http://blankensteins.com,"Parking: Free Wheelchair Accessible: Yes",,,,,,,,
411336,139805,"2020-09-27 02:43:51","Aceves Construction and Design Inc.",http://acevesconstruction.com,acevesconstruction@live.com,"(310) 350-8040","2121 W. Imperial Hwy Suite E #471","La Habra",CA,90631,"2121 W. Imperial Hwy Suite E #471,La Habra,CA 90631","Construction Estimates, Apartments, Bathroom Remodeling, Building Construction Consultants, Building Contractors, Concrete Contractors, Condominiums, Drywall Contractors, Electrical Power Systems-Maintenance, General Contractors, Home Builders, Home Design & Planning, Home Improvements, Home Repair & Maintenance, Kitchen Cabinets-Refinishing, Refacing & Resurfacing, Kitchen Planning & Remodeling Service, Patio Builders, Plumbing Contractors-Commercial & Industrial, Residential Designers, Roofing Contractors, Stucco & Exterior Coating Contractors, Swimming Pool Construction",,,,33.91786,-117.96991,,,,"Mon - Sun: Open 24 Hours",,,"check, cash, all major credit cards, financing available, insurance, debit",,,website,,,,,,,,,
697119,240561,"2020-09-27 02:53:34","Falcon Concrete Service",,,"(985) 960-1585",,Slidell,LA,70459,"Slidell,LA 70459","Concrete Restoration, Sealing & Cleaning, Building Contractors, Concrete Contractors, Concrete Equipment & Supplies, Flooring Contractors, Parking Lot Maintenance & Marking, Patio Builders, Stamped & Decorative Concrete, Swimming Pool Construction",,,,,,https://i3.ypcdn.com/blob/594b2f507d86dd6de9c52c8cc61777a66b18fba4_100x100_crop.jpg?63f80dd,,"The Decorative Concrete home for Northshore Homewowners","Mon - Fri: 8:00 am - 5:00 pm",,,,,,,,,,,,,,,
704017,242631,"2020-09-27 02:53:50","Frontier Builders, Int.",http://www.frontierbuilders.com,Angela@FrontierBuilders.com,"(702) 897-7171","8275 S Eastern Ave","Las Vegas",NV,89123,"8275 S Eastern Ave,Las Vegas,NV 89123","Parking Lots & Garages, Altering & Remodeling Contractors, Architects, Architects & Builders Services, Basement Contractors, Bathroom Fixtures, Cabinets & Accessories, Bathroom Remodeling, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Maintenance, Building Specialties, Cabinet Makers, Cabinets, Cabinets-Refinishing, Refacing & Resurfacing, Construction Consultants, Construction Management, Garage Cabinets & Organizers, Garages-Building & Repairing, General Contractors, Hardware Stores, Home Builders, Home Design & Planning, Home Improvements, Home Repair & Maintenance, Kitchen Cabinets & Equipment-Household, Kitchen Cabinets-Refinishing, Refacing & Resurfacing, Kitchen Planning & Remodeling Service, Real Estate Developers, Sunrooms & Solariums, Swimming Pool Construction, Swimming Pool Covers & Enclosures","4,5","11 Reviews",A+,36.03884,-115.11901,https://i3.ypcdn.com/blob/c6b428a6ffce7ad10124fdc3486cf2f2dd23730b_100x100_crop.jpg?63f80dd,"Big Enough To Get The Job Done Small Enough To Care.","Residential & Commercial General Contractor. We can handle any construction project, large or small. We construct new homes/buildings, Remodeling, Room Additions, Remodeling of any kind, and smaller projects as well. Frontier Builders is a ""one stop shop"", we take care of all the work & coordination of your project from start to finish. Call today, we would love to work with you!","Mon - Thu: 8:00 am - 5:00 pm Fri: 8:00 am - 1:00 pm Sat - Sun Closed",,,"check, amex, cash, debit, master card, money order, visa",,,"http://www.frontierbuilders.com http://www.yellowbot.com/frontier-builders-incorporated-henderson-nv.html",,"Dan J.",12/15/2016,five,"Frontier Builders has done 3 remodeling projects for me so far and I am having LaVar come back mid 2017 for my master bathroom remodel! I can't wait!",mebarzio2000,"Edited: 12/14/2016",five,"My husband and I had a wonderful experience with Frontier Builders start to finish!! When they visited our home to give us a FREE estimate they were very professional and courteous. They returned the estimate to us within 1 day and their prices were great!! We had 2 other companies bid our remodel and their prices were higher and it took both of them a week to get back to us. Frontier started our job exactly when they said they would and finished BEFORE they said they would. We stayed in our home throughout the whole remodel process and they made the atmosphere very livable. The on-site staff cleaned up each day and left no mess for us to deal with. We are now getting ready to add onto our home and are once again signing up with Lavar and his staff at Frontier Builders."
706768,243481,"2020-09-27 02:53:52","Westec Builders",https://westec-builders.com,westec1@msn.com,"(720) 739-4350","2850 W 92nd Ave",Denver,CO,80260,"2850 W 92nd Ave,Denver,CO 80260","Kitchen Planning & Remodeling Service, Altering & Remodeling Contractors, Bathroom Remodeling, Building Contractors, Building Specialties, Cabinet Makers, Cabinets, Carports, Foundation Contractors, Garages-Building & Repairing, General Contractors, Home Builders, Home Repair & Maintenance, Parking Lots & Garages, Siding Contractors, Siding Materials, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Vinyl Windows & Doors",,,A+,39.86322,-105.02193,https://i3.ypcdn.com/blob/501f1b51bc404951deb68aaeefd38fa8bbb9afd4_100x100_crop.jpg?63f80dd,,,"Mon - Fri: 8:00 am - 4:00 pm Sat - Sun Closed","303 IMPROVE: (303) 467-7683",,"check, all major credit cards, debit, financing available, insurance, visa, mastercard, cash",,"Wes-Tec Builders Company Inc WesTec Builders",https://westec-builders.com,"Services: Concrete Stamping, Roof Decks, Basement Remodeling, Bathroom Remodeling, Carport Construction, Kitchen Remodeling, Patio Enclosures, Sun Rooms",,,,,,,,
733755,252171,"2020-09-27 02:55:01","Ohio State Striping",http://ohiostatestriping.com,Stripe@OhioStateStriping.com,"(614) 369-1980",,,,,,"Parking Lot Maintenance & Marking, Architectural Designers, Architectural Model Makers, Architectural Support Services, Automobile Storage, Basketball Court Construction, Building Construction Consultants, Building Restoration & Preservation, Commercial & Industrial Flooring Contractors, Commercial Artists, Concrete Staining Services, Construction Consultants, Construction Estimates, Contractor Referral Services, Designers-Industrial & Commercial, Driveway Contractors, Driving Training Equipment, Garages-Building & Repairing, Masonry Contractors-Commercial & Industrial, Painting Contractors, Painting Contractors-Commercial & Industrial, Parking Lots & Garages, Parking Stations & Garages-Construction, Pavement & Floor Marking Services, Restaurant Design & Planning, Road Building Contractors, Service Station Builders & Consultants, Spray Painting & Finishing, Store Fronts, Stripers Mechanical, Swimming Pool Construction, Tennis Court Construction, Traffic & Parking Consultants",,,,,,,,,,"Primary Phone: (614) 447-8060 Phone: (614) 447-8060",,,,,http://ohiostatestriping.com,"Parking: Private",,,,,,,,
736969,253322,"2020-09-27 02:55:23","Us 1 Home Crafters",http://www.skeetrbeatr.com,homecraft1945@gmail.com,"(386) 673-2342","102 Addison Dr","Ormond Beach",FL,32174,"102 Addison Dr,Ormond Beach,FL 32174","Garage Doors & Openers, Awnings & Canopies, Building Contractors, Building Specialties, Cabinet Makers, Cabinets, Door & Window Screens, Home Builders, Home Improvements, Home Repair & Maintenance, Interior Designers & Decorators, Overhead Doors, Parking Lots & Garages, Screen Enclosures, Screens, Storm Windows & Doors, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Windows",,,A+,29.33209,-81.11727,,"Home of SKEETВ’R BEATВ’R, the revolutionary automated roll-up screen, motorized and remote controlled.","We sell Mortorized roll-up screens called the Skeet'r Beat'r. Enjoy ventilated, pest-free environment. They can be used on almost any application for your home, such as garages, porches, windows, sliding glass doors,etc. They come in a variety of colors, choose from regular screening for air flow or solar for privacy and heat reduction. No tracks to trip over or run over with car. Convenient push button or remote controls. We also sell Retractable Screen Doors for single entry way doors, french doors, patio doors and out swing doors. Also, Panorama-lite screens are manual roll-down screens for small garages, windows, small openings up to 10' in width. Re-screening of pools and porches, screen room enclosures","Mon - Fri: 9:00 am - 5:00 pm Sat - Sun Closed",": (386) 673-2372 : (800) 743-4871",,"check, discover, mastercard, visa",,"also known as Skeet'r Beat'r US 1 Home Crafters",http://www.skeetrbeatr.com,,,,,,,,,
951971,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",,,,,,,,
959140,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."
975380,317151,"2020-09-27 03:01:33","Thompson Granite",,tthompsongranite@aol.com,"(337) 662-3249","177 Martin L King Rd","Grand Coteau",LA,70541,"177 Martin L King Rd,Grand Coteau,LA 70541","Burial Vaults, Counter Tops, Granite, Industrial Ceramic Products, Swimming Pool Construction",,,,30.419722,-92.04667,,,,,,,,,,,,,,,,,,,
977802,317722,"2020-09-27 03:01:33","Powerhouse Mason Supply",http://www.powerhousemasonsupply.com,powerhouse85@optonline.net,"(516) 629-5824","85 Powerhouse Rd","Roslyn Heights",NY,11577,"85 Powerhouse Rd,Roslyn Heights,NY 11577","Paving Contractors, Building Contractors, Building Materials, Building Specialties, Masonry Contractors, Masonry Contractors-Commercial & Industrial, Masonry Equipment & Supplies, Stone Natural, Swimming Pool Construction",5,"1 Review",,40.78558,-73.64622,,,"Powerhouse Mason Supply is family owned and operated. We carry Concrete Pavers, Natural Stone, Natural Veneer Stone, Thin stone, Panel stone, and much more","Mon - Sat: 7:00 am - 5:00 pm",,,"mastercard, amex, visa",,,"http://www.powerhousemasonsupply.com http://atmconst.net","Specialties: Masonry","Michael R.",11/11/2014,five,"The whole staff is so pleasant to deal with and so helpful. They explained everything I needed in such great details and were so patient with me. I will be going back to them a lot more as well as referring as much business to them as possible.",,,,
978535,317906,"2020-09-27 03:01:33","Outback Landscape",,,"(972) 262-8700",,"Grand Prairie",TX,75051,"Grand Prairie,TX 75051","Deck Builders, Fence-Sales, Service & Contractors, Landscape Contractors, Patio Builders, Stone Natural, Swimming Pool Construction",,,,,,,"Call Me Today",,,,,,,,,,,,,,,,,
982014,318711,"2020-09-27 03:01:44","Arreola Lawn Maintenance, LLC",http://arreolalawn.com,victorarrerolaladscaping@yahoo.com,"(816) 945-7041","1004 E 23rd St S",Independence,MO,64055,"1004 E 23rd St S,Independence,MO 64055","Sod & Sodding Service, Building Contractors, Building Specialties, Crushed Stone, Foundation Contractors, Gardeners, General Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Lawn Maintenance, Masonry Contractors, Retaining Walls, Sand & Gravel, Stone Natural, Stone Products, Stone-Retail, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Tree Service",,,,39.07886,-94.4023,,,"Contact Arreola Lawn Maintenance for your lawn & landscaping. We know exactly what your home needs. Our trained professionals will work to make your lawn greener and more weed free. Call today for free estimate!","Mon - Sat: 7:00 am - 6:00 pm",,,"cash, check, paypal",,,http://arreolalawn.com,,,,,,,,,
998481,322596,"2020-09-27 03:02:00","FIRSTHAND CONSTRUCTION",https://www.firsthandconstruction.com,jesse@firsthandconstruction.com,"(651) 376-0845","14655 Sycamore St NW",Andover,MN,55304,"14655 Sycamore St NW,Andover,MN 55304","Stone Natural, Altering & Remodeling Contractors, Building Contractors, Building Specialties, Deck Builders, Gazebos, General Contractors, Patio Builders, Roofing Contractors, Siding Contractors, Swimming Pool Construction, Swimming Pool Covers & Enclosures",,,,45.23613,-93.28892,https://i1.ypcdn.com/blob/99afd0c98fcb7bc6b28f5554ced0c0263f59a3cd_100x100_crop.jpg?f9d23e1,"Built With Integrity!","Firsthand construction is a builder of premium decks with the highest quality! What sets Firsthand Construction apart is our team making sure that all the work we deliver is absolutely flawless. After all, our superior quality Deck Contractor is precisely what separates us from other similar companies. Whether you need a small touch up or you're thinking of a bigger project, let us know what you need and well help you out. What sets Firsthand Construction apart is our team making sure that all the work we deliver is absolutely flawless. After all, our superior quality Deck Contractor is precisely what separates us from other similar companies. Whether you need a small touch up or youre thinking of a bigger project, let us know what you need and well help you out. Call us now!","Mon - Thu: 9:00 am - 5:00 pm Fri - Sat Closed Sun: 9:00 am - 5:00 pm",,,,,,https://www.firsthandconstruction.com,,,,,,,,,
1000894,323161,"2020-09-27 03:02:10","Green Rebecca",,jerrygreenconcrete@yahoo.com,"(828) 926-1719","76 Morning Dew Dr","Maggie Valley",NC,28751,"76 Morning Dew Dr,Maggie Valley,NC 28751","Sand & Gravel, Building Contractors, Building Specialties, Concrete Contractors, Concrete Equipment & Supplies, Crushed Stone, Foundation Contractors, Masonry Contractors, Stone Natural, Stone Products, Stone-Retail, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,35.52888,-83.08567,,,"Concrete Foundations, Bar-b-que Grills, Greenhouses, Sun rooms Concrete Sawing, Breakout, Concrete Hauling, Swimming Pool Repair, Cutting, Concrete Restoration, Concrete Sealing, FULLY LICENSED & INSURED, OVER 40 YEARS OF EXPERIENCE IN DEMOLITION, CONCRETE PUMPING, BREAKING, CUTTING & SAWING, BLOCK FILL, BASEMENT WALLS, concrete Staining, Concrete",,,,"cash, check, master card, visa",,,,,,,,,,,,
1005859,324321,"2020-09-27 03:02:20","Johnson City Stone Supply",http://www.jcstonesupply.com,zach@johnsoncitystone.com,"(423) 440-8318","3552 W Market St","Johnson City",TN,37604,"3552 W Market St,Johnson City,TN 37604","Stone Natural, Building Contractors, Building Specialties, Masonry Contractors, Swimming Pool Construction",1,"1 Review",,36.31387,-82.42251,,,"Johnson City Stone Supply is family owned and operated in Johnson City, TN offering Timeless Beauty and Practicality. Professional installation by expert masonry contractors. -Swimming Pool Design and Installation -Waterscapes -Outdoor Entertainment Areas -Stone/Brick Pizza Ovens -Fireplaces -Patios -Steps -Retaining Walls -Mailboxes -and more...","Mon - Fri: 8:00 am - 5:00 pm Sat: 9:00 am - 3:00 pm",,,,,,"http://www.jcstonesupply.com http://www.johnsoncitystone.com",,"Dan S.",06/23/2016,one,"Don't buy stone from this guy..he is way way way over priced charging 150 dollars per ton for river rock...lol he told me flat out "" I have the best prices in tricities"" come to find out he has the worst prices in jc..he was actually charging me almost 3 times as much then other folks..I got a ton of river rock for 60 dollars at ""down to earth"" off old kingsport highway...not to mention he was charging 80 dollars to deliver a few miles down the road...down to earth only charged 50 dollars to deliver twice as far..long story short..over priced, bad service, plus you have to listen to this guy talk out his butt like he is doing you a favor...go somewhere else and save time and money",,,,
1006952,324594,"2020-09-27 03:02:20","A-Fast Tile & Coping",http://www.4afasttile.com,ramon@afasttile.com,"(817) 535-7274","2201 E Maddox Ave","Fort Worth",TX,76104,"2201 E Maddox Ave,Fort Worth,TX 76104","Granite, Contractors Equipment & Supplies, Landscape Contractors, Masonry Contractors, Swimming Pool Construction, Tile-Contractors & Dealers",,,,32.72707,-97.29738,,,"A-Fast Tile, Stone & Coping is a professional masonry contractor located in Fort Worth. We specialize in pool renovation, outdoor living areas, granite and stone fabrication. We also offer stone masonry services, such as custom patios, flagstone decks and decorative stone landscaping.","Mon - Fri: 7:30 am - 5:00 pm",,,"check, all major credit cards, amex, discover, master card, visa",,,"http://www.4afasttile.com http://afasttile.com http://www.afaststone.com",,,,,,,,,
1026936,329441,"2020-09-27 03:02:46","Long Island Marble Dusting",http://longislanddust.com,longislanddust@aol.com,"(631) 923-3332","680 E Jericho Tpke","Huntington Station",NY,11746,"680 E Jericho Tpke,Huntington Station,NY 11746","Marble & Terrazzo Cleaning & Service, Masonry Contractors, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,40.83405,-73.38409,,"Long Island Marble Dusting Provides Marble Dusting, Gunite Pool Renovation, Gunite Pool Coping, Gunite Pool Tile & Pool Patios To The Huntington Station, NY Area.",,"Mon - Fri: 9:00 am - 3:00 pm","Primary Phone: (631) 923-3332 Phone: (631) 351-1088",,"amex, discover, master card, visa, cash",,"Long Island Marine Co Long Island Marine Co Inc",http://longislanddust.com,,,,,,,,,
1031658,330609,"2020-09-27 03:02:55","Malosi Tile and Stone, LLC",,malositileandstone@gmail.com,"(808) 728-7965",,,,,,"Floor Materials-Wholesale & Manufacturers, Building Specialties, Importers, Marble-Natural, Stone Natural, Swimming Pool Construction, Tile-Contractors & Dealers",,,,,,,"""where strength and beauty come together""","Malosi Tile and Stone is a locally owned and operated natural stone tile, paver, and pool coping supplier in Hilo. We supply projects throughout the island chain and offer one of the finest stone tile selections in Hawai'i. Our main focus and goals in business are customer service, quality, and price, and we pride ourselves in delivering just that. We go out of our way to treat every customer like Ohana and to make their experience with us a pleasant and relaxful one.","Mon - Fri: 8:00 am - 5:00 pm Sat: 8:00 am - 3:00 pm Sun Closed","Sina: (808) 315-9693",,"check, cash",,,,,,,,,,,,
1032499,330844,"2020-09-27 03:02:55","Ramahi Tile & Stone",http://www.ramahitile.com,ramahitile@gmail.com,"(916) 355-8700","12181 Folsom Blvd Ste D","Rancho Cordova",CA,95742,"12181 Folsom Blvd Ste D,Rancho Cordova,CA 95742","Kitchen Planning & Remodeling Service, Bathroom Remodeling, Flooring Contractors, Granite, Swimming Pool Construction, Swimming Pool Repair & Service, Tile-Contractors & Dealers, Tile-Wholesale & Manufacturers",,,A+,38.62769,-121.22134,,"TILE STONE BRICK MOSAIC MARBLE! We would love to bring your idea to life. Call RTS today!","Family Owned Local Business providing tile & stone installation and design for swimming pools, floors, kitchen & bath in the Sacramento, El Dorado, and Placer areas. Our showroom displays natural stone, glass, ceramic, and porcelain tile for creative and elegant designs! We also carry beautiful mosaic tiles to add an extra touch to your home improvement project. We are Licensed (# 928358), Insured & Bonded and would love to bring your idea to life.We use Angie's List to allow customers to assess whether we're doing a good job and to make sure customers like you will be assured and happy.","Mon - Sat: 10:00 am - 5:00 pm Sun: 11:00 am - 3:00 pm","Fax Inquiries: (916) 266-9293",,"all major credit cards, check, debit, insurance",,,"Tile &amp.amp. Stone Sales and Installation","Parking: Lot",,,,,,,,
1234667,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!",,,,
1244249,399117,"2020-09-27 03:09:22","Flannery's Drop Box Service, Inc.",http://www.angieslist.com/companylist/us/or/fairview/flannery%27s-drop-box-service-inc-reviews-286639.htm,scottbarbach@ortrash.com,"(503) 669-8002","2430 NW Marine Dr",Troutdale,OR,97060,"2430 NW Marine Dr,Troutdale,OR 97060","Rubbish & Garbage Removal & Containers, Architects & Builders Services, Architectural Support Services, Building Contractors, Building Specialties, Children's Instructional Play Programs, Concrete Contractors, Construction Site-Clean-Up, Contractors Equipment & Supplies, Educational Services, Foundation Contractors, Garbage & Rubbish Removal Contractors Equipment, Garbage Collection, General Contractors, Landscaping Equipment & Supplies, Lawn & Garden Equipment & Supplies, Masonry Contractors, Patio Builders, Recycling Equipment & Services, Spas & Hot Tubs, Stone Cutting, Stoneware, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Tutoring, Waste Recycling & Disposal Service & Equipment, Youth Organizations & Centers",,,,45.547,-122.41123,https://i2.ypcdn.com/blob/838ac99ecbe2bc82e16351e51071c73b89dbe59b_100x100_crop.jpg?f9d23e1,,"Whether your project is residential, commercial or industrial, we can help you find the perfect option to stay within budget and eliminate the hassles of material disposal. In addition to receiving the fastest same-day service around, you can also take advantage of our exclusive additional disposal discounts for composition roofing.","Mon - Fri: 7:00 am - 5:00 pm Sat - Sun Closed",,,"amex, check, discover, master card, visa, cash, debit, diners club",,,http://www.angieslist.com/companylist/us/or/fairview/flannery%27s-drop-box-service-inc-reviews-286639.htm,,,,,,,,,
1281633,410001,"2020-09-27 03:10:15","Associated Builders",http://associatedpoolbuilders.com,,"(701) 224-9729",,Bismarck,ND,58502,"Bismarck,ND 58502","General Contractors, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Building Specialties, Metal Buildings, Real Estate Developers, Steel Erectors, Swimming Pool Construction",,,,,,,,,"Mon - Fri: 8:00 am - 5:00 pm","Phone: (701) 258-7302 Fax: (701) 224-9729",,,,"Associated Supply Co",http://associatedpoolbuilders.com,,,,,,,,,
1300137,415242,"2020-09-27 03:10:42","Associated Pool Builders",http://www.associatedpool.com,,"(701) 258-6012","2121 Lovett Ave",Bismarck,ND,58504,"2121 Lovett Ave,Bismarck,ND 58504","Swimming Pool Construction, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Specialties, Construction Consultants, Garages-Building & Repairing, General Contractors, Home Builders, Home Centers, Metal Buildings, Plumbers, Real Estate Developers, Spas & Hot Tubs, Steel Erectors, Swimming Pool Dealers",,,A+,46.79288,-100.75812,,,"At Associated Pool Builders, we've been offering quality pools and hot tubs since 1959. Serving the residential and commercial market with hot tubs and whirlpools, swimming pools and any accessory you may need. We Proudly offer the Following Services to the upper Midwest: -Commercial Swimming Pool Construction -Concrete Swimming Pool Construction -Gunite Swimming Pool Construction -Indoor Swimming Pool Construction -New Swimming Pool Construction -Commercial and Residential Hot Tubs -Swimming Pool and Hot Tub chemicals and accessories. -Builders of Distinctive Pools Distinctive designs, quality materials and experienced staff will help you create a convenient, healthy, delightful gathering place for family and friends.","Mon - Fri: 8:00 am - 5:00 pm","Fax: (701) 224-9729",,"visa, discover, mastercard, all major credit cards, financing available",,"Associated Builders Inc",http://www.associatedpool.com,"Specialties: Hotels / Motels",,,,,,,,
1319515,420775,"2020-09-27 03:11:07",Double-E-Rebar,,doubleerebar@yahoo.com,"(832) 386-8544","6018 Moonmist Dr",Houston,TX,77081,"6018 Moonmist Dr,Houston,TX 77081","Deck Builders, Lake & Pond Construction, Steel Detailers Structural, Swimming Pool Construction, Swimming Pool Dealers","2,5","2 Reviews",,29.71122,-95.48784,,"Many years of experience and offer best deals possible to all customers","We provide any service which involves steel(rebar) in any project Residential or commercial. We do our best to provide quality workmanship on any and every project. We like to offer the best deals possible to every customer.","Mon - Sun: 8:00 am - 5:00 pm",,,,,,,,"Mike T.","Edited: 10/02/2016",one,"Complete joke doubt they are in business anymore but just in case they are DO NOT HIRE THESE CLOWNS FOR ANYTHING. The only other post on here is the guy that runs this crap show and it is exactly that. He tries to do things at such a low cost it will end up costing more in the end, work will drage on for months becaus he won't pay his workers. I wouldn't hire this guy to watch my plants grow AVOID AT ALL COSTS.",elmer6018,03/25/2010,four,"They provided good workmanship and got the job done. It looked impossible to get done but they pulled it off."
1324700,422234,"2020-09-27 03:11:18","Cope Brothers Construction",http://www.copebros.com,copeconstruction@optilink.us,"(706) 226-0989","1007 Richards St",Dalton,GA,30721,"1007 Richards St,Dalton,GA 30721","General Contractors, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Home Builders, Metal Buildings, Steel Erectors, Swimming Pool Construction, Swimming Pool Dealers",,,A+,34.7631,-84.9518,,,,"Mon - Sun: 8:00 am - 4:30 pm","Phone: (706) 226-9772 Fax: (706) 226-9772 Fax Number: (706) 226-9772",,"cash, check, debit, master card, visa",,,http://www.copebros.com,,,,,,,,,
1337764,425898,"2020-09-27 03:11:38","S & S Builders",http://ssbuildersllc.com,spotter@ssbuildersllc.com,"(307) 257-6079","716 Road 128a",Cheyenne,WY,82007,"716 Road 128a,Cheyenne,WY 82007","Excavation Contractors, Altering & Remodeling Contractors, Asphalt Paving & Sealcoating, Basement Contractors, Bathroom Remodeling, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Maintenance, Building Restoration & Preservation, Building Specialties, Cabinet Makers, Cabinets, Carports, Ceilings-Supplies, Repair & Installation, Concrete Contractors, Construction Management, Deck Builders, Drywall Contractors, Foundation Contractors, Garages-Building & Repairing, Gazebos, General Contractors, Grading Contractors, Home Builders, Home Improvements, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Log Cabins, Homes & Buildings, Masonry Contractors, Metal Buildings, Mobile Home Dealers, Modular Homes, Buildings & Offices, Patio Builders, Paving Contractors, Stair Builders, Stamped & Decorative Concrete, Steel Erectors, Sunrooms & Solariums, Swimming Pool Construction, Utility Contractors",,,,41.12296,-104.74954,,"Providing World-Class Construction Since 1981","S & S Builders, LLC has been a Gillette, WY area general contractor and subcontractor since 1982. In 1998, we opened an additional office in Cheyenne, Wyoming. Our staff has diverse backgrounds providing us with a wide range of talents. We have the resources and expertise necessary to provide a wide variety of services to our customers, helping them make their construction dreams a reality. We specialize in: Commercial and industrial concrete projects Design/build commercial buildings Land development Commercial bid projects At S & S Builders, LLC, we attribute our success to a combination of workmanship, exceeding our client's expectations and our long-term relationships with customers and team members. We realize how hard it is to find a contractor you can rely on, and we are confident that we will be able to deliver the results you are looking for in a professional manner. Call S & S Builders, LLC today for more informat","Mon - Fri: 7:30 am - 5:00 pm Sat - Sun Closed","Fax: (307) 682-9335",,"amex, discover, visa, master card",,,http://ssbuildersllc.com,,,,,,,,,
1343164,427482,"2020-09-27 03:11:50","Blood Sweat & Rebar Inc",,,"(925) 687-8246",,Concord,CA,94520,"Concord,CA 94520","Steel Fabricators, Swimming Pool Construction",,,,,,,,"Founded in 1975, Blood Sweat and Rebar Inc. is a small structural steel erection contractor in Martinez, California. Offers Swimming Pool and Spa Construction services.",,,,,,,,,,,,,,,,
1350507,429666,"2020-09-27 03:12:04","C & H Fence & Patio",http://www.candhfence.com,chfence@atg1.com,"(661) 855-4489","1752 Girard St",Delano,CA,93215,"1752 Girard St,Delano,CA 93215","Fence-Sales, Service & Contractors, Awnings & Canopies, Building Contractors, Building Materials, Building Specialties, Carports, Deck Builders, Fence Materials, Fence Repair, Fence-Wholesale & Manufacturers, Gates & Accessories, Iron Ornamental Work-Supplies, Metal Tanks, Metal Tubing, Ornamental Metal Work, Patio Builders, Rental Service Stores & Yards, Steel Erectors, Steel Processing, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Vinyl Fences",,,A+,35.77902,-119.24939,,,"*Construction Fence Rentals *At Your Home Estimates *Se Habla Espanol *Serving Kern, Tulare & Kings Counties Since 1967 *Electric Gate Operators *Sales & Installation","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed","Delano: (661) 725-3600 Fax: (661) 725-0580",,"visa, discover, check, master card, cash",,,http://www.candhfence.com,"Specialties: Swimming Pools, Commercial, Farms, Business, Industrial, Residential, Tennis Courts, Homes, Yards",,,,,,,,
1354356,430752,"2020-09-27 03:12:14","All-Star Fence Company",https://api.superpages.com/xml/search?SRC=ypintfeed&subaffiliate=DXC&PGID=e02.7182.8182845904523&SPGID=1583655450365.f953f81f&ADID=5894347&DEST=http%3A%2F%2Fallstarfencelv.mydex.com%2FdH5NQh-Ejc4&C=steel&T=Las%20Vegas&S=NV&PH=(702)%20979-1151&FL=url&TL=off&position=22&PS=30&PI=1&Results=FEED_CLCK&uid=f953f81f-fc40-427d-9170-63608fab1b3e&REF=&IP=172.104.191.106&UserAgent=Mozilla%2F5.0%20(Windows%20NT%2010.0%3B%20Win64%3B%20x64)%20AppleWebKit%2F537.36%20(KHTML%2C%20like%20Gecko)%20Chrome%2F70.0.3538.110%20Safari%2F537.36,lisa@allstarfencelv.com,"(702) 979-1151","4845 W Reno Ave","Las Vegas",NV,89118,"4845 W Reno Ave,Las Vegas,NV 89118","Fence-Sales, Service & Contractors, Building Contractors, Building Specialties, Fence Repair, Gates & Accessories, Metal Tanks, Metal Tubing, Steel Erectors, Steel Processing, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Vinyl Fences, Welders",,,,36.09675,-115.20666,https://i4.ypcdn.com/blob/25a68d0cfcb54905ca35c130e2644b92b63d323c_100x100_crop.jpg?63f80dd,"Serving Southern Nevada Since 2003.","All Star Fence Company of Las Vegas, NV has been providing comprehensive fencing services for commercial, industrial and residential customers throughout Southern Nevada since 2003. We handle everything from home fencing installation to custom fencing and even event and crowd control fences. Our fencing solutions are limitless. Our fences include: В• Wood fences В• Vinyl fences В• Chain link fencing В• Iron fences В• Dog kennels В• Security and construction rental fencing В• Fence gates В• Crowd control fencing Whether your focus is more aesthetic or top security-minded, we are well-equipped, skilled and experienced to fulfill your request. All-Star Fence has been a reputable source for fencing and gates in southern Nevada for over a decade. We offer a complete range of solutions for general contractors, wholesale industries, casinos, state and county agencies and other government agencies. Call All Star Fence Company today for more information.","Mon - Fri: 7:00 am - 4:00 pm",,,"mastercard, check, discover, amex, visa",,,http://www.allstarfencelv.com,"Specialties: Commercial, Business, Residential, Homes Services: Ironwork, Pool Enclosures",,,,,,,,
1354897,430905,"2020-09-27 03:12:14","Home Center Construction Inc",http://www.hccgeneralcontractors.com,hcc@hccgeneralcontractors.com,"(620) 231-0992","420 W Atkinson Rd",Pittsburg,KS,66762,"420 W Atkinson Rd,Pittsburg,KS 66762","General Contractors, Altering & Remodeling Contractors, Building Construction Consultants, Building Contractors, Building Contractors-Commercial & Industrial, Building Specialties, Cabinet Makers, Cabinets, Concrete Contractors, Deck Builders, Home Builders, Home Centers, Kitchen Cabinets & Equipment-Household, Kitchen Cabinets-Refinishing, Refacing & Resurfacing, Metal Buildings, Steel Erectors, Swimming Pool Construction, Swimming Pool Dealers",,,,37.44052,-94.70968,,,,,"Phone: (620) 231-6962 Fax: (620) 231-6962",,,,,http://www.hccgeneralcontractors.com,"Specialties: Cabinetry, Cabinets, Buildings",,,,,,,,
1366177,434207,"2020-09-27 03:12:37","Arizona Civl Contructors",http://www.arizonacivil.com,,"(702) 366-0567","737 N Main St","Las Vegas",NV,89101,"737 N Main St,Las Vegas,NV 89101","Cabanas, General Contractors, Landscape Contractors, Steel Fabricators, Swimming Pool Construction",,,,36.17985,-115.14182,,,"General Construction (residential), custom home remodeling, framing, drywall and painting. Landscaping, pools and concrete. Steel fabrication, misting technologies, cabanas, trellis' and fabric structures.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"check, cash",,,"General Contractor",,,,,,,,,
1587128,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!",,,,
1587850,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",,,,,,,,
1592037,495771,"2020-09-27 03:19:11","Emerald Hearth, Spa & Patio",http://www.emeraldpool.com,mediarep@laycorp.com,"(541) 688-1090","1885 Highway 99 N",Eugene,OR,97402,"1885 Highway 99 N,Eugene,OR 97402","Home Improvements, Awnings & Canopies, Bathroom Remodeling, Building Contractors, Building Specialties, Cabinet Makers, Cabinets, Fireplace Equipment, Furniture Stores, General Contractors, Heating Equipment & Systems, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Major Appliances, Patio & Outdoor Furniture, Patio Equipment & Supplies, Plumbing Fixtures, Parts & Supplies, Screen Enclosures, Small Appliances, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Repair & Service","2,5","8 Reviews",,44.08226,-123.15246,,"Locally Owned For 59 Years.","Locally Owned For 59 Years. Since 1955, Emerald Hearth, Spa & Patio has been a Eugene, OR leader in the sales, installation, maintenance, service, and repair of heating sources for the inside of your home and recreational items for the outside of your home. Our outdoor products include a wide range of hot tubs, pools, patio furniture, grills, and related accessories. Our indoor products include fireplaces, heating stoves, and hearths. Below are just some of our top-of-the-line products: In- and above-ground spas and hot tubs. In- and above-ground swimming pools. Pool and spa chemicals. Patio furniture, Barbecues and grills. Wood, gas, and pellet stoves. Wood, gas, and electric fireplaces. Hearths. We've been keeping you warm in winter, and helping you have fun outdoors in summer for nearly 60 years. Our professional staff are factory-trained and certified. Our products are cost-effective, energy-efficient, and environmentally friendly. Are you ready to relax in your spa or in front of your fireplace? Then call Emerald Hearth, Spa & Patio today!","Mon - Sat: 9:00 am - 6:00 pm Sun: 11:00 am - 4:00 pm",,,"amex, cash, master card, discover, visa",,,http://www.emeraldpool.com,"Parking: Lot, Free",june.gordonstrome,09/06/2013,one,"Worse service manager in town he is a rude crude disgusting man named Pat. He is not good for this company he talks down to people and is disgusting. If I was the comptroller at this store I would fire him in a second I would never allow this in the companies I have run!","un satisfied",06/06/2011,one,"We bought a new spa from emerald 1 yr ago we have had nothing but problems with it. I have complained to the owner and still havent been able to get anything taken care of. STAY AWAY FROM THIS BUSINESS we finally hired another business on w11th to fix the problems we highly recomend them OVER emerald pool & patio"
1593313,495992,"2020-09-27 03:19:11","ABC Seamless Of Nebraska",http://www.abcofnebraska.com,abcomaha@hotmail.com,"(402) 477-5400","4700 Cornhusker Hwy",Lincoln,NE,68504,"4700 Cornhusker Hwy,Lincoln,NE 68504","Siding Contractors, Altering & Remodeling Contractors, Building Contractors, Building Specialties, Door & Window Screens, Door Repair, Doors, Frames, & Accessories, Gutters & Downspouts, Home Improvements, Home Repair & Maintenance, Roofing Contractors, Screens, Siding Materials, Storm Windows & Doors, Sunrooms & Solariums, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Windows",,,,40.85195,-96.65459,https://i3.ypcdn.com/blob/883ab4995f406385dfed10e7e012b6b011ef3476_100x100_crop.jpg?f832250,,"Your home is one of the biggest investments you will ever make, and products like house siding, gutters and roofing are some of your first lines of defense in protecting your home from heavy weather, rot, and even rodents. So, when you choose an exterior for your home, you want to be sure youre getting a durable product that will protect your house from the harsh Midwest elements while enhancing the value and appearance of your home. At ABC Seamless, we sell and install a wide range of products, from house siding to gutters, which are superior in quality, durability and beauty to virtually any other products on the market. Most home improvement companies offer wood or vinyl house siding, asphalt roofing, and other products made with materials that are prone to warping, fading, and cracking. Plus most of those other products need constant painting, replacing and maintenance! At ABC Seamless, we manufacture our products and they are made of steel. Steel offers superior protection from moisture, wind, and other elements and can last indefinitely. Additionally, our steel products feature a chip- and fade-resistant coating, so our house siding, roofing, and gutters are maintenance free.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed",,,"visa, amex, discover, master card, cash, check, financing available",,,http://www.abcofnebraska.com,,,,,,,,,
1607660,498327,"2020-09-27 03:19:18","Green Future Remodeling",http://greenfutureconstruction.com,,"(818) 462-3888","18375 Ventura Blvd",Tarzana,CA,91356,"18375 Ventura Blvd,Tarzana,CA 91356","Home Improvements, Bathroom Remodeling, Building Contractors, Kitchen Planning & Remodeling Service, Swimming Pool Construction",5,"2 Reviews",,34.168,-118.53371,https://i3.ypcdn.com/blob/660f5979a8cb192f50e92e914269f2712fd6ef82_100x100_crop.jpg?f832250,,,"Mon - Fri: 7:30 am - 7:00 pm Sun: 7:30 am - 7:00 pm",,,"paypal, all major credit cards",,,"Green Future Remodeling",,"Ann A.",06/06/2016,five,"What a great group of contractors! These guys followed through on everything they promised. I had two bathrooms and my master bedroom completely remodeled and all of my floors replaced. The work took a little over two months. In that time, I saw the same workers working every day. They were friendly and all of the work was done in an organized manner. The home was kept as clean as possible. It is truly amazing. Everything I hoped for. I hope to remodel my kitchen someday, and Green Future Construction will be the ones to do it. I trust all of the men who worked for me and would hire them again.","Kenneth P.",06/04/2016,five,"My extremely old and ugly kitchen was in desperate need of an update so I reached out to several home remodeling contractors for ideas and estimates. I liked the vision proposed by Moses for my kitchen the best and although his estimate was not the cheapest, it was the most detailed and seemed to leave no room for any surprises. Moses took the time to make sure I was comfortable with everything, did very high quality work, and finished the project within budget. I am very pleased with the beautiful modern kitchen remodel built for me and am looking forward to working with Green Future again on future projects."
1608274,498420,"2020-09-27 03:19:18","Malone Construction CO. INC.",,malone4construction@gmail.com,"(724) 443-6662","5807 State Rd",Gibsonia,PA,15044,"5807 State Rd,Gibsonia,PA 15044","Concrete Contractors, Driveway Contractors, Excavation Contractors, Foundation Contractors, Garages-Building & Repairing, General Contractors, Home Improvements, Masonry Contractors, Swimming Pool Construction",,,A+,40.65955,-79.96803,,,,,"Phone: (724) 272-6888",,,,,,,,,,,,,,
1616306,499787,"2020-09-27 03:19:21","Alpha & Omega Siding & Windows L.L.C.",http://www.alphaomegasiding.com,manuel@alphaomegasiding.com,"(361) 360-5689","5715 Christine St","Corpus Christi",TX,78415,"5715 Christine St,Corpus Christi,TX 78415","Roofing Contractors, Altering & Remodeling Contractors, Architects, Architects & Builders Services, Bathroom Remodeling, Building Contractors, Building Specialties, Door & Window Screens, Fine Art Artists, General Contractors, Glass Blowers, Home Improvements, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Metal Buildings, Shutters, Siding Contractors, Siding Materials, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Windows, Windows-Repair, Replacement & Installation",,,A+,27.721676,-97.42469,,"WE HAVE YOUR REMODELING NEEDS COVERED","Alpha & Omega Siding & Windows, L.L.C. is a locally owned Christian company to trust with every facet of your home. We are unique in the remodeling business because we go further than our competitors. Our experience branches out into other areas to provide full-service remodeling and repair. You would be hard pressed to find contractors with such experience at their disposal, especially at a competitive rate. We do our best to make sure your home is everything it should be. If you have any additional questions or would like a free estimate or consultation, please call us today.","Mon - Fri: 9:00 am - 5:00 pm Sat - Sun Closed",,,"cash only, check, master card, visa, amex, discover",,,http://www.alphaomegasiding.com,"Wheelchair Accessible: Yes Parking: Lot, Free",,,,,,,,
1618920,500213,"2020-09-27 03:19:30","A2Z Fence",,,"(845) 608-6004","126 Bethune Blvd","Spring Valley",NY,10977,"126 Bethune Blvd,Spring Valley,NY 10977","Landscape Contractors, Deck Builders, Fence Materials, Fence Repair, Fence-Sales, Service & Contractors, Fence-Wholesale & Manufacturers, General Contractors, Home Improvements, Home Repair & Maintenance, Landscaping & Lawn Services, Painting Contractors, Roofing Contractors, Siding Contractors, Snow Removal Service, Swimming Pool Construction, Vinyl Fences",,,,41.11972,-74.03774,https://i1.ypcdn.com/blob/7737fdd960dd69da669831ab87277039e275013f_100x100_crop.jpg?f832250,,,"Mon - Fri: 9:00 am - 5:00 pm Sat: 9:00 am - 12:00 pm",,,check,,,,,,,,,,,,
1620464,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."
1624496,501103,"2020-09-27 03:19:40","Silverhawk Services",https://m.facebook.com/Silverhawkserviceswa-159255784626644,silverhawkdavid@gmail.com,"(206) 395-2455","531 NE 79th St",Seattle,WA,98115,"531 NE 79th St,Seattle,WA 98115","Swimming Pool Construction, Bathroom Remodeling, Building Contractors, Building Specialties, Cabinet Makers, Cabinets, Fire & Water Damage Restoration, General Contractors, Home Improvements, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Painting Contractors, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service, Water Damage Restoration",,,,47.68585,-122.32149,,"General Contractor SILVES*835KH. Licensed bond insured. Inside and out side painting remodels and pool painting. Clean and do not leave job sight looking like a job site. We work with you to do the best job the way you like it the best.","Silverhawk Services is a painting and restoration contractor serving homeowners and businesses in the Seattle Metro area, and Snohomish County. We pride our company on reliability, great communication, integrity, and quality work. We are experts in our trade and will do our best to keep you as educated as we can on your particular task or project. We take pride in doing every job right the first time, and if you choose Silverhawk Services, you can rest assured that your satisfaction is our #1 priority. Service Area: Seattle Metro Snohomish County Quick Facts: Credit Cards Accepted Materials Free Estimates Business Hours: Monday Friday : 9 am 7 Pm Sat Sun: 10 am 7 pm EMERGENCY 24 HOUR SERVICE AVAILABLE (additional charges apply) Discounts: Seniors & Military 10% Services and Expertise in: Interior Painting Exterior Painting Swimming Pool Restoration & Painting Fire Damage Restoration (Including Insurance Claims) Remodeling Kitchen Cabinet Refinishing We are licensed, bonded and insured, and free estimates are gladly provided. Before scheduling your next project, be sure to give us a call. Youll be happy you did!","Mon - Sun: Open 24 Hours",,,,,,https://m.facebook.com/Silverhawkserviceswa-159255784626644,,,,,,,,,
1630419,502111,"2020-09-27 03:19:43","Memphis Fence Co",http://www.memphisfence.com,contact@memphisfence.com,"(901) 278-9710","1380 N Willett St",Memphis,TN,38108,"1380 N Willett St,Memphis,TN 38108","Home Improvements, Building Specialties, Cabinet Makers, Cabinets, Fence Materials, Fence Repair, Fence-Sales, Service & Contractors, Gates & Accessories, Home Repair & Maintenance, Landscape Designers & Consultants, Landscaping & Lawn Services, Ornamental Metal Work, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",2,"1 Review",A+,35.17672,-90.00548,,"THE RIGHT CHOICE!","Memphis Fence Company is a National Award Winning Fence Contractor. We are licensed in Tennessee, Mississippi, and Arkansas. Memphis Fence Company offers pricing and installation for clear cedar, chain link and vinyl-coated chainlink, cedar split rail, aluminum and ornamental iron. We have been bringing the highest level of service to the Mid-South area for over 30 years.","Mon - Sat: 8:00 am - 5:00 pm",,,"all major credit cards, amex, discover, mastercard, visa",,,http://www.memphisfence.com,"Specialties: Commercial, Business, Industrial, Residential, Special Events, Homes Parking: Lot",jerry.daniel.528,04/11/2013,two,,,,,
1639392,503584,"2020-09-27 03:19:49","Four Seasons Grounds Care Inc",http://www.fourseasonsgc.com,info@fourseasonsgc.com,"(570) 842-3230","2085 Hamlin Hwy",Moscow,PA,18444,"2085 Hamlin Hwy,Moscow,PA 18444","Holiday Lights & Decorations, Asphalt Paving & Sealcoating, Concrete Blocks & Shapes, Concrete Contractors, Concrete Staining Services, Containers, Excavation Contractors, Fence Materials, Fertilizers, Firewood, Home Improvements, Hydroseeding, Ice Melting Equipment & Supplies, Landscape Contractors, Landscape Designers & Consultants, Landscaping & Lawn Services, Mulches, Nurseries-Plants & Trees, Paving Contractors, Ready Mixed Concrete, Real Estate Agents, Retaining Walls, Salt, Snow Removal Service, Spas & Hot Tubs, Sprinklers-Garden & Lawn, Stamped & Decorative Concrete, Stone Products, Street Cleaning, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Swimming Pool Dealers, Swimming Pool Equipment & Supplies, Topsoil, Tree Service, Trucking",5,"4 Reviews",,41.38856,-75.44751,https://i3.ypcdn.com/blob/394108deef7308c22496b4722074f7f5c2fdb494_100x100_crop.jpg?f832250,,,"Mon - Fri: 8:00 am - 6:00 pm Sat: 8:00 am - 12:00 pm","Phone: (570) 689-5296 Fax: (570) 689-5296",,"check, visa",,,http://www.fourseasonsgc.com,"Specialties: Tree Removal Services: DrivewaysPatiosStamped ConcreteWalkways","John W.",08/29/2018,five,"Highly recommend! Excellent company to deal with! Installed our inground swimming pool and beautiful stamped concrete! Within budget! Coordinated our landscaping and pool house! Enjoying our paradise!","Lieslie B.",07/12/2018,five,"Highly Recommend! Guys did an amazing Job! Designer Pool Company and Four Seasons Grounds Care installed our inground swimming pool, fence, concrete decking and landscaping!"
1646238,504724,"2020-09-27 03:19:59",ABConstruction,https://www.abchouserepair.com,abcon@abconctuctllc.com,"(253) 248-7719","18002 15th Ave E",Spanaway,WA,98387,"18002 15th Ave E,Spanaway,WA 98387","Patio Builders, Altering & Remodeling Contractors, Bathroom Remodeling, Building Contractors, Building Specialties, Deck Builders, Fence Repair, Fence-Sales, Service & Contractors, General Contractors, Home Improvements, Home Repair & Maintenance, Kitchen Planning & Remodeling Service, Roof Decks, Roofing Contractors, Roofing Equipment & Supplies, Siding Contractors, Siding Materials, Swimming Pool Construction, Swimming Pool Covers & Enclosures",,,,47.09319,-122.40925,,"We'll Help You Get Those Projects Done!","With more than 19 years of experience, ABConstruction creates unique outdoor areas and beautiful remodeled living spaces. From new flooring and cabinets to decks and patio covers, we offer clear and consistent communication during the entire construction process.","Mon - Thu: 9:00 am - 5:00 pm Fri - Sat Closed Sun: 9:00 am - 5:00 pm",,,,,,https://www.abchouserepair.com,,,,,,,,,
1661888,507361,"2020-09-27 03:20:30","Bug Busters Inc",https://api.superpages.com/xml/search?SRC=ypintfeed&subaffiliate=DXC&PGID=e02.7182.8182845904523&SPGID=1579784578967.3da8d9c8&ADID=12026993&DEST=http%3A%2F%2Fbugbusterssc1.mydex.com%2Far14I4UAQps&C=home%20improvements&T=Hampton&S=SC&PH=(803)%20398-5493&FL=url&TL=off&position=5&PS=30&PI=1&Results=FEED_CLCK&uid=3da8d9c8-a0b8-44e0-9a65-674408aa6ac3&REF=&IP=165.22.35.81&UserAgent=Mozilla%2F5.0%20(Macintosh%3B%20Intel%20Mac%20OS%20X%2010_14_1)%20AppleWebKit%2F537.36%20(KHTML%2C%20like%20Gecko)%20Chrome%2F70.0.3538.102%20Safari%2F537.36,jmhbbi@islc.net,"(803) 398-5493","1141 Elm St W",Hampton,SC,29924,"1141 Elm St W,Hampton,SC 29924","Termite Control, Altering & Remodeling Contractors, Bee Control & Removal Service, Building Cleaning-Exterior, Building Contractors, Building Maintenance, Building Specialties, Cabinet Makers, Cabinets, Cleaning Contractors, General Contractors, Gutters & Downspouts, Home Improvements, Home Repair & Maintenance, Hospital Equipment & Supplies, House Cleaning, Medical Equipment & Supplies, Pest Control Equipment & Supplies, Pest Control Services, Pest Control Services-Commercial & Industrial, Roofing Contractors, Swimming Pool Construction, Swimming Pool Covers & Enclosures, Ultrasonic Equipment & Supplies",,,,32.87874,-81.12175,https://i3.ypcdn.com/blob/a6ff7bf645fdb921139ec23d40c7c71dc804b575_100x100_crop.jpg?f832250,"Let Us Solve Your Pest Problems.","Bug Busters Inc. has the Experience, Knowledge and Professional Services to help rid your home or business of annoying pests. The Team at Bug Busters Inc. is ready and available to help solve any pest issue you are facing. Whether they are bugs or animals, Bug Busters Inc. will immediately solve the problem for you. Bug Busters Inc. Service Guarantee/Promise At Bug Busters Inc.we strive to provide quality and affordable services to our customers. Customer Satisfaction is our #1 priority. If an issue should arise, we at Bug Busters Inc. will return to address your concern and make sure the services are resolved to your satisfaction. At Bug Busters Inc. we are committed and passionate about protecting your family, home and business from unwanted pests. We are a local family owned company that has been protecting homes and businesses here the Low Country of South Carolina since 1986. In addition to our Pest Prevention Services, we offer Termite Protection, Mosquito Services, Moisture Control for crawl spaces and Lawn Care Services. Choose our residential or commercial services page to learn more about our services and how to pick the right package for you.","Mon - Fri: 8:00 am - 5:00 pm Sat - Sun Closed","TollFree: (800) 633-0694",,"master card, visa, cash, check, debit",,,"http://bugbusterssc1.com http://bugbusterssc.net",,,,,,,,,
1664369,507780,"2020-09-27 03:20:30","Metro Gas Installers",http://www.metrogasinstallers.com,mike@metrogasinstallers.com,"(612) 470-0432","685 141 Ln NW",Andover,MN,55304,"685 141 Ln NW,Andover,MN 55304","Home Improvements, Building Specialties, Cabinet Makers, Cabinets, Fireplace Equipment, Fireplaces, Generators, Generators-Electric-Service & Repair, Heating Equipment & Systems, Home Repair & Maintenance, Swimming Pool Construction, Swimming Pool Equipment & Supplies, Swimming Pool Repair & Service",,,,45.227875,-93.28296,https://i1.ypcdn.com/blob/112fe2a0a3682ba3db74d10b89fc15b81fc13d4a_100x100_crop.jpg?f832250,"Our Gas Never Stinks.","Metro Gas Installers has been in business for over 30 years. We provide installation services to natural gas appliances, pool heaters, stoves, dryers, grills, garage heaters, generators, fire places, and outdoor fire pits. We are licensed, bonded, and insured. Give us a call today!","Mon - Fri: 7:00 am - 9:00 pm Sat - Sun Closed",,,"all major credit cards",,,http://www.metrogasinstallers.com,,,,,,,,,
1688369,511733,"2020-09-27 03:20:50","Sunset Xteriors - south Carolina",,sunsetxteriors@yahoo.com,"(803) 973-5466","4018 Centurion Pass","West Columbia",SC,29170,"4018 Centurion Pass,West Columbia,SC 29170","Deck Builders, Altering & Remodeling Contractors, Building Contractors, Building Specialties, Deck Cleaning & Treatment, Fence Repair, Flooring Contractors, Home Improvements, Home Repair & Maintenance, Patio Builders, Screen Enclosures, Siding Contractors, Sunrooms & Solariums, Swimming Pool Construction, Swimming Pool Covers & Enclosures",5,"1 Review",,33.93547,-81.15402,https://i3.ypcdn.com/blob/68b9a21db3c4560dbe94a7925cca3f0b01f5fbc8_100x100_crop.jpg?f832250,,"Sunset Xteriors is a locally owned home improvement company specializing in exterior projects. We have been serving the Columbia and Lexington areas since 2008. We believe in providing our customers with the best possible service to ensure that their home improvement experience is easy and stress free. We offer free estimates and competitive pricing. For more inquiries call us now!","Mon - Fri: 9:00 am - 5:00 pm Sat - Sun Closed",,,,,"Sunset Xteriors",,"Services: Screen Enclosures, Patio Enclosures",csabet1,01/20/2009,five,"I am so glad to have finally found a company that truly works for the money! I had hardwood floors installed and was impressed from the very beginning. The owner came to my home, at my convienence, and gave me a free quote. He answered all my questions and assured me that every detail would be attended too. He even brought me multiple samples and materials to choose from!! The pricing was what astounded me! I had taken several quotes from other local businesses and he was able to blow their prices out of the water!! The date the project was to begin, they were there! Very professional attire and very fast workers. If I had a question or a concern, the owner Steven would stop and answer. He didn't seem to be flustered by my curiousity. The icing on the cake was the way they kept the work site so tidy! They didn't trash my home and left no nail exposed! It took a few days but I felt like I could still live in my home. I would give them more than 5 stars if I could!!!!",,,,
1689933,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,,,,,,,,,