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

Ernest Hemingway wrote some of his best works while living on Historic Route 1, in the Florida Keys. These include "Death in the Afternoon," "For Whom the Bell Tolls," "To Have and Have Not," and "Green Hills of Africa."

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