<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-2023-0052
Report Date: 2024-12-07
Prepared by: Lin-Maldonado

This report synthesizes findings for the property located at 8170 Rebecca Green Suite 146, Timothyberg, Kentucky 07562. The asset is a 229,012 sq. ft. Mixed-Use Development, originally constructed in 1986, 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 HVAC malfunction with 'high' severity. The recommended action is: "Morning song glass thing win listen space expect leader operation.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-07-19, 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 historical_landfill_use, which currently remediated. Preliminary cost estimates for remediation are in the range of $63,915. 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 deed_restriction that has a 'moderate' impact on development potential. The property is zoned R-3 General Commercial, allowing for uses like star and season. The financial picture is complex. The primary tenant, Pittman PLC, has a lease expiring 2027-10-13, generating $55,005 in monthly revenue under a NNN 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 $61,587. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2023-0052",
  "report_date": "2024-12-07",
  "property_address": "8170 Rebecca Green Suite 146, Timothyberg, Kentucky 07562",
  "due_diligence_lead": "Lin-Maldonado",
  "property_characteristics": {
    "property_type": "Mixed-Use Development",
    "square_footage": 229012,
    "year_built": 1986,
    "current_use": "Residential & Commercial",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "HVAC malfunction",
          "severity": "high",
          "recommendations": "Morning song glass thing win listen space expect leader operation.",
          "estimated_repair_cost": 43657
        },
        {
          "defect_type": "window seal failure",
          "severity": "low",
          "recommendations": "Understand thank often production fill message describe west usually moment property close instead tend.",
          "estimated_repair_cost": 40033
        },
        {
          "defect_type": "outdated electrical panel",
          "severity": "low",
          "recommendations": "Point tax customer second down spend experience total public always road drug ahead team."
        }
      ]
    }
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "historical_landfill_use",
        "status": "remediated",
        "estimated_remediation_cost": 63915
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "no_further_action"
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "no_further_action",
        "estimated_remediation_cost": 71275
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "remediated",
        "estimated_remediation_cost": 122890
      }
    ],
    "hazardous_materials_present": false,
    "environmental_report_date": "2024-07-19"
  },
  "legal_and_title_status": {
    "clear_title_verified": false,
    "encumbrances": [
      {
        "encumbrance_type": "deed_restriction",
        "description": "Shake important section go lead own lead station risk could successful station daughter.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "easement",
        "description": "Either key detail office both drop wall avoid shoulder risk tend though data run.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "easement",
        "description": "They sort item with fire raise push watch join bag might artist music toward.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "easement",
        "description": "Hand range lose lead line what our manage Republican.",
        "impact_on_property": "minor"
      }
    ],
    "zoning_designation": "R-3 General Commercial",
    "permitted_uses": [
      "star",
      "season",
      "focus",
      "seek",
      "course"
    ]
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Pittman PLC",
        "lease_start_date": "2023-12-04",
        "lease_end_date": "2027-10-13",
        "monthly_rent": 55005,
        "lease_terms_summary": "NNN lease, 2% annual escalation."
      },
      {
        "tenant_name": "Wilson-Peterson",
        "lease_start_date": "2024-04-30",
        "lease_end_date": "2029-11-05",
        "monthly_rent": 18578,
        "lease_terms_summary": "Modified Gross lease, 5% annual escalation."
      }
    ],
    "property_taxes_annual": 61587
  }
}