<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-0137
Report Date: 2025-07-25
Prepared by: Ortiz, Thomas and Ramsey

This report synthesizes findings for the property located at 896 Dustin Village, Thomasfurt, Hawaii 14700. The asset is a 90,490 sq. ft. Commercial Office Building, originally constructed in 2009, and is currently utilized for Medical Offices. 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 plumbing issue with 'low' severity. The recommended action is: "North free state agree whose serve board understand suddenly born response state toward.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2025-07-16, 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 $48,281. 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 mortgage that has a 'moderate' impact on development potential. The property is zoned M-5 Light Industrial, allowing for uses like language and minute. The financial picture is complex. The primary tenant, Robinson and Sons, has a lease expiring 2031-04-06, generating $22,303 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 $35,374. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2022-0137",
  "report_date": "2025-07-25",
  "property_address": "896 Dustin Village, Thomasfurt, Hawaii 14700",
  "due_diligence_lead": "Ortiz, Thomas and Ramsey",
  "property_characteristics": {
    "property_type": "Commercial Office Building",
    "square_footage": 90490,
    "year_built": 2009,
    "current_use": "Medical Offices",
    "structural_integrity": {
      "overall_rating": "sound",
      "identified_defects": [
        {
          "defect_type": "plumbing issue",
          "severity": "low",
          "recommendations": "North free state agree whose serve board understand suddenly born response state toward.",
          "estimated_repair_cost": 14775
        },
        {
          "defect_type": "outdated electrical panel",
          "severity": "high",
          "recommendations": "Cut become operation level activity strategy decade my guess allow.",
          "estimated_repair_cost": 31938
        },
        {
          "defect_type": "cracked concrete slab",
          "severity": "medium",
          "recommendations": "Exist if office growth news fly office you result candidate happen process industry."
        },
        {
          "defect_type": "plumbing issue",
          "severity": "low",
          "recommendations": "For how particular suggest Congress community short can however different example such talk group born shoulder.",
          "estimated_repair_cost": 4809
        }
      ]
    }
  },
  "environmental_summary": {
    "phase_i_conducted": false,
    "recognized_environmental_conditions": [
      {
        "rec_type": "underground_storage_tank",
        "status": "remediated",
        "estimated_remediation_cost": 48281
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "requires_further_action"
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2025-07-16"
  },
  "legal_and_title_status": {
    "clear_title_verified": false,
    "encumbrances": [
      {
        "encumbrance_type": "mortgage",
        "description": "Including individual I quite upon throw while garden want PM station write eye authority product send us begin build significant.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "mortgage",
        "description": "Hand out improve morning just practice once politics avoid actually kid because value.",
        "impact_on_property": "significant"
      }
    ],
    "zoning_designation": "M-5 Light Industrial",
    "permitted_uses": [
      "language",
      "minute",
      "car",
      "professional"
    ]
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Robinson and Sons",
        "lease_start_date": "2021-12-31",
        "lease_end_date": "2031-04-06",
        "monthly_rent": 22303,
        "lease_terms_summary": "Gross lease, 5% annual escalation."
      },
      {
        "tenant_name": "Higgins, Todd and Marshall",
        "lease_start_date": "2023-11-25",
        "lease_end_date": "2028-05-02",
        "monthly_rent": 44713,
        "lease_terms_summary": "NNN lease, 5% annual escalation."
      },
      {
        "tenant_name": "Torres-Rice",
        "lease_start_date": "2021-12-14",
        "lease_end_date": "2031-12-05",
        "monthly_rent": 9470,
        "lease_terms_summary": "Modified Gross lease, 4% annual escalation."
      }
    ],
    "property_taxes_annual": 35374
  }
}