| original_reply | [{ "entity": "Pomo RV Park & Campground", "summary": "Pomo RV Park & Campground is the closest RV park in Mendocino County. It offers spacious RV sites, beautiful surroundings, and amenities like Wi-Fi and a convenience store. Perfect for campers and RV enthusiasts looking for a convenient and comfortable place to stay."},{ "entity": "Russian Gulch State Park", "summary": "If you're looking for a scenic camping experience, Russian Gulch State Park is a great option. Located in Mendocino County, it offers RV camping sites surrounded by towering trees and picturesque coastal views. Ideal for nature lovers and those seeking a peaceful getaway."},{ "entity": "Anchor Bay Campground", "summary": "For a camping experience near the coast, Anchor Bay Campground is a fantastic choice. Situated in Mendocino County, it provides RV sites with ocean views and easy access to the beach. Perfect for beach lovers and those who want to relax by the water."},{ "entity": "Willits KOA Journey", "summary": "Willits KOA Journey is a family-friendly RV park located in Mendocino County. It offers spacious RV sites, a swimming pool, and fun activities like mini-golf and a petting zoo. Ideal for families and travelers looking for a fun and entertaining camping experience."},{ "entity": "Manchester Beach / Mendocino Coast KOA", "summary": "If you're looking for a beachfront RV camping experience, Manchester Beach / Mendocino Coast KOA is a top choice. Located in Mendocino County, it offers RV sites just steps away from the sandy shoreline. Perfect for beach enthusiasts and those who want a relaxing coastal getaway."}] |
| Pomo RV Park & Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Pomo%RV%Park%&%Campground%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Pomo RV Park & Campground') OR SOUNDEX(post_title) LIKE SOUNDEX('pomo rv park & campground') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Pomo%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%RV%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Campground%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Pomo RV Park & Campground')OR SOUNDEX(post_title) LIKE SOUNDEX('pomo rv park & campground')OR (post_title LIKE '%Pomo%' OR post_title LIKE '%RV%' OR post_title LIKE '%Park%' OR post_title LIKE '%Campground%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Pomo RV Park & Campground | {"post":{"ID":"31969","post_title":"Pomo Campground & RV Park","match_count":"4"},"summary":"Pomo RV Park & Campground is the closest RV park in Mendocino County. It offers spacious RV sites, beautiful surroundings, and amenities like Wi-Fi and a convenience store. Perfect for campers and RV enthusiasts looking for a convenient and comfortable place to stay.","permalink":"https://www.visitmendocino.com/listing/pomo-campground-rv-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":"If you're looking for a scenic camping experience, Russian Gulch State Park is a great option. Located in Mendocino County, it offers RV camping sites surrounded by towering trees and picturesque coastal views. Ideal for nature lovers and those seeking a peaceful getaway.","permalink":"https://www.visitmendocino.com/listing/russian-gulch-state-park/"} |
| Anchor Bay Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Anchor%Bay%Campground%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Anchor Bay Campground') OR SOUNDEX(post_title) LIKE SOUNDEX('anchor bay campground') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Anchor%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bay%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Campground%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Anchor Bay Campground')OR SOUNDEX(post_title) LIKE SOUNDEX('anchor bay campground')OR (post_title LIKE '%Anchor%' OR post_title LIKE '%Bay%' OR post_title LIKE '%Campground%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Anchor Bay Campground | {"post":{"ID":"32162","post_title":"Anchor Bay Campground","match_count":"23"},"summary":"For a camping experience near the coast, Anchor Bay Campground is a fantastic choice. Situated in Mendocino County, it provides RV sites with ocean views and easy access to the beach. Perfect for beach lovers and those who want to relax by the water.","permalink":"https://www.visitmendocino.com/listing/anchor-bay-campground/"} |
| Willits KOA Journey query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Willits%KOA%Journey%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Willits KOA Journey') OR SOUNDEX(post_title) LIKE SOUNDEX('willits koa journey') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Willits%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%KOA%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Journey%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Willits KOA Journey')OR SOUNDEX(post_title) LIKE SOUNDEX('willits koa journey')OR (post_title LIKE '%Willits%' OR post_title LIKE '%KOA%' OR post_title LIKE '%Journey%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Willits KOA Journey | {"post":"","summary":"Willits KOA Journey is a family-friendly RV park located in Mendocino County. It offers spacious RV sites, a swimming pool, and fun activities like mini-golf and a petting zoo. Ideal for families and travelers looking for a fun and entertaining camping experience.","permalink":""} |
| Manchester Beach / Mendocino Coast KOA query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Manchester%Beach%/%Mendocino%Coast%KOA%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Manchester Beach / Mendocino Coast KOA') OR SOUNDEX(post_title) LIKE SOUNDEX('manchester beach / mendocino coast koa') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Manchester%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Beach%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%/%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coast%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%KOA%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Manchester Beach / Mendocino Coast KOA')OR SOUNDEX(post_title) LIKE SOUNDEX('manchester beach / mendocino coast koa')OR (post_title LIKE '%Manchester%' OR post_title LIKE '%Beach%' OR post_title LIKE '%/%' OR post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%KOA%'))HAVING match_count >= 6ORDER BY match_count DESC; |
| Manchester Beach / Mendocino Coast KOA | {"post":"","summary":"If you're looking for a beachfront RV camping experience, Manchester Beach / Mendocino Coast KOA is a top choice. Located in Mendocino County, it offers RV sites just steps away from the sandy shoreline. Perfect for beach enthusiasts and those who want a relaxing coastal getaway.","permalink":""} |
| paragraph | <a href="https://www.visitmendocino.com/listing/pomo-campground-rv-park/">Pomo RV Park & Campground</a> is the closest RV park in Mendocino County. It offers spacious RV sites, beautiful surroundings, and amenities like Wi-Fi and a convenience store. Perfect for campers and RV enthusiasts looking for a convenient and comfortable place to stay.<br><br>If you're looking for a scenic camping experience, <a href="https://www.visitmendocino.com/listing/russian-gulch-state-park/">Russian Gulch State Park</a> is a great option. Located in Mendocino County, it offers RV camping sites surrounded by towering trees and picturesque coastal views. Ideal for nature lovers and those seeking a peaceful getaway.<br><br>For a camping experience near the coast, <a href="https://www.visitmendocino.com/listing/anchor-bay-campground/">Anchor Bay Campground</a> is a fantastic choice. Situated in Mendocino County, it provides RV sites with ocean views and easy access to the beach. Perfect for beach lovers and those who want to relax by the water.<br><br>Willits KOA Journey is a family-friendly RV park located in Mendocino County. It offers spacious RV sites, a swimming pool, and fun activities like mini-golf and a petting zoo. Ideal for families and travelers looking for a fun and entertaining camping experience.<br><br>If you're looking for a beachfront RV camping experience, Manchester Beach / Mendocino Coast KOA is a top choice. Located in Mendocino County, it offers RV sites just steps away from the sandy shoreline. Perfect for beach enthusiasts and those who want a relaxing coastal getaway.<br><br> |
Add Your Heading Text Here
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.