{
  "property": {
    "property_id": "P-108",
    "name": "Leonardo Hotel Koln",
    "chain": "Leonardo",
    "station": "CGN",
    "city": "Cologne",
    "country": "DE",
    "address": "233 Cargo Boulevard, Cologne",
    "star": 4,
    "distance_km": 12.26,
    "transfer_minutes": 16,
    "transfer_mode": "taxi",
    "reception_24h": 1,
    "blackout_curtains": 1,
    "sound_mitigated": 1,
    "temp_controlled": 1,
    "day_rooms": 0,
    "faa_suitable": 1,
    "easa_suitable": 1,
    "total_rooms": 337,
    "allotment_rooms": 7,
    "release_days": 6,
    "room_types": "Standard king, Twin, Suite",
    "contract_id": "C-108",
    "contract_start": "2026-01-01",
    "contract_end": "2026-10-31",
    "contracted_rate": 292.91,
    "currency": "EUR",
    "rate_includes": "Breakfast, wifi, taxes, parking",
    "cancellation_terms": "Free until 24h before arrival",
    "payment_terms": "Prepaid, virtual card",
    "early_checkin": 0,
    "late_checkout": 0,
    "auto_renew": 1,
    "status": "expiring",
    "crew_score": 3.52,
    "last_audit": "2026-02-17",
    "notes": "Crew have raised noise from the ramp side; request high floor.",
    "public_rate": 356.98
  },
  "contacts": [
    {
      "contact_id": "PCT-29",
      "property_id": "P-108",
      "role": "reservations",
      "name": "Liam Moreau",
      "email": "reservations@leonardohotelk.com",
      "phone": "+38 89 8249031",
      "primary_contact": 1
    },
    {
      "contact_id": "PCT-31",
      "property_id": "P-108",
      "role": "billing",
      "name": "Chloe Moreau",
      "email": "billing@leonardohotelk.com",
      "phone": "+42 24 6251710",
      "primary_contact": 0
    },
    {
      "contact_id": "PCT-28",
      "property_id": "P-108",
      "role": "general_manager",
      "name": "Liam Faber",
      "email": "general@leonardohotelk.com",
      "phone": "+35 61 7677479",
      "primary_contact": 0
    },
    {
      "contact_id": "PCT-30",
      "property_id": "P-108",
      "role": "night_manager",
      "name": "Anna Hendricks",
      "email": "night@leonardohotelk.com",
      "phone": "+37 39 6664550",
      "primary_contact": 0
    }
  ],
  "usage": {
    "nights": 230,
    "spend": 66384.16,
    "avg_rate": 282.0753043478261,
    "honoured_pct": 97.3913043478261,
    "allotment_nights": 78,
    "crew_score": 2.341176470588235,
    "complaints": 28,
    "billing_issues": 3
  },
  "themes": [
    {
      "theme": "noise",
      "n": 59
    },
    {
      "theme": "transfer",
      "n": 41
    },
    {
      "theme": "checkin",
      "n": 23
    },
    {
      "theme": "room",
      "n": 20
    },
    {
      "theme": "food",
      "n": 11
    }
  ]
}