WHERE 1 AND `State` = 'NH' AND (`AddlSubCatList` like '%237%' OR `AddlSubCatList` like '%253%')
select * from `listing` WHERE 1 AND `State` = 'NH' AND (`AddlSubCatList` like '%237%' OR `AddlSubCatList` like '%253%') AND Listingid NOT IN (720,658)
Start Exploring
Route 1 Fun Facts
Fun Fact #7

Groton, Connecticut, is called the "Submarine Capital of the World."

More Fun Facts

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

Print