sharonfronk.com
A full-stack production real-estate site for a working Howard Hanna agent in upstate New York. Live MLS search, Zillow-style map, AI chat with human takeover, and a custom CRM coordination layer. ~3 months end-to-end.
Visit live site/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 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.
/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.
/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.
/public/work/sharon/hyperlocal-community-page.jpg · or .mp4
1440×900 image · or short looping video
Editorial Saratoga Springs page with live market data.
- Active listings
- 3,000+
- MLS sync cadence
- 15 min
- Build time
- ~3 mo
- Status
- Live · prod
What I built
- Live MLS property search. 3,000+ active Capital Region listings with 8-tier autocomplete (city, hamlet, school district, ZIP, MLS#, neighborhood), continuously synced.
- Zillow-style map search. Leaflet map with marker clustering and map-as-viewport — pick an area, list filters to viewport, pan/zoom updates results live.
- AI chat with human takeover. Anthropic Claude assistant with tool use (search, schedule showings, capture leads). Sharon can hop in mid-conversation; visitor sees "Sharon Fronk has joined the chat".
- Free home valuation tool. School-district-aware comp scoring (not just ZIP), 6-step seller funnel, structured CRM event firing.
- Hyperlocal community pages. Hand-curated city + hamlet pages with editorial copy, school lists, live market trends, click-a-school-to-filter.
- Custom CRM coordination layer. Two-system architecture sharing one Postgres database, 16-event versioned contract, synthetic monitoring + bidirectional uptime watchdog.