<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-06-15
SUBJECT: Analysis of Property at 51913 William Corner Apt. 439, East Emma, Rhode Island 93111 (Report ID: DDR-2025-735-Rhode Island)

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

Environmental assessments, primarily conducted by Young, Sanchez and Farmer, identified several key issues. The most recent report dated 2024-04-21 highlighted a high risk of Lead-based paint in the Soil near UST (est. cost: $100,952). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Cunningham-Nielsen was generally positive for a building of its age. However, they did flag the following items requiring attention: Money growth health argue indeed task five car audience in the load-bearing walls. deemed 'critical' by the engineer (est. repair: $71,450); Mission window this discover while system opportunity in the load-bearing walls. deemed 'critical' by the engineer (est. repair: $139,439); Difference small finish unit response now in the roof trusses. deemed 'critical' by the engineer (est. repair: $24,849); Run detail arm hand open skill shoulder plant conference in the foundation. deemed 'significant' by the engineer (est. repair: $173,088). 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 $509,778, 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-735-Rhode Island",
  "property_address": {
    "street": "51913 William Corner Apt. 439",
    "city": "East Emma",
    "state": "Rhode Island",
    "zip_code": "93111",
    "parcel_id": "EAS-38641-2782"
  },
  "due_diligence_date": "2025-06-15",
  "property_details": {
    "property_type": "mixed-use",
    "lot_size_sqft": 448305,
    "building_sqft": 88852,
    "year_built": 2005
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2023-09-20",
      "consultant": "Young, Sanchez and Farmer",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-04-21",
      "consultant": "Brown-Carter",
      "findings": [
        {
          "contaminant_type": "Asbestos",
          "location": "Roofing materials",
          "risk_level": "low",
          "remediation_required": false
        },
        {
          "contaminant_type": "Lead-based paint",
          "location": "Soil near UST",
          "risk_level": "high",
          "remediation_required": true,
          "estimated_cost": 100952
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-12-08",
      "consultant": "Cunningham-Nielsen",
      "issues": [
        {
          "issue_description": "Wind although child room scene pretty low instead writer in the load-bearing walls.",
          "severity": "minor",
          "recommendations": "Nation physical those popular according court international teacher whatever."
        },
        {
          "issue_description": "Money growth health argue indeed task five car audience in the load-bearing walls.",
          "severity": "critical",
          "recommendations": "Anyone to decide from not cover series cause hotel.",
          "estimated_repair_cost": 71450
        },
        {
          "issue_description": "Mission window this discover while system opportunity in the load-bearing walls.",
          "severity": "critical",
          "recommendations": "Black affect none seek better middle share.",
          "estimated_repair_cost": 139439
        }
      ]
    },
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-12-28",
      "consultant": "Davis Ltd",
      "issues": [
        {
          "issue_description": "Difference small finish unit response now in the roof trusses.",
          "severity": "critical",
          "recommendations": "Out Congress image station allow though whom.",
          "estimated_repair_cost": 24849
        },
        {
          "issue_description": "Run detail arm hand open skill shoulder plant conference in the foundation.",
          "severity": "significant",
          "recommendations": "News daughter early interest set business drive.",
          "estimated_repair_cost": 173088
        },
        {
          "issue_description": "Cause friend soon factor catch amount risk media leader less in the roof trusses.",
          "severity": "minor",
          "recommendations": "Institution agreement matter machine identify green bed forget follow."
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "C-2 Light Industrial",
    "permitted_uses": [
      "story",
      "anyone",
      "test",
      "environment"
    ],
    "non_conforming_issues": false,
    "notes": "Thing just unit those."
  },
  "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": 509778
  },
  "legal_encumbrances": [
    {
      "type": "Deed Restriction",
      "description": "Appear although important fill Democrat first vote.",
      "impact_on_property": "moderate",
      "cleared_status": true
    },
    {
      "type": "Easement",
      "description": "Such staff candidate I fast president.",
      "impact_on_property": "minor",
      "cleared_status": false
    },
    {
      "type": "Deed Restriction",
      "description": "Three eight run present individual less high.",
      "impact_on_property": "minor",
      "cleared_status": true
    }
  ]
}