Rentals in Leggett - Visit Mendocino County

View Holiday Hours for Restaurants in Mendocino County

original_reply	[{"entity": "Standish-Hickey State Recreation Area","summary": "Outdoor enthusiasts will enjoy camping, hiking, and fishing at Standish-Hickey State Recreation Area."}, {"entity": "Richardson Grove State Park","summary": "Nature lovers looking for camping, picnicking, and hiking opportunities should visit Richardson Grove State Park."}, {"entity": "Rock Front Ranch","summary": "Those seeking a peaceful getaway in a scenic ranch setting will appreciate the rentals at Rock Front Ranch."}]
Standish-Hickey State Recreation Area query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Standish-Hickey%State%Recreation%Area%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Standish-Hickey State Recreation Area’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘standish-hickey state recreation area’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Standish-Hickey%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Recreation%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Area%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Standish-Hickey State Recreation Area’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘standish-hickey state recreation area’)OR (post_title LIKE ‘%Standish-Hickey%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Recreation%’ OR post_title LIKE ‘%Area%’))HAVING match_count >= 4ORDER BY match_count DESC;
Standish-Hickey State Recreation Area	{"post":{"ID":"31792","post_title":"Standish-Hickey State Recreation Area","match_count":"24"},"summary":"Outdoor enthusiasts will enjoy camping, hiking, and fishing at Standish-Hickey State Recreation Area.","permalink":"https://www.visitmendocino.com/listing/standish-hickey-state-recreation-area/"}
Richardson Grove State Park query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Richardson%Grove%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Richardson Grove State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘richardson grove state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Richardson%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Grove%’ 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(‘Richardson Grove State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘richardson grove state park’)OR (post_title LIKE ‘%Richardson%’ OR post_title LIKE ‘%Grove%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 4ORDER BY match_count DESC;
Richardson Grove State Park	{"post":"","summary":"Nature lovers looking for camping, picnicking, and hiking opportunities should visit Richardson Grove State Park.","permalink":""}
Rock Front Ranch query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Rock%Front%Ranch%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Rock Front Ranch’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘rock front ranch’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Rock%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Front%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Ranch%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Rock Front Ranch’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘rock front ranch’)OR (post_title LIKE ‘%Rock%’ OR post_title LIKE ‘%Front%’ OR post_title LIKE ‘%Ranch%’))HAVING match_count >= 3ORDER BY match_count DESC;
Rock Front Ranch	{"post":"","summary":"Those seeking a peaceful getaway in a scenic ranch setting will appreciate the rentals at Rock Front Ranch.","permalink":""}
paragraph	Outdoor enthusiasts will enjoy camping, hiking, and fishing at <a href="https://www.visitmendocino.com/listing/standish-hickey-state-recreation-area/">Standish-Hickey State Recreation Area</a>.<br><br>Nature lovers looking for camping, picnicking, and hiking opportunities should visit Richardson Grove State Park.<br><br>Those seeking a peaceful getaway in a scenic ranch setting will appreciate the rentals at Rock Front Ranch.<br><br>