WHERE 1 AND `State` = 'ME' AND (`AddlSubCatList` like '%236%' OR `AddlSubCatList` like '%254%')
select * from `listing` WHERE 1 AND `State` = 'ME' AND (`AddlSubCatList` like '%236%' OR `AddlSubCatList` like '%254%') 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.

  • Aroostock War Fort Kent

    291 West Main Street, Fort Kent, ME, 04743
    Phone: (207) 834-5354

  • Aroostock War Fort Kent Blockhouse

    416 W. Main Street, Fort Kent, ME, 04743
    Phone: (207) 834-9040

  • Bath

    55 Front Street, Bath, ME, 04530
    Phone: (207) 443-8330

  • Baxter State Park

    64 Balsam Drive, Millinocket, ME, 04462
    Phone: (207) 723-5140

  • Beals Island and Jonesport Nautical Antiques

    6 Cogwell St, Jonesport, ME, 04649

Print