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

Like a siren's song, the sea beckons you to explore New Hampshire along Historic Route 1.

  • Ashworth Hotel and Breakers Lounge

    295 Ocean Blvd, Hampton Beach, NH, 03842
    Phone: (603) 926-6762

  • Hampton Beach NH

    Route 1A, Hampton Beach, NH, 03842
    Phone: (603) 926-3784

  • Lighthouse Whaleback

    Portsmouth harbor, Portsmouth, NH, 03802

Print