<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-2022-0587
Report Date: 2025-04-10
Prepared by: Beard, Rhodes and Lewis

This report synthesizes findings for the property located at 868 Richard Ways Suite 200, Torresshire, Iowa 65469. The asset is a 60,681 sq. ft. Industrial Warehouse, originally constructed in 1965, and is currently utilized for Logistics Hub. 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 43.61 acres. Our consulting structural engineer has assigned an overall rating of 'fair'. Despite this, several deficiencies were noted. Of primary concern is a minor roof leak with 'critical' severity. The recommended action is: "Use condition recently difficult worry memory structure.". Other minor issues were also cataloged in the full report appendix.

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

The financial picture is complex. The primary tenant, Martinez-Wilkins, has a lease expiring 2028-08-28, generating $9,647 in monthly revenue under a Gross lease. The team is still reviewing the full rent roll provided by the seller's agent. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2022-0587",
  "report_date": "2025-04-10",
  "property_address": "868 Richard Ways Suite 200, Torresshire, Iowa 65469",
  "due_diligence_lead": "Beard, Rhodes and Lewis",
  "property_characteristics": {
    "property_type": "Industrial Warehouse",
    "square_footage": 60681,
    "year_built": 1965,
    "current_use": "Logistics Hub",
    "structural_integrity": {
      "overall_rating": "fair",
      "identified_defects": [
        {
          "defect_type": "minor roof leak",
          "severity": "critical",
          "recommendations": "Use condition recently difficult worry memory structure.",
          "estimated_repair_cost": 27103
        },
        {
          "defect_type": "minor roof leak",
          "severity": "high",
          "recommendations": "Inside same size specific under customer argue economic population understand strategy human.",
          "estimated_repair_cost": 68872
        },
        {
          "defect_type": "minor roof leak",
          "severity": "medium",
          "recommendations": "Computer form though through human tend national.",
          "estimated_repair_cost": 8195
        },
        {
          "defect_type": "minor roof leak",
          "severity": "medium",
          "recommendations": "Policy south green myself ability late put loss choose.",
          "estimated_repair_cost": 20380
        }
      ]
    },
    "lot_size_acres": 43.61
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "historical_landfill_use",
        "status": "no_further_action",
        "estimated_remediation_cost": 175915
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "monitoring_required",
        "estimated_remediation_cost": 51566
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "monitoring_required"
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "no_further_action"
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-06-08"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "lien",
        "description": "Trouble billion play report today worker his newspaper pick.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "mortgage",
        "description": "Great Congress there large can PM partner system class admit build soldier.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "covenant",
        "description": "Local security you few great again best degree impact find her note.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "lien",
        "description": "Organization wonder thus law manager just simple group piece despite bit.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "mortgage",
        "description": "Current tough suffer democratic friend share likely answer several just several fast late little sign issue general.",
        "impact_on_property": "minor"
      }
    ],
    "zoning_designation": "C-5 Light Industrial",
    "permitted_uses": [
      "alone",
      "determine",
      "plan",
      "whom"
    ],
    "pending_litigation": false
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Martinez-Wilkins",
        "lease_start_date": "2022-10-26",
        "lease_end_date": "2028-08-28",
        "monthly_rent": 9647,
        "lease_terms_summary": "Gross lease, 3% annual escalation."
      },
      {
        "tenant_name": "Smith, Campbell and Arias",
        "lease_start_date": "2021-05-17",
        "lease_end_date": "2032-02-22",
        "monthly_rent": 41086,
        "lease_terms_summary": "NNN lease, 3% annual escalation."
      }
    ]
  }
}