Brown Harris Stevens

Search
State School Road
Warwick, New York
$3,199,999 Price
5 Bedrooms  
CloseClose Video
Photo 1 of State School Road, Warwick, New York, $3,199,999, Web #: 824790Previous PhotoNext Photo1 of 46

Longhouse Farm, a beautifully restored farmhouse with many designer upgrades, is absolutely breathtaking! Its 11+ acres of scenic beauty, historic elegance, and luxurious modern amenities, make it the perfect blend of sophistication and tranquility. This equestrian estate consists of the main house, a guest house, a 9-stall barn,...

Longhouse Farm, a beautifully restored farmhouse with many designer upgrades, is absolutely breathtaking! Its 11+ acres of scenic beauty, historic elegance, and luxurious modern amenities, make it the perfect blend of sophistication and tranquility. This equestrian estate consists of the main house, a guest house, a 9-stall barn, 4 stall run-in overlooking fountained pond and a trout-fed stream, which all add a wonderful touch for those who appreciate country living. Plus, with the chef’s kitchen that includes: a 6-burner LeCornue range, a Subzero refrigerator, a huge quartz top island with a second sink, dual Bosch dishwashers, Miele expresso machine, and wine cooler, as well as the many beautiful spaces like the conservatory and library, make it an entertainers dream home for anyone who loves comfort and style. The newly built Hamptons-style heated pool with a pergola is incredible for entertaining or simply unwinding. And the wrap-around deck is perfect for taking in the sunsets. All of the window treatments are custom-made. There are fenced pastures in a bucolic setting. This amazing property was featured in Mansion Global and Cottages & Gardens. The proximity to NYC makes it even more desirable for a peaceful year-round getaway without being too far from the city.

Listing courtesy of William Raveis-New York Llc

Calculate your Payments

Asking Price:

Percent Down:

Loan Amount:

Interest Rate:

Loan Term (years):

Estimated Mortgage Payment:

Monthly Real Estate Tax:

Total Monthly Payment:

* All information furnished regarding property for sale, rental, financing or estimated mortgage rates is from sources deemed reliable but no warranty or representation is made as to the accuracy thereof. For further financing information, please contact a Brown Harris Stevens agent.

Listing Details

New Listing
Warwick, New York
Type: House
Price: $3,199,999
Re Tax: $33,121
Date Listed: 3/3/2025
Web ID: 824790

Info & Amenities

Type: Single Family
Size: 11.0 acres
Bedrooms: 5
Bathrooms: 5.5
Woodburning fireplaces: 5
Built: 1780
Pool: Yes

All information is from sources deemed reliable but is subject to errors, omissions, changes in price, prior sale or withdrawal without notice. No representation is made as to the accuracy of any description. All measurements and square footages are approximate and all descriptive information should be confirmed by customer. All rights to content, photographs and graphics are reserved to Brown Harris Stevens. Customer should consult with its counsel regarding all closing and tax costs. Broker represents the seller/owner on Broker's own exclusives, except if another agent of Broker represents the buyer/tenant, in which case Broker will be a dual agent, in Connecticut, or , in New York State and New Jersey, a dual agent with designated or disclosed agents representing seller/owner and buyer/tenant. Broker represents the buyer/tenant when showing the exclusives of other real estate firms. In Florida, Broker acts as a Transaction Broker with all sellers and buyers, unless a different form of agency has been established in writing. If you are looking to purchase or rent housing, are using a screen reader, and are having problems using this website, please call 1-212-712-1163 for assistance. All phone charges will be reimbursed by Brown Harris Stevens. Broker actively supports Fair Housing and Equal Housing Opportunities. BHS has adopted the attached policy statement - Prior to showing a homebuyer a property or providing services: (1) BHS does not require identification from a prospective homebuyer, (2) BHS may require a written agreement from a homebuyer before showing properties; and (3) BHS does not require a pre-approval for a mortgage loan in order to show a homebuyer properties. However, based upon the requirements of the seller, the building in which the properties is located, or others, some or all of the foregoing items may be required. Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York's Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer's personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. 2025 The Real Estate Board of New York, Inc., all rights reserved. RLS Data display by Brown Harris Stevens. Powered by Terra Holdings.