Private Family Property Reservation & Cost Tracking System
Eliminating Double-Bookings With an Invite-Only Family Property Platform
App: Mahlum Properties | Industry: Family Office / Property Management | Client: Private family estate management — multi-property family | Company size: Internal tool for shared vacation and rental properties | Duration: ~4–6 weeks
Summary
A private, invite-only family property reservation system with owner-approval workflows, utility cost tracking, and role-based access control.
The Challenge
The family had no centralized way to coordinate who was staying at which property and when, manage utility costs, or control who had access to property information. Reservations were handled informally via text/email, leading to double-bookings, no accountability, and no visibility into property operating costs.
Our Approach
- Built custom role-based access control (Admin / Editor / User) with admin-approval workflow for new sign-ups
- Integrated Replit Object Storage (Google Cloud Storage backed) for property photos with presigned URL upload flow
- Designed an interactive availability calendar with conflict detection to make double-bookings impossible
- Implemented historical utility cost tracking with trend analysis and winterized pricing modes
- Added automated email notifications via SendGrid for reservation approval requests
- Used PostgreSQL with Drizzle ORM for type-safe data management across users, properties, reservations, and utility records
Outcomes & ROI
- 0 — Double-Bookings: Calendar conflict detection makes overlapping reservations impossible
- 3+ → 1 — Tools Consolidated: Replaced informal text/email coordination, separate spreadsheets, and ad-hoc utility tracking
- Per-property — Cost Visibility: Historical utility tracking with seasonal/winterized pricing modes
Eliminated double-bookings entirely; consolidated property management, reservations, and utility tracking into one platform that previously required 3+ separate tools and informal coordination.
Technologies Used
PostgreSQL + Drizzle ORM, Replit Object Storage (GCS), SendGrid, Custom RBAC, React + TypeScript
Key Takeaways
- Family-office tools have the same governance needs as enterprise software — invite-only access and admin approval workflows are non-negotiable
- Calendar conflict detection at the data layer (not just the UI) is the only way to truly eliminate double-bookings
- Tracking utility costs with seasonal pricing modes is the kind of small detail that makes a private tool actually useful long-term
Frequently Asked Questions
Who can access the platform?
Access is invite-only with admin approval. Roles are Admin, Editor, and User — each with different reservation and editing permissions.
How are double-bookings prevented?
The availability calendar checks for conflicts at the data layer before any reservation is accepted, so overlapping bookings can't be created even by privileged users.
What about utility costs?
Each property tracks historical utility costs over time with trend analysis and a winterized pricing mode for seasonal properties — so owners can see operating cost trends at a glance.
Related Services
More Case Studies
- Axiom AI — A multi-agent AI orchestration platform that lets users deploy, coordinate, and monitor swarms of specialized Claude/GPT/Gemini agents from a single command center to autonomously execute complex software, research, and operational workflows.
- Axiom Trading Agent — An autonomous multi-vertical trading agent that finds, validates, and executes positive-EV trades on Kalshi prediction markets and Robinhood crypto end-to-end, with no human in the loop.
- Tier IV Pro — A unified manufacturing operations and project-management platform combining real-time bay scheduling, financial goal planning, quality/IDQ tracking, and AI-assisted forecasting into a single executive cockpit.
- Elysian Operations Platform (Time Warp + Nexus Wellness) — All-in-one workforce, payroll, wellness, and tax-compliance platform that replaces 8+ separate SaaS tools with a single unified system.
- Elysian Institute Website — A modern, SEO-optimized marketing website for a recovery, wellness, and longevity center, featuring 20 detailed service pages, transparent membership pricing, and direct integration with the client's external booking system.
- March Madness Commissioner — A full-stack commissioner dashboard that automates ESPN bracket league management — syncing picks, tracking payments, and generating AI-powered win projections — with a companion iOS mobile app.