<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-3990
Date of Report: 2025-06-08
Subject Property: 3800 Hannah Bridge, Melissaton, Minnesota 64032
Prepared by: Combs PLC

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, Nearly always the me more bring. Military instead year when film image experience scene. All want they others foot. 

Structural Assessment:
The building's core structure presents a mixed condition. The foundation was observed to be in poor state, with field notes indicating spalling concrete. Specialist notes recommend: 'High smile stage rich nature fine plant.' Similarly, the framing is considered Good; however, no significant issues were readily apparent. Of greater concern is the TPO Membrane roofing system. Having been in service for approximately 18 years, its condition is fair, and it will require monitoring. 

Environmental Findings:
The Phase I Environmental Site Assessment (ESA) concluded with a status of 'No RECs Identified'. A survey for hazardous materials confirmed that the presence of asbestos-containing materials is not suspected, while lead-based paint is a concern. 

Building Systems and Capital Needs:
An evaluation of major building systems revealed significant deferred maintenance. The Electrical system is in Fair condition. The Main Switchgear exhibits issues such as requires immediate service, nearing end of useful life. The Fire Safety system is in Poor condition. The Sprinkler System exhibits issues such as nearing end of useful life, inefficient operation. The Plumbing system is in Poor condition. The Supply Pipes exhibits issues such as inefficient operation, nearing end of useful life. The HVAC system is in Poor condition. The Boiler exhibits issues such as nearing end of useful life, requires immediate service. These deficiencies translate into considerable near-term capital needs. Our projections identify a total of $76,956 in required expenditures over the next decade. This includes approximately $65,688 for Supply Pipes Replacement/Repair within 3 year(s). Immediate and environmental remediation costs are preliminarily budgeted at $76,956. 

Title & Encumbrances:
A preliminary title report review found 4 encumbrances. These include items of moderate impact, such as a Encroachment related to 'Orozco, Alvarez and Johnson holds a encroachment for expedite sticky schemas.'. 

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 supply pipes.; Obtain proposals for replacement of boiler..</data>
{
  "report_id": "DDR-2025-3990",
  "property_address": "3800 Hannah Bridge, Melissaton, Minnesota 64032",
  "report_date": "2025-06-08",
  "report_author_firm": "Combs PLC",
  "overall_risk_assessment": "Significant",
  "structural_assessment": {
    "foundation": {
      "condition": "Poor",
      "issues_identified": [
        "spalling concrete"
      ],
      "notes": "High smile stage rich nature fine plant."
    },
    "framing": {
      "condition": "Good",
      "issues_identified": []
    },
    "roofing": {
      "material": "TPO Membrane",
      "age_years": 18,
      "condition": "Fair"
    }
  },
  "environmental_findings": {
    "phase_i_esa_status": "No RECs Identified",
    "recognized_environmental_conditions": [],
    "asbestos_containing_materials_present": false,
    "lead_based_paint_present": true
  },
  "building_systems": [
    {
      "system_type": "Electrical",
      "components_summary": [
        {
          "component_name": "Main Switchgear",
          "condition": "Fair",
          "issues": [
            "requires immediate service",
            "nearing end of useful life"
          ]
        }
      ],
      "overall_system_condition": "Fair"
    },
    {
      "system_type": "Fire Safety",
      "components_summary": [
        {
          "component_name": "Sprinkler System",
          "condition": "Fair",
          "estimated_lifespan_remaining_years": 14,
          "issues": [
            "nearing end of useful life",
            "inefficient operation"
          ]
        },
        {
          "component_name": "Fire Alarm Control Panel",
          "condition": "Poor"
        }
      ],
      "overall_system_condition": "Poor"
    },
    {
      "system_type": "Plumbing",
      "components_summary": [
        {
          "component_name": "Supply Pipes",
          "condition": "Poor",
          "estimated_lifespan_remaining_years": 7,
          "issues": [
            "inefficient operation",
            "nearing end of useful life"
          ]
        }
      ],
      "overall_system_condition": "Poor",
      "system_recommendations": "Recommend comprehensive review and budgeting for Plumbing system upgrades."
    },
    {
      "system_type": "HVAC",
      "components_summary": [
        {
          "component_name": "Boiler",
          "condition": "Poor",
          "issues": [
            "nearing end of useful life",
            "requires immediate service"
          ]
        }
      ],
      "overall_system_condition": "Poor",
      "system_recommendations": "Recommend comprehensive review and budgeting for HVAC system upgrades."
    }
  ],
  "title_encumbrances": [
    {
      "type": "Encroachment",
      "description": "Orozco, Alvarez and Johnson holds a encroachment for expedite sticky schemas.",
      "impact_assessment": "Moderate"
    },
    {
      "type": "Lien",
      "description": "Martinez, Dennis and Decker holds a lien for synergize holistic platforms.",
      "impact_assessment": "Significant"
    },
    {
      "type": "Covenant",
      "description": "Miller LLC holds a covenant for redefine magnetic infrastructures.",
      "impact_assessment": "Significant"
    },
    {
      "type": "Covenant",
      "description": "Smith Inc holds a covenant for iterate enterprise solutions.",
      "impact_assessment": "Significant"
    }
  ],
  "capital_expenditure_projections": [
    {
      "item": "Supply Pipes Replacement/Repair",
      "category": "Short-Term CAPEX",
      "estimated_cost_usd": 65688,
      "timeline_years": 3
    },
    {
      "item": "Boiler Replacement/Repair",
      "category": "Short-Term CAPEX",
      "estimated_cost_usd": 11268,
      "timeline_years": 3
    }
  ],
  "key_due_diligence_recommendations": [
    "Require seller to resolve existing mechanics lien prior to closing.",
    "Obtain proposals for replacement of supply pipes.",
    "Obtain proposals for replacement of boiler."
  ],
  "estimated_remediation_cost_usd": 76956,
  "summary_narrative": "Nearly always the me more bring. Military instead year when film image experience scene. All want they others foot."
}