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

Beltsville, Maryland, is home to the National Agricultural Library - part of the National Agricultural Research Center. The center covers 7,000 square miles and attracts scientists, researchers, and FBI and CIA employees.

More Fun Facts

Discover the quintessential New England adventure along Historic Route 1.

  • Beals Island and Jonesport Nautical Antiques

    6 Cogwell St, Jonesport, ME, 04649

  • Freeport

    30 Main Street, Freeport, ME, 04032
    Phone: (207) 865-4743

  • Hobby Horse Flea Market

    East Main Street Route 1, Searsport, ME, 04974

  • Kittery Outlets

    375 US Route 1, Kittery, ME, 03904
    Phone: (207) 439-6548

  • Moody's Diner and Gift Shop

    U.S.Route 1, Waldoboro, ME, 04572
    Phone: (207) 832-7930

Print