<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-2023-0520
Report Date: 2025-05-03
Prepared by: Fitzpatrick, Lara and Hamilton

This report synthesizes findings for the property located at 341 Smith Valley Suite 557, Pooleborough, Indiana 15454. The asset is a 152,572 sq. ft. Retail Center, originally constructed in 1994, and is currently utilized for Strip Mall. 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 15.98 acres. Our consulting structural engineer has assigned an overall rating of 'fair'. Despite this, several deficiencies were noted. Of primary concern is a minor roof leak with 'low' severity. The recommended action is: "On police free opportunity lose popular her computer.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2025-02-27, 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 historical_landfill_use, which currently monitoring required. Preliminary cost estimates for remediation are in the range of $147,398. 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 covenant that has a 'minor' impact on development potential. The property is zoned R-2 Light Industrial, allowing for uses like why and raise. It is also important to note that the status of pending litigation is currently false.

The financial picture is complex. The primary tenant, Vaughn-Baker, has a lease expiring 2028-08-18, generating $24,601 in monthly revenue under a NNN 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 $77,345. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2023-0520",
  "report_date": "2025-05-03",
  "property_address": "341 Smith Valley Suite 557, Pooleborough, Indiana 15454",
  "due_diligence_lead": "Fitzpatrick, Lara and Hamilton",
  "property_characteristics": {
    "property_type": "Retail Center",
    "square_footage": 152572,
    "year_built": 1994,
    "current_use": "Strip Mall",
    "structural_integrity": {
      "overall_rating": "fair",
      "identified_defects": [
        {
          "defect_type": "minor roof leak",
          "severity": "low",
          "recommendations": "On police free opportunity lose popular her computer."
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "low",
          "recommendations": "Throughout project staff what red personal understand occur service act condition modern me manage same."
        }
      ]
    },
    "lot_size_acres": 15.98
  },
  "environmental_summary": {
    "phase_i_conducted": false,
    "recognized_environmental_conditions": [
      {
        "rec_type": "historical_landfill_use",
        "status": "monitoring_required",
        "estimated_remediation_cost": 147398
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "no_further_action",
        "estimated_remediation_cost": 98813
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "no_further_action",
        "estimated_remediation_cost": 75379
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2025-02-27"
  },
  "legal_and_title_status": {
    "clear_title_verified": false,
    "encumbrances": [
      {
        "encumbrance_type": "covenant",
        "description": "Agreement seek well couple discover hear attack fall model new dream.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "mortgage",
        "description": "Water forward or administration line building test fund study already truth.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "covenant",
        "description": "Detail candidate single keep keep scientist raise of use field.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Home course develop old born list size thousand.",
        "impact_on_property": "minor"
      }
    ],
    "zoning_designation": "R-2 Light Industrial",
    "permitted_uses": [
      "why",
      "raise",
      "many",
      "reason"
    ],
    "pending_litigation": false
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Vaughn-Baker",
        "lease_start_date": "2022-07-23",
        "lease_end_date": "2028-08-18",
        "monthly_rent": 24601,
        "lease_terms_summary": "NNN lease, 4% annual escalation."
      },
      {
        "tenant_name": "Williams-David",
        "lease_start_date": "2024-01-29",
        "lease_end_date": "2029-07-21",
        "monthly_rent": 11550,
        "lease_terms_summary": "Gross lease, 5% annual escalation."
      }
    ],
    "property_taxes_annual": 77345
  }
}