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

The Franklin Mint - the leader in the multibillion-dollar instant collectibles industry - is located on Historic Route 1 in Pennsylvania.

More Fun Facts

Discover the quintessential New England adventure along Historic Route 1.

  • Lighthouse Nubble

    Sohier Park Road, York, ME, 03909

  • Rachel Carson NWR

    321 Port Road, Wells, ME, 04090
    Phone: (207) 646-9226

  • Rapid Rays

    189 Saco Street, Saco, ME, 04072
    Phone: (207) 282-1847

  • The Acadian Village

    US Route 1, Van Buren, ME, 04785

  • Wells Reserve & Laudholm Trust Site

    342 Laudholm Farm Road, Wells, ME, 04090
    Phone: (207) 646-1555

Print