WHERE 1 AND `State` = 'ME' AND `AddlSubCatList` like '%167%'
select * from `listing` WHERE 1 AND `State` = 'ME' AND `AddlSubCatList` like '%167%' AND Listingid NOT IN (720,658)
Start Exploring
Route 1 Fun Facts
Fun Fact #4

Florida's John Pennekamp Coral Reef State Park provides 178 square miles of ocean wonderland. Visitors can enjoy snorkeling, scuba diving, and sailing.

More Fun Facts

Discover the quintessential New England adventure along Historic Route 1.

Print