office@stype.com 631-298-8760

Newest Listings

    to
     
     
     
    Search Search
    » Property Criteria
    » Features
    •  
    » Display Tools
    Search

    334  properties match your search;

    334 with Multiple photos ;  43 with Virtual Tour ;  3 with Videos

    Save Search
    Showing 1 - 10 of 334 results| view:  results per page« 1|2|3|4|5|...|last »
    • Nestled within the picturesque landscapes of the East End of Long Island, 162 acres encompasses the North Fork’s largest commercially operating equestrian training & boarding facility. Originally founded by the Entenmann Family, The property encompasses 3 parcels including 51+ Developable Acres. Positioned at the core of the estate stands a modest yet inviting home, offering four bedrooms and two bathrooms, alongside a quaint cottage designated for the farm’s watchman. The esteemed property boasts rolling paddocks throughout the tract, two ponds, several boarding barns, workshops and detached structures. It features a half mile race track, in addition to two outdoor riding arenas. The indoor riding arena provides the necessary infrastructure to ride, train and retire horses of the highest caliber within this unparalleled equestrian sanctuary. The farm boasts three separate boarding stables with 90+ boarding stalls. 31
      Jamesport, NY 11947
      $7,999,000
      4 Bedrooms 2 Full Baths Sq. Ft. 1800.00:# Square Feet
      Single Family For Sale ML# 3542952
      Nestled within the picturesque landscapes of the East End of Long Island, 162 acres encompasses the North Fork’s largest commercially operating equestrian training & boarding facility. Originally founded by the Entenmann Family, The property encompasses 3 parcels including 51+ Developable Acres. Positioned at the core of the estate stands a modest yet inviting home, offering four bedrooms and two bathrooms, alongside a quaint cottage designated for the farm’s watchman. The esteemed property boasts rolling paddocks throughout the tract, two ponds, several boarding barns, workshops and detached structures. It features a half mile race track, in addition to two outdoor riding arenas. The indoor riding arena provides the necessary infrastructure to ride, train and retire horses of the highest caliber within this unparalleled equestrian sanctuary. The farm boasts three separate boarding stables with 90+ boarding stalls.
      Presented By: Century 21 Albertson Realty  631-765-3800
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • Nestled within the picturesque landscape of the East End of Long Island, 162 acres encompass the North Fork’s largest commercially operating equestrian training & boarding facility. Originally founded by the Entenmann Family, The property is comprised of 3 parcels including 51+ Developable Acres. Positioned at the core of the estate stands a modest yet inviting home, offering four bedrooms and two bathrooms, alongside a quaint cottage designated for the farm’s watchman. The esteemed property boasts rolling paddocks throughout the tract, two ponds, several boarding barns, workshops and detached structures. It features a half mile race track, in addition to two outdoor riding arenas. The indoor riding arena provides the necessary infrastructure to ride, train and retire horses of the highest caliber within this unparalleled equestrian sanctuary. The farm boasts three separate boarding stables with 90+ boarding stalls. 31
      Jamesport, NY 11947
      $7,999,000
      Unimproved Land For Sale ML# 3540630
      Nestled within the picturesque landscape of the East End of Long Island, 162 acres encompass the North Fork’s largest commercially operating equestrian training & boarding facility. Originally founded by the Entenmann Family, The property is comprised of 3 parcels including 51+ Developable Acres. Positioned at the core of the estate stands a modest yet inviting home, offering four bedrooms and two bathrooms, alongside a quaint cottage designated for the farm’s watchman. The esteemed property boasts rolling paddocks throughout the tract, two ponds, several boarding barns, workshops and detached structures. It features a half mile race track, in addition to two outdoor riding arenas. The indoor riding arena provides the necessary infrastructure to ride, train and retire horses of the highest caliber within this unparalleled equestrian sanctuary. The farm boasts three separate boarding stables with 90+ boarding stalls.
      Presented By: Century 21 Albertson Realty  631-765-3800
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • Unsurpassed opportunity. Private family compound or pampering hospitality venue minutes from downtown Hudson!. Exquisite estate on 100 park-like acres with historic 6000SF manor house, 2100SF guest cottage and a cavernous 7, 000 SF Barn structure. History shows that the famed Hudson River artist Frederic Church participated in the siting and construction of this impressive house which is a located near his own renowned masterpiece, Olana. The manor is an elegant, three story, stick style home with Catskill Mountain views and sunsets right out of the paintings themselves . Lovingly restored, the house has 7-Bedrooms (all with ensuite baths), spacious wrap around porch, floor to ceiling double front doors, impressive foyer with sweeping mahogany staircase, soaring 15 foot ceilings, hardwood floors and a swoon-worthy dining room off the foyer with a carved working fireplace, floor to ceiling windows, the largest is a Western facing mammoth plate glass window offering a masterpiece Catskill Mountain view. The kitchen is large and features a preserved red brick fireplace with woodbox. The first floor has high ceiling parlor rooms for libraries, music or winter gathering by a fire. There is a primary bedroom on the first floor wing with spa-worthy ensuite bathroom. This recently added wing provides an ADA compliant entrance off of a deck with a ramp. The storybook Guest Cottage, constructed in 2002, is ideal for caretaker or additional house guests, features a large open floor plan with 2-bedrooms each one with an ensuite baths. The easily customizable Pole Barn building offers endless opportunities as an entertainment venue, restaurant, private sports arena, gymnasium, art gallery space, vintage car collection display, etc. The long, winding entrance drive uphill leads to captivating walking trails, protected woodlands, picturesque stone walls and sweeping views in all directions. A mere two hours from New York City and minutes from the creative and entrepreneurial excitement of Hudson, New York and the Amtrak station. If you’re in need of a private compound with room to grow that is steeped in the rich history of the Hudson Valley, this is a gem. It’s reputation as a boutique hotel and wedding hospitality venues make it a strong choice to further grow a branded experience . And, the 100-acre parcel provides the perfect canvas for added expansion and development near Hudson! 36
      Greenport, NY 12534
      $7,330,000
      7 Bedrooms 7 Full Baths 1 Half Bath Sq. Ft. 6000.00:# Square Feet
      Single Family For Sale NEW ML# H6312196
      Unsurpassed opportunity. Private family compound or pampering hospitality venue minutes from downtown Hudson!. Exquisite estate on 100 park-like acres with historic 6000SF manor house, 2100SF guest cottage and a cavernous 7, 000 SF Barn structure. History shows that the famed Hudson River artist Frederic Church participated in the siting and construction of this impressive house which is a located near his own renowned masterpiece, Olana. The manor is an elegant, three story, stick style home with Catskill Mountain views and sunsets right out of the paintings themselves . Lovingly restored, the house has 7-Bedrooms (all with ensuite baths), spacious wrap around porch, floor to ceiling double front doors, impressive foyer with sweeping mahogany staircase, soaring 15 foot ceilings, hardwood floors and a swoon-worthy dining room off the foyer with a carved working fireplace, floor to ceiling windows, the largest is a Western facing mammoth plate glass window offering a masterpiece Catskill Mountain view. The kitchen is large and features a preserved red brick fireplace with woodbox. The first floor has high ceiling parlor rooms for libraries, music or winter gathering by a fire. There is a primary bedroom on the first floor wing with spa-worthy ensuite bathroom. This recently added wing provides an ADA compliant entrance off of a deck with a ramp. The storybook Guest Cottage, constructed in 2002, is ideal for caretaker or additional house guests, features a large open floor plan with 2-bedrooms each one with an ensuite baths. The easily customizable Pole Barn building offers endless opportunities as an entertainment venue, restaurant, private sports arena, gymnasium, art gallery space, vintage car collection display, etc. The long, winding entrance drive uphill leads to captivating walking trails, protected woodlands, picturesque stone walls and sweeping views in all directions. A mere two hours from New York City and minutes from the creative and entrepreneurial excitement of Hudson, New York and the Amtrak station. If you’re in need of a private compound with room to grow that is steeped in the rich history of the Hudson Valley, this is a gem. It’s reputation as a boutique hotel and wedding hospitality venues make it a strong choice to further grow a branded experience . And, the 100-acre parcel provides the perfect canvas for added expansion and development near Hudson!
      Presented By: Houlihan Lawrence, Inc  518-822-0300
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • Welcome to this exquisite private compound nestled on 4.72 acres of pristine land surrounded by the breathtaking Laurel Lake Preserve of 300 plus preserved acres. This spectacular property offers a harmonious blend of luxury, elegance, and natural beauty. As you step inside, you’ll be greeted by a grand entrance that sets the tone for the rest of the home. With 6 spacious bedrooms and 5 full bathrooms and 2 half bathrooms, there is ample room for comfort and privacy. One of the standout features of this estate is the award-winning inground saltwater pool, complete with a spa and a cascading waterfall. Adjacent to the pool is a charming 400 square foot pool house, creating the perfect space for entertaining guests or simply unwinding in style. The property boasts meticulously curated specimen gardens, showcasing nature’s beauty at its finest. For those seeking entertainment and relaxation, the finished lower level of the home is a haven of indulgence. It features a climate-controlled 2250 bottle wine cellar, where you can store and display your prized collections. A state-of-the-art home theatre awaits movie enthusiasts, while a well-equipped gym allows for daily workouts without leaving the comforts of home. The expansive bar area sets the stage for unforgettable gatherings and socializing. This estate home offers a truly luxurious lifestyle, combining the serenity of nature with the finest amenities. It is a place where you can escape the ordinary and embrace the extraordinary! 35
      Mattituck, NY 11952
      $6,399,000
      6 Bedrooms 5 Full Baths 2 Half Baths
      Single Family For Sale ML# 3554200
      Welcome to this exquisite private compound nestled on 4.72 acres of pristine land surrounded by the breathtaking Laurel Lake Preserve of 300 plus preserved acres. This spectacular property offers a harmonious blend of luxury, elegance, and natural beauty. As you step inside, you’ll be greeted by a grand entrance that sets the tone for the rest of the home. With 6 spacious bedrooms and 5 full bathrooms and 2 half bathrooms, there is ample room for comfort and privacy. One of the standout features of this estate is the award-winning inground saltwater pool, complete with a spa and a cascading waterfall. Adjacent to the pool is a charming 400 square foot pool house, creating the perfect space for entertaining guests or simply unwinding in style. The property boasts meticulously curated specimen gardens, showcasing nature’s beauty at its finest. For those seeking entertainment and relaxation, the finished lower level of the home is a haven of indulgence. It features a climate-controlled 2250 bottle wine cellar, where you can store and display your prized collections. A state-of-the-art home theatre awaits movie enthusiasts, while a well-equipped gym allows for daily workouts without leaving the comforts of home. The expansive bar area sets the stage for unforgettable gatherings and socializing. This estate home offers a truly luxurious lifestyle, combining the serenity of nature with the finest amenities. It is a place where you can escape the ordinary and embrace the extraordinary!
      Presented By: Engel & Volkers North Fork  631-298-7953
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • This premium North Fork land comprised of 33 acres, spanning two highly desirable locations, creates a unique acquisition opportunity with development rights intact. Capturing the true essence of the North Fork and nestled in a picturesque location, this property boasts a beautiful vineyard, perfect for wine enthusiasts and investors alike. The vineyard is well established and features a variety of mature grape varietals that thrive with the North Fork’s climate and soil conditions. Whether you are a wine connoisseur or aspiring winemaker, this vineyard presents an incredible chance to cultivate and produce your own high-quality wines. In addition to the vineyard, the property features a spacious 2, 500 square foot tasting room. This tastefully designed and well-appointed space welcomes visitors with its high ceilings and large windows that provide breathtaking views of the surrounding landscape. The abundance of natural light creates a warm and inviting ambiance, making it the perfect setting for wine tastings, weddings, private events, and gatherings. This offering also includes a a 3, 500 square foot fully climate controlled wine cellar with 35’ ceilings, 13 fermentation tanks, 30 French Oak barrels and a full bottling line. This property also features a 1, 500 square foot retail shop with showcase laboratory and crush pad to give tour-goers the ultimate experience. Overall, this prime land on the North with development rights intact, a beautiful vineyard, and a spacious tasting room offers a unique and enticing package for those looking to enter or expand in the wine industry with excellent potential for growth or as an ideal investment property. 29
      Cutchogue, NY 11935
      $5,800,000
      Mixed Use Commercial ML# 3547111
      This premium North Fork land comprised of 33 acres, spanning two highly desirable locations, creates a unique acquisition opportunity with development rights intact. Capturing the true essence of the North Fork and nestled in a picturesque location, this property boasts a beautiful vineyard, perfect for wine enthusiasts and investors alike. The vineyard is well established and features a variety of mature grape varietals that thrive with the North Fork’s climate and soil conditions. Whether you are a wine connoisseur or aspiring winemaker, this vineyard presents an incredible chance to cultivate and produce your own high-quality wines. In addition to the vineyard, the property features a spacious 2, 500 square foot tasting room. This tastefully designed and well-appointed space welcomes visitors with its high ceilings and large windows that provide breathtaking views of the surrounding landscape. The abundance of natural light creates a warm and inviting ambiance, making it the perfect setting for wine tastings, weddings, private events, and gatherings. This offering also includes a a 3, 500 square foot fully climate controlled wine cellar with 35’ ceilings, 13 fermentation tanks, 30 French Oak barrels and a full bottling line. This property also features a 1, 500 square foot retail shop with showcase laboratory and crush pad to give tour-goers the ultimate experience. Overall, this prime land on the North with development rights intact, a beautiful vineyard, and a spacious tasting room offers a unique and enticing package for those looking to enter or expand in the wine industry with excellent potential for growth or as an ideal investment property.
      Presented By: Engel & Volkers North Fork  631-298-7953
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • Rarely does a farm of this size and quality come on the market on Oregon Road in Cutchogue. Two farms included with a Total of 69.70 acres, Devlopment rights sold on 65.93 acres with 3.71 acres of full right land, includes 6+ barns, outbuildings, all farm equipment necessary to operate this turnkey business operation. Extensive list of additional features available. 15
      Cutchogue, NY 11935
      $5,000,000
      Unimproved Land For Sale ML# 3523614
      Rarely does a farm of this size and quality come on the market on Oregon Road in Cutchogue. Two farms included with a Total of 69.70 acres, Devlopment rights sold on 65.93 acres with 3.71 acres of full right land, includes 6+ barns, outbuildings, all farm equipment necessary to operate this turnkey business operation. Extensive list of additional features available.
      Presented By: Douglas Elliman Real Estate  631-354-8100
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • Stunning waterfront modern with sweeping views of the Peconic Bay from every room. The 130’ of bay frontage is complimented by your 70’ dock, waterside gunite pool and five ensuite bedrooms overlooking the water. With soaring ceilings, a chef’s kitchen, wood burning fireplace, and a dedicated teak balcony for each second-floor bedroom, the property blends the luxury vacation experience with the comforts of home. 34
      Southold, NY 11971
      $4,995,000
      5 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 5000.00:# Square Feet
      Single Family For Sale ML# 3554272
      Stunning waterfront modern with sweeping views of the Peconic Bay from every room. The 130’ of bay frontage is complimented by your 70’ dock, waterside gunite pool and five ensuite bedrooms overlooking the water. With soaring ceilings, a chef’s kitchen, wood burning fireplace, and a dedicated teak balcony for each second-floor bedroom, the property blends the luxury vacation experience with the comforts of home.
      Presented By: Compass Greater NY LLC  516-330-6086
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • OLIVER WISWALL HUDSON RIVER HOUSE c1835 Indulge in the allure of mesmerizing views that will captivate your senses and imagination. Perched atop Mt. Merino, the iconic Oliver Wiswall House stands as a beacon of timeless elegance, offering commanding forever vistas of the majestic Hudson River. Originally built in 1835 by one of Hudson’s esteemed mayors and founder of Greenport, this historic Greek Revival masterpiece is steeped in a rich tapestry of heritage. Set on 39 acres this residence commands not only the tranquil Hudson River but also offers sweeping panoramas that encompass the iconic Athens lighthouse and the picturesque Catskill Mountains painting the horizon. Rarely does an opportunity arise to own a piece of history so deeply entrenched in the fabric of the region. Step inside to discover a meticulous and thoughtful restoration, where every detail has been methodically preserved and enhanced. From the grandeur of the classic brick Greek Revival architecture to the intricate details of stately moldings, marble fireplaces, and most original doors and windows, the Oliver Wiswall House exudes an air of timeless sophistication. The interior layout features a gracious center hall entry leading to the formal living room, library and formal dining room all adorned with iconic moldings and meticulous craftsmanship that effortlessly blends historic charm with modern comforts all bathed in natural light pouring in countless oversized windows. A seamless transition takes you to the later postmodernism addition, where a grand great room awaits boasting curved, soaring ceilings a chef-worthy open kitchen, gracious dining round, fantasy mud room, pantry, and laundry area, all thoughtfully designed to complement the home’s historic grandeur. With four bedrooms and three and a half baths, including the upstairs sumptuous primary suite, guest en-suite, and two additional bedrooms and bath, all flooded with natural light, high ceilings and offering captivating river views, this home is a sanctuary of comfort and luxury. Step outside onto multi-level decks and a patio, where you can immerse yourself in the mesmerizing expanse of the river’s beauty. Whether you’re a star-gazer or simply seeking a tranquil retreat, the Oliver Wiswall House offers the perfect sanctuary amidst its sprawling lawns and panoramic views. Just moments to Hudson, Amtrak and to all the Hudson Valley has to offer while just 2 hrs to NYC 36
      Greenport, NY 12534
      $4,500,000
      4 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 4903.00:# Square Feet
      Single Family For Sale ML# H6295670
      OLIVER WISWALL HUDSON RIVER HOUSE c1835 Indulge in the allure of mesmerizing views that will captivate your senses and imagination. Perched atop Mt. Merino, the iconic Oliver Wiswall House stands as a beacon of timeless elegance, offering commanding forever vistas of the majestic Hudson River. Originally built in 1835 by one of Hudson’s esteemed mayors and founder of Greenport, this historic Greek Revival masterpiece is steeped in a rich tapestry of heritage. Set on 39 acres this residence commands not only the tranquil Hudson River but also offers sweeping panoramas that encompass the iconic Athens lighthouse and the picturesque Catskill Mountains painting the horizon. Rarely does an opportunity arise to own a piece of history so deeply entrenched in the fabric of the region. Step inside to discover a meticulous and thoughtful restoration, where every detail has been methodically preserved and enhanced. From the grandeur of the classic brick Greek Revival architecture to the intricate details of stately moldings, marble fireplaces, and most original doors and windows, the Oliver Wiswall House exudes an air of timeless sophistication. The interior layout features a gracious center hall entry leading to the formal living room, library and formal dining room all adorned with iconic moldings and meticulous craftsmanship that effortlessly blends historic charm with modern comforts all bathed in natural light pouring in countless oversized windows. A seamless transition takes you to the later postmodernism addition, where a grand great room awaits boasting curved, soaring ceilings a chef-worthy open kitchen, gracious dining round, fantasy mud room, pantry, and laundry area, all thoughtfully designed to complement the home’s historic grandeur. With four bedrooms and three and a half baths, including the upstairs sumptuous primary suite, guest en-suite, and two additional bedrooms and bath, all flooded with natural light, high ceilings and offering captivating river views, this home is a sanctuary of comfort and luxury. Step outside onto multi-level decks and a patio, where you can immerse yourself in the mesmerizing expanse of the river’s beauty. Whether you’re a star-gazer or simply seeking a tranquil retreat, the Oliver Wiswall House offers the perfect sanctuary amidst its sprawling lawns and panoramic views. Just moments to Hudson, Amtrak and to all the Hudson Valley has to offer while just 2 hrs to NYC
      Presented By: Brown Harris Stevens HV LLC  (854) 871-2700
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • Attention Developers and Discerning Investors! Opportunity knocks with this 36-acre parcel, Development Rights in Tact, nestled in the heart of the North Fork. Ideally positioned along Arshamomack Creek with access to both County and Municipal roadways, this property offers a perfect setting for the development of either workforce housing, an exclusive residential enclave or a private estate. A generous tract of land within the R80 zone, allowing for 2-acre zoning. Close proximity to pristine beaches, renowned farmstands, and esteemed wineries. Bring your vision. (see attachments for more info.) 6
      Southold, NY 11971
      $4,495,000
      Unimproved Land For Sale ML# 3520399
      Attention Developers and Discerning Investors! Opportunity knocks with this 36-acre parcel, Development Rights in Tact, nestled in the heart of the North Fork. Ideally positioned along Arshamomack Creek with access to both County and Municipal roadways, this property offers a perfect setting for the development of either workforce housing, an exclusive residential enclave or a private estate. A generous tract of land within the R80 zone, allowing for 2-acre zoning. Close proximity to pristine beaches, renowned farmstands, and esteemed wineries. Bring your vision. (see attachments for more info.)
      Presented By: Compass Greater NY LLC  631-251-8644
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    • Orient, North Fork - Nantucket inspired waterfront estate with 130’ private beach. Featuring over 5, 000 sf of upscale living space, this home takes advantage of the hilltop setting & encompasses sweeping views over the LI Sound. Luxury is apparent: spacious covered porch entry leads to foyer, LR w/clerestory windows overlooking the water & vaulted ceilings, large dining room, immaculate kitchen w/breakfast area overlooks the lush landscape of this coastal retreat. Open plan family room w/gas fireplace leads to waterside terrace, primary floor owner’s suite w/fireplace, sunroom/sitting room & a home office w/private en suite bath (or 5th bedroom). Upstairs is found a large sitting room, billiard/family room, sewing/craft room, junior owner’s suite w/full bath, plus an additional 2 bedrooms w/’Jack & Jill’ bath. Immaculate and well-maintained, this ’estate’ also features a wine cellar, full house generator, outdoor shower & other quality details not to be missed. Room for a waterside pool. No flood insurance needed. North Fork living at its BEST! 35
      Orient, NY 11957
      $4,250,000
      5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 5200.00:# Square Feet
      Single Family For Sale NEW ML# 3559218
      Orient, North Fork - Nantucket inspired waterfront estate with 130’ private beach. Featuring over 5, 000 sf of upscale living space, this home takes advantage of the hilltop setting & encompasses sweeping views over the LI Sound. Luxury is apparent: spacious covered porch entry leads to foyer, LR w/clerestory windows overlooking the water & vaulted ceilings, large dining room, immaculate kitchen w/breakfast area overlooks the lush landscape of this coastal retreat. Open plan family room w/gas fireplace leads to waterside terrace, primary floor owner’s suite w/fireplace, sunroom/sitting room & a home office w/private en suite bath (or 5th bedroom). Upstairs is found a large sitting room, billiard/family room, sewing/craft room, junior owner’s suite w/full bath, plus an additional 2 bedrooms w/’Jack & Jill’ bath. Immaculate and well-maintained, this ’estate’ also features a wine cellar, full house generator, outdoor shower & other quality details not to be missed. Room for a waterside pool. No flood insurance needed. North Fork living at its BEST!
      Presented By: Town And Country Real Estate  631-298-0600
      Call Today: (631)298-8760, (631)298-8760, or  Email: Andrew Stype Realty Inc
    Showing 1 - 10 of 334 results| view:  results per page« 1|2|3|4|5|...|last »
    OneKey™ MLS The data relating to real estate for sale on this web site comes in part from the OneKey™ MLS. Real Estate listings held by brokerage firms other than Andrew Stype Realty Inc are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.

    Questions? Just Ask!

     Submit
    12985 Main Road, P.O. Box 63, Mattituck, NY 11952

    Office: (631)298-8760

    Fax: (631)298-5779

    office@stype.com

    DMCA Notice | Admin Login
    powered by www.erealtymedia.com