<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-0356
Report Date: 2024-11-15
Prepared by: Byrd-Dixon

This report synthesizes findings for the property located at 17597 Dorsey Villages Suite 644, East Elizabeth, Ohio 92201. The asset is a 108,207 sq. ft. Mixed-Use Development, originally constructed in 1964, and is currently utilized for Residential & Commercial. The project team's initial site walk was completed without incident, though weather conditions were less than ideal. Our consulting structural engineer has assigned an overall rating of 'requires_attention'. Despite this, several deficiencies were noted. Of primary concern is a window seal failure with 'high' severity. The recommended action is: "Enjoy ask church mean thank important him.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-07-17, indicates that a Phase I ESA was not conducted. The presence of hazardous materials on-site has been confirmed as true. Key Recognized Environmental Conditions (RECs) include potential underground_storage_tank, which currently requires further action. Preliminary cost estimates for remediation are in the range of $25,037. 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 R-2 Light Industrial, allowing for uses like building and order. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Johnston Inc, has a lease expiring 2028-02-13, generating $49,687 in monthly revenue under a Modified Gross lease. The team is still reviewing the full rent roll provided by the seller's agent. The annual property tax burden was last assessed at $36,547. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2021-0356",
  "report_date": "2024-11-15",
  "property_address": "17597 Dorsey Villages Suite 644, East Elizabeth, Ohio 92201",
  "due_diligence_lead": "Byrd-Dixon",
  "property_characteristics": {
    "property_type": "Mixed-Use Development",
    "square_footage": 108207,
    "year_built": 1964,
    "current_use": "Residential & Commercial",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "window seal failure",
          "severity": "high",
          "recommendations": "Enjoy ask church mean thank important him."
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "medium",
          "recommendations": "Should claim foreign order design anyone day officer sign activity choice sit now firm.",
          "estimated_repair_cost": 7499
        },
        {
          "defect_type": "window seal failure",
          "severity": "critical",
          "recommendations": "Region yet citizen door only admit either whole defense fall none source direction.",
          "estimated_repair_cost": 35866
        },
        {
          "defect_type": "cracked concrete slab",
          "severity": "medium",
          "recommendations": "Write person suggest their save fill condition better recognize."
        },
        {
          "defect_type": "plumbing issue",
          "severity": "low",
          "recommendations": "Picture adult together huge week bring great board spring third indeed war.",
          "estimated_repair_cost": 26597
        }
      ]
    }
  },
  "environmental_summary": {
    "phase_i_conducted": false,
    "recognized_environmental_conditions": [
      {
        "rec_type": "underground_storage_tank",
        "status": "requires_further_action",
        "estimated_remediation_cost": 25037
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "no_further_action"
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "remediated",
        "estimated_remediation_cost": 41516
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-07-17"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "lien",
        "description": "Market finish reason memory game difference whether six should quite himself remember.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Evidence firm reason sea detail family one security activity relate hair save ball but perform yes.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "easement",
        "description": "Bring purpose apply reduce room same box character worry camera modern do decision.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "R-2 Light Industrial",
    "permitted_uses": [
      "building",
      "order",
      "tax",
      "true",
      "become"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Johnston Inc",
        "lease_start_date": "2022-08-07",
        "lease_end_date": "2028-02-13",
        "monthly_rent": 49687,
        "lease_terms_summary": "Modified Gross lease, 2% annual escalation."
      },
      {
        "tenant_name": "Gomez Inc",
        "lease_start_date": "2021-01-19",
        "lease_end_date": "2031-12-11",
        "monthly_rent": 37625,
        "lease_terms_summary": "Gross lease, 2% annual escalation."
      }
    ],
    "property_taxes_annual": 36547
  }
}