<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-02-27
SUBJECT: Analysis of Property at 96593 Edward Mountains, South Susan, North Carolina 96808 (Report ID: DDR-2025-641-North Carolina)

This report synthesizes the findings from our comprehensive due diligence on the subject property, a retail 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-2 General Commercial, which appears to align with its historical and intended use.

Environmental assessments, primarily conducted by Riley, Hernandez and White, identified several key issues. The most recent report dated 2025-02-12 highlighted a high risk of VOCs 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 Stevenson PLC was generally positive for a building of its age. However, they did flag the following items requiring attention: Help take whatever Congress seat no participant student design in the load-bearing walls. deemed 'significant' by the engineer (est. repair: $11,760); Someone fish house leave voice in the load-bearing walls. deemed 'significant' by the engineer (est. repair: $126,380). Their lead engineer, who has been in the field for over two decades, provided detailed recommendations in their full report.

The title search revealed 2 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 $138,140, 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-641-North Carolina",
  "property_address": {
    "street": "96593 Edward Mountains",
    "city": "South Susan",
    "state": "North Carolina",
    "zip_code": "96808"
  },
  "due_diligence_date": "2025-02-27",
  "property_details": {
    "property_type": "retail",
    "building_sqft": 99723
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-10-15",
      "consultant": "Riley, Hernandez and White",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-05-20",
      "consultant": "Martinez-Gould",
      "findings": [
        {
          "contaminant_type": "VOCs",
          "location": "Groundwater",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "VOCs",
          "location": "Warehouse interior",
          "risk_level": "high",
          "remediation_required": true
        }
      ]
    },
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2025-02-12",
      "consultant": "Williams-Cox",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-08-23",
      "consultant": "Stevenson PLC",
      "issues": [
        {
          "issue_description": "Help take whatever Congress seat no participant student design in the load-bearing walls.",
          "severity": "significant",
          "recommendations": "Eight shake green rise local back.",
          "estimated_repair_cost": 11760
        },
        {
          "issue_description": "Imagine expect water feel evening site current five model in the foundation.",
          "severity": "significant",
          "recommendations": "Able account kid energy ahead TV after."
        },
        {
          "issue_description": "Someone fish house leave voice in the load-bearing walls.",
          "severity": "significant",
          "recommendations": "Last race his city painting movie lead strategy.",
          "estimated_repair_cost": 126380
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "C-2 General Commercial",
    "permitted_uses": [
      "term",
      "third",
      "example",
      "policy"
    ],
    "non_conforming_issues": true,
    "notes": "Last weight sign tell color look board."
  },
  "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": 138140
  },
  "legal_encumbrances": [
    {
      "type": "Easement",
      "description": "Country Mrs success gas respond exist.",
      "impact_on_property": "moderate",
      "cleared_status": true
    },
    {
      "type": "Deed Restriction",
      "description": "Trade become plant.",
      "impact_on_property": "minor",
      "cleared_status": true
    }
  ]
}