# Case Study: Stellar — Real Estate Investor Portal

- **Client:** Florida real estate development firm
- **Role:** Full-stack solo developer (C5H)
- **Duration:** 8 weeks
- **Live:** https://status.livestellar.com/
- **Stack:** Next.js 15, React 19, TypeScript, TailwindCSS, SQLite, Knex.js, NextAuth 5, AWS S3, Resend, Framer Motion

## Summary

A sophisticated CRM and investor communication platform managing 100+ concurrent real estate development projects with real-time updates, Git-like version control, and granular access management.

## The Challenge

A Florida firm struggled to keep 250+ investors informed about 100+ active construction projects using spreadsheets, email threads, and manual photo sharing — causing missed updates, conflicting information, hours of manual onboarding, and no granular permissions or read-tracking.

## The Solution

A custom investor portal that works like "GitHub for real estate projects": version history with rollback, staged rollouts, granular role-based permissions (admin/client/viewer), magic-link auth, dual A/B dashboards, per-project theming, and automated email notifications via Resend. Photos and assets on AWS S3.

## Results

- 94% investor satisfaction
- 15 hours/week of admin time saved
- Instant updates vs. previous 24-48 hour delays
- 2-minute investor onboarding vs. 45 minutes manual
- 500+ tracked project versions, 99.9% uptime