Where should I hike?

original_reply	[{"entity": "Mendocino Headlands State Park","summary": "Outdoor enthusiasts will appreciate the stunning coastal views and diverse trails that Mendocino Headlands State Park offers for hiking."}, {"entity": "Russian Gulch State Park","summary": "Nature lovers will enjoy exploring the lush forests, waterfalls, and coastal bluffs along the hiking trails at Russian Gulch State Park."}, {"entity": "Montgomery Woods State Natural Reserve","summary": "Hikers seeking a peaceful and serene experience should visit Montgomery Woods State Natural Reserve to marvel at the towering old-growth redwood trees."}, {"entity": "Jug Handle State Natural Reserve","summary": "Those looking for a unique hiking experience can explore the Ecological Staircase trail at Jug Handle State Natural Reserve, showcasing different ecosystems in one hike."}]
Mendocino Headlands State Park query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Headlands%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Headlands State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino headlands state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Headlands%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Park%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Headlands State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino headlands state park’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Headlands%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 4ORDER BY match_count DESC;
Mendocino Headlands State Park	{"post":{"ID":"31563","post_title":"Mendocino Headlands State Park","match_count":"24"},"summary":"Outdoor enthusiasts will appreciate the stunning coastal views and diverse trails that Mendocino Headlands State Park offers for hiking.","permalink":"https://www.visitmendocino.com/listing/mendocino-headlands-state-park/"}
Russian Gulch State Park query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Russian%Gulch%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Russian Gulch State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian gulch state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Russian%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Gulch%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Park%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Russian Gulch State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian gulch state park’)OR (post_title LIKE ‘%Russian%’ OR post_title LIKE ‘%Gulch%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 4ORDER BY match_count DESC;
Russian Gulch State Park	{"post":{"ID":"31719","post_title":"Russian Gulch State Park","match_count":"24"},"summary":"Nature lovers will enjoy exploring the lush forests, waterfalls, and coastal bluffs along the hiking trails at Russian Gulch State Park.","permalink":"https://www.visitmendocino.com/listing/russian-gulch-state-park/"}
Montgomery Woods State Natural Reserve query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Montgomery%Woods%State%Natural%Reserve%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Montgomery Woods State Natural Reserve’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘montgomery woods state natural reserve’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Montgomery%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Woods%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Natural%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Reserve%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Montgomery Woods State Natural Reserve’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘montgomery woods state natural reserve’)OR (post_title LIKE ‘%Montgomery%’ OR post_title LIKE ‘%Woods%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Natural%’ OR post_title LIKE ‘%Reserve%’))HAVING match_count >= 5ORDER BY match_count DESC;
Montgomery Woods State Natural Reserve	{"post":"","summary":"Hikers seeking a peaceful and serene experience should visit Montgomery Woods State Natural Reserve to marvel at the towering old-growth redwood trees.","permalink":""}
Jug Handle State Natural Reserve query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Jug%Handle%State%Natural%Reserve%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Jug Handle State Natural Reserve’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘jug handle state natural reserve’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Jug%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Handle%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Natural%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Reserve%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Jug Handle State Natural Reserve’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘jug handle state natural reserve’)OR (post_title LIKE ‘%Jug%’ OR post_title LIKE ‘%Handle%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Natural%’ OR post_title LIKE ‘%Reserve%’))HAVING match_count >= 5ORDER BY match_count DESC;
Jug Handle State Natural Reserve	{"post":"","summary":"Those looking for a unique hiking experience can explore the Ecological Staircase trail at Jug Handle State Natural Reserve, showcasing different ecosystems in one hike.","permalink":""}
paragraph	Outdoor enthusiasts will appreciate the stunning coastal views and diverse trails that <a href="https://www.visitmendocino.com/listing/mendocino-headlands-state-park/">Mendocino Headlands State Park</a> offers for hiking.<br><br>Nature lovers will enjoy exploring the lush forests, waterfalls, and coastal bluffs along the hiking trails at <a href="https://www.visitmendocino.com/listing/russian-gulch-state-park/">Russian Gulch State Park</a>.<br><br>Hikers seeking a peaceful and serene experience should visit Montgomery Woods State Natural Reserve to marvel at the towering old-growth redwood trees.<br><br>Those looking for a unique hiking experience can explore the Ecological Staircase trail at Jug Handle State Natural Reserve, showcasing different ecosystems in one hike.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here