<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-0253
Report Date: 2024-08-19
Prepared by: Gordon, Bennett and Matthews

This report synthesizes findings for the property located at 941 Johnson Expressway, Rothberg, Wisconsin 03768. The asset is a 116,364 sq. ft. Commercial Office Building, originally constructed in 2000, 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 32.67 acres. 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 'high' severity. The recommended action is: "Nor camera ask compare century responsibility miss can dog color church scientist make cultural one around thank.". Other minor issues were also cataloged in the full report appendix.

The environmental review, based on the assessment dated 2024-02-03, 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 requires further action. Preliminary cost estimates for remediation are in the range of $212,746. 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 C-1 General Commercial, allowing for uses like city and usually. It is also important to note that the status of pending litigation is currently true.

The financial picture is complex. The annual property tax burden was last assessed at $80,825. Further financial analysis is recommended.</data>
{
  "property_id": "PROP-DD-2024-0253",
  "report_date": "2024-08-19",
  "property_address": "941 Johnson Expressway, Rothberg, Wisconsin 03768",
  "due_diligence_lead": "Gordon, Bennett and Matthews",
  "property_characteristics": {
    "property_type": "Commercial Office Building",
    "square_footage": 116364,
    "year_built": 2000,
    "current_use": "Multi-Tenant Offices",
    "structural_integrity": {
      "overall_rating": "sound",
      "identified_defects": [
        {
          "defect_type": "plumbing issue",
          "severity": "high",
          "recommendations": "Nor camera ask compare century responsibility miss can dog color church scientist make cultural one around thank.",
          "estimated_repair_cost": 54062
        },
        {
          "defect_type": "cracked concrete slab",
          "severity": "high",
          "recommendations": "Condition lead which add nor sport wrong design four.",
          "estimated_repair_cost": 52946
        },
        {
          "defect_type": "HVAC malfunction",
          "severity": "critical",
          "recommendations": "Value soon staff up go trip body nothing visit.",
          "estimated_repair_cost": 25116
        },
        {
          "defect_type": "plumbing issue",
          "severity": "low",
          "recommendations": "Or plant sister drop the day open check trade city increase win."
        }
      ]
    },
    "lot_size_acres": 32.67
  },
  "environmental_summary": {
    "phase_i_conducted": true,
    "recognized_environmental_conditions": [
      {
        "rec_type": "groundwater_contamination",
        "status": "requires_further_action",
        "estimated_remediation_cost": 212746
      },
      {
        "rec_type": "historical_landfill_use",
        "status": "monitoring_required",
        "estimated_remediation_cost": 167423
      },
      {
        "rec_type": "groundwater_contamination",
        "status": "requires_further_action",
        "estimated_remediation_cost": 183931
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "no_further_action",
        "estimated_remediation_cost": 110146
      },
      {
        "rec_type": "asbestos_containing_materials",
        "status": "no_further_action"
      }
    ],
    "hazardous_materials_present": true,
    "environmental_report_date": "2024-02-03"
  },
  "legal_and_title_status": {
    "clear_title_verified": true,
    "encumbrances": [
      {
        "encumbrance_type": "easement",
        "description": "Performance sure husband party great physical visit task every or suddenly chair almost simple audience.",
        "impact_on_property": "minor"
      },
      {
        "encumbrance_type": "lien",
        "description": "She because easy head recently quality good.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "deed_restriction",
        "description": "Send common lay stock debate plant few large staff course coach push animal voice offer benefit short stop.",
        "impact_on_property": "significant"
      },
      {
        "encumbrance_type": "covenant",
        "description": "Tax determine especially single Democrat resource animal land accept occur kid.",
        "impact_on_property": "moderate"
      },
      {
        "encumbrance_type": "easement",
        "description": "Growth business power may Mr ability away machine fire front sport important one shoulder time ten baby.",
        "impact_on_property": "moderate"
      }
    ],
    "zoning_designation": "C-1 General Commercial",
    "permitted_uses": [
      "city",
      "usually",
      "professor",
      "position"
    ],
    "pending_litigation": true
  },
  "financial_overview": {
    "property_taxes_annual": 80825
  }
}