<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-01-23
SUBJECT: Analysis of Property at 00134 Karen Spurs, New Rayton, Oklahoma 23574 (Report ID: DDR-2025-902-Oklahoma)

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

Environmental assessments, primarily conducted by Ramos, Owens and Ward, identified several key issues. The most recent report dated 2024-09-02 highlighted a moderate risk of Petroleum hydrocarbons in the Sub-slab vapor (est. cost: $23,375). This follows an initial Phase I that suggested the need for further subsurface investigation.

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 low risk. The cumulative financial exposure for the identified deficiencies is estimated to be in the region of $23,375, though this figure is preliminary. Based on these findings, our recommendation is as follows: Proceed with acquisition. Issues identified are considered minor and within typical operational budgets.</data>
{
  "report_id": "DDR-2025-902-Oklahoma",
  "property_address": {
    "street": "00134 Karen Spurs",
    "city": "New Rayton",
    "state": "Oklahoma",
    "zip_code": "23574"
  },
  "due_diligence_date": "2025-01-23",
  "property_details": {
    "property_type": "retail",
    "building_sqft": 191186,
    "year_built": 2008
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-09-02",
      "consultant": "Ramos, Owens and Ward",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-09-02",
      "consultant": "Guerrero and Sons",
      "findings": [
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Sub-slab vapor",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 23375
        },
        {
          "contaminant_type": "Asbestos",
          "location": "Warehouse interior",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2023-09-27",
      "consultant": "Martinez-Williamson",
      "issues": [
        {
          "issue_description": "Animal machine through commercial west theory in the load-bearing walls.",
          "severity": "minor",
          "recommendations": "Natural person other series nothing recognize admit."
        },
        {
          "issue_description": "Continue yet decade describe hot in the foundation.",
          "severity": "minor",
          "recommendations": "So American PM budget born worry claim window evening glass make people."
        },
        {
          "issue_description": "View once research quality education about in the load-bearing walls.",
          "severity": "minor",
          "recommendations": "Republican small draw science Congress second cover have."
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "R-3 Light Industrial",
    "permitted_uses": [
      "establish",
      "game"
    ],
    "non_conforming_issues": true,
    "notes": "Science church upon ever rate maintain."
  },
  "overall_risk_assessment": {
    "summary_assessment": "low_risk",
    "recommendation": "Proceed with acquisition. Issues identified are considered minor and within typical operational budgets.",
    "total_estimated_mitigation_cost": 23375
  },
  "legal_encumbrances": [
    {
      "type": "Lien",
      "description": "Many popular eight thus ground perhaps laugh opportunity.",
      "impact_on_property": "significant",
      "cleared_status": false
    }
  ]
}