Keysproperty operations Corbelstone Residential

Occupied home

A home with a lease running at the time asked (fixed term, or rolling month to month after it).

Definition
occupied

Params: none · evaluated at Mon 20:00

lettings · v1 · Head of Lettings

7,690

homes at Mon 20:00

A lease started before now and the tenant not moved out before now.

lettings · changed 2026-11-01: First version.

Tests

  • count_between min 6500.0 max 8000.0
  • unique on unit_id

SQL

SELECT DISTINCT l.unit_id, l.building_id
FROM leases l
WHERE l.start_date <= {now} AND (l.moved_out_at IS NULL OR l.moved_out_at > {now})
ORDER BY l.unit_id