-- Adminer 4.8.1 MySQL 8.0.31 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

INSERT INTO `estimate_templates` (`id`, `uuid`, `correlative_code`, `provider_id`, `name`, `introduction`,
                                  `contract_detail`, `created_at`, `created_by`, `sub_total`, `tax`, `total`,
                                  `gross_profit`, `discount_id`, `project_id`, `deleted_at`)
VALUES (1, 'e72052c1-2fe9-4c10-9b6e-0a28f35d156a', NULL, 2, 'OC Premium Order Template', NULL,
        '<p>My signature below authorizes L&amp;B Roofing LLC to perform the above-described scope of work and I agree to pay L&amp;B Roofing LLC the above estimate amount upon completion of work, and (ii) if insurance proceeds, if any, are received, Owner assigns to L&amp;B Roofing LLC all insurance proceeds paid in connection with L&amp;B Roofing LLC’s services. For insurance work an initial payment is due upon completion of work and the balance is due upon Property Owner’s receipt of final insurance proceeds. For non-insurance related work, payment in full is due upon completion of all work. Terms and Conditions 1. Property Owner Authorization to Perform Work, Communications. Owner authorizes L&amp;B Roofing LLC (Contractor) to perform the work described in this Agreement per the terms and conditions reflected herein. 2. Property Owner’s Selection of Roofing and Authorizations. Owner or an authorized representative of Owner will select all material brands, colors, styles, and features for those options provided by Contractor. In making these selections, Owner shall assess the underlying materials and work to/upon which the Work will be attached or adhered for the suitability of the Work to be performed, and Owner authorizes Contractor to acquire and install said materials at the Property. Contractor agrees to perform its Work in a good workmanlike manner, in accordance with standard industry practices. Alterations, modifications, changes or additions, if any, must be agreed in writing by the parties as evidenced by their respective signatures, although Contractor reserves the right to perform additional work upon Owner’s verbal instruction therefor, which instruction shall be binding on Owner. 3. Limitations on Scope of Work. Unless expressly agreed to the contrary, the following are outside the scope of this Agreement and will be performed only upon Contractor securing a confirmed source of payment for that work: (i) Replacement of deteriorated decking, fascia board, roof-jacks, ventilators, flashing and related materials; (ii) painting; and (iii) gutter work. 4. Indemnity and Hold Harmless. Owner agrees to indemnify and hold Contractor harmless for damage caused by improper original construction, including faulty framing, masonry bracing and roof decks, or for rotted siding; mold and mildew; paint and sheetrock damage due to vibration: damaged electrical wiring, cables, and air conditioning or plumbing lines installed within six (6) inches of the roofline; and incidental and consequential damages. Furthermore, Owner agrees that Contractor’s work may be delayed due to labor controversies, strikes, storms, inability to obtain necessary materials from customary sources, or any other circumstances beyond the control of Contractor, none of which shall constitute abandonment of the Contract or the Project. 5. Remedy for Nonpayment. If Owner fails to pay Contractor any amounts due under this Contract within thirty (30) days from the date of completion of the Work, or Owner’s receipt of insurance funds, whichever is sooner, Owner agrees to pay all costs of collection, including reasonable attorney fees, interest on any unpaid balance at a rate of one and one-half percent (1 1⁄2%) per month, (18% perineum) or the maximum allowed by law. 6. Dispute Resolution. Any dispute between Contractor and Owner arising out of or relating to this Agreement or the breach thereof, shall first be subject to mediation, and if not so resolved, shall be decided by arbitration. Should Contractor prevail in any affirmative claim, or successfully defend against Owner’s claims, Contractor shall be entitled to its attorney’s fees and cost incurred therein. The award rendered by the arbitrator shall be final, and judgment maybe entered upon it in any Court having jurisdiction thereof. Owner agrees that in no event shall Contractor be liable for consequential or exemplary damages. 7. For limited Warranties. Contractor warrants workmanship and materials (2) years on roof replacement jobs after the date of substantial completion and will remedy substantial defects in workmanship within a reasonable time after receipt of written notice from Owner. The Limited Warranty inures solely to the benefit of, and is enforceable only by, Owner, and is not transferable or assignable. Owner agrees to assert all warranty claims for defective materials solely against the manufacturer of such materials. In the event that Owner asserts a claim of defect in workmanship, Owner agrees to permit Contractor to gain access to the affected area so as to cure any purported defect. In the event Contractor is not permitted by Owner to cure such defects, Contractor shall have no liability for the cost of repair or damages resulting therefrom. This Limited Warranty shall not apply to damages arising from settling, abuse, winds more than 60 mph, impact of foreign objects, damage due to settlement of foundation, or Owner’s failure to properly maintain the Property or the Work, including the accumulation of leaves or pine needles in gutters or roof valley which accumulation can force water under roofing. Furthermore, this Limited Warranty shall not apply to smoke damage; fire; hailstorms; hurricanes; and other roof damage resulting from Acts of God. 8. Miscellaneous: A. Owner agrees to notify Contractor of any deed restrictions or homeowner association requirement that may affect the performance of Contractor’s roofing services. B. All restocked material is subject to a 10% restocking fee. All work and material delivered to the premises, whether incorporated therein, remain the property of Contractor until paid for. C. Owner acknowledges that Contractor may utilize subcontractors in the performance of its Work. Owner authorizes Contractor to photograph its work and to utilize same in its marketing materials and on social media. D. Owner agrees to carry owner’s and contents insurance. Owner agrees to obtain Homeowner’s Association approval, if necessary, and to permit access to the property at reasonable times for Contractor to perform its Work under this Agreement. 9. Entire Agreement. This Agreement constitutes the entire agreement between the parties, supersedes any previous understanding or agreement of the parties, and may be changed only by written instrument, signed by all parties. There are no representations, either oral or written, other than those set forth herein. After Owner’s right, if applicable, to cancel this Agreement has passed, this Agreement cannot be cancelled except by mutual written agreement of all parties. If subsequently cancelled without Contractor’s agreement, Owner agrees to pay Contractor a termination fee equal to 30% of the Agreement price. 10. Severability. If any provisions of this Agreement should be held to be invalid or unenforceable, the validity, and the enforceability of the remaining provisions of this Agreement shall remain in full force and effect.11. This Agreement is subject to Chapter 27 of the Texas Property Code. The provisions of that chapter may affect your right to recover damages arising from a construction defect. If you have a complaint concerning a construction defect and that defect has not been corrected as may be required by law or by Agreement, you must provide the notice required by Chapter 27 of the Texas Property Code to the Contractor by certified mail, return receipt requested, not later than the 60th day before the date you file suit to recover damages in a court of law or initiate arbitration. The notice must refer to Chapter 27 of the Texas Property Code and must describe the construction defect. If requested by the Contractor, you must provide the Contractor an opportunity to inspect and cure the defect as provided by Section 27.004 of the Texas Property Code. 12. Insurance Addendum: For those properties for which some or all of the work will be paid by insurance proceeds, the following terms apply: 1. Neither Contractor nor any of its authorized management or sales representatives are Public Insurance Adjusters, are not offering to or performing any insurance adjusting services to Owner.2. Owner appoints Contractor as Owner’s ATTORNEY-IN-FACT for the sole purpose of communicating directly with Owner’s insurance and/or Mortgage Company regarding recommended supplements to the project scope/pricing and status of payment for any of Contractor’s Work. Owner agrees to aid in collection of all monies due Contractor by executing any necessary paperwork and/or communicating with insurance company and/or Mortgage Company, including Owner’s agreement that any settlement made between Owners and Owner’s insurance company(ies) shall include Contractor as a payee, and that Contractor may present a signed copy of this Agreement, which shall be sufficient authority and direction to Owner’s insurance or mortgage company to include Contractor as a payee in any payments made in settlement of Owner\'s claim. Should amounts paid by any such insurance company be insufficient to pay the agreed price herein,
        Owner agrees to pay the difference to Contractor immediately upon demand. 3. Owner agrees that any sums obtained by Owner,
        whether through litigation, public insurance adjuster or appraisal,
        shall first be applied to payment for the maximum identified scope of work developed on Owner’s behalf,
        up to Owner’s recovery, however, obtained.In the event insurance denies Owner’s claim,
        this Agreement is voidable at the option of Contractor. 4. Approved supplemental charges to the insurance company shall,
        if any, be paid to L&amp;B Roofing LLC and are not reflected in the Estimated Charge to Property Owner (Owner). 5. L&amp;B Roofing LLC will, as a courtesy to Owner, submit a final invoice directly to the insurance company, if any, to facilitate the insurance company’s release of any remaining payments, all which Customer acknowledges is due L&amp;B Roofing LLC for its work at Owner’s home. 6. Owner agrees to promptly obtain the signature endorsement of any other payee, including Owner’s mortgage company, who is named on any check issued by Owner’s insurance company. This proposal may be withdrawn if not accepted within 30 days, or in the event Owner’s insurance company declines coverage for Owner’s damage made the subject of this contract.</p><p>&nbsp;</p><p><strong>&#xFEFF;YOU, THE BUYER, MAY CANCEL THIS TRANSACTION AT ANY TIME PRIOR TO MIDNIGHT OF THE THIRD BUSINESS DAY AFTER THE DATE OF THIS TRANSACTION. (For Residential Properties Only)</strong>. After the right to cancel has passed, any attempt to terminate this Agreement shall be deemed a material breach of this Agreement and entitle Contractor to damages. The Terms and Conditions bellow are incorporated herein by reference.</p><p>&nbsp;</p><p><br>&nbsp;</p>',	'2024-03-17 01:15:10',	1,	1006.04,	60.61,	1066.65,	290.68,	NULL,	NULL,	NULL),
(2,	'a341ed62-feeb-4b10-bb48-00bc30f45810',	NULL,	2,	'OC Base Package Order Template',	NULL,	NULL,	'2024-03-17 01:30:21',	1,	903.49,	42.72,	946.21,	260.44,	NULL,	NULL,	NULL),
(3,	'f2134ea2-37c3-48d4-a708-40eeac1b2d11',	NULL,	2,	'OC Preferred Order template 1',	'<p><span style=\"color:rgb(136,136,136);\"><strong>Roof Replacement with Owens Corning Duration TruDefinition Shingles with Preferred Warranty</strong>&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Existing Roof - Remove, Haul, Tear - Off &amp; Dispose of 1 Layer of Existing Roof.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Conduct Thorough Inspection of Decking Structure&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Re-nail any loose wood. Replace up to 2 Sheets of Rotten Decking free of charge. Additional rotten wood will be replaced at a price of $120 per sheet.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Install Lifetime Owens Corning Duration SureNail® Technology with StreakGuard™ Algae Resistance. Color: (Driftwood)&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Install Owens Cornings Pro Edge on Hips &amp; Ridges&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Install Synthetic Rhino Roof Underlayment for added Protection Against Moisture &amp; Wind Driven Rain.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Remove &amp; Replace Pipe Flashing with Upgraded Lifetime Bullet Boot Pipe flashings.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Remove &amp; Replace Ventilation (Ridge Vent and/or Square Vent)&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Chimney Reseal and install Ice &amp; Water shield.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Remove &amp; Replace 1 ½” x 1 ½” Aluminum Pre-Painted Dripedge.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Install OC Ice &amp; Water Shield on Valleys and Flashing to help protect water.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Apply Caulk to All Flashings to Seal Properly and Avoid Corrosion.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Apply Paint to all Metal Flashings with Exposed Metal to Protect Against Rust for Finish Protection.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\"><strong>L&amp;B Home Care System&nbsp;</strong></span></p><p><span style=\"color:rgb(136,136,136);\">- Protect landscaping/ Cover Pools with Plastic and Trim branches off roof surfaces.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Remove Debris from gutters after roof installation.&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Clean up all job-related debris. Magnetic sweep (Retrieve dropped nails and other metals objects).&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Neighbor Courtesy Notification. &nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">-L&amp;B Foreman Present to Ensure All Materials are Correct&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Final Walk Around for Quality Satisfaction Warranty&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- L&amp;B 5 Year Workmanship Warranty&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Owens Corning Limited Lifetime Product Warranty&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Algae Resistance&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">-10 years Warranty&nbsp;</span></p><p><span style=\"color:rgb(136,136,136);\">- Wind Resistance -15 years Warranty (130MPH)</span></p>',	'<p>My signature below authorizes L&amp;B Roofing LLC to perform the above-described scope of work and I agree to pay L&amp;B Roofing LLC the above estimate amount upon completion of work, and (ii) if insurance proceeds, if any, are received, Owner assigns to L&amp;B Roofing LLC all insurance proceeds paid in connection with L&amp;B Roofing LLC’s services. For insurance work an initial payment is due upon completion of work and the balance is due upon Property Owner’s receipt of final insurance proceeds. For non-insurance related work, payment in full is due upon completion of all work. Terms and Conditions 1. Property Owner Authorization to Perform Work, Communications. Owner authorizes L&amp;B Roofing LLC (Contractor) to perform the work described in this Agreement per the terms and conditions reflected herein. 2. Property Owner’s Selection of Roofing and Authorizations. Owner or an authorized representative of Owner will select all material brands, colors, styles, and features for those options provided by Contractor. In making these selections, Owner shall assess the underlying materials and work to/upon which the Work will be attached or adhered for the suitability of the Work to be performed, and Owner authorizes Contractor to acquire and install said materials at the Property. Contractor agrees to perform its Work in a good workmanlike manner, in accordance with standard industry practices. Alterations, modifications, changes or additions, if any, must be agreed in writing by the parties as evidenced by their respective signatures, although Contractor reserves the right to perform additional work upon Owner’s verbal instruction therefor, which instruction shall be binding on Owner. 3. Limitations on Scope of Work. Unless expressly agreed to the contrary, the following are outside the scope of this Agreement and will be performed only upon Contractor securing a confirmed source of payment for that work: (i) Replacement of deteriorated decking, fascia board, roof-jacks, ventilators, flashing and related materials; (ii) painting; and (iii) gutter work. 4. Indemnity and Hold Harmless. Owner agrees to indemnify and hold Contractor harmless for damage caused by improper original construction, including faulty framing, masonry bracing and roof decks, or for rotted siding; mold and mildew; paint and sheetrock damage due to vibration: damaged electrical wiring, cables, and air conditioning or plumbing lines installed within six (6) inches of the roofline; and incidental and consequential damages. Furthermore, Owner agrees that Contractor’s work may be delayed due to labor controversies, strikes, storms, inability to obtain necessary materials from customary sources, or any other circumstances beyond the control of Contractor, none of which shall constitute abandonment of the Contract or the Project. 5. Remedy for Nonpayment. If Owner fails to pay Contractor any amounts due under this Contract within thirty (30) days from the date of completion of the Work, or Owner’s receipt of insurance funds, whichever is sooner, Owner agrees to pay all costs of collection, including reasonable attorney fees, interest on any unpaid balance at a rate of one and one-half percent (1 1⁄2%) per month, (18% perineum) or the maximum allowed by law. 6. Dispute Resolution. Any dispute between Contractor and Owner arising out of or relating to this Agreement or the breach thereof, shall first be subject to mediation, and if not so resolved, shall be decided by arbitration. Should Contractor prevail in any affirmative claim, or successfully defend against Owner’s claims, Contractor shall be entitled to its attorney’s fees and cost incurred therein. The award rendered by the arbitrator shall be final, and judgment maybe entered upon it in any Court having jurisdiction thereof. Owner agrees that in no event shall Contractor be liable for consequential or exemplary damages. 7. For limited Warranties. Contractor warrants workmanship and materials (2) years on roof replacement jobs after the date of substantial completion and will remedy substantial defects in workmanship within a reasonable time after receipt of written notice from Owner. The Limited Warranty inures solely to the benefit of, and is enforceable only by, Owner, and is not transferable or assignable. Owner agrees to assert all warranty claims for defective materials solely against the manufacturer of such materials. In the event that Owner asserts a claim of defect in workmanship, Owner agrees to permit Contractor to gain access to the affected area so as to cure any purported defect. In the event Contractor is not permitted by Owner to cure such defects, Contractor shall have no liability for the cost of repair or damages resulting therefrom. This Limited Warranty shall not apply to damages arising from settling, abuse, winds more than 60 mph, impact of foreign objects, damage due to settlement of foundation, or Owner’s failure to properly maintain the Property or the Work, including the accumulation of leaves or pine needles in gutters or roof valley which accumulation can force water under roofing. Furthermore, this Limited Warranty shall not apply to smoke damage; fire; hailstorms; hurricanes; and other roof damage resulting from Acts of God. 8. Miscellaneous: A. Owner agrees to notify Contractor of any deed restrictions or homeowner association requirement that may affect the performance of Contractor’s roofing services. B. All restocked material is subject to a 10% restocking fee. All work and material delivered to the premises, whether incorporated therein, remain the property of Contractor until paid for. C. Owner acknowledges that Contractor may utilize subcontractors in the performance of its Work. Owner authorizes Contractor to photograph its work and to utilize same in its marketing materials and on social media. D. Owner agrees to carry owner’s and contents insurance. Owner agrees to obtain Homeowner’s Association approval, if necessary, and to permit access to the property at reasonable times for Contractor to perform its Work under this Agreement. 9. Entire Agreement. This Agreement constitutes the entire agreement between the parties, supersedes any previous understanding or agreement of the parties, and may be changed only by written instrument, signed by all parties. There are no representations, either oral or written, other than those set forth herein. After Owner’s right, if applicable, to cancel this Agreement has passed, this Agreement cannot be cancelled except by mutual written agreement of all parties. If subsequently cancelled without Contractor’s agreement, Owner agrees to pay Contractor a termination fee equal to 30% of the Agreement price. 10. Severability. If any provisions of this Agreement should be held to be invalid or unenforceable, the validity, and the enforceability of the remaining provisions of this Agreement shall remain in full force and effect.11. This Agreement is subject to Chapter 27 of the Texas Property Code. The provisions of that chapter may affect your right to recover damages arising from a construction defect. If you have a complaint concerning a construction defect and that defect has not been corrected as may be required by law or by Agreement, you must provide the notice required by Chapter 27 of the Texas Property Code to the Contractor by certified mail, return receipt requested, not later than the 60th day before the date you file suit to recover damages in a court of law or initiate arbitration. The notice must refer to Chapter 27 of the Texas Property Code and must describe the construction defect. If requested by the Contractor, you must provide the Contractor an opportunity to inspect and cure the defect as provided by Section 27.004 of the Texas Property Code. 12. Insurance Addendum: For those properties for which some or all of the work will be paid by insurance proceeds, the following terms apply: 1. Neither Contractor nor any of its authorized management or sales representatives are Public Insurance Adjusters, are not offering to or performing any insurance adjusting services to Owner.2. Owner appoints Contractor as Owner’s ATTORNEY-IN-FACT for the sole purpose of communicating directly with Owner’s insurance and/or Mortgage Company regarding recommended supplements to the project scope/pricing and status of payment for any of Contractor’s Work. Owner agrees to aid in collection of all monies due Contractor by executing any necessary paperwork and/or communicating with insurance company and/or Mortgage Company, including Owner’s agreement that any settlement made between Owners and Owner’s insurance company(ies) shall include Contractor as a payee, and that Contractor may present a signed copy of this Agreement, which shall be sufficient authority and direction to Owner’s insurance or mortgage company to include Contractor as a payee in any payments made in settlement of Owner\'s claim. Should amounts paid by any such insurance company be insufficient to pay the agreed price herein, Owner agrees to pay the difference to Contractor immediately upon demand. 3. Owner agrees that any sums obtained by Owner, whether through litigation, public insurance adjuster or appraisal, shall first be applied to payment for the maximum identified scope of work developed on Owner’s behalf, up to Owner’s recovery, however, obtained. In the event insurance denies Owner’s claim, this Agreement is voidable at the option of Contractor. 4. Approved supplemental charges to the insurance company shall, if any, be paid to L&amp;B Roofing LLC and are not reflected in the Estimated Charge to Property Owner (Owner). 5. L&amp;B Roofing LLC will, as a courtesy to Owner, submit a final invoice directly to the insurance company, if any, to facilitate the insurance company’s release of any remaining payments, all which Customer acknowledges is due L&amp;B Roofing LLC for its work at Owner’s home. 6. Owner agrees to promptly obtain the signature endorsement of any other payee, including Owner’s mortgage company, who is named on any check issued by Owner’s insurance company. This proposal may be withdrawn if not accepted within 30 days, or in the event Owner’s insurance company declines coverage for Owner’s damage made the subject of this contract.</p><p>&nbsp;</p><p><strong>&#xFEFF;YOU, THE BUYER, MAY CANCEL THIS TRANSACTION AT ANY TIME PRIOR TO MIDNIGHT OF THE THIRD BUSINESS DAY AFTER THE DATE OF THIS TRANSACTION. (For Residential Properties Only)</strong>. After the right to cancel has passed, any attempt to terminate this Agreement shall be deemed a material breach of this Agreement and entitle Contractor to damages. The Terms and Conditions bellow are incorporated herein by reference.</p><p>&nbsp;</p><p><br>&nbsp;</p>',	'2024-03-17 01:35:49',	1,	226.36,	18.67,	245.03,	2.97,	NULL,	NULL,	NULL),
(4,	'940324a3-9abd-4f88-9eeb-9ef4706a56f4',	NULL,	2,	'OC Preferred Order Template 2',	NULL,	'<p>My signature below authorizes L&amp;B Roofing LLC to perform the above-described scope of work and I agree to pay L&amp;B Roofing LLC the above estimate amount upon completion of work, and (ii) if insurance proceeds, if any, are received, Owner assigns to L&amp;B Roofing LLC all insurance proceeds paid in connection with L&amp;B Roofing LLC’s services. For insurance work an initial payment is due upon completion of work and the balance is due upon Property Owner’s receipt of final insurance proceeds. For non-insurance related work, payment in full is due upon completion of all work. Terms and Conditions 1. Property Owner Authorization to Perform Work, Communications. Owner authorizes L&amp;B Roofing LLC (Contractor) to perform the work described in this Agreement per the terms and conditions reflected herein. 2. Property Owner’s Selection of Roofing and Authorizations. Owner or an authorized representative of Owner will select all material brands, colors, styles, and features for those options provided by Contractor. In making these selections, Owner shall assess the underlying materials and work to/upon which the Work will be attached or adhered for the suitability of the Work to be performed, and Owner authorizes Contractor to acquire and install said materials at the Property. Contractor agrees to perform its Work in a good workmanlike manner, in accordance with standard industry practices. Alterations, modifications, changes or additions, if any, must be agreed in writing by the parties as evidenced by their respective signatures, although Contractor reserves the right to perform additional work upon Owner’s verbal instruction therefor, which instruction shall be binding on Owner. 3. Limitations on Scope of Work. Unless expressly agreed to the contrary, the following are outside the scope of this Agreement and will be performed only upon Contractor securing a confirmed source of payment for that work: (i) Replacement of deteriorated decking, fascia board, roof-jacks, ventilators, flashing and related materials; (ii) painting; and (iii) gutter work. 4. Indemnity and Hold Harmless. Owner agrees to indemnify and hold Contractor harmless for damage caused by improper original construction, including faulty framing, masonry bracing and roof decks, or for rotted siding; mold and mildew; paint and sheetrock damage due to vibration: damaged electrical wiring, cables, and air conditioning or plumbing lines installed within six (6) inches of the roofline; and incidental and consequential damages. Furthermore, Owner agrees that Contractor’s work may be delayed due to labor controversies, strikes, storms, inability to obtain necessary materials from customary sources, or any other circumstances beyond the control of Contractor, none of which shall constitute abandonment of the Contract or the Project. 5. Remedy for Nonpayment. If Owner fails to pay Contractor any amounts due under this Contract within thirty (30) days from the date of completion of the Work, or Owner’s receipt of insurance funds, whichever is sooner, Owner agrees to pay all costs of collection, including reasonable attorney fees, interest on any unpaid balance at a rate of one and one-half percent (1 1⁄2%) per month, (18% perineum) or the maximum allowed by law. 6. Dispute Resolution. Any dispute between Contractor and Owner arising out of or relating to this Agreement or the breach thereof, shall first be subject to mediation, and if not so resolved, shall be decided by arbitration. Should Contractor prevail in any affirmative claim, or successfully defend against Owner’s claims, Contractor shall be entitled to its attorney’s fees and cost incurred therein. The award rendered by the arbitrator shall be final, and judgment maybe entered upon it in any Court having jurisdiction thereof. Owner agrees that in no event shall Contractor be liable for consequential or exemplary damages. 7. For limited Warranties. Contractor warrants workmanship and materials (2) years on roof replacement jobs after the date of substantial completion and will remedy substantial defects in workmanship within a reasonable time after receipt of written notice from Owner. The Limited Warranty inures solely to the benefit of, and is enforceable only by, Owner, and is not transferable or assignable. Owner agrees to assert all warranty claims for defective materials solely against the manufacturer of such materials. In the event that Owner asserts a claim of defect in workmanship, Owner agrees to permit Contractor to gain access to the affected area so as to cure any purported defect. In the event Contractor is not permitted by Owner to cure such defects, Contractor shall have no liability for the cost of repair or damages resulting therefrom. This Limited Warranty shall not apply to damages arising from settling, abuse, winds more than 60 mph, impact of foreign objects, damage due to settlement of foundation, or Owner’s failure to properly maintain the Property or the Work, including the accumulation of leaves or pine needles in gutters or roof valley which accumulation can force water under roofing. Furthermore, this Limited Warranty shall not apply to smoke damage; fire; hailstorms; hurricanes; and other roof damage resulting from Acts of God. 8. Miscellaneous: A. Owner agrees to notify Contractor of any deed restrictions or homeowner association requirement that may affect the performance of Contractor’s roofing services. B. All restocked material is subject to a 10% restocking fee. All work and material delivered to the premises, whether incorporated therein, remain the property of Contractor until paid for. C. Owner acknowledges that Contractor may utilize subcontractors in the performance of its Work. Owner authorizes Contractor to photograph its work and to utilize same in its marketing materials and on social media. D. Owner agrees to carry owner’s and contents insurance. Owner agrees to obtain Homeowner’s Association approval, if necessary, and to permit access to the property at reasonable times for Contractor to perform its Work under this Agreement. 9. Entire Agreement. This Agreement constitutes the entire agreement between the parties, supersedes any previous understanding or agreement of the parties, and may be changed only by written instrument, signed by all parties. There are no representations, either oral or written, other than those set forth herein. After Owner’s right, if applicable, to cancel this Agreement has passed, this Agreement cannot be cancelled except by mutual written agreement of all parties. If subsequently cancelled without Contractor’s agreement, Owner agrees to pay Contractor a termination fee equal to 30% of the Agreement price. 10. Severability. If any provisions of this Agreement should be held to be invalid or unenforceable, the validity, and the enforceability of the remaining provisions of this Agreement shall remain in full force and effect.11. This Agreement is subject to Chapter 27 of the Texas Property Code. The provisions of that chapter may affect your right to recover damages arising from a construction defect. If you have a complaint concerning a construction defect and that defect has not been corrected as may be required by law or by Agreement, you must provide the notice required by Chapter 27 of the Texas Property Code to the Contractor by certified mail, return receipt requested, not later than the 60th day before the date you file suit to recover damages in a court of law or initiate arbitration. The notice must refer to Chapter 27 of the Texas Property Code and must describe the construction defect. If requested by the Contractor, you must provide the Contractor an opportunity to inspect and cure the defect as provided by Section 27.004 of the Texas Property Code. 12. Insurance Addendum: For those properties for which some or all of the work will be paid by insurance proceeds, the following terms apply: 1. Neither Contractor nor any of its authorized management or sales representatives are Public Insurance Adjusters, are not offering to or performing any insurance adjusting services to Owner.2. Owner appoints Contractor as Owner’s ATTORNEY-IN-FACT for the sole purpose of communicating directly with Owner’s insurance and/or Mortgage Company regarding recommended supplements to the project scope/pricing and status of payment for any of Contractor’s Work. Owner agrees to aid in collection of all monies due Contractor by executing any necessary paperwork and/or communicating with insurance company and/or Mortgage Company, including Owner’s agreement that any settlement made between Owners and Owner’s insurance company(ies) shall include Contractor as a payee, and that Contractor may present a signed copy of this Agreement, which shall be sufficient authority and direction to Owner’s insurance or mortgage company to include Contractor as a payee in any payments made in settlement of Owner\'s claim. Should amounts paid by any such insurance company be insufficient to pay the agreed price herein, Owner agrees to pay the difference to Contractor immediately upon demand. 3. Owner agrees that any sums obtained by Owner, whether through litigation, public insurance adjuster or appraisal, shall first be applied to payment for the maximum identified scope of work developed on Owner’s behalf, up to Owner’s recovery, however, obtained. In the event insurance denies Owner’s claim, this Agreement is voidable at the option of Contractor. 4. Approved supplemental charges to the insurance company shall, if any, be paid to L&amp;B Roofing LLC and are not reflected in the Estimated Charge to Property Owner (Owner). 5. L&amp;B Roofing LLC will, as a courtesy to Owner, submit a final invoice directly to the insurance company, if any, to facilitate the insurance company’s release of any remaining payments, all which Customer acknowledges is due L&amp;B Roofing LLC for its work at Owner’s home. 6. Owner agrees to promptly obtain the signature endorsement of any other payee, including Owner’s mortgage company, who is named on any check issued by Owner’s insurance company. This proposal may be withdrawn if not accepted within 30 days, or in the event Owner’s insurance company declines coverage for Owner’s damage made the subject of this contract.</p><p>&nbsp;</p><p><strong>&#xFEFF;YOU, THE BUYER, MAY CANCEL THIS TRANSACTION AT ANY TIME PRIOR TO MIDNIGHT OF THE THIRD BUSINESS DAY AFTER THE DATE OF THIS TRANSACTION. (For Residential Properties Only)</strong>. After the right to cancel has passed, any attempt to terminate this Agreement shall be deemed a material breach of this Agreement and entitle Contractor to damages. The Terms and Conditions bellow are incorporated herein by reference.</p><p>&nbsp;</p><p><br>&nbsp;</p>',	'2024-03-17 02:13:48
',	3,	1012.25,	60.26,	1072.51,	292.35,	NULL,	NULL,	NULL);



INSERT INTO `estimate_template_sections` (`id`, `name`, `estimate_template_id`, `created_at`, `created_by`, `total`, `type`, `value`) VALUES
(1,	'OC Premium Order Template',	1,	'2024-03-14 04:10:51',	1,	549.81,	1,	1),
(4,	'Total Square',	1,	'2024-03-14 04:06:43',	1,	442.77,	1,	1),
(5,	'Perimeter Eave',	1,	'2024-03-17 01:12:04',	1,	1.96,	2,	1),
(6,	'Hips & Ridge',	1,	'2024-03-14 04:07:37',	1,	3.29,	2,	1),
(7,	'Valleys',	1,	'2024-03-17 01:11:57',	1,	2.35,	2,	1),
(8,	'Ridge',	1,	'2024-03-17 01:11:55',	1,	5.86,	2,	1),
(9,	'OC Base Package Order Template',	2,	'2024-03-17 01:23:05',	3,	465.94,	1,	1),
(10,	'Total Square',	2,	'2024-03-17 01:26:00',	3,	425.85,	1,	1),
(11,	'Perimeter Eave',	2,	'2024-03-17 01:27:36',	3,	1.96,	2,	1),
(12,	'Hips & Ridge',	2,	'2024-03-17 01:28:19',	3,	1.43,	2,	1),
(13,	'Valleys',	2,	'2024-03-17 01:29:21',	3,	2.45,	2,	1),
(14,	'Ridge',	2,	'2024-03-17 01:29:57',	3,	5.86,	2,	1),
(15,	'OC Preferred Order template',	3,	'2024-03-17 01:33:59',	3,	212.86,	1,	1),
(16,	'Area 1',	3,	'2024-03-17 01:34:45',	3,	5.00,	1,	1),
(17,	'Area 2',	3,	'2024-03-17 01:35:18',	3,	4.00,	1,	1),
(18,	'Area 3',	3,	'2024-03-17 01:35:46',	3,	4.50,	1,	1),
(19,	'OC Preferred Order Template',	4,	'2024-03-17 01:39:42',	3,	549.81,	1,	1),
(20,	'Total Square',	4,	'2024-03-17 02:10:13',	3,	447.72,	1,	1),
(21,	'Perimeter Eave',	4,	'2024-03-17 02:11:16',	3,	2.59,	2,	1),
(22,	'Hips & Ridge',	4,	'2024-03-17 02:12:00',	3,	3.92,	2,	1),
(23,	'Valleys',	4,	'2024-03-17 02:12:40',	3,	2.35,	1,	1),
(24,	'Ridge',	4,	'2024-03-17 02:13:45',	3,	5.86,	1,	1);


INSERT INTO `estimate_template_products` (`id`, `estimate_template_section_id`, `provider_id`, `product_id`, `description`, `quantity`, `tax`, `tax_bool`, `price_for_customer`) VALUES
(1,	1,	2,	2,	NULL,	1.0000,	2.12,	1,	25.69),
(2,	1,	2,	3,	NULL,	1.0000,	2.31,	1,	27.96),
(3,	1,	2,	4,	NULL,	1.0000,	2.49,	1,	30.22),
(4,	1,	2,	5,	NULL,	1.0000,	4.36,	1,	52.89),
(5,	1,	2,	6,	NULL,	1.0000,	8.10,	1,	98.22),
(6,	1,	2,	7,	NULL,	1.0000,	1.23,	1,	14.95),
(7,	1,	2,	8,	NULL,	1.0000,	1.25,	1,	15.12),
(8,	1,	2,	9,	NULL,	1.0000,	3.12,	1,	37.77),
(9,	1,	1,	10,	NULL,	1.0000,	0.00,	0,	28.57),
(10,	1,	1,	11,	NULL,	1.0000,	11.79,	1,	142.86),
(11,	1,	2,	12,	NULL,	1.0000,	6.23,	1,	75.56),
(12,	4,	1,	1,	NULL,	1.0000,	0.00,	0,	100.00),
(13,	4,	2,	14,	NULL,	3.0000,	14.19,	1,	57.34),
(14,	4,	2,	15,	NULL,	0.1000,	1.05,	1,	126.84),
(15,	4,	1,	16,	NULL,	1.0000,	0.00,	0,	21.43),
(16,	4,	2,	17,	NULL,	0.0600,	0.21,	1,	42.31),
(17,	4,	1,	19,	NULL,	1.0000,	0.00,	0,	35.71),
(18,	4,	1,	20,	NULL,	1.0000,	0.00,	0,	14.29),
(19,	4,	2,	21,	NULL,	0.0600,	0.46,	1,	92.17),
(20,	4,	1,	22,	NULL,	1.0000,	0.00,	0,	71.43),
(21,	5,	2,	23,	NULL,	0.1000,	0.10,	1,	11.55),
(22,	5,	2,	24,	NULL,	0.0100,	0.07,	1,	80.29),
(23,	5,	1,	25,	NULL,	0.0000,	0.00,	0,	100.00),
(25,	6,	1,	26,	NULL,	0.0000,	0.00,	0,	100.00),
(26,	6,	2,	27,	NULL,	0.0300,	0.27,	1,	109.61),
(27,	7,	2,	28,	NULL,	0.0200,	0.19,	1,	117.68),
(28,	8,	2,	29,	NULL,	0.2500,	0.48,	1,	23.42),
(29,	4,	1,	18,	NULL,	1.0000,	0.59,	1,	7.14),
(30,	9,	2,	30,	NULL,	1.0000,	1.87,	1,	22.67),
(31,	9,	2,	31,	NULL,	1.0000,	2.49,	1,	30.22),
(32,	9,	2,	6,	NULL,	1.0000,	8.10,	1,	98.22),
(33,	9,	2,	7,	NULL,	1.0000,	1.23,	1,	14.95),
(34,	9,	2,	8,	NULL,	1.0000,	1.25,	1,	15.12),
(35,	9,	2,	9,	NULL,	1.0000,	3.12,	1,	37.77),
(36,	9,	1,	10,	NULL,	1.0000,	2.36,	1,	28.57),
(37,	9,	1,	11,	NULL,	1.0000,	0.00,	0,	142.86),
(38,	9,	2,	12,	NULL,	1.0000,	6.23,	1,	75.56),
(39,	10,	2,	32,	NULL,	3.0000,	13.38,	1,	54.08),
(40,	10,	2,	15,	NULL,	0.1000,	1.05,	1,	126.84),
(41,	10,	2,	21,	NULL,	0.0600,	0.46,	1,	92.17),
(42,	10,	2,	17,	NULL,	0.0600,	0.21,	1,	42.31),
(43,	10,	1,	1,	NULL,	1.0000,	0.00,	0,	100.00),
(44,	10,	1,	22,	NULL,	1.0000,	0.00,	0,	71.43),
(45,	10,	1,	20,	NULL,	1.0000,	0.00,	0,	14.29),
(46,	10,	1,	16,	NULL,	1.0000,	0.00,	0,	21.43),
(47,	10,	1,	19,	NULL,	1.0000,	0.00,	0,	35.71),
(48,	11,	2,	24,	NULL,	0.0100,	0.07,	1,	80.29),
(49,	11,	2,	23,	NULL,	0.1000,	0.10,	1,	11.55),
(50,	11,	1,	25,	NULL,	0.0000,	0.00,	0,	100.00),
(51,	12,	2,	33,	NULL,	0.0300,	0.12,	1,	47.71),
(52,	12,	1,	26,	NULL,	0.0000,	0.00,	0,	100.00),
(53,	13,	2,	34,	NULL,	0.0200,	0.20,	1,	122.55),
(54,	14,	2,	29,	NULL,	0.2500,	0.48,	1,	23.42),
(55,	15,	2,	35,	NULL,	1.0000,	1.06,	1,	12.86),
(56,	15,	2,	36,	NULL,	1.0000,	16.50,	1,	200.00),
(57,	16,	2,	37,	NULL,	1.0000,	0.41,	1,	5.00),
(59,	17,	2,	37,	NULL,	1.0000,	0.33,	1,	4.00),
(60,	18,	2,	37,	NULL,	1.0000,	0.37,	1,	4.50),
(61,	19,	2,	2,	NULL,	1.0000,	2.12,	1,	25.69),
(62,	19,	2,	3,	NULL,	1.0000,	2.31,	1,	27.96),
(63,	19,	2,	4,	NULL,	1.0000,	2.49,	1,	30.22),
(64,	19,	2,	5,	NULL,	1.0000,	4.36,	1,	52.89),
(65,	19,	2,	6,	NULL,	1.0000,	8.10,	1,	98.22),
(66,	19,	2,	7,	NULL,	1.0000,	1.23,	1,	14.95),
(67,	19,	2,	8,	NULL,	1.0000,	1.25,	1,	15.12),
(68,	19,	2,	9,	NULL,	1.0000,	0.00,	0,	37.77),
(69,	19,	1,	10,	NULL,	1.0000,	2.36,	1,	28.57),
(70,	19,	1,	11,	NULL,	1.0000,	11.79,	1,	142.86),
(71,	19,	2,	12,	NULL,	1.0000,	6.23,	1,	75.56),
(72,	20,	2,	14,	NULL,	3.0000,	14.19,	1,	57.34),
(73,	20,	2,	15,	NULL,	0.1000,	1.05,	1,	126.84),
(74,	20,	2,	21,	NULL,	0.0600,	0.46,	1,	92.17),
(75,	20,	2,	17,	NULL,	0.0600,	0.21,	1,	42.31),
(76,	20,	1,	1,	NULL,	1.0000,	0.00,	0,	100.00),
(77,	20,	1,	22,	NULL,	1.0000,	0.00,	0,	71.43),
(78,	20,	1,	20,	NULL,	1.0000,	0.00,	0,	14.29),
(79,	20,	1,	16,	NULL,	1.0000,	0.00,	0,	21.43),
(80,	20,	1,	19,	NULL,	1.0000,	0.00,	0,	35.71),
(81,	20,	2,	38,	NULL,	1.0000,	1.00,	1,	12.09),
(82,	21,	2,	24,	NULL,	0.0100,	0.07,	1,	80.29),
(83,	21,	2,	23,	NULL,	0.1000,	0.10,	1,	11.55),
(84,	21,	1,	25,	NULL,	0.0033,	0.00,	0,	100.00),
(85,	22,	2,	27,	NULL,	0.0300,	0.27,	1,	109.61),
(86,	22,	1,	26,	NULL,	0.0033,	0.00,	0,	100.00),
(87,	23,	2,	28,	NULL,	0.0200,	0.19,	1,	117.68),
(88,	24,	2,	29,	NULL,	0.2500,	0.48,	1,	23.42);
-- 2024-03-28 19:27:56
