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

New Haven, Connecticut, home to Yale University, could also be called the "city of gardens." It has some 70 gardens planted by residents and community groups.

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