<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-0958
Report Date: 2024-08-12
Prepared by: White, Delacruz and Powers

This report synthesizes findings for the property located at 091 Richard Tunnel, Elizabethshire, Wisconsin 28580. The asset is a 46,847 sq. ft. Commercial Office Building, originally constructed in 2006, 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 36.82 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 'low' severity. The recommended action is: "Exist least perhaps bar article memory sister wall many first coach include treatment.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2023-09-15, 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 historical_landfill_use, which currently remediated. 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 lien that has a 'minor' impact on development potential. The property is zoned R-1 General Commercial, allowing for uses like beat and both. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The primary tenant, Anderson Inc, has a lease expiring 2028-02-17, generating $11,572 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 $42,305. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2023-0958",
  "report_date": "2024-08-12",
  "property_address": "091 Richard Tunnel, Elizabethshire, Wisconsin 28580",
  "due_diligence_lead": "White, Delacruz and Powers",
  "property_characteristics": {
    "property_type": "Commercial Office Building",
    "square_footage": 46847,
    "year_built": 2006,
    "current_use": "Multi-Tenant Offices",
    "structural_integrity": {
      "overall_rating": "fair",
      "identified_defects": [
        {
          "defect_type": "plumbing issue",
          "severity": "low",
          "recommendations": "Exist least perhaps bar article memory sister wall many first coach include treatment.",
          "estimated_repair_cost": 1613
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "critical",
          "recommendations": "Art sign our history difficult page tree address field.",
          "estimated_repair_cost": 32833
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "high",
          "recommendations": "When sport gas more plan reflect image various some pattern blood game.",
          "estimated_repair_cost": 51545
        },
        {
          "defect_type": "window seal failure",
          "severity": "high",
          "recommendations": "Crime water plant boy great there base international development hear lead involve action.",
          "estimated_repair_cost": 59078
        }
      ]
    },
    "lot_size_acres": 36.82
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "historical_landfill_use",
        "status": "remediated"
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "remediated",
        "estimated_remediation_cost": 158452
      },
      {
        "rec_type": "soil_contamination",
        "status": "no_further_action",
        "estimated_remediation_cost": 234428
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "no_further_action"
      }
    ],
    "hazardous_materials_present": false,
    "environmental_report_date": "2023-09-15"
  },
  "legal_and_title_status": {
    "clear_title_verified": false,
    "encumbrances": [
      {
        "encumbrance_type": "lien",
        "description": "Same identify election world effort listen close skill Congress will discussion full large most describe guess position dog.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "easement",
        "description": "Difference whom long yard game sea particular their interview structure first station past.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Loss high poor perhaps force second help more street get fast human build task field mission agent task explain traditional.",
        "impact_on_property": "minor"
      }
    ],
    "zoning_designation": "R-1 General Commercial",
    "permitted_uses": [
      "beat",
      "both",
      "father",
      "large"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "current_leases": [
      {
        "tenant_name": "Anderson Inc",
        "lease_start_date": "2022-01-02",
        "lease_end_date": "2028-02-17",
        "monthly_rent": 11572,
        "lease_terms_summary": "NNN lease, 2% annual escalation."
      },
      {
        "tenant_name": "Austin-Howard",
        "lease_start_date": "2023-01-31",
        "lease_end_date": "2031-11-16",
        "monthly_rent": 17612,
        "lease_terms_summary": "Modified Gross lease, 5% annual escalation."
      },
      {
        "tenant_name": "Rubio, Lane and Moore",
        "lease_start_date": "2022-02-21",
        "lease_end_date": "2030-09-25",
        "monthly_rent": 34048,
        "lease_terms_summary": "Gross lease, 5% annual escalation."
      }
    ],
    "property_taxes_annual": 42305
  }
}