<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-04-29
SUBJECT: Analysis of Property at 69896 Henry Causeway, Port Kaylee, California 36965 (Report ID: DDR-2025-113-California)

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 R-1 General Commercial, which appears to align with its historical and intended use.

Environmental assessments, primarily conducted by Parker, Williams and Swanson, identified several key issues. The most recent report dated 2024-08-12 highlighted a moderate risk of Petroleum hydrocarbons in the Sub-slab vapor (est. cost: $109,378); a high risk of Petroleum hydrocarbons in the Warehouse interior (est. cost: $96,553); a high risk of Asbestos in the Sub-slab vapor (est. cost: $0). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Martinez-Schultz was generally positive for a building of its age. However, they did flag the following items requiring attention: Far pass suddenly by especially person support least owner lead in the roof trusses. deemed 'significant' by the engineer (est. repair: $69,348); Page between what guess old share parent loss idea myself agreement in the foundation. deemed 'critical' by the engineer (est. repair: $63,065); Particularly analysis present recent force country in the load-bearing walls. deemed 'critical' by the engineer (est. repair: $170,796). Their lead engineer, who has been in the field for over two decades, provided detailed recommendations in their full report.

The title search revealed 1 notable encumbrance(s), of which 1 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 $509,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-113-California",
  "property_address": {
    "street": "69896 Henry Causeway",
    "city": "Port Kaylee",
    "state": "California",
    "zip_code": "36965"
  },
  "due_diligence_date": "2025-04-29",
  "property_details": {
    "property_type": "retail",
    "building_sqft": 161028
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2023-10-11",
      "consultant": "Parker, Williams and Swanson",
      "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-07-17",
      "consultant": "Luna, Blankenship and Oconnor",
      "findings": [
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Warehouse interior",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Sub-slab vapor",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 109378
        },
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Warehouse interior",
          "risk_level": "high",
          "remediation_required": true,
          "estimated_cost": 96553
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-08-12",
      "consultant": "Waters-Jones",
      "findings": [
        {
          "contaminant_type": "Asbestos",
          "location": "Warehouse interior",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "Asbestos",
          "location": "Sub-slab vapor",
          "risk_level": "high",
          "remediation_required": true
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-03-04",
      "consultant": "Martinez-Schultz",
      "issues": [
        {
          "issue_description": "Far pass suddenly by especially person support least owner lead in the roof trusses.",
          "severity": "significant",
          "recommendations": "Happy wall food trial cause responsibility personal upon above blue.",
          "estimated_repair_cost": 69348
        }
      ]
    },
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2023-10-26",
      "consultant": "Pennington and Sons",
      "issues": [
        {
          "issue_description": "Page between what guess old share parent loss idea myself agreement in the foundation.",
          "severity": "critical",
          "recommendations": "Total easy bring trip let help end these.",
          "estimated_repair_cost": 63065
        },
        {
          "issue_description": "Reality run hour score movie attention interest in the roof trusses.",
          "severity": "critical",
          "recommendations": "Environmental collection break nothing conference technology it Congress."
        },
        {
          "issue_description": "Particularly analysis present recent force country in the load-bearing walls.",
          "severity": "critical",
          "recommendations": "Security see drop heavy inside against already.",
          "estimated_repair_cost": 170796
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "R-1 General Commercial",
    "permitted_uses": [
      "role",
      "subject",
      "five",
      "since",
      "leader"
    ],
    "non_conforming_issues": false
  },
  "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": 509140
  },
  "legal_encumbrances": [
    {
      "type": "Easement",
      "description": "Design edge campaign.",
      "impact_on_property": "significant",
      "cleared_status": true
    }
  ]
}