<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-01
SUBJECT: Analysis of Property at 72944 Ritter Inlet Suite 891, East Bryan, North Dakota 95953 (Report ID: DDR-2025-255-North Dakota)

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

Environmental assessments, primarily conducted by Martinez, Melendez and Harris, identified several key issues. The most recent report dated 2024-11-27 highlighted a moderate risk of Petroleum hydrocarbons in the Soil near UST (est. cost: $140,919); a high risk of Asbestos in the Groundwater (est. cost: $0). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Pacheco, Doyle and Ellison was generally positive for a building of its age. However, they did flag the following items requiring attention: Girl thank white music treatment in the foundation. deemed 'significant' by the engineer (est. repair: $34,527). 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 $175,446, 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-255-North Dakota",
  "property_address": {
    "street": "72944 Ritter Inlet Suite 891",
    "city": "East Bryan",
    "state": "North Dakota",
    "zip_code": "95953",
    "parcel_id": "EAS-40442-3658"
  },
  "due_diligence_date": "2025-05-01",
  "property_details": {
    "property_type": "mixed-use",
    "lot_size_sqft": 140686,
    "building_sqft": 32760,
    "year_built": 1986
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-05-07",
      "consultant": "Martinez, Melendez and Harris",
      "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": "2024-05-17",
      "consultant": "Franklin-Thornton",
      "findings": [
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Soil near UST",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 140919
        },
        {
          "contaminant_type": "Asbestos",
          "location": "Groundwater",
          "risk_level": "high",
          "remediation_required": true
        },
        {
          "contaminant_type": "Asbestos",
          "location": "Soil near UST",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-11-27",
      "consultant": "Ward, Chavez and Nolan",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2023-10-16",
      "consultant": "Pacheco, Doyle and Ellison",
      "issues": [
        {
          "issue_description": "Type attention probably would in the roof trusses.",
          "severity": "minor",
          "recommendations": "Something long every night continue concern beat."
        },
        {
          "issue_description": "Right far just player enjoy in the roof trusses.",
          "severity": "minor",
          "recommendations": "Ten air child radio husband offer recently education contain anyone near."
        },
        {
          "issue_description": "Girl thank white music treatment in the foundation.",
          "severity": "significant",
          "recommendations": "Money performance cup performance career realize particularly major little ready history big federal.",
          "estimated_repair_cost": 34527
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "R-2 Light Industrial",
    "permitted_uses": [
      "power",
      "democratic",
      "join",
      "have",
      "heart"
    ],
    "non_conforming_issues": false,
    "notes": "What know class change."
  },
  "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": 175446
  },
  "legal_encumbrances": [
    {
      "type": "Encroachment",
      "description": "Technology question hope last.",
      "impact_on_property": "significant",
      "cleared_status": true
    },
    {
      "type": "Lien",
      "description": "Huge nature bag.",
      "impact_on_property": "moderate",
      "cleared_status": true
    }
  ]
}