Crescent View Media
Real estate photography site with a five-step booking wizard and scheduling that cannot double-book.
A client site built under Imprint for a real estate photography business. The centre of it is a five-step booking wizard: pick a service, pick a package and photo count, enter the property address, choose a slot, then review and submit. Availability comes live from Postgres, and a unique constraint on the date and time slot makes double-booking impossible at the database level rather than merely unlikely at the application level. Open slots are exposed through a security-definer function so the public booking page can read availability without ever seeing customer details. Travel fees are estimated automatically by geocoding the property address against the studio's base location. Domain, SSL, and deployment were live the same day the client bought the domain.
Highlights
- Five-step booking wizard from service selection through to confirmation
- Live slot availability, with a database constraint that makes double-booking impossible
- Availability exposed through a security-definer function, so no customer details leak
- Automatic travel-fee estimate from geocoded distance to the property
- Tiered photo packages priced in data rather than hardcoded