Arxec Systems
Back to Archive
Case Study · 2025FeaturedLIVE

Keyark

Keyark

Property showcase and lead pipeline CRM built with Next.js, Prisma WASM, and Neon serverless Postgres.

Keyark

Real estate platform and internal CRM for Keyark Realtor Consulting. Pairs a public property catalog and inquiry flow with a role-protected admin pipeline for tracking buyer leads, site visits, builder partnerships, and negotiation stages on Neon serverless PostgreSQL.

Problem Visual
The Problem

Untracked buyer inquiries & inventory sheets

Property listings, buyer inquiries, and site-visit follow-ups were managed manually across WhatsApp threads and spreadsheets, making it easy to lose track of lead status and builder inventory.

Solution Visual
The Solution

Property catalog + integrated lead pipeline

Engineered a Next.js App Router application using Prisma with Neon serverless Postgres. Built a custom property catalog with filterable specs and an internal lead CRM that tracks each inquiry from initial contact through site visit and negotiation.

Feature Visual
Implementation

Prisma + Neon Serverless Lead CRM

Prisma WASM
Next.js App Router
Serverless Postgres
Edge Runtime

System Core · Dynamic Status Orchestration

function getStatusColor(status: string | null): string {
  const s = status || 'New';
  if (s.includes('In Progress')) return 'bg-amber-500/10 text-amber-400 border-amber-500/20';
  if (s.includes('Visit')) return 'bg-blue-500/10 text-blue-400 border-blue-500/20';
  if (s.includes('Negotiation')) return 'bg-emerald-500/10 text-emerald-400 border-emerald-500/20';
  if (s.includes('Won')) return 'bg-emerald-500/10 text-emerald-400 border-emerald-500/20';
  if (s.includes('Lost')) return 'bg-red-500/10 text-red-400 border-red-500/20';
  if (s.includes('Assigned')) return 'bg-keyark-gold/10 text-keyark-gold border-keyark-gold/20';
  return 'bg-surface text-text-muted border-edge';
}
typescript
Next Project

Next Case Study

God's Own Guide