sharonfronk.com + AssistantDB
Two production products for a working Howard Hanna agent in upstate New York: a custom MLS-integrated public site AND a full agent-operations CRM that runs her business. Sharon reports hours of her workday disappearing — and she's gotten 2 real buyers from the site in its first 60 days.
Visit live site Image or Video · NEEDED
/public/work/sharon/hero.jpg · or /public/work/sharon/hero.mp4
1600×1000 image · or 1920×1080 H.264 video (~8MB max)
Marquee asset for the sharonfronk.com + AssistantDB case. A 10-15s silent video loop showing the live experience (search, hover, click into listing) lands way harder than a static screenshot. Image works too — full-bleed homepage above-the-fold.
Image or Video · NEEDED
/public/work/sharon/search-experience.jpg · or .mp4
1440×900 image · or short looping video
Live MLS map search with marker clustering and viewport-driven filtering.
Image or Video · NEEDED
/public/work/sharon/ai-chat-in-action.jpg · or .mp4
1440×900 image · or short looping video
Anthropic Claude conversation with the human-takeover handoff fired.
Image or Video · NEEDED
/public/work/sharon/hyperlocal-community-page.jpg · or .mp4
1440×900 image · or short looping video
Editorial Saratoga Springs page with live market data.
- Real buyers captured
- 2 in 60 days
- Sharon's time back
- Hours per day
- Active listings
- 3,000+
- Google ranking
- Page 1 · local terms
What I built
- Live MLS property search (3,000+ listings). 8-tier autocomplete (city, hamlet, school district, ZIP, MLS#, neighborhood). Daily Spark/RESO API sync. Active, Coming Soon, Pending, Sold, Expired all crawlable.
- Zillow-style map search + Swipe-to-Discover. Leaflet map with marker clustering and map-as-viewport filtering. Tinder-style Swipe-to-Discover UX with AI preference learning — saves feed Sharon's CRM.
- "Sharon's Take" AI listing summaries. Unique-per-listing fair-housing-gated narrative generated for every active listing — NOT MLS remarks. Differentiates SERP snippets vs every other IDX mirror. Admin override per-listing.
- AI chat with human takeover. Anthropic Claude with tool use (search, schedule showings, capture leads). Sharon hops in mid-conversation — visitor sees "Sharon Fronk has joined the chat". Chat → CRM webhook is two-way.
- Buyer toolkit + first-time-buyer flow. Mortgage calc, Down Payment Planner, Rent-vs-Buy, Neighborhood Matcher (5-question, Fair Housing compliant), Pre-Approval intake, 12-step buyer guide with NY-specific programs (SONYMA, HomeFirst DPA, FHA, VA, USDA).
- Seller toolkit + Renovation ROI tool. Free CMA workflow (Sharon-prepared, not algorithmic), Net Proceeds Calculator with NY transfer tax disclosed, Renovation ROI Analyzer (14 projects ranked, Zonda 2025 Cost vs Value sourcing), staging checklist.
- Buyer/seller portal — saves, alerts, shortlist. NextAuth sign-in. Saved homes with price-drop tracking, saved searches with alert digests, recently-viewed rail, gamified Shortlist with podium ranking + binary-insertion sort "Match-up" mode, "Send my top 3 to Sharon" button.
- Hyperlocal communities + Market Reports. 40+ hand-curated editorial town pages plus auto-discovered MLS towns. Live Capital Region market dashboard, quarterly county deep-dives. No fabricated metrics — sourced and dated.
- AI morning briefing + daily action queue. Creon agent generates Sharon's overnight priorities + warnings + auto-tasks via MCP. Action queue sorts clients to call/text by urgency with the reason. "Who needs you today" with one-click call/text.
- Drag-and-drop pipeline kanbans. Seller (Prospects → Listed → Pending → Closed) and Buyer (Leads → Pre-approved → Active Search → Under Offer → Closed) boards with auto-promotion. 90-day velocity chart + per-source ROI report.
- Universal contact profiles + engagement scoring. Smart CSV import (auto-dedup, E.164 normalization). 15+ event types per contact (call, email, text, showing, offer, view, search, AI action). Engagement score crosses 40 → "hot lead" badge + Discord alert + AI "next best action" suggestion.
- Drip campaigns with manual approval queue. 4 pre-built nurture sequences. Every drip email lands in Sharon's approval queue for review before sending. Gmail sync (15-min polling) auto-pauses drips when a client is actively emailing — no auto-nurturing a live conversation.
- Two-way Google Calendar + Twilio SMS + Resend email. Events in CRM → Sharon's phone calendar in seconds. 12 event types. Twilio A2P 10DLC-compliant SMS (tour confirmations, reminders). Resend with full webhook lifecycle (sent/opened/clicked/bounced), HMAC-signed unsubscribe links, hard-bounce suppression.
- Property Workspace + AI listing presentations. Tabbed property page: Details, Listing Intake (AI extracts from photos + scribbles), Walkthrough (room-by-room), Showings + feedback, Comps via Spark API, Taxes, Presentation (one-click AI seller deck PDF: hero + 3-comp CMA + narrative + net sheet), Documents (zipForm field-fill), Offers.
- Multi-offer comparison + Buyer offer prep. Seller side: side-by-side multi-offer table with public shareable link. Buyer side: offer prep wizard that pulls MLS facts → emits Prep Sheet (zipForm-ready) + Buck Sheet (office review). Escalation clause builder. Copy-to-clipboard outputs.
- Open House kiosk mode. Tablet at the door — zero-login visitor sign-in captures name/email/phone/interest. Auto-triggers thank-you + similar-homes follow-up. Sign-in log shows on the property record. Approval queue covers the auto-follow-ups so Sharon reviews before send.
- Compliance: agency disclosure, RLS, audit trails. NY agency disclosure footer on every CRM-originated email. Row-level security isolates every table by agent_id. Anonymous deletion anonymizes name/email/phone while preserving activity history for audit. Multi-agent ready, no crosstalk.