Is there such a thing as a day tour of long island from Manhattan? I would love to see the scenery,villages,mansions etc. Thanks!

I really doubt it

I've never heard of one but in any event, you would have to be more specific then a "day tour of long island." Long Island is over 100 miles long. I would start by figuring out what part of Long Island you want to see. This website might have some information: http://www.discoverlongisland.com/

You can certainly hire a limo (in season) to take you around to the wineries.

Long Island is more than 110 miles long and more than 8 million people live there. It consists of 4 counties - Queens and Brooklyn, which are boroughs of NYC - and Nassau and Suffolk - which are primarily suburban. In fact, Long Island is the largest suburban development in the the entire world. Much of it is simply miles and miles of lower, middle and upper middle class housing, strip malls, etc.

There are some resort areas at the far end - 80 or so miles from Manhattan - and a large variety of sights (the below does not include Brooklyn or Queens, which has a host of other sights) as well as some nice public beaches for most of the length of the island.

Old Westbury mansion and gardens (late spring and summer)
Old Bethpage restoration (most active ditto)
Several cute towns with 1900s to 1920s downtowns to explore
The Hamptons through Montauk - with some of the best beaches in the country and a host of incredibly expensive (and private) mansions
Sag Harbor and other East End pre-revolutionary villages
Museum of Flight
Several art museums
Teddy Roosevelt's House
And a whole lot more

There is way more than can be seen in one day and the only way I know of exploring it in any sort of detail is by car. It is possible to get to a few places by train and then cab - but would be a major PIA.

There is little scenery until you get out to the Hamptons - and we would have to know what sort of "villages" you are looking for. And almost all the mansions are still lived in and sited to be invisible from the road.

thankyou for your replies, I will rethink exactly what to do!

IMHO there are lots more interesting towns/villages in Rye,Scarsdale/Larchmont areas--theyd be easire to see,and closer--Id do a limo ride and just drive around for a few hours

There are cos. that offer day tours of the North Fork visiting wineries but this is more likely during the summer. Hamptonjitney.com does day trips to the South Fork during the summer. You can spend a day going to the Hamptons by train or bus at any time but during the winter midweek, many places close.