Screen 1 of 5

Customer Intake Form

Multi-step wizard for homeowner project submission

SC
SoCal Remodeling
Get Your Free AI Estimate
Questions?
(818) 555-0123

What type of project?

Select all that apply to your remodel

🍳
Kitchen
Full or partial
🛁
Bathroom
Primary or guest
🏠
ADU
Accessory unit
Property data auto-populated
Address
1234 Oak Valley Dr
Year Built
1987
Sq Footage
2,450 sq ft
Screen 2 of 5

Photo Upload & AI Analysis

Real-time photo analysis with material detection

✓
✓
3
Step 3 of 5: Upload Photos

Upload Kitchen Photos

Take 15-20 photos covering all angles, cabinets, counters, and appliances

📸
Drag & drop photos here
or click to browse
📋 Photo Tips for Better Estimates
  • ✓ Good lighting (open blinds/turn on lights)
  • ✓ Capture all 4 walls
  • ✓ Close-ups of cabinets, counters, fixtures
  • ✓ Any damage or problem areas
Uploaded (12 of 15-20 recommended)
+

AI Analysis Results

Live
IMG_2847.jpg
Kitchen - Overview
94%
confidence
Cabinets Shaker Style - Oak
Countertops Granite - Tan/Brown
Flooring Ceramic Tile - 12"
Condition Fair - Dated (1990s)
🤖 AI Scope Summary
Cabinet Linear Ft ~28 LF (detected)
Counter Sq Ft ~45 SF (estimated)
Appliances 6 detected
Fixtures Sink, Faucet, Disposal
Overall Confidence 87%
⚠️ 1 item flagged: Ceiling not visible - please add photo
Screen 3 of 5

Estimate Delivery

Good/Better/Best pricing tiers with CA-compliant format

socal-remodeling.com/estimate/abc123
SC
Your Kitchen Remodel Estimate
Prepared for John & Sarah Martinez
Estimate #EST-2024-0847
Valid through Feb 28, 2024
Property
1234 Oak Valley Dr, Pasadena CA 91101
Project Type
Full Kitchen Remodel
Kitchen Size
~165 sq ft (Medium)
AI Confidence
87% ±15%
💵
GOOD
Builder Grade
$38,500
$233/sq ft
✓ Stock cabinets (RTA)
✓ Laminate countertops
✓ LVP flooring
✓ Standard appliances
MOST POPULAR
💰
BETTER
Mid-Range
$52,800
$320/sq ft
✓ Semi-custom cabinets
✓ Quartz countertops
✓ Hardwood/tile flooring
✓ Mid-tier appliances (SS)
💎
BEST
Premium/Custom
$78,500
$475/sq ft
✓ Custom cabinets
✓ Natural stone counters
✓ Premium hardwood
✓ High-end appliances
California Business and Professions Code §7159 Notice: This is an estimate only and not a contract. Final pricing will be provided in a written contract before work begins. Contractor License #1234567. This estimate is valid for 30 days. All work includes required permits and inspections per Los Angeles County Building Code.
Ready to discuss your project?
Schedule a free in-home consultation to finalize scope and pricing
or call (818) 555-0123
Screen 4 of 5

Contractor Admin Dashboard

Lead management and estimate review interface

SC
SoCal Admin
New Leads
12
↑ 3 today
Pending Review
5
AI analyzed
Sent This Week
8
$420K total
Conversion Rate
34%
↑ 8% vs last month

Recent Leads - Pending Review

Lead Project AI Estimate Confidence Status Actions
John Martinez
Pasadena, CA • 2h ago
 Kitchen
$48,500 - $52,800
Better tier selected
87%
Needs Review
Sarah Chen
Glendale, CA • 5h ago
 Bathroom
$22,400 - $28,600
Good tier selected
72%
⚠️ Flagged
Mike Johnson
Burbank, CA • 1d ago
 Kitchen
$62,000 - $68,500
Best tier selected
94%
✓ Approved
Screen 5 of 5

Database Schema View

Supabase PostgreSQL data model visualization

Tables
Views
👁️ lead_summary 📊 estimate_details

leads

247 rows
Schema Definition
id
uuid
PRIMARY KEY, default: uuid_generate_v4()
PK
name
text
NOT NULL
email
text
NOT NULL, UNIQUE
phone
text
project_type
text
CHECK (project_type IN ('kitchen', 'bathroom', 'adu'))
scope_prefs
jsonb
AI-extracted scope preferences
budget_min
decimal
budget_max
decimal
status
text
default: 'new'
lead_score
int
0-100 AI-calculated score
created_at
timestamptz
default: now()
Sample Data
id name email project_type status lead_score
a1b2c3d4... John Martinez john@email.com kitchen pending 87
e5f6g7h8... Sarah Chen sarah@email.com bathroom flagged 72
i9j0k1l2... Mike Johnson mike@email.com kitchen approved 94
Foreign Key Relationships
leads.id → properties.lead_id (1:1)
leads.id → photos.lead_id (1:N)
leads.id → estimates.lead_id (1:N)