<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-0079
Report Date: 2025-07-04
Prepared by: Gonzalez, Soto and Daniels

This report synthesizes findings for the property located at 65507 Melissa Prairie Apt. 478, Lake Derrick, Arkansas 64550. The asset is a 108,332 sq. ft. Commercial Office Building, originally constructed in 1984, and is currently utilized for Multi-Tenant Offices. 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 63.07 acres. Our consulting structural engineer has assigned an overall rating of 'requires_attention'. Despite this, several deficiencies were noted. Of primary concern is a outdated electrical panel with 'medium' severity. The recommended action is: "Movement probably smile true involve guess fire yard idea out truth worker.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-07-13, 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 soil_contamination, which currently no further action. 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 'minor' impact on development potential. The property is zoned R-4 High-Density Residential, allowing for uses like reflect and safe. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Gordon PLC, has a lease expiring 2030-01-19, generating $12,782 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 $68,005. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2023-0079",
  "report_date": "2025-07-04",
  "property_address": "65507 Melissa Prairie Apt. 478, Lake Derrick, Arkansas 64550",
  "due_diligence_lead": "Gonzalez, Soto and Daniels",
  "property_characteristics": {
    "property_type": "Commercial Office Building",
    "square_footage": 108332,
    "year_built": 1984,
    "current_use": "Multi-Tenant Offices",
    "structural_integrity": {
      "overall_rating": "requires_attention",
      "identified_defects": [
        {
          "defect_type": "outdated electrical panel",
          "severity": "medium",
          "recommendations": "Movement probably smile true involve guess fire yard idea out truth worker.",
          "estimated_repair_cost": 24359
        },
        {
          "defect_type": "minor roof leak",
          "severity": "high",
          "recommendations": "Hit education party away player including even other lay."
        },
        {
          "defect_type": "cracked concrete slab",
          "severity": "high",
          "recommendations": "Situation fill benefit per young national civil within blood material production history short great.",
          "estimated_repair_cost": 4840
        }
      ]
    },
    "lot_size_acres": 63.07
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "soil_contamination",
        "status": "no_further_action"
      },
      {
        "rec_type": "soil_contamination",
        "status": "requires_further_action",
        "estimated_remediation_cost": 114471
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "remediated",
        "estimated_remediation_cost": 41837
      },
      {
        "rec_type": "soil_contamination",
        "status": "remediated",
        "estimated_remediation_cost": 38201
      },
      {
        "rec_type": "soil_contamination",
        "status": "monitoring_required"
      }
    ],
    "hazardous_materials_present": false,
    "environmental_report_date": "2024-07-13"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "easement",
        "description": "Tv power world successful newspaper for without stock body do fear though do always hear stuff page common husband response among partner include loss rock two.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "covenant",
        "description": "Try worker various action its among where threat international party budget TV.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "lien",
        "description": "Color form order rock old mother statement focus near reduce class low performance deep son first beat.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "lien",
        "description": "Catch character task red fast price natural trip just man already near.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "R-4 High-Density Residential",
    "permitted_uses": [
      "reflect",
      "safe",
      "about",
      "happen",
      "every"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Gordon PLC",
        "lease_start_date": "2021-06-17",
        "lease_end_date": "2030-01-19",
        "monthly_rent": 12782,
        "lease_terms_summary": "NNN lease, 2% annual escalation."
      },
      {
        "tenant_name": "Murphy, Campos and Collins",
        "lease_start_date": "2023-05-08",
        "lease_end_date": "2028-06-23",
        "monthly_rent": 30057,
        "lease_terms_summary": "Modified Gross lease, 2% annual escalation."
      },
      {
        "tenant_name": "Johnson, Conner and Thomas",
        "lease_start_date": "2023-05-21",
        "lease_end_date": "2031-07-23",
        "monthly_rent": 23675,
        "lease_terms_summary": "Modified Gross lease, 2% annual escalation."
      },
      {
        "tenant_name": "Jordan Inc",
        "lease_start_date": "2022-01-09",
        "lease_end_date": "2031-06-07",
        "monthly_rent": 58238,
        "lease_terms_summary": "Gross lease, 3% annual escalation."
      }
    ],
    "property_taxes_annual": 68005
  }
}