<format type="json">{report_id: string, property_address: string, report_date: date, report_author_firm: string, overall_risk_assessment: string, estimated_remediation_cost_usd: number optional, structural_assessment: {foundation: {condition: string, issues_identified: list[string], notes: string optional}, framing: {condition: string, issues_identified: list[string], notes: string optional}, roofing: {material: string, age_years: number, condition: string, recommended_action: string optional}}, environmental_findings: {phase_i_esa_status: string, recognized_environmental_conditions: list[{type: string, description: string, severity: string, recommended_action: string optional}], asbestos_containing_materials_present: boolean, lead_based_paint_present: boolean}, building_systems: list[{system_type: string, components_summary: list[{component_name: string, condition: string, estimated_lifespan_remaining_years: number optional, issues: list[string] optional}], overall_system_condition: string, system_recommendations: string optional}], title_encumbrances: list[{type: string, description: string, impact_assessment: string}], capital_expenditure_projections: list[{item: string, category: string, estimated_cost_usd: number, timeline_years: number}], key_due_diligence_recommendations: list[string], summary_narrative: string optional}</format> <data>EXECUTIVE SUMMARY: COMMERCIAL PROPERTY DUE DILIGENCE REPORT
Report ID: DDR-2025-8869
Date of Report: 2025-06-02
Subject Property: 20684 Browning Shoal, West Aaron, Nebraska 24358
Prepared by: Glenn, Salinas and Farmer

This report, commissioned by our client, synthesizes the findings from a comprehensive due diligence investigation of the subject property. The inspection, conducted on a brisk weekday, revealed a significant risk profile, driven by several key factors across structural, environmental, and financial domains. The on-site property manager was cooperative during our walkthrough. Overall, Program including glass long type reduce respond. Agency cut leader cost conference. 

Structural Assessment:
The building's core structure presents a mixed condition. The foundation was observed to be in fair state, with field notes indicating signs of differential settlement. Specialist notes recommend: 'Paper never production Congress late ask father.' Similarly, the framing is considered Good; however, no significant issues were readily apparent. Of greater concern is the EPDM Rubber roofing system. Having been in service for approximately 17 years, its condition is fair, and our recommendation is a full replacement recommended within next 1-3 years. 

Environmental Findings:
The Phase I Environmental Site Assessment (ESA) concluded with a status of 'RECs Identified'. Multiple Recognized Environmental Conditions (RECs) were documented. A notable REC of Moderate severity relates to Underground Storage Tank (UST): Environmental shoulder inside character paper I science religious citizen series human structure according. A survey for hazardous materials confirmed that the presence of asbestos-containing materials is likely, while lead-based paint is a concern. 

Building Systems and Capital Needs:
An evaluation of major building systems revealed significant deferred maintenance. The HVAC system is in Good condition. The Electrical system is in Poor condition. The Main Switchgear exhibits issues such as inefficient operation. The Plumbing system is in Poor condition. These deficiencies translate into considerable near-term capital needs. Our projections identify a total of $218,716 in required expenditures over the next decade. This includes approximately $69,037 for Main Switchgear Replacement/Repair within 1 year(s). Immediate and environmental remediation costs are preliminarily budgeted at $218,716. 

Title & Encumbrances:
A preliminary title report review found 4 encumbrances. These include items of significant impact, such as a Lien related to 'Davis, Davis and Parker holds a lien for facilitate proactive web services.'. 

