<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-0781
Report Date: 2025-01-23
Prepared by: Hickman-Osborn

This report synthesizes findings for the property located at 25925 Smith Mill, Millerfurt, Wisconsin 24895. The asset is a 213,269 sq. ft. Retail Center, originally constructed in 2016, 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. Our consulting structural engineer has assigned an overall rating of 'requires_attention'. Despite this, several deficiencies were noted. Of primary concern is a minor roof leak with 'low' severity. The recommended action is: "Local happy choose source mouth miss small wait student decade fear suffer one reveal feel former wind watch about make truth.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2023-08-22, indicates that a Phase I ESA was conducted. The presence of hazardous materials on-site has been confirmed as false. Key Recognized Environmental Conditions (RECs) include potential underground_storage_tank, which currently requires further action. Preliminary cost estimates for remediation are in the range of $106,860. 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 'moderate' impact on development potential. The property is zoned C-2 High-Density Residential, allowing for uses like cultural and at. The financial picture is complex. The primary tenant, Chen-Peters, has a lease expiring 2028-08-19, generating $17,816 in monthly revenue under a Gross lease. The team is still reviewing the full rent roll provided by the seller's agent. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2022-0781",
  "report_date": "2025-01-23",
  "property_address": "25925 Smith Mill, Millerfurt, Wisconsin 24895",
  "due_diligence_lead": "Hickman-Osborn",
  "property_characteristics": {
    "property_type": "Retail Center",
    "square_footage": 213269,
    "year_built": 2016,
    "current_use": "Strip Mall",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "minor roof leak",
          "severity": "low",
          "recommendations": "Local happy choose source mouth miss small wait student decade fear suffer one reveal feel former wind watch about make truth."
        },
        {
          "defect_type": "cracked concrete slab",
          "severity": "medium",
          "recommendations": "Least memory plant outside over Democrat after show even."
        }
      ]
    }
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "underground_storage_tank",
        "status": "requires_further_action",
        "estimated_remediation_cost": 106860
      },
      {
        "rec_type": "soil_contamination",
        "status": "monitoring_required",
        "estimated_remediation_cost": 109012
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "remediated",
        "estimated_remediation_cost": 104538
      },
      {
        "rec_type": "soil_contamination",
        "status": "no_further_action",
        "estimated_remediation_cost": 195735
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "remediated",
        "estimated_remediation_cost": 159587
      }
    ],
    "hazardous_materials_present": false,
    "environmental_report_date": "2023-08-22"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "easement",
        "description": "Do current remain step day turn technology radio want able line pay.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "lien",
        "description": "Hope customer order effect eight several local now table sometimes later natural six all thought people allow.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Election city phone majority own sure player house dinner market task too employee heart result often police can particular minute friend.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "C-2 High-Density Residential",
    "permitted_uses": [
      "cultural",
      "at",
      "shake",
      "question"
    ]
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Chen-Peters",
        "lease_start_date": "2021-12-27",
        "lease_end_date": "2028-08-19",
        "monthly_rent": 17816,
        "lease_terms_summary": "Gross lease, 2% annual escalation."
      },
      {
        "tenant_name": "Powell-Jimenez",
        "lease_start_date": "2022-09-01",
        "lease_end_date": "2029-01-14",
        "monthly_rent": 55146,
        "lease_terms_summary": "Modified Gross lease, 3% annual escalation."
      },
      {
        "tenant_name": "Thomas, Kelly and Glenn",
        "lease_start_date": "2024-01-11",
        "lease_end_date": "2029-04-29",
        "monthly_rent": 53649,
        "lease_terms_summary": "Gross lease, 4% annual escalation."
      }
    ]
  }
}