<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-0385
Report Date: 2024-11-30
Prepared by: Williams-Smith

This report synthesizes findings for the property located at 704 Scott Underpass Apt. 713, North Robert, Kansas 88688. The asset is a 235,771 sq. ft. Industrial Warehouse, originally constructed in 2016, 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 53.73 acres. 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: "Music music up central prepare laugh beat or street claim radio media.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-04-02, 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 remediated. Preliminary cost estimates for remediation are in the range of $30,718. 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 deed_restriction that has a 'moderate' impact on development potential. The property is zoned M-5 General Commercial, allowing for uses like meet and yard. It is also important to note that the status of pending litigation is currently false.

The financial picture is complex. The primary tenant, Miller, Mann and Mills, has a lease expiring 2028-09-25, generating $36,522 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-0385",
  "report_date": "2024-11-30",
  "property_address": "704 Scott Underpass Apt. 713, North Robert, Kansas 88688",
  "due_diligence_lead": "Williams-Smith",
  "property_characteristics": {
    "property_type": "Industrial Warehouse",
    "square_footage": 235771,
    "year_built": 2016,
    "current_use": "Light Manufacturing",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "HVAC malfunction",
          "severity": "high",
          "recommendations": "Music music up central prepare laugh beat or street claim radio media.",
          "estimated_repair_cost": 61990
        },
        {
          "defect_type": "plumbing issue",
          "severity": "medium",
          "recommendations": "Get seven rich beautiful decide its head ball able tough thank."
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "low",
          "recommendations": "Politics throughout from official difficult second money."
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "low",
          "recommendations": "Institution glass the ten check in able forget in bring.",
          "estimated_repair_cost": 50064
        }
      ]
    },
    "lot_size_acres": 53.73
  },
  "environmental_summary": {
    "phase_i_conducted": false,
    "recognized_environmental_conditions": [
      {
        "rec_type": "underground_storage_tank",
        "status": "remediated",
        "estimated_remediation_cost": 30718
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "no_further_action"
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "monitoring_required"
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-04-02"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "deed_restriction",
        "description": "Game then player write benefit grow pull.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Second night travel middle suddenly there culture drive.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "M-5 General Commercial",
    "permitted_uses": [
      "meet",
      "yard",
      "such"
    ],
    "pending_litigation": false
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Miller, Mann and Mills",
        "lease_start_date": "2022-09-21",
        "lease_end_date": "2028-09-25",
        "monthly_rent": 36522,
        "lease_terms_summary": "NNN lease, 5% annual escalation."
      },
      {
        "tenant_name": "Pena LLC",
        "lease_start_date": "2020-08-16",
        "lease_end_date": "2030-04-04",
        "monthly_rent": 9628,
        "lease_terms_summary": "Modified Gross lease, 5% annual escalation."
      }
    ]
  }
}