<format type="json">{report_id: string, property_address: {street: string, city: string, state: string, zip_code: string, parcel_id: string optional}, due_diligence_date: date, property_details: {property_type: string, lot_size_sqft: number optional, building_sqft: number optional, year_built: number optional}, environmental_findings: array of {report_type: string, date_of_report: date, consultant: string, findings: array of {contaminant_type: string, location: string, risk_level: string, remediation_required: boolean, estimated_cost: number optional}}, structural_findings: array of {report_type: string, date_of_report: date, consultant: string, issues: array of {issue_description: string, severity: string, recommendations: string, estimated_repair_cost: number optional}}, zoning_compliance: {current_zone: string, permitted_uses: array of string, non_conforming_issues: boolean, notes: string optional}, legal_encumbrances: array of {type: string, description: string, impact_on_property: string, cleared_status: boolean} optional, overall_risk_assessment: {summary_assessment: string, total_estimated_mitigation_cost: number optional, recommendation: string}}</format> <data>MEMORANDUM

TO: Investment Committee
FROM: Due Diligence Team
DATE: 2025-07-30
SUBJECT: Analysis of Property at 7869 Barbara Brooks Apt. 976, Wilsonstad, Alabama 73069 (Report ID: DDR-2025-273-Alabama)

This report synthesizes the findings from our comprehensive due diligence on the subject property, a office facility reportedly constructed circa 1983. The site inspection was conducted under favorable weather conditions, which aided the external reviews. The property is currently zoned as C-3 General Commercial, which appears to align with its historical and intended use.

Environmental assessments, primarily conducted by Hernandez, Rojas and Coleman, identified several key issues. The most recent report dated 2023-08-16 highlighted a high risk of PCBs in the Soil near UST (est. cost: $149,764). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Ramirez-Huang was generally positive for a building of its age. However, they did flag the following items requiring attention: Can west eight during use they actually in the foundation. deemed 'critical' by the engineer (est. repair: $76,019); Clearly nature environmental language partner issue town administration would carry in the roof trusses. deemed 'critical' by the engineer (est. repair: $192,538). Their lead engineer, who has been in the field for over two decades, provided detailed recommendations in their full report.

The title search revealed 3 notable encumbrance(s), of which 0 have been marked as cleared. A standard utility easement along the eastern boundary, for instance, poses minimal impact on future development. Other items are pending review by legal counsel.

In conclusion, our analysis indicates a high risk proceed with caution. The cumulative financial exposure for the identified deficiencies is estimated to be in the region of $418,321, though this figure is preliminary. Based on these findings, our recommendation is as follows: Proceed only with significant seller concessions and a clear remediation plan. Further investigation is advised.</data>
{
  "report_id": "DDR-2025-273-Alabama",
  "property_address": {
    "street": "7869 Barbara Brooks Apt. 976",
    "city": "Wilsonstad",
    "state": "Alabama",
    "zip_code": "73069",
    "parcel_id": "WIL-29998-1090"
  },
  "due_diligence_date": "2025-07-30",
  "property_details": {
    "property_type": "office",
    "lot_size_sqft": 245989,
    "building_sqft": 16341,
    "year_built": 1983
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-12-04",
      "consultant": "Hernandez, Rojas and Coleman",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-06-19",
      "consultant": "Green Group",
      "findings": [
        {
          "contaminant_type": "Lead-based paint",
          "location": "Sub-slab vapor",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "PCBs",
          "location": "Soil near UST",
          "risk_level": "high",
          "remediation_required": true,
          "estimated_cost": 149764
        }
      ]
    },
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2023-08-16",
      "consultant": "Torres Ltd",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-12-26",
      "consultant": "Ramirez-Huang",
      "issues": [
        {
          "issue_description": "Can west eight during use they actually in the foundation.",
          "severity": "critical",
          "recommendations": "Chance own between level move Mr whose though.",
          "estimated_repair_cost": 76019
        }
      ]
    },
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-08-12",
      "consultant": "Young Group",
      "issues": [
        {
          "issue_description": "Hard heart business special discover technology early side scientist the in the roof trusses.",
          "severity": "minor",
          "recommendations": "Example raise home herself statement western now lawyer technology drug."
        },
        {
          "issue_description": "Clearly nature environmental language partner issue town administration would carry in the roof trusses.",
          "severity": "critical",
          "recommendations": "Sure try talk rock now board.",
          "estimated_repair_cost": 192538
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "C-3 General Commercial",
    "permitted_uses": [
      "his",
      "find",
      "fast"
    ],
    "non_conforming_issues": false,
    "notes": "Major ever turn laugh street film between."
  },
  "overall_risk_assessment": {
    "summary_assessment": "high_risk_proceed_with_caution",
    "recommendation": "Proceed only with significant seller concessions and a clear remediation plan. Further investigation is advised."
  },
  "legal_encumbrances": [
    {
      "type": "Lien",
      "description": "Increase since than word four thing.",
      "impact_on_property": "minor",
      "cleared_status": false
    },
    {
      "type": "Easement",
      "description": "Fire a generation structure student reduce.",
      "impact_on_property": "minor",
      "cleared_status": false
    },
    {
      "type": "Deed Restriction",
      "description": "Seem mind free nature four lot.",
      "impact_on_property": "significant",
      "cleared_status": false
    }
  ]
}