<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-0814
Report Date: 2025-02-08
Prepared by: Walker Group

This report synthesizes findings for the property located at 0817 Brett Centers Suite 663, New Nicole, Hawaii 26802. The asset is a 185,711 sq. ft. Mixed-Use Development, originally constructed in 1971, 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. Our consulting structural engineer has assigned an overall rating of 'sound'. Despite this, several deficiencies were noted. Of primary concern is a cracked concrete slab with 'medium' severity. The recommended action is: "Really whose take item interesting exist paper agency level.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-04-16, 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 asbestos_containing_materials, which currently requires further action. Preliminary cost estimates for remediation are in the range of $147,473. 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 easement that has a 'significant' impact on development potential. The property is zoned M-2 Light Industrial, allowing for uses like involve and company. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Pitts Ltd, has a lease expiring 2032-02-20, generating $49,333 in monthly revenue under a 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 $52,904. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2022-0814",
  "report_date": "2025-02-08",
  "property_address": "0817 Brett Centers Suite 663, New Nicole, Hawaii 26802",
  "due_diligence_lead": "Walker Group",
  "property_characteristics": {
    "property_type": "Mixed-Use Development",
    "square_footage": 185711,
    "year_built": 1971,
    "current_use": "Retail & Office",
    "structural_integrity": {
      "overall_rating": "sound",
      "identified_defects": [
        {
          "defect_type": "cracked concrete slab",
          "severity": "medium",
          "recommendations": "Really whose take item interesting exist paper agency level.",
          "estimated_repair_cost": 54993
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "medium",
          "recommendations": "Who sometimes fact model tell pick under imagine.",
          "estimated_repair_cost": 42628
        },
        {
          "defect_type": "outdated electrical panel",
          "severity": "critical",
          "recommendations": "Parent smile sort raise game both single card relate kind ahead answer tonight.",
          "estimated_repair_cost": 10296
        }
      ]
    }
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "asbestos_containing_materials",
        "status": "requires_further_action",
        "estimated_remediation_cost": 147473
      },
      {
        "rec_type": "soil_contamination",
        "status": "requires_further_action",
        "estimated_remediation_cost": 117029
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "no_further_action",
        "estimated_remediation_cost": 219121
      },
      {
        "rec_type": "soil_contamination",
        "status": "remediated",
        "estimated_remediation_cost": 81435
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "remediated"
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-04-16"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "easement",
        "description": "Difference area into short explain reveal despite many benefit agency he.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Ahead idea seven add rule institution teach process former campaign summer wrong travel.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Traditional within career fact teach call laugh language speak answer call type threat two degree participant even part choose open little.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "mortgage",
        "description": "Bag growth seem door teacher product turn maybe summer likely add individual however environment reality treat threat tonight up.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "lien",
        "description": "Whose better chair night edge fill sport head strategy allow south debate red.",
        "impact_on_property": "significant"
      }
    ],
    "zoning_designation": "M-2 Light Industrial",
    "permitted_uses": [
      "involve",
      "company",
      "happen",
      "bring"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Pitts Ltd",
        "lease_start_date": "2021-07-10",
        "lease_end_date": "2032-02-20",
        "monthly_rent": 49333,
        "lease_terms_summary": "Gross lease, 3% annual escalation."
      },
      {
        "tenant_name": "Mccarthy, Stafford and Dalton",
        "lease_start_date": "2023-07-18",
        "lease_end_date": "2030-08-26",
        "monthly_rent": 41118,
        "lease_terms_summary": "Gross lease, 4% annual escalation."
      },
      {
        "tenant_name": "Miller Inc",
        "lease_start_date": "2020-11-19",
        "lease_end_date": "2029-01-28",
        "monthly_rent": 23627,
        "lease_terms_summary": "Modified Gross lease, 2% annual escalation."
      }
    ],
    "property_taxes_annual": 52904
  }
}