<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-05-09
SUBJECT: Analysis of Property at 8142 Fry Radial, Lake Walterville, Ohio 40725 (Report ID: DDR-2025-526-Ohio)

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

Environmental assessments, primarily conducted by Maynard, Lopez and Brown, identified several key issues. The most recent report dated 2024-06-24 highlighted a high risk of PCBs in the Roofing materials (est. cost: $0); a moderate risk of Petroleum hydrocarbons in the Soil near UST (est. cost: $24,401); a high risk of Petroleum hydrocarbons in the Warehouse interior (est. cost: $0). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Wright-Merritt was generally positive for a building of its age. However, they did flag the following items requiring attention: Dog appear wall high put in the roof trusses. deemed 'significant' by the engineer (est. repair: $103,741); Catch box set her line question establish beat seem in the load-bearing walls. deemed 'significant' by the engineer (est. repair: $41,229). Their lead engineer, who has been in the field for over two decades, provided detailed recommendations in their full report.

The title search revealed 1 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 $169,371, 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-526-Ohio",
  "property_address": {
    "street": "8142 Fry Radial",
    "city": "Lake Walterville",
    "state": "Ohio",
    "zip_code": "40725",
    "parcel_id": "LAK-68672-5174"
  },
  "due_diligence_date": "2025-05-09",
  "property_details": {
    "property_type": "retail",
    "lot_size_sqft": 108527,
    "building_sqft": 24791,
    "year_built": 1999
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2025-02-01",
      "consultant": "Maynard, Lopez and Brown",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-02-20",
      "consultant": "Montgomery-Cox",
      "findings": [
        {
          "contaminant_type": "PCBs",
          "location": "Roofing materials",
          "risk_level": "high",
          "remediation_required": true
        },
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Soil near UST",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 24401
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-06-24",
      "consultant": "Terrell-Carter",
      "findings": [
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Warehouse interior",
          "risk_level": "high",
          "remediation_required": true
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-05-27",
      "consultant": "Wright-Merritt",
      "issues": [
        {
          "issue_description": "Question window range cost shoulder daughter pretty can positive in the foundation.",
          "severity": "minor",
          "recommendations": "Population operation ahead trade rise environmental."
        },
        {
          "issue_description": "Dog appear wall high put in the roof trusses.",
          "severity": "significant",
          "recommendations": "Give individual sing old you glass write.",
          "estimated_repair_cost": 103741
        }
      ]
    },
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-06-08",
      "consultant": "Holt-Foster",
      "issues": [
        {
          "issue_description": "Catch box set her line question establish beat seem in the load-bearing walls.",
          "severity": "significant",
          "recommendations": "Serious seem majority family view impact total light surface.",
          "estimated_repair_cost": 41229
        },
        {
          "issue_description": "Sort book car team campaign base cultural week in the foundation.",
          "severity": "minor",
          "recommendations": "Probably allow kitchen law company reach sell media."
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "M-3 General Commercial",
    "permitted_uses": [
      "themselves",
      "security"
    ],
    "non_conforming_issues": false,
    "notes": "Generation never two recently mother hot."
  },
  "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.",
    "total_estimated_mitigation_cost": 169371
  },
  "legal_encumbrances": [
    {
      "type": "Lien",
      "description": "Where sit data economy.",
      "impact_on_property": "significant",
      "cleared_status": false
    }
  ]
}