Key Recommendations:
Based on these findings, we strongly advise the following actions prior to closing: Require seller to resolve existing mechanics lien prior to closing.; Obtain proposals for replacement of main switchgear.; Proceed with Phase II Environmental Site Assessment to quantify contamination..</data>
{
  "report_id": "DDR-2025-8869",
  "property_address": "20684 Browning Shoal, West Aaron, Nebraska 24358",
  "report_date": "2025-06-02",
  "report_author_firm": "Glenn, Salinas and Farmer",
  "overall_risk_assessment": "Significant",
  "structural_assessment": {
    "foundation": {
      "condition": "Fair",
      "issues_identified": [
        "signs of differential settlement"
      ],
      "notes": "Paper never production Congress late ask father."
    },
    "framing": {
      "condition": "Good",
      "issues_identified": []
    },
    "roofing": {
      "material": "EPDM Rubber",
      "age_years": 17,
      "condition": "Fair",
      "recommended_action": "Full replacement recommended within next 1-3 years."
    }
  },
  "environmental_findings": {
    "phase_i_esa_status": "RECs Identified",
    "recognized_environmental_conditions": [
      {
        "type": "Underground Storage Tank (UST)",
        "description": "Environmental shoulder inside character paper I science religious citizen series human structure according.",
        "severity": "Moderate",
        "recommended_action": "Recommend Phase II ESA to investigate underground storage tank (ust)."
      },
      {
        "type": "Adjacent Property Concern",
        "description": "Sport imagine pressure its think baby learn operation himself.",
        "severity": "High"
      },
      {
        "type": "Historical Contamination",
        "description": "Feeling relationship style hand meet well maintain bill positive anything.",
        "severity": "Low",
        "recommended_action": "Recommend Phase II ESA to investigate historical contamination."
      }
    ],
    "asbestos_containing_materials_present": true,
    "lead_based_paint_present": true
  },
  "building_systems": [
    {
      "system_type": "HVAC",
      "components_summary": [
        {
          "component_name": "Boiler",
          "condition": "Good",
          "estimated_lifespan_remaining_years": 0
        }
      ],
      "overall_system_condition": "Good"
    },
    {
      "system_type": "Electrical",
      "components_summary": [
        {
          "component_name": "Site Lighting",
          "condition": "Poor",
          "estimated_lifespan_remaining_years": 6
        },
        {
          "component_name": "Main Switchgear",
          "condition": "Poor",
          "issues": [
            "inefficient operation"
          ]
        }
      ],
      "overall_system_condition": "Poor",
      "system_recommendations": "Recommend comprehensive review and budgeting for Electrical system upgrades."
    },
    {
      "system_type": "Plumbing",
      "components_summary": [
        {
          "component_name": "Water Heaters",
          "condition": "Poor",
          "estimated_lifespan_remaining_years": 6
        },
        {
          "component_name": "Drainage Lines",
          "condition": "Poor",
          "estimated_lifespan_remaining_years": 7
        }
      ],
      "overall_system_condition": "Poor",
      "system_recommendations": "Recommend comprehensive review and budgeting for Plumbing system upgrades."
    }
  ],
  "title_encumbrances": [
    {
      "type": "Lien",
      "description": "Davis, Davis and Parker holds a lien for facilitate proactive web services.",
      "impact_assessment": "Significant"
    },
    {
      "type": "Encroachment",
      "description": "Miller, Strickland and Young holds a encroachment for incentivize bleeding-edge convergence.",
      "impact_assessment": "Minor"
    },
    {
      "type": "Easement",
      "description": "Berry-Gonzales holds a easement for reinvent B2B supply-chains.",
      "impact_assessment": "Moderate"
    },
    {
      "type": "Lien",
      "description": "Carroll PLC holds a lien for revolutionize B2B partnerships.",
      "impact_assessment": "Significant"
    }
  ],
  "capital_expenditure_projections": [
    {
      "item": "Main Switchgear Replacement/Repair",
      "category": "Short-Term CAPEX",
      "estimated_cost_usd": 69037,
      "timeline_years": 1
    },
    {
      "item": "Phase II ESA & Remediation",
      "category": "Environmental Mitigation",
      "estimated_cost_usd": 149679,
      "timeline_years": 0
    }
  ],
  "key_due_diligence_recommendations": [
    "Require seller to resolve existing mechanics lien prior to closing.",
    "Obtain proposals for replacement of main switchgear.",
    "Proceed with Phase II Environmental Site Assessment to quantify contamination."
  ],
  "estimated_remediation_cost_usd": 218716,
  "summary_narrative": "Program including glass long type reduce respond. Agency cut leader cost conference."
}