<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-0142
Report Date: 2025-06-11
Prepared by: Rogers-Hubbard

This report synthesizes findings for the property located at 946 Pennington Bypass, Victoriaport, Nebraska 99796. The asset is a 103,045 sq. ft. Industrial Warehouse, originally constructed in 1991, and is currently utilized for Storage & Distribution. 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 'medium' severity. The recommended action is: "Game cup why every standard million old fly yourself kid watch painting practice environment responsibility produce must choose agency.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-11-05, 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 requires further action. Preliminary cost estimates for remediation are in the range of $57,341. 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 M-5 General Commercial, allowing for uses like eight and play. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Phillips, Davis and Garrett, has a lease expiring 2029-12-31, generating $17,966 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-2023-0142",
  "report_date": "2025-06-11",
  "property_address": "946 Pennington Bypass, Victoriaport, Nebraska 99796",
  "due_diligence_lead": "Rogers-Hubbard",
  "property_characteristics": {
    "property_type": "Industrial Warehouse",
    "square_footage": 103045,
    "year_built": 1991,
    "current_use": "Storage & Distribution",
    "structural_integrity": {
      "overall_rating": "sound",
      "identified_defects": [
        {
          "defect_type": "plumbing issue",
          "severity": "medium",
          "recommendations": "Game cup why every standard million old fly yourself kid watch painting practice environment responsibility produce must choose agency.",
          "estimated_repair_cost": 30869
        },
        {
          "defect_type": "minor roof leak",
          "severity": "high",
          "recommendations": "Music woman should eye create maintain at remember news later read.",
          "estimated_repair_cost": 7910
        },
        {
          "defect_type": "minor roof leak",
          "severity": "medium",
          "recommendations": "Serious activity increase conference apply product example population try society training very.",
          "estimated_repair_cost": 1508
        }
      ]
    }
  },
  "environmental_summary": {
    "phase_i_conducted": false,
    "recognized_environmental_conditions": [
      {
        "rec_type": "historical_landfill_use",
        "status": "requires_further_action",
        "estimated_remediation_cost": 57341
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "remediated"
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "no_further_action",
        "estimated_remediation_cost": 45679
      },
      {
        "rec_type": "underground_storage_tank",
        "status": "remediated",
        "estimated_remediation_cost": 146795
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-11-05"
  },
  "legal_and_title_status": {
    "clear_title_verified": false,
    "encumbrances": [
      {
        "encumbrance_type": "covenant",
        "description": "Turn quality take research director administration guy hand easy social value my door mother individual watch nation none course list difficult others also.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "easement",
        "description": "Toward since each since but think too feel many wall will enter new produce name response around better hot business glass happen could.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "easement",
        "description": "Difference here exactly conference painting suggest more receive according foot key.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Degree government hope name become pressure six player end model behind.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Authority our somebody type question card current group month carry last land step course.",
        "impact_on_property": "minor"
      }
    ],
    "zoning_designation": "M-5 General Commercial",
    "permitted_uses": [
      "eight",
      "play",
      "sense"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Phillips, Davis and Garrett",
        "lease_start_date": "2021-12-26",
        "lease_end_date": "2029-12-31",
        "monthly_rent": 17966,
        "lease_terms_summary": "Modified Gross lease, 2% annual escalation."
      },
      {
        "tenant_name": "Johnson LLC",
        "lease_start_date": "2022-02-25",
        "lease_end_date": "2027-09-29",
        "monthly_rent": 6508,
        "lease_terms_summary": "Gross lease, 2% annual escalation."
      },
      {
        "tenant_name": "Boyd-Luna",
        "lease_start_date": "2022-01-08",
        "lease_end_date": "2029-03-22",
        "monthly_rent": 39416,
        "lease_terms_summary": "Gross lease, 4% annual escalation."
      },
      {
        "tenant_name": "Chavez Inc",
        "lease_start_date": "2022-06-24",
        "lease_end_date": "2030-08-18",
        "monthly_rent": 49881,
        "lease_terms_summary": "Modified Gross lease, 4% annual escalation."
      }
    ]
  }
}