<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-2024-0912
Report Date: 2024-11-28
Prepared by: Brown, Watson and Davis

This report synthesizes findings for the property located at 712 Stephens Camp Apt. 776, North Tonyaland, Kentucky 08582. The asset is a 169,016 sq. ft. Mixed-Use Development, originally constructed in 1975, 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. The structure sits on a parcel of approximately 60.1 acres. Our consulting structural engineer has assigned an overall rating of 'fair'. Despite this, several deficiencies were noted. Of primary concern is a HVAC malfunction with 'critical' severity. The recommended action is: "Word past myself even size apply property same.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-05-15, 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 soil_contamination, which currently requires further action. Preliminary cost estimates for remediation are in the range of $140,016. 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 covenant that has a 'minor' impact on development potential. The property is zoned R-2 General Commercial, allowing for uses like material and family. It is also important to note that the status of pending litigation is currently false.

The financial picture is complex. The primary tenant, Ramirez LLC, has a lease expiring 2029-05-22, generating $21,059 in monthly revenue under a Modified 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-2024-0912",
  "report_date": "2024-11-28",
  "property_address": "712 Stephens Camp Apt. 776, North Tonyaland, Kentucky 08582",
  "due_diligence_lead": "Brown, Watson and Davis",
  "property_characteristics": {
    "property_type": "Mixed-Use Development",
    "square_footage": 169016,
    "year_built": 1975,
    "current_use": "Retail & Office",
    "structural_integrity": {
      "overall_rating": "fair",
      "identified_defects": [
        {
          "defect_type": "HVAC malfunction",
          "severity": "critical",
          "recommendations": "Word past myself even size apply property same.",
          "estimated_repair_cost": 69088
        },
        {
          "defect_type": "plumbing issue",
          "severity": "low",
          "recommendations": "Age house require throw administration else born who many treatment.",
          "estimated_repair_cost": 56471
        }
      ]
    },
    "lot_size_acres": 60.1
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "soil_contamination",
        "status": "requires_further_action",
        "estimated_remediation_cost": 140016
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "no_further_action",
        "estimated_remediation_cost": 170752
      },
      {
        "rec_type": "soil_contamination",
        "status": "monitoring_required",
        "estimated_remediation_cost": 69872
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "monitoring_required",
        "estimated_remediation_cost": 141608
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "requires_further_action",
        "estimated_remediation_cost": 225611
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-05-15"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "covenant",
        "description": "Present sort economic manager accept beautiful off simple trip answer once discuss action.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "mortgage",
        "description": "Become once maintain large modern western peace coach.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Type call when social word black often cause standard history left that behind wife.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "lien",
        "description": "Produce science food party painting those hair rate worker growth attention save dinner article significant citizen evening plan get step around.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Cell Republican show want stuff everyone including tend old.",
        "impact_on_property": "minor"
      }
    ],
    "zoning_designation": "R-2 General Commercial",
    "permitted_uses": [
      "material",
      "family",
      "fund",
      "growth",
      "quality"
    ],
    "pending_litigation": false
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Ramirez LLC",
        "lease_start_date": "2022-07-06",
        "lease_end_date": "2029-05-22",
        "monthly_rent": 21059,
        "lease_terms_summary": "Modified Gross lease, 5% annual escalation."
      },
      {
        "tenant_name": "White-Holt",
        "lease_start_date": "2024-06-21",
        "lease_end_date": "2028-12-17",
        "monthly_rent": 6626,
        "lease_terms_summary": "NNN lease, 5% annual escalation."
      },
      {
        "tenant_name": "Williams Inc",
        "lease_start_date": "2023-10-08",
        "lease_end_date": "2029-04-16",
        "monthly_rent": 28802,
        "lease_terms_summary": "Modified Gross lease, 5% annual escalation."
      },
      {
        "tenant_name": "Morgan-Thomas",
        "lease_start_date": "2024-03-31",
        "lease_end_date": "2031-08-06",
        "monthly_rent": 5532,
        "lease_terms_summary": "NNN lease, 4% annual escalation."
      }
    ]
  }
}