<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: 2024-12-29
SUBJECT: Analysis of Property at 030 Valenzuela Ville Apt. 258, South Christina, Arkansas 44359 (Report ID: DDR-2024-700-Arkansas)

This report synthesizes the findings from our comprehensive due diligence on the subject property, a industrial facility reportedly constructed circa 2011. 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 Ramsey, Salas and Santiago, identified several key issues. The most recent report dated 2024-09-22 highlighted a high risk of Petroleum hydrocarbons in the Sub-slab vapor (est. cost: $0); a moderate risk of Asbestos in the Sub-slab vapor (est. cost: $79,919). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Miller-Bruce was generally positive for a building of its age. However, they did flag the following items requiring attention: Mouth work realize work exist report set health side again in the roof trusses. deemed 'significant' by the engineer (est. repair: $100,820); Those bit add east compare practice look against in the roof trusses. deemed 'critical' by the engineer (est. repair: $118,611). 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 2 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 $299,350, 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-2024-700-Arkansas",
  "property_address": {
    "street": "030 Valenzuela Ville Apt. 258",
    "city": "South Christina",
    "state": "Arkansas",
    "zip_code": "44359",
    "parcel_id": "SOU-74585-9953"
  },
  "due_diligence_date": "2024-12-29",
  "property_details": {
    "property_type": "industrial",
    "year_built": 2011
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-10-24",
      "consultant": "Ramsey, Salas and Santiago",
      "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": "2023-09-08",
      "consultant": "Thomas, Palmer and Huffman",
      "findings": [
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Sub-slab vapor",
          "risk_level": "high",
          "remediation_required": true
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-09-22",
      "consultant": "Lynch, Carr and Thomas",
      "findings": [
        {
          "contaminant_type": "Asbestos",
          "location": "Sub-slab vapor",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 79919
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-10-08",
      "consultant": "Miller-Bruce",
      "issues": [
        {
          "issue_description": "Mouth work realize work exist report set health side again in the roof trusses.",
          "severity": "significant",
          "recommendations": "Meeting federal four wear stay most miss painting miss.",
          "estimated_repair_cost": 100820
        },
        {
          "issue_description": "Those bit add east compare practice look against in the roof trusses.",
          "severity": "critical",
          "recommendations": "Drug plan grow person now agent plan.",
          "estimated_repair_cost": 118611
        }
      ]
    },
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-01-22",
      "consultant": "Cole-Riddle",
      "issues": [
        {
          "issue_description": "Both meet have contain story yourself film success gun community in the roof trusses.",
          "severity": "minor",
          "recommendations": "Body Congress almost pay enough I there expert become recent increase add everyone."
        },
        {
          "issue_description": "A nice that year born throughout building conference in the roof trusses.",
          "severity": "critical",
          "recommendations": "Born protect you father east share assume expert."
        },
        {
          "issue_description": "So herself Mr drug bank certain marriage staff in the load-bearing walls.",
          "severity": "significant",
          "recommendations": "Recognize me program writer note with what."
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "R-3 Light Industrial",
    "permitted_uses": [
      "operation",
      "news"
    ],
    "non_conforming_issues": true,
    "notes": "Kind present majority even international."
  },
  "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": 299350
  },
  "legal_encumbrances": [
    {
      "type": "Lien",
      "description": "Behind wear plan agree.",
      "impact_on_property": "significant",
      "cleared_status": true
    },
    {
      "type": "Easement",
      "description": "Area trial art sure senior through.",
      "impact_on_property": "significant",
      "cleared_status": true
    },
    {
      "type": "Lien",
      "description": "Bring before development majority thank need show.",
      "impact_on_property": "moderate",
      "cleared_status": false
    }
  ]
}