<format type="json">{ "property_identifier": "string", "due_diligence_summary_date": "date", "analyst_firm": "string optional", "overall_risk_assessment": "string", "environmental_findings": { "phase1_status": "string", "recognized_environmental_conditions": "list[{rec_type: string, description: string, severity: string, remediation_required: boolean, estimated_cost: number optional}]", "wetlands_impact": "boolean", "hazardous_materials_on_site": "list[string] optional" }, "structural_integrity": { "assessment_date": "date", "overall_condition_rating": "string", "major_structural_issues": "list[{issue_type: string, location: string, repair_recommendation: string, estimated_repair_cost: number optional}]", "ada_compliance_notes": "string optional" }, "lease_analysis_summary": { "total_occupied_sqft": "number", "weighted_average_lease_term_years": "number", "major_tenants": "list[{tenant_name: string, lease_start_date: date, lease_end_date: date, annual_rent: number, rent_escalation_mechanism: string, renewal_options: number, option_term_years: number optional}]", "vacancy_rate_percentage": "number", "tenant_defaults_identified": "boolean" }, "title_and_legal": { "clear_title_confirmed": "boolean", "major_encumbrances": "list[{encumbrance_type: string, description: string, parties_involved: string optional}] optional", "pending_litigation_related_to_property": "boolean", "zoning_classification": "string", "zoning_compliance_confirmed": "boolean" } }</format> <data>**CONFIDENTIAL DUE DILIGENCE MEMORANDUM**

**DATE:** 2025-08-14
**SUBJECT PROPERTY:** 147 Caldwell Drive Apt. 272, Caseyberg, Indiana 00591
**PREPARED BY:** Johnson, Stanley and Sullivan

This report summarizes key findings from the due diligence conducted for the subject property. Our analysis, completed on 2025-08-14, indicates an overall risk profile assessed as **low-to-moderate** for a potential acquisition. The lead analyst, Roy White, noted the complexity of the file.

**Environmental Review:** The Phase I Environmental Site Assessment (ESA) is noted as **completed**. Several Recognized Environmental Conditions (RECs) were identified. Key among these are a significant issue of asbestos_containing_materials, a significant issue of groundwater_impact, a significant issue of soil_contamination, a moderate issue of soil_contamination with potential remediation costs of $5397. The assessment found no evidence of direct wetlands impact. Standard storage of materials like nice, power was observed. 

**Structural and Physical Condition:** A Property Condition Assessment was performed on 2025-08-14, rating the property's overall condition as **'poor'**. The engineer's report highlighted several capital-intensive repairs. Specifically, roof_system_degradation in the North wing, upper level requires attention with an estimated repair cost of $122,680. Specifically, facade_water_intrusion in the North wing, upper level requires attention with an estimated repair cost of $42,481. Specifically, foundation_settlement in the North wing, upper level requires attention with an estimated repair cost of $181,534. Furthermore, Language page wonder hot argue. The inspection was briefly delayed due to a minor scheduling conflict with a vendor.

**Lease and Tenancy Analysis:** The property's financial stability appears robust, with tenants occupying 48,369 sqft of a total 62,403 sqft, implying a vacancy of 22.49%. The rent roll is anchored by major tenants such as Blake, Gonzales and Haynes and Hunt, Allen and Padilla. The weighted average lease term (WALT) is approximately 7.4 years, providing stable near-term cash flow. Rent escalation for key tenants is a mix of mechanisms, including fixed_annual_3_percent. Our review found no evidence of current tenant defaults.

**Title and Legal Matters:** The preliminary title report review indicates that clear title is **confirmed**. The property is zoned I-1 (Optional demand-driven installation), and its current use is deemed non-compliant with local ordinances. We are not aware of any pending litigation concerning the property at this time. </data>
{
  "property_identifier": "147 Caldwell Drive Apt. 272, Caseyberg, Indiana 00591",
  "due_diligence_summary_date": "2025-08-14",
  "overall_risk_assessment": "low-to-moderate",
  "environmental_findings": {
    "phase1_status": "completed",
    "recognized_environmental_conditions": [
      {
        "rec_type": "asbestos_containing_materials",
        "description": "Society power enjoy culture forward I.",
        "severity": "significant",
        "remediation_required": false
      },
      {
        "rec_type": "groundwater_impact",
        "description": "Form society mouth indicate stage speak north peace star catch better glass best.",
        "severity": "significant",
        "remediation_required": false
      },
      {
        "rec_type": "soil_contamination",
        "description": "Very yard development modern church moment billion require increase future next kid.",
        "severity": "significant",
        "remediation_required": false
      },
      {
        "rec_type": "soil_contamination",
        "description": "Reflect next role and often government line health.",
        "severity": "moderate",
        "remediation_required": true,
        "estimated_cost": 5397
      }
    ],
    "wetlands_impact": false,
    "hazardous_materials_on_site": [
      "nice",
      "power"
    ]
  },
  "structural_integrity": {
    "assessment_date": "2025-08-14",
    "overall_condition_rating": "poor",
    "major_structural_issues": [
      {
        "issue_type": "roof_system_degradation",
        "location": "North wing, upper level",
        "repair_recommendation": "Western second necessary while again despite.",
        "estimated_repair_cost": 122680
      },
      {
        "issue_type": "facade_water_intrusion",
        "location": "North wing, upper level",
        "repair_recommendation": "Onto development population wait peace result.",
        "estimated_repair_cost": 42481
      },
      {
        "issue_type": "foundation_settlement",
        "location": "North wing, upper level",
        "repair_recommendation": "Above watch position. Build born everyone seek move customer pressure hit.",
        "estimated_repair_cost": 181534
      }
    ],
    "ada_compliance_notes": "Language page wonder hot argue."
  },
  "lease_analysis_summary": {
    "total_occupied_sqft": 48369,
    "weighted_average_lease_term_years": 7.4,
    "major_tenants": [
      {
        "tenant_name": "Blake, Gonzales and Haynes",
        "lease_start_date": "2021-09-06",
        "lease_end_date": "2026-09-28",
        "annual_rent": 418268,
        "rent_escalation_mechanism": "fixed_annual_3_percent",
        "renewal_options": 0
      },
      {
        "tenant_name": "Hunt, Allen and Padilla",
        "lease_start_date": "2022-01-05",
        "lease_end_date": "2031-12-09",
        "annual_rent": 211395,
        "rent_escalation_mechanism": "negotiated_increase",
        "renewal_options": 3,
        "option_term_years": 3
      }
    ],
    "vacancy_rate_percentage": 22.49,
    "tenant_defaults_identified": false
  },
  "title_and_legal": {
    "clear_title_confirmed": true,
    "pending_litigation_related_to_property": true,
    "zoning_classification": "I-1 (Optional demand-driven installation)",
    "zoning_compliance_confirmed": false
  },
  "analyst_firm": "Johnson, Stanley and Sullivan"
}