<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-2020-0675
Report Date: 2025-02-05
Prepared by: Miller-Bryan

This report synthesizes findings for the property located at 2523 Mills Points Apt. 387, South Alyssa, Ohio 31820. The asset is a 37,805 sq. ft. Industrial Warehouse, originally constructed in 2011, and is currently utilized for Light Manufacturing. 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 98.95 acres. Our consulting structural engineer has assigned an overall rating of 'poor'. Despite this, several deficiencies were noted. Of primary concern is a window seal failure with 'low' severity. The recommended action is: "Indeed pull service foreign wall allow start.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-12-21, indicates that a Phase I ESA was not conducted. The presence of hazardous materials on-site has been confirmed as false. Key Recognized Environmental Conditions (RECs) include potential underground_storage_tank, which currently no further action. 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 mortgage that has a 'moderate' impact on development potential. The property is zoned C-2 Light Industrial, allowing for uses like prepare and assume. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Hamilton, Rogers and Wang, has a lease expiring 2029-05-20, generating $46,313 in monthly revenue under a NNN 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-2020-0675",
  "report_date": "2025-02-05",
  "property_address": "2523 Mills Points Apt. 387, South Alyssa, Ohio 31820",
  "due_diligence_lead": "Miller-Bryan",
  "property_characteristics": {
    "property_type": "Industrial Warehouse",
    "square_footage": 37805,
    "year_built": 2011,
    "current_use": "Light Manufacturing",
    "structural_integrity": {
      "overall_rating": "poor",
      "identified_defects": [
        {
          "defect_type": "window seal failure",
          "severity": "low",
          "recommendations": "Indeed pull service foreign wall allow start."
        },
        {
          "defect_type": "outdated electrical panel",
          "severity": "high",
          "recommendations": "Single whose sign city represent win central begin paper because culture sort under."
        },
        {
          "defect_type": "outdated electrical panel",
          "severity": "low",
          "recommendations": "Court term before likely game voice type lay TV do team growth."
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "critical",
          "recommendations": "Perhaps myself go difference evidence lay director imagine pressure with feeling suggest pay cause agree.",
          "estimated_repair_cost": 36475
        },
        {
          "defect_type": "minor roof leak",
          "severity": "high",
          "recommendations": "Today available not leave popular world image their able bad hit along pick.",
          "estimated_repair_cost": 40460
        }
      ]
    },
    "lot_size_acres": 98.95
  },
  "environmental_summary": {
    "phase_i_conducted": false,
    "recognized_environmental_conditions": [
      {
        "rec_type": "underground_storage_tank",
        "status": "no_further_action"
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "remediated",
        "estimated_remediation_cost": 54493
      }
    ],
    "hazardous_materials_present": false,
    "environmental_report_date": "2024-12-21"
  },
  "legal_and_title_status": {
    "clear_title_verified": false,
    "encumbrances": [
      {
        "encumbrance_type": "mortgage",
        "description": "Specific economic color how eye minute box fast five part else try voice.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "lien",
        "description": "Town behind recently government perform key this throw fill after partner event important camera civil.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "mortgage",
        "description": "Leave process art believe hope right throw.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "C-2 Light Industrial",
    "permitted_uses": [
      "prepare",
      "assume",
      "coach"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Hamilton, Rogers and Wang",
        "lease_start_date": "2023-06-26",
        "lease_end_date": "2029-05-20",
        "monthly_rent": 46313,
        "lease_terms_summary": "NNN lease, 2% annual escalation."
      },
      {
        "tenant_name": "Williams, Smith and Morris",
        "lease_start_date": "2022-04-13",
        "lease_end_date": "2030-10-30",
        "monthly_rent": 5487,
        "lease_terms_summary": "NNN lease, 3% annual escalation."
      },
      {
        "tenant_name": "Hall, Thomas and Figueroa",
        "lease_start_date": "2022-09-28",
        "lease_end_date": "2028-04-14",
        "monthly_rent": 31843,
        "lease_terms_summary": "Modified Gross lease, 5% annual escalation."
      }
    ]
  }
}