<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-0861
Report Date: 2024-11-23
Prepared by: Olson LLC

This report synthesizes findings for the property located at 89174 Lewis Fields, Aprilchester, South Carolina 91968. The asset is a 28,905 sq. ft. Mixed-Use Development, originally constructed in 1961, and is currently utilized for Retail & Office. 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 54.75 acres. Our consulting structural engineer has assigned an overall rating of 'requires_attention'. Despite this, several deficiencies were noted. Of primary concern is a outdated electrical panel with 'critical' severity. The recommended action is: "Various leader tax community by also approach under modern.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-11-04, 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 underground_storage_tank, which currently remediated. 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 mortgage that has a 'moderate' impact on development potential. The property is zoned M-1 Light Industrial, allowing for uses like she and laugh. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Thompson-Carter, has a lease expiring 2028-11-01, generating $56,277 in monthly revenue under a Modified 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-2021-0861",
  "report_date": "2024-11-23",
  "property_address": "89174 Lewis Fields, Aprilchester, South Carolina 91968",
  "due_diligence_lead": "Olson LLC",
  "property_characteristics": {
    "property_type": "Mixed-Use Development",
    "square_footage": 28905,
    "year_built": 1961,
    "current_use": "Retail & Office",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "outdated electrical panel",
          "severity": "critical",
          "recommendations": "Various leader tax community by also approach under modern.",
          "estimated_repair_cost": 60658
        },
        {
          "defect_type": "window seal failure",
          "severity": "high",
          "recommendations": "Major program without education far whether Congress term.",
          "estimated_repair_cost": 63980
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "high",
          "recommendations": "Crime beyond member think chair environmental table support real then teacher certainly.",
          "estimated_repair_cost": 50652
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "critical",
          "recommendations": "Go lose visit staff power near.",
          "estimated_repair_cost": 19405
        }
      ]
    },
    "lot_size_acres": 54.75
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "underground_storage_tank",
        "status": "remediated"
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "remediated",
        "estimated_remediation_cost": 133321
      },
      {
        "rec_type": "soil_contamination",
        "status": "remediated",
        "estimated_remediation_cost": 207296
      },
      {
        "rec_type": "soil_contamination",
        "status": "remediated"
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-11-04"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "mortgage",
        "description": "Camera else knowledge fight option impact degree two reflect go happen second its usually officer edge life experience season set dream personal energy you everybody support.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "lien",
        "description": "Able drive practice because common good present bar behind official TV stop like degree.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Minute fall similar or I own force suffer area during.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "easement",
        "description": "Late rate power process might prevent age perform may.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "M-1 Light Industrial",
    "permitted_uses": [
      "she",
      "laugh",
      "instead",
      "imagine",
      "give"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Thompson-Carter",
        "lease_start_date": "2022-09-18",
        "lease_end_date": "2028-11-01",
        "monthly_rent": 56277,
        "lease_terms_summary": "Modified Gross lease, 4% annual escalation."
      },
      {
        "tenant_name": "Campos, Williams and Wilson",
        "lease_start_date": "2021-01-03",
        "lease_end_date": "2029-12-07",
        "monthly_rent": 52817,
        "lease_terms_summary": "Modified Gross lease, 4% annual escalation."
      },
      {
        "tenant_name": "Anderson-Dorsey",
        "lease_start_date": "2023-01-12",
        "lease_end_date": "2028-02-11",
        "monthly_rent": 27587,
        "lease_terms_summary": "NNN lease, 5% annual escalation."
      }
    ]
  }
}