SacFleaMarkets.com | Sacramento's Flea Market Guide

The problem

Sacramento has a thriving flea market scene spread across the region, from Denio’s 70-acre swap meet in Roseville to the monthly Folsom Antique Faire. But finding reliable information about these markets is a mess. Schedules are buried in Facebook groups that require membership. Yelp listings show outdated hours. Google results return spam aggregators that scrape data and get it wrong. If you want to know when the next Davis Craft & Vintage Fair is, or whether Galt’s Tuesday market is running this week, you’re stuck digging through social media posts and hoping for the best.

What I built

SacFleaMarkets.com is the central resource for every flea market, swap meet, and vintage fair in the Sacramento region. The directory covers 17 markets from Denio’s 70-acre Roseville swap meet to seasonal fairs like the Great Junk Hunt and Old Town Auburn Antiques Faire. Each market has a dedicated profile page with hours, directions, parking info, payment details, a photo gallery, Google Calendar integration, and a live countdown to the next occurrence. The homepage surfaces the next 10 upcoming markets across all venues, computed in real time. A blog with 36 articles covers everything from haggling strategy to vendor spotlights to furniture identification guides.

The site originally launched on WordPress in 2013. I rebuilt it from scratch in Astro 6 in 2025, migrating all content while eliminating the database, the PHP runtime, and the monthly hosting overhead that comes with them.

The migration

The WordPress version served its purpose for 12 years, but it carried baggage: a MySQL database for what is now 17 market listings, PHP rendering for pages that never change, plugin updates that broke things quarterly, and a shared hosting bill for resources the site barely used. The content was solid. The platform was dead weight.

The Astro rebuild preserved every URL. Blog posts kept their root-level slugs (/denios-roseville-market-guide-sacramento-flea-market/ not /blog/denios...) to maintain the SEO equity built over a decade of organic rankings. All 36 articles migrated to Markdown with Zod-validated frontmatter schemas. The market database moved from MySQL rows to a single YAML file that any text editor can update.

The result: a static site with zero JavaScript in the baseline bundle, sub-second page loads, and no server to maintain.

Architecture

Data layer: All market data lives in markets.yaml, a single file defining names, locations, GPS coordinates, hours, recurrence patterns, admission prices, parking details, FAQs, and image paths. Adding a new market means adding a YAML block. No admin panel, no CMS, no database migrations.

Events engine: The most interesting piece of engineering on the site. A 478-line client-side JavaScript module reads recurrence patterns from HTML data- attributes and computes every upcoming market date in the browser. It handles patterns like “every saturday,sunday” for weekly markets, “second sunday of month” for monthlies, and specific calendar dates for seasonal fairs. The homepage generates the next 10 upcoming events across all markets. The listing page renders 500+ events across 12 months. All computed at page load, no API calls.

Search: Pagefind generates a static search index at build time that covers all blog posts and market pages. The search overlay activates from the header, delivers results in milliseconds, and adds zero weight to the initial page load.

Deployment: GitHub Actions on a self-hosted runner builds the Astro site, generates the Pagefind index, and rsyncs the output to cPanel. Cloudflare sits in front for CDN caching and SSL.

Content strategy

The blog targets 1,343 rankable keyword opportunities (KD under 40, volume over 100) identified through SEMrush analysis. Articles are organized into five categories: Flea Market Tips, Flea Market News, Flea Market Photos, Lifestyle, and Local Markets. The editorial voice reads like a fellow collector talking over coffee, not a corporate content mill.

Key content pillars:

• Market guides with first-hand intel on parking, vendor layout, and what to expect (Denio’s guide, Folsom Boulevard breakdown)
• Buying guides covering furniture identification, antique pricing, and haggling technique
• Seller resources for vendors looking to set up at Sacramento markets
• Local lifestyle connecting flea market culture to Sacramento living

Revenue comes through guest post advertising targeting antique dealers, estate sale companies, and furniture restoration services. The advertise page is live, and the site has generated its first revenue.

The Sacramento angle

Every market listing includes intel you can only get from showing up repeatedly. Which parking lot at Denio’s fills by 8 AM on Saturdays. That the Galt market runs Tuesday and Thursday, not just weekends. That Davis Craft & Vintage Fair happens monthly at the Veterans Memorial Center on C Street, first Sundays only. This is the kind of specific, verified, regularly-updated local knowledge that national directory scrapers cannot replicate.