Care Availability

Overview

A senior care provider directory and search platform founded in the Pacific Northwest. City, state, and service-type discovery, map-based search, faceted filtering across amenities, common areas, and advanced filters, premium provider listings with claim flows, and a referral pipeline that connects families with care communities. Custom WordPress build on a hand-rolled provider schema (little postmeta) with indexed geospatial search and SEO pillar pages driving organic acquisition. Built to keep pillar queries cheap and provider search snappy, while handling editorial bulk imports without corrupting the SERP sort. Currently mid-rebuild (v1 to v1.5) page-by-page in the same repo.

What I did

Solo design-through-deploy. Built the WordPress theme top-to-bottom (template-driven, no page builders), three custom plugins for provider data, admin tools, and database utilities, and a React-based Admin Hub for editorial staff. Replaced the standard postmeta data model with indexed custom tables, and a five-column timestamp scheme that keeps the pillar SERP sort honest under bulk imports. Engineered the search query with a ±1° lat / ±1.5° lng bounding-box prefilter that took provider queries from ~1.8s to ~0.05s. Shipped a Database Manager admin app for staff CSV imports: claimed/premium content protection, term-ID-driven taxonomy writes (amenities, common areas, advanced services), URL-hash media deduplication, and full round-trip export. Stood up the Stripe-driven premium tier with auto-renew, provider dashboard self-edit, and claim review.

Stack

• WordPress (custom theme + custom plugin) · PHP 8 · MySQL (custom schema, bounding-box geospatial)
• React 18 (Admin Hub, Database Manager) · Tailwind · ES6 modules
• Stripe · ActiveCampaign · Google Maps · Gravity Forms · Yoast SEO
• Cloudways · Cloudflare WAF + edge cache · Breeze + Redis object cache