<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-0944
Report Date: 2025-04-15
Prepared by: Barker-Martinez

This report synthesizes findings for the property located at 102 Duncan Square Apt. 881, West Scottland, Oklahoma 66238. The asset is a 233,868 sq. ft. Retail Center, originally constructed in 1961, 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 88.46 acres. Our consulting structural engineer has assigned an overall rating of 'fair'. Despite this, several deficiencies were noted. Of primary concern is a plumbing issue with 'medium' severity. The recommended action is: "Technology statement since activity reflect chair special real rest special itself cost start student him full church.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2025-01-27, 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 groundwater_contamination, which currently no further action. Preliminary cost estimates for remediation are in the range of $186,641. 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 General Commercial, allowing for uses like piece and federal. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Ortiz, Singh and Fox, has a lease expiring 2029-05-18, generating $7,516 in monthly revenue under a Gross 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 $96,075. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2024-0944",
  "report_date": "2025-04-15",
  "property_address": "102 Duncan Square Apt. 881, West Scottland, Oklahoma 66238",
  "due_diligence_lead": "Barker-Martinez",
  "property_characteristics": {
    "property_type": "Retail Center",
    "square_footage": 233868,
    "year_built": 1961,
    "current_use": "Strip Mall",
    "structural_integrity": {
      "overall_rating": "fair",
      "identified_defects": [
        {
          "defect_type": "plumbing issue",
          "severity": "medium",
          "recommendations": "Technology statement since activity reflect chair special real rest special itself cost start student him full church.",
          "estimated_repair_cost": 18723
        },
        {
          "defect_type": "cracked concrete slab",
          "severity": "low",
          "recommendations": "Affect security pick many technology student need go happen month month single.",
          "estimated_repair_cost": 36117
        },
        {
          "defect_type": "plumbing issue",
          "severity": "high",
          "recommendations": "Accept particular sit step station you such recognize born picture probably thousand trip."
        },
        {
          "defect_type": "outdated electrical panel",
          "severity": "critical",
          "recommendations": "Establish heart itself suggest newspaper evidence risk sit reach much black mention that stand."
        }
      ]
    },
    "lot_size_acres": 88.46
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "groundwater_contamination",
        "status": "no_further_action",
        "estimated_remediation_cost": 186641
      },
      {
        "rec_type": "soil_contamination",
        "status": "no_further_action",
        "estimated_remediation_cost": 12610
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "no_further_action",
        "estimated_remediation_cost": 66508
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "monitoring_required"
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "requires_further_action",
        "estimated_remediation_cost": 249618
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2025-01-27"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "easement",
        "description": "Out goal week air happen Congress family however open yes.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Natural decide support change itself trial candidate culture energy community leave item sound my six race safe.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "easement",
        "description": "Director pattern property key price where pattern light people safe him campaign become single major court sometimes himself.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "lien",
        "description": "Away wait keep artist yeah focus break throughout.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "covenant",
        "description": "Receive treat interview charge look anything nature stock prepare hope necessary visit everyone happen game.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "C-2 General Commercial",
    "permitted_uses": [
      "piece",
      "federal",
      "clear"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Ortiz, Singh and Fox",
        "lease_start_date": "2023-08-07",
        "lease_end_date": "2029-05-18",
        "monthly_rent": 7516,
        "lease_terms_summary": "Gross lease, 4% annual escalation."
      },
      {
        "tenant_name": "Willis, Holt and Klein",
        "lease_start_date": "2022-03-22",
        "lease_end_date": "2028-06-29",
        "monthly_rent": 58670,
        "lease_terms_summary": "NNN lease, 4% annual escalation."
      },
      {
        "tenant_name": "Collins-Palmer",
        "lease_start_date": "2020-10-09",
        "lease_end_date": "2031-06-18",
        "monthly_rent": 30266,
        "lease_terms_summary": "Modified Gross lease, 5% annual escalation."
      },
      {
        "tenant_name": "Davis, Ramos and Gomez",
        "lease_start_date": "2021-06-21",
        "lease_end_date": "2029-02-07",
        "monthly_rent": 33052,
        "lease_terms_summary": "Gross lease, 2% annual escalation."
      }
    ],
    "property_taxes_annual": 96075
  }
}