<format type="json">{property_id: string, report_date: date, property_address: string, due_diligence_lead: string, property_characteristics: {property_type: string, square_footage: number, year_built: number, lot_size_acres: number optional, current_use: string, structural_integrity: {overall_rating: string, identified_defects: list[{defect_type: string, severity: string, estimated_repair_cost: number optional, recommendations: string}]}}, environmental_summary: {phase_i_conducted: boolean, recognized_environmental_conditions: list[{rec_type: string, status: string, estimated_remediation_cost: number optional}], hazardous_materials_present: boolean, environmental_report_date: date}, legal_and_title_status: {clear_title_verified: boolean, encumbrances: list[{encumbrance_type: string, description: string, impact_on_property: string}], zoning_designation: string, permitted_uses: list[string], pending_litigation: boolean optional}, financial_overview: {current_leases: list[{tenant_name: string, lease_start_date: date, lease_end_date: date, monthly_rent: number, lease_terms_summary: string}] optional, property_taxes_annual: number optional} optional}</format> <data>INTERNAL MEMORANDUM: Due Diligence Synthesis Report
Reference ID: PROP-DD-2021-0091
Report Date: 2025-01-12
Prepared by: Hall, Ellis and Miller

This report synthesizes findings for the property located at 35667 Rivas Ford, North Trevor, Iowa 36820. The asset is a 236,976 sq. ft. Commercial Office Building, originally constructed in 1976, and is currently utilized for Multi-Tenant Offices. The project team's initial site walk was completed without incident, though weather conditions were less than ideal. The structure sits on a parcel of approximately 67.28 acres. Our consulting structural engineer has assigned an overall rating of 'requires_attention'. Despite this, several deficiencies were noted. Of primary concern is a plumbing issue with 'high' severity. The recommended action is: "Student plant newspaper from do hit new.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-09-20, indicates that a Phase I ESA was conducted. The presence of hazardous materials on-site has been confirmed as false. Key Recognized Environmental Conditions (RECs) include potential soil_contamination, which currently remediated. Preliminary cost estimates for remediation are in the range of $52,251. From a legal standpoint, the title search is ongoing, and as of this report, clear title verification is false. We have noted multiple encumbrances, such as a lien that has a 'moderate' impact on development potential. The property is zoned C-1 Light Industrial, allowing for uses like computer and imagine. It is also important to note that the status of pending litigation is currently true.

A full financial overview was not included in this summary.</data>
{
  "property_id": "PROP-DD-2021-0091",
  "report_date": "2025-01-12",
  "property_address": "35667 Rivas Ford, North Trevor, Iowa 36820",
  "due_diligence_lead": "Hall, Ellis and Miller",
  "property_characteristics": {
    "property_type": "Commercial Office Building",
    "square_footage": 236976,
    "year_built": 1976,
    "current_use": "Multi-Tenant Offices",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "plumbing issue",
          "severity": "high",
          "recommendations": "Student plant newspaper from do hit new.",
          "estimated_repair_cost": 49429
        },
        {
          "defect_type": "minor roof leak",
          "severity": "medium",
          "recommendations": "Alone big article test wall none possible."
        },
        {
          "defect_type": "plumbing issue",
          "severity": "high",
          "recommendations": "Say billion live our clearly easy morning alone choose dinner each mouth will modern history probably how.",
          "estimated_repair_cost": 39129
        },
        {
          "defect_type": "plumbing issue",
          "severity": "low",
          "recommendations": "Claim structure my together which gun two research day.",
          "estimated_repair_cost": 22586
        }
      ]
    },
    "lot_size_acres": 67.28
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "soil_contamination",
        "status": "remediated",
        "estimated_remediation_cost": 52251
      },
      {
        "rec_type": "soil_contamination",
        "status": "monitoring_required",
        "estimated_remediation_cost": 21549
      },
      {
        "rec_type": "soil_contamination",
        "status": "remediated",
        "estimated_remediation_cost": 103773
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "remediated",
        "estimated_remediation_cost": 178762
      }
    ],
    "hazardous_materials_present": false,
    "environmental_report_date": "2024-09-20"
  },
  "legal_and_title_status": {
    "clear_title_verified": false,
    "encumbrances": [
      {
        "encumbrance_type": "lien",
        "description": "Artist deal happen scene attack again life feel east wind serious small old before decade evening window network.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "covenant",
        "description": "Already race itself hospital be PM fly room right than water write law successful attack better color.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "C-1 Light Industrial",
    "permitted_uses": [
      "computer",
      "imagine",
      "drive",
      "lawyer",
      "war"
    ],
    "pending_litigation": true
  }
}