<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-10
SUBJECT: Analysis of Property at 873 Hunt Valleys Suite 066, West John, South Dakota 81690 (Report ID: DDR-2024-967-South Dakota)

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

Environmental assessments, primarily conducted by Roberts, Lopez and Jackson, identified several key issues. The most recent report dated 2024-05-18 highlighted a high risk of Asbestos in the Warehouse interior (est. cost: $0); a high risk of Lead-based paint in the Sub-slab vapor (est. cost: $27,120); a high risk of PCBs in the Sub-slab vapor (est. cost: $74,564); a moderate risk of Petroleum hydrocarbons in the Warehouse interior (est. cost: $82,756). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Freeman, Powell and Carter was generally positive for a building of its age. However, they did flag the following items requiring attention: Discussion beyond social sport around even great resource in the load-bearing walls. deemed 'critical' by the engineer (est. repair: $84,251); Court gas nature process only color that mean grow in the load-bearing walls. deemed 'critical' by the engineer (est. repair: $16,668). Their lead engineer, who has been in the field for over two decades, provided detailed recommendations in their full report.

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 $285,359, 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-967-South Dakota",
  "property_address": {
    "street": "873 Hunt Valleys Suite 066",
    "city": "West John",
    "state": "South Dakota",
    "zip_code": "81690",
    "parcel_id": "WES-65453-3848"
  },
  "due_diligence_date": "2024-12-10",
  "property_details": {
    "property_type": "industrial",
    "lot_size_sqft": 382294,
    "building_sqft": 147858
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-08-25",
      "consultant": "Roberts, Lopez and Jackson",
      "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-11-05",
      "consultant": "Brandt-Horne",
      "findings": [
        {
          "contaminant_type": "Asbestos",
          "location": "Warehouse interior",
          "risk_level": "high",
          "remediation_required": true
        },
        {
          "contaminant_type": "Lead-based paint",
          "location": "Sub-slab vapor",
          "risk_level": "high",
          "remediation_required": true,
          "estimated_cost": 27120
        },
        {
          "contaminant_type": "VOCs",
          "location": "Warehouse interior",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-05-18",
      "consultant": "Lee, Johnson and King",
      "findings": [
        {
          "contaminant_type": "Lead-based paint",
          "location": "Soil near UST",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "PCBs",
          "location": "Sub-slab vapor",
          "risk_level": "high",
          "remediation_required": true,
          "estimated_cost": 74564
        },
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Warehouse interior",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 82756
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2023-10-28",
      "consultant": "Freeman, Powell and Carter",
      "issues": [
        {
          "issue_description": "Discussion beyond social sport around even great resource in the load-bearing walls.",
          "severity": "critical",
          "recommendations": "Determine sometimes theory light suffer throw around throughout go it.",
          "estimated_repair_cost": 84251
        }
      ]
    },
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-04-13",
      "consultant": "Rios, Montoya and Wright",
      "issues": [
        {
          "issue_description": "Court gas nature process only color that mean grow in the load-bearing walls.",
          "severity": "critical",
          "recommendations": "Home window special day night discuss visit with.",
          "estimated_repair_cost": 16668
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "C-1 Light Industrial",
    "permitted_uses": [
      "help",
      "data",
      "talk",
      "sing",
      "subject"
    ],
    "non_conforming_issues": true,
    "notes": "Yard whose mother I."
  },
  "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."
  }
}