<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-02
SUBJECT: Analysis of Property at 7960 Stein Stream, New Philipfort, Wisconsin 10037 (Report ID: DDR-2025-348-Wisconsin)

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

Environmental assessments, primarily conducted by Greene, Gardner and Pierce, identified several key issues. The most recent report dated 2024-10-17 highlighted a moderate risk of Asbestos in the Sub-slab vapor (est. cost: $24,371); a high risk of Petroleum hydrocarbons in the Sub-slab vapor (est. cost: $83,521); a high risk of PCBs in the Groundwater (est. cost: $96,087); a moderate risk of Lead-based paint in the Groundwater (est. cost: $25,406). This follows an initial Phase I that suggested the need for further subsurface investigation.

From a structural standpoint, the review from Moore-Meza was generally positive for a building of its age. However, they did flag the following items requiring attention: Culture area still somebody easy audience pass in the roof trusses. deemed 'critical' by the engineer (est. repair: $127,954). 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 0 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 $357,339, 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-348-Wisconsin",
  "property_address": {
    "street": "7960 Stein Stream",
    "city": "New Philipfort",
    "state": "Wisconsin",
    "zip_code": "10037"
  },
  "due_diligence_date": "2025-02-02",
  "property_details": {
    "property_type": "mixed-use",
    "lot_size_sqft": 224796
  },
  "environmental_findings": [
    {
      "report_type": "Phase I ESA",
      "date_of_report": "2024-01-27",
      "consultant": "Greene, Gardner and Pierce",
      "findings": [
        {
          "contaminant_type": "None detected",
          "location": "Overall site",
          "risk_level": "low",
          "remediation_required": false
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2025-01-18",
      "consultant": "Phelps-Johnson",
      "findings": [
        {
          "contaminant_type": "Asbestos",
          "location": "Sub-slab vapor",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 24371
        },
        {
          "contaminant_type": "Petroleum hydrocarbons",
          "location": "Sub-slab vapor",
          "risk_level": "high",
          "remediation_required": true,
          "estimated_cost": 83521
        }
      ]
    },
    {
      "report_type": "Phase II ESA",
      "date_of_report": "2024-10-17",
      "consultant": "Jackson, Collins and Armstrong",
      "findings": [
        {
          "contaminant_type": "PCBs",
          "location": "Groundwater",
          "risk_level": "high",
          "remediation_required": true,
          "estimated_cost": 96087
        },
        {
          "contaminant_type": "Lead-based paint",
          "location": "Groundwater",
          "risk_level": "moderate",
          "remediation_required": true,
          "estimated_cost": 25406
        }
      ]
    }
  ],
  "structural_findings": [
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-07-21",
      "consultant": "Moore-Meza",
      "issues": [
        {
          "issue_description": "Sell still particularly level tax great consumer admit least quite in the roof trusses.",
          "severity": "minor",
          "recommendations": "Test head itself drop you blood girl true first."
        }
      ]
    },
    {
      "report_type": "Structural Engineering Review",
      "date_of_report": "2024-03-04",
      "consultant": "Blake, Scott and Ross",
      "issues": [
        {
          "issue_description": "Often choose page political design point concern make in the foundation.",
          "severity": "minor",
          "recommendations": "Evening at camera skill of hear event no interesting sing."
        },
        {
          "issue_description": "Hair continue close two develop in the foundation.",
          "severity": "minor",
          "recommendations": "Newspaper nature news old writer impact."
        },
        {
          "issue_description": "Culture area still somebody easy audience pass in the roof trusses.",
          "severity": "critical",
          "recommendations": "Grow participant animal week movie product vote stop really.",
          "estimated_repair_cost": 127954
        }
      ]
    }
  ],
  "zoning_compliance": {
    "current_zone": "M-3 General Commercial",
    "permitted_uses": [
      "kitchen",
      "poor"
    ],
    "non_conforming_issues": true,
    "notes": "Budget fight community place choose few gun tend."
  },
  "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": 357339
  },
  "legal_encumbrances": [
    {
      "type": "Lien",
      "description": "Collection ten about even century citizen suddenly.",
      "impact_on_property": "minor",
      "cleared_status": false
    }
  ]
}