Scenic drivesM9l0¡l

original_reply	[{"entity": "Pacific Coast Highway","summary": "The Pacific Coast Highway is a breathtaking scenic drive along the coast of Mendocino County, offering stunning ocean views and picturesque landscapes. Perfect for nature lovers and those seeking a peaceful and serene road trip experience."}, {"entity": "Highway 128","summary": "Highway 128 meanders through the beautiful Anderson Valley, surrounded by vineyards, redwood forests, and rolling hills. Ideal for wine enthusiasts and anyone who wants to explore the charming small towns along the way."}, {"entity": "Skunk Train","summary": "The Skunk Train takes you on a scenic journey through the majestic redwood forests of Mendocino County. Enjoy the vintage train ride and immerse yourself in the natural beauty of the area. A must-do for train enthusiasts and families."}, {"entity": "Mendocino Headlands State Park","summary": "Mendocino Headlands State Park offers a stunning coastal drive with panoramic views of the Pacific Ocean, rugged cliffs, and charming historic buildings. It’s a great option for outdoor enthusiasts and history buffs."}]
Pacific Coast Highway query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Pacific%Coast%Highway%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Pacific Coast Highway’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘pacific coast highway’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Pacific%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Coast%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Highway%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Pacific Coast Highway’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘pacific coast highway’)OR (post_title LIKE ‘%Pacific%’ OR post_title LIKE ‘%Coast%’ OR post_title LIKE ‘%Highway%’))HAVING match_count >= 3ORDER BY match_count DESC;
Pacific Coast Highway	{"post":"","summary":"The Pacific Coast Highway is a breathtaking scenic drive along the coast of Mendocino County, offering stunning ocean views and picturesque landscapes. Perfect for nature lovers and those seeking a peaceful and serene road trip experience.","permalink":""}
Highway 128 query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Highway%128%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Highway 128’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘highway 128’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Highway%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%128%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Highway 128’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘highway 128’)OR (post_title LIKE ‘%Highway%’ OR post_title LIKE ‘%128%’))HAVING match_count >= 2ORDER BY match_count DESC;
Highway 128	{"post":"","summary":"Highway 128 meanders through the beautiful Anderson Valley, surrounded by vineyards, redwood forests, and rolling hills. Ideal for wine enthusiasts and anyone who wants to explore the charming small towns along the way.","permalink":""}
Skunk Train query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Skunk%Train%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Skunk Train’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘skunk train’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Skunk%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Train%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Skunk Train’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘skunk train’)OR (post_title LIKE ‘%Skunk%’ OR post_title LIKE ‘%Train%’))HAVING match_count >= 2ORDER BY match_count DESC;
Skunk Train	{"post":{"ID":"32011","post_title":"Skunk Train – Willits","match_count":"12"},"summary":"The Skunk Train takes you on a scenic journey through the majestic redwood forests of Mendocino County. Enjoy the vintage train ride and immerse yourself in the natural beauty of the area. A must-do for train enthusiasts and families.","permalink":"https://www.visitmendocino.com/listing/skunk-train-willits/"}
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":"Mendocino Headlands State Park offers a stunning coastal drive with panoramic views of the Pacific Ocean, rugged cliffs, and charming historic buildings. It’s a great option for outdoor enthusiasts and history buffs.","permalink":"https://www.visitmendocino.com/listing/mendocino-headlands-state-park/"}
paragraph	The Pacific Coast Highway is a breathtaking scenic drive along the coast of Mendocino County, offering stunning ocean views and picturesque landscapes. Perfect for nature lovers and those seeking a peaceful and serene road trip experience.<br><br>Highway 128 meanders through the beautiful Anderson Valley, surrounded by vineyards, redwood forests, and rolling hills. Ideal for wine enthusiasts and anyone who wants to explore the charming small towns along the way.<br><br>The <a href="https://www.visitmendocino.com/listing/skunk-train-willits/">Skunk Train</a> takes you on a scenic journey through the majestic redwood forests of Mendocino County. Enjoy the vintage train ride and immerse yourself in the natural beauty of the area. A must-do for train enthusiasts and families.<br><br><a href="https://www.visitmendocino.com/listing/mendocino-headlands-state-park/">Mendocino Headlands State Park</a> offers a stunning coastal drive with panoramic views of the Pacific Ocean, rugged cliffs, and charming historic buildings. It’s a great option for outdoor enthusiasts and history buffs.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here