WHERE 1 AND `State` = 'NY' AND `AddlSubCatList` like '%167%'
select * from `listing` WHERE 1 AND `State` = 'NY' AND `AddlSubCatList` like '%167%' 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

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.