WHERE 1 AND `State` = 'NY' AND (`AddlSubCatList` like '%238%' OR `AddlSubCatList` like '%255%')
select * from `listing` WHERE 1 AND `State` = 'NY' AND (`AddlSubCatList` like '%238%' OR `AddlSubCatList` like '%255%') AND Listingid NOT IN (720,658)
Start Exploring
Route 1 Fun Facts
Fun Fact #15

Historic Route 1 is home to Fort Belvoir - headquarters of the Army Corps of Engineers - and the main gate to Quantico Marine Corps Base.

More Fun Facts

Driving through New York City requires a steady hand and some edge and attitude. But you'll be rewarded by an indescribable symphony of sights, sounds, and people.