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 #14

Dumfries, Virginia, is the state's oldest town.

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.

  • Bronx Zoo

    2300 Southern Avenue, Bronx, NY, 10460

  • New York Botanical Garden

    2900 Southern Blvd, Bronx, NY, 10458
    Phone: (718) 817-8700

  • Playland Amusement Park

    Playland Parkway, Rye, NY, 10580
    Phone: (914) 813-7010

Print