INSERT INTO poolwizpooldetails (assocID, pID, baseDetails, topledge, uprightposts, height, shape, ovalStructure, warranty, installs, newHeader, s2header, s2roundImg, s2ovalImg, s2aImg, s2Desc, s2HamptonDesc, s2HamptionOval, s2HamptonAFrame, s2Footer, acc129, acc131, acc132, acc133) VALUES ('1', '2', 'Awesome value! High performance, 7\" extruded resin top rail offers superior corrosion resistance and doesn\'t heat up in the sun as do typical steel top rails!<br>Large variety of sizes in oval and round, can be installed Semi-inground.', '7\" Resin top rails with Resin interlocking caps', '6\" Krystal Kote coated steel Uprights with hardware free \'Snap In\' resin bottom cuff', '52\"', 'Round or Oval', 'Space Saving Yardmore Non Buttress System', '60 Year Manufacturers Limited Warranty', 'Installs Above Ground and Semi-Inground', 'heritagertr.png', 's2header-heritagertr.png', 'heritage-rtr-round-', 'heritage-rtr-oval-', '', '<span class=\'descHeader\' id=\'dh1\'>Superior Strength and Design</span><br>
<span class=\'descContent\' id=\'dc1\'>Unlike other aboveground pools on the market, our high performance, 7\" extruded resin top rail offers superior corrosion resistance and doesn’t heat up in the sun as do typical steel top rails! Plus the two-piece, injected molded top cover and steel Krystal Kote® pool uprights combine superior design elements for superior long-term performance of this above ground pool for you and your family.</span><br><br>

<span class=\'descHeader\' id=\'dh2\'>Reliability and Satisfaction</span><br>
<span class=\'descContent\' id=\'dc2\'>The engineering details of this aboveground swimming pool make it one of our best sellers. Using an interlocking steel stabilizer at the top of the swimming pool combined with a hardware-free \'Snap-In\' resin bottom cuff ensures a stronger, faster installation with superior stability. The attractive embossed top ledges and uprights give the Heritage RTR above ground pool added strength with visual appeal. From top to bottom, the details of this swimming pool will be enjoyed for many years to come. From the two-piece, molded top cover to the steel Krystal Kote top ledges and uprights, the Heritage RTR swimming pool incorporates superior design elements for superior long term performance.</span><br><br>

<span class=\'descHeader\' id=\'dh3\'>Yardmore Space Saving System</span><br>
<span class=\'descContent\' id=\'dc3\'>The Heritage RTR oval aboveground pool with the Yardmore Buttressless Oval system is specially designed for small spaces. Traditionally, oval above ground pools have large triangular butress structures running along each side.  The Yardmore Buttressless Oval system takes up less room in the yard, and lets every homeowner create a summer getaway in their own backyard.</span>', '', '', '', '<br><br><table width=\'100%\' cellpadding=\'0\' border=\'0\' cellspacing=\'0\'>
<tr><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagertrf1.png\'></td><td width=\'34%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagertrf2.png\'></td><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagertrf3.png\'></td></tr></table>', '34.99', '', '', '29.99');
INSERT INTO poolwizpooldetails (assocID, pID, baseDetails, topledge, uprightposts, height, shape, ovalStructure, warranty, installs, newHeader, s2header, s2roundImg, s2ovalImg, s2aImg, s2Desc, s2HamptonDesc, s2HamptionOval, s2HamptonAFrame, s2Footer, acc129, acc131, acc132, acc133) VALUES ('2', '3', 'Whether you are looking for a large or small pool, round or oval, or even Semi-inground installation, the perfect pool awaits your backyard.', 'Embossed 7\" steel Krystal Kote top rails with Resin interlocking top caps', '6\" Krystal Kote coated steel Uprights with hardware free \'Snap In\' resin bottom cuff', '52\"', 'Round or Oval', 'Space Saving Yardmore Non Buttress System', '40 Year Manufacturers Limited Warranty', 'Installs Above Ground', 'heritagestr.png', 's2header-heritagestr.png', 'heritage-str-round-', 'heritage-str-oval-', '', '<span class=\'descHeader\' id=\'dh1\'>Superior Strength and Design</span><br>
<span class=\'descContent\' id=\'dc1\'>Unlike other aboveground pools on the market, our high performance, 7\" steel top rail with Krystal Kote offers superior corrosion resistance. Plus the two-piece, injected molded resin top cover and steel Krystal Kote® uprights combine superior design elements for superior long-term performance of this aboveground pool for you and your family. The engineering details of this swimming pool make it one of our best sellers.</span><br><br>

<span class=\'descHeader\' id=\'dh2\'>Reliability and Satisfaction</span><br>
<span class=\'descContent\' id=\'dc2\'>Using an interlocking steel stabilizer at the top of the pool combined with a hardware-free \'Snap-In\' resin bottom cuff ensures a stronger, faster installation with superior stability. The attractive embossed top ledges and uprights give the Heritage STR added strength with visual appeal. From top to bottom, the details of this above ground pool will be enjoyed for many years to come. From the two-piece, molded top cover to the steel Krystal Kote top ledges and uprights, the Heritage STR aboveground pool incorporates superior design elements for superior long term performance.</span><br><br>

<span class=\'descHeader\' id=\'dh3\'>Yardmore Space Saving System</span><br>
<span class=\'descContent\' id=\'dc3\'>The Heritage STR above ground oval pool with the Yardmore Buttressless Oval system is specially designed for small spaces. Traditionally, aboveground oval pools have large triangular butress structures running along each side.  The Yardmore Buttressless Oval system takes up less room in the yard, and lets every homeowner create a summer getaway in their own backyard.</span>', '', '', '', '<br><br><table width=\'100%\' cellpadding=\'0\' border=\'0\' cellspacing=\'0\'>
<tr><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagestrf1.png\'></td><td width=\'34%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagestrf2.png\'></td><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagestrf3.png\'></td></tr></table>', '34.99', '', '', '29.99');
INSERT INTO poolwizpooldetails (assocID, pID, baseDetails, topledge, uprightposts, height, shape, ovalStructure, warranty, installs, newHeader, s2header, s2roundImg, s2ovalImg, s2aImg, s2Desc, s2HamptonDesc, s2HamptionOval, s2HamptonAFrame, s2Footer, acc129, acc131, acc132, acc133) VALUES ('3', '4', 'Super Premium, 54\" High Pool utilizing advanced all-Resin Top-Rails, end caps, bottom plates and bottom Rail to provide superior looks and unmatched durability. <br>Large variety of sizes in oval and round, can be installed Semi-inground.', '9\" wide 100% Resin true radius reinforced top rails', '8\" wide Resin covered steel vertical supports with Duratex 2000 coating', '54\"', 'Round or Oval', 'Space Saving Yardmore Non Buttress System', '60 Year Manufacturers Limited Warranty', 'Installs Above Ground and Semi-Inground', 'moradartr.png', 's2header-moradartr.png', 'morada-rtr-round-', 'morada-rtr-oval-', '', '<span class=\'descHeader\' id=\'dh1\'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;All Resin Top-Rails</span><br>
<span class=\'descContent\' id=\'dc1\'>The Morada RTR Aboveground Swimming Pool utilizes advanced all-Resin Top-Rails, end caps, bottom plates and bottom Rail to provide superior looks and unmatched durability. The top rails, end-caps, and foundation are made of corrosion-proof injection-molded resin, while its walls and verticals are galvanized steel coated with Duratex 2000 to resist even the worst weather with ease. The exterior finish on this above ground pool is an attractive champagne color with a unique wave pattern to blend seamlessly into any backyard decor.</span><br><br>

<span class=\'descHeader\' id=\'dh2\'>Oval Free System</span><br>
<span class=\'descContent\' id=\'dc2\'>Morada RTR Oval Pools feature Buttress Free Oval System designed to use less space in your backyard. No traditional large angled braces like typical above ground oval pools that stick out and take up space in your yard.</span><br><br>

<span class=\'descHeader\' id=\'dh3\'></span><br>
<span class=\'descContent\' id=\'dc3\'></span>', '', '', '', '<br><br><table width=\'100%\' cellpadding=\'0\' border=\'0\' cellspacing=\'0\'>
<tr><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/moradartrf1.png\'></td><td width=\'34%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/moradartrf2.png\'></td><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/moradartrf3.png\'></td></tr></table>', '34.99', '', '', '29.99');
INSERT INTO poolwizpooldetails (assocID, pID, baseDetails, topledge, uprightposts, height, shape, ovalStructure, warranty, installs, newHeader, s2header, s2roundImg, s2ovalImg, s2aImg, s2Desc, s2HamptonDesc, s2HamptionOval, s2HamptonAFrame, s2Footer, acc129, acc131, acc132, acc133) VALUES ('4', '5', 'A premium above ground pool with 9\" all Resin top ledges.  Engineered for long life and easy care. <br>Large variety of sizes in oval and round, can be installed Semi-inground.<br>Oval features the spce saving NBS Narrow Buttress System.', '9\" All Resin top rails with Resin interlocking caps', '6\" Resin Coated Steel Uprights with Resin Foot Collars', '52\"', 'Round or Oval', 'Space Saving NBS Non Buttress System or A Brace Oval', '30 Year Manufacturers Limited Warranty, Lifetime warranty on Resin Components', 'Installs Above Ground and Semi-Inground', 'hampton.png', 's2header-hampton.png', 'hampton-round-', 'hampton-nbs-oval-', 'hampton-aframe-', '<span class=\'descHeader\' id=\'dh1\'>Long Life and Easy To Care For</span><br>
<span class=\'descContent\' id=\'dc1\'>A HAMPTON NBS Oval aboveground pool is engineered for long life, easy care and more usable yard space. That brings the ultimate in style to your yard, in a fun, flexible shape. Available with a space-saving no brace system (NBS).</span><br><br>

<span class=\'descHeader\' id=\'dh2\'>Narrow Buttress System (NBS)</span><br>
<span class=\'descContent\' id=\'dc2\'>The Narrow Buttress System (NBS) is a unique engineering design for an aboveground oval pool. Traditionally, above ground oval pools have large triangular butress structures running along each side. While
this produces the oval shape it takes up valuable yard space. The NBS has eliminated this problem to produce an oval aboveground pool that takes up less room in the yard.</span><br><br>

', 'Your Hampton above ground swimming pool brings a timeless touch to enhance your landscape. The stunning Maya pool wall pattern adds sophistication and beauty. Color cordinated Mist upright columns compliment the whole package. This Hampton pool holds its beauty, like a classic sculpture for years to come.

The Hampton above ground pool stands the test of time and the elements. The solid resin 9\" top ledge resists weather, water and wear. Durable 6\" upright columns with unique interlocking resin caps, and resin foot collars give the Hampton swimming pool strength, support and style. The hot dipped galvanized frame with liquid resin coating provides years of lasting beauty and quality. The Hampton aboveground pool is made with heavy-duty tracks, oversized connectors and oversized fasteners to add strength for a swimming pool that will last for years to come.', 'A HAMPTON NBS Oval aboveground pool is engineered for long life, easy care and more usable yard space. That brings the ultimate in style to your yard, in a fun, flexible shape. Available with a space-saving no brace system (NBS).

The Narrow Buttress System (NBS) is a unique engineering design for an aboveground oval pool. Traditionally, above ground oval pools have large triangular butress structures running along each side. While this produces the oval shape it takes up valuable yard space. The NBS has eliminated this problem to produce an oval aboveground pool that takes up less room in the yard', '<span class=\'descHeader\' id=\'dh3\'>Hampton A Brace</span><br>
<span class=\'descContent\' id=\'dc3\'>The Hampton A Brace oval aboveground pools have large triangular buttress structures running along each side of the oval (see diagram). These A braces measuring out about 32\" from the pool wall.  While taking up more yard space, the A-Brace system is a more cost effective way to putting an oval above ground pool in the backyard.</span>', '<br><br><table width=\'100%\' cellpadding=\'0\' border=\'0\' cellspacing=\'0\'>
<tr><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/hamptonf1.png\'></td><td width=\'34%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/hamptonf2.png\'></td><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/hamptonf3.png\'></td></tr></table>', '0.00', '29.99', '19.99', '');
INSERT INTO poolwizpooldetails (assocID, pID, baseDetails, topledge, uprightposts, height, shape, ovalStructure, warranty, installs, newHeader, s2header, s2roundImg, s2ovalImg, s2aImg, s2Desc, s2HamptonDesc, s2HamptionOval, s2HamptonAFrame, s2Footer, acc129, acc131, acc132, acc133) VALUES ('5', '147', 'Details', '8\" Wide 100% Resin curved injection molded top rails. Synflex Resin protects against weather, chlorine and saltwater. ', '6\" wide Resin covered steel vertical supports with Duratex 2000 coating', '54\" Pool Wall Height', 'Round or Oval', 'Details', '60 Year Manufacturers Limited Warranty. Lifetime Manufacturers Warranty on All Resin Parts. Warranty Covers Use of Salt System.', 'Installs Above Ground and Semi-Inground', 'saltwater8000.png', 's2header-sw8000.png', 'sw8000-round-', 'sw8000-oval-', '', '<span class=\'descHeader\' id=\'dh1\'>Built for the Saltwater Environment</span><br>
<span class=\'descContent\' id=\'dc1\'>The 54\" Saltwater 8000 is designed from the ground up with ultimate corrosion protection.  The 54\" high pool wall and upright posts feature the Duratex 2000 anti corrosion coatings. The 8\" injection molded curved Synflex resin top ledges and heavy duty resin tracks and connectors resist wear from saltwater and chlorine. The Stainless Steel service panel adds superior corrosion protection for the skimmer and return lines.  The 60 year manufacutrers limited warranty (lifetime on resin parts) covers the use of a salt system.    </span><br><br>

<span class=\'descHeader\' id=\'dh3\'>Yardmore Oval Space Saving System</span><br>
<span class=\'descContent\' id=\'dc3\'>The Saltwater 8000 oval pool with the Yardmore Buttressless Oval system is specially designed for small spaces. Traditionally, oval above ground pools have large triangular butress structures running along each side.  The Yardmore Buttressless Oval system takes up less room in the yard with superior strength and beauty.</span>', '', '', '', '<br><br><table width=\'100%\' cellpadding=\'0\' border=\'0\' cellspacing=\'0\'>
<tr><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/sw8000f1.png\'></td><td width=\'34%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/sw8000f2.png\'></td><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/sw8000f3.png\'></td></tr></table>', '34.99', '', '', '29.99');
INSERT INTO poolwizpooldetails (assocID, pID, baseDetails, topledge, uprightposts, height, shape, ovalStructure, warranty, installs, newHeader, s2header, s2roundImg, s2ovalImg, s2aImg, s2Desc, s2HamptonDesc, s2HamptionOval, s2HamptonAFrame, s2Footer, acc129, acc131, acc132, acc133) VALUES ('6', '192', 'Details', 'Top Ledges vary on these closeout pools, see store for details', 'Our closeout pools are either 52\" or 54\" high, see store for details.', 'Our closeout pools are either 52\" or 54\" high, see store for details.', 'Round or Oval', 'Details', 'Warranties vary on our closeout pools.', 'See salesperson for details', 'heritagestr.png', 's2header-heritagestr.png', 'heritage-str-round-', 'heritage-str-oval-', '', '<span class=\'descHeader\' id=\'dh1\'>Take advantage of great prices on these closeout pools</span><br>
<span class=\'descContent\' id=\'dc1\'>Special deals on round and oval aboveground pools.</span><br><br>
', '', '', '', '<br><br><table width=\'100%\' cellpadding=\'0\' border=\'0\' cellspacing=\'0\'>
<tr><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagertrf1.png\'></td><td width=\'34%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagertrf2.png\'></td><td width=\'33%\' align=\'center\'><img src=\'https://www.sipoolandspa.com/images/poolwizard/v2/heritagertrf3.png\'></td></tr></table>', '34.99', '', '', '29.99');
