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 #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.

  • Acadia National Park

    Park Loop Road, Bar Harbor, ME, 04609
    Phone: (207) 288-3338

  • Captain Fish's Puffin Nature Cruises

    65 Atlantic Avenue, Boothbay Harbor, ME, 04538
    Phone: (207) 633-3244

  • Desert of Maine

    95 Desert Road, Freeport, ME, 04032
    Phone: (207) 865-6962

  • Lighthouse Nubble

    Sohier Park Road, York, ME, 03909

  • Rachel Carson NWR

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

Print