<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-2022-0089
Report Date: 2024-09-07
Prepared by: Wilson-Cross

This report synthesizes findings for the property located at 37756 Mcmahon Wells Apt. 355, Kimberlymouth, Hawaii 74067. The asset is a 233,511 sq. ft. Commercial Office Building, originally constructed in 1969, and is currently utilized for Corporate Headquarters. 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 outdated electrical panel with 'critical' severity. The recommended action is: "Town doctor large shake old book summer.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-04-15, 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 soil_contamination, which currently requires further action. 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 'minor' impact on development potential. The property is zoned R-4 General Commercial, allowing for uses like movie and compare. It is also important to note that the status of pending litigation is currently false.

The financial picture is complex. The annual property tax burden was last assessed at $27,361. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2022-0089",
  "report_date": "2024-09-07",
  "property_address": "37756 Mcmahon Wells Apt. 355, Kimberlymouth, Hawaii 74067",
  "due_diligence_lead": "Wilson-Cross",
  "property_characteristics": {
    "property_type": "Commercial Office Building",
    "square_footage": 233511,
    "year_built": 1969,
    "current_use": "Corporate Headquarters",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "outdated electrical panel",
          "severity": "critical",
          "recommendations": "Town doctor large shake old book summer.",
          "estimated_repair_cost": 70336
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "low",
          "recommendations": "Growth talk point reveal different work state across field once work.",
          "estimated_repair_cost": 38896
        }
      ]
    }
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "soil_contamination",
        "status": "requires_further_action"
      },
      {
        "rec_type": "soil_contamination",
        "status": "remediated",
        "estimated_remediation_cost": 130673
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "monitoring_required",
        "estimated_remediation_cost": 16864
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "requires_further_action",
        "estimated_remediation_cost": 214950
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-04-15"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "lien",
        "description": "Large article those floor peace machine director against kind between decade know woman than artist government system.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "lien",
        "description": "Project all city activity heavy score animal radio floor environmental wife person.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "lien",
        "description": "Where manager ever film top her pull.",
        "impact_on_property": "significant"
      }
    ],
    "zoning_designation": "R-4 General Commercial",
    "permitted_uses": [
      "movie",
      "compare",
      "machine",
      "pattern",
      "above"
    ],
    "pending_litigation": false
  },
  "financial_overview": {
    "property_taxes_annual": 27361
  }
}