231 Celery Ave
Warwick, NY 10990
4 Beds
3.5 Baths
3,925 sqft (on 38.70 acres)
4 Beds
3.5 Baths
3,925 sqft
(on 38.70 acres)
Local Information
© Google
-- mins to
Description
Welcome to a rare offering in the heart of New Hampton—an exceptional gentleman's farm set on 38 picturesque acres of thriving sod farmland. This remarkable property seamlessly blends rural charm with modern comfort, featuring a beautifully updated main residence, a separate caretaker's home, and an oversized barn ideal for agricultural use, storage, or hobby pursuits. The spacious main farmhouse offers four bedrooms and four bathrooms, thoughtfully designed with bright, open living spaces and scenic views in every direction. A warm wood-burning fireplace anchors the living area, while the expansive chef's kitchen is outfitted with designer cabinetry, stainless steel appliances, and a premium water filtration system—perfect for both everyday living and entertaining. Additional highlights include a generous family room, recreation area, and a two-car garage. The property's layout supports both lifestyle and business opportunities, whether you envision continuing the sod farming operation, creating an equestrian retreat, or simply enjoying the privacy and beauty of wide-open land. The caretaker's house provides flexibility for staff, guests, or extended family. Ideally located in the charming Town of New Hampton, this property offers the tranquility of country living with convenient access to local shops, dining, and everyday amenities. A truly special opportunity to own a working farm with modern appeal in a sought-after Hudson Valley setting. Goshen is about 64 miles (103 km) from New York City by car, depending on where in NYC you're headed. The drive usually takes around 1 hour 15 minutes to 1 hour 30 minutes. Notable spots to try: Storm King Art Center Bear Mountain State Park Woodbury Common Premium Outlets Warwick village wineries and cideries Hot air balloon rides over the Hudson Valley
Home Highlights
Parking
2 Car Garage
Outdoor
Deck
A/C
Heating & Cooling
HOA
None
Price/Sqft
$497
Listed
No Info
Last check for updates: about 12 hours ago
Listing by: Compass Greater NY LLC, (516) 331-0070
Lisa Lonuzzi
Source: SIBOR, MLS#2602582
Also Listed on SIBOR.
Home Details for 231 Celery Ave
|
|---|
Interior Details Basement: Finished,Full |
Beds & Baths Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 3Number of Bathrooms (half): 1 |
Dimensions and Layout Living Area: 3925 Square Feet |
Heating & Cooling Heating: Natural Gas,Hot WaterHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Natural Gas |
Gas & Electric Electric: 220 Volts |
Levels, Entrance, & Accessibility Stories: 3 |
View No View |
|
|---|
Exterior Home Features Patio / Porch: DeckExterior: Balcony |
Parking & Garage Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Additional Parking |
Water & Sewer Sewer: Cesspool |
|
|---|
Days on Market: <1 days on Trulia |
|
|---|
Year Built Year Built: 2009 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family Residence |
Building Construction Materials: StoneNot a New Construction |
Property Information Condition: Excellent |
|
|---|
Price List Price: $1,950,000Price Per Sqft: $497 |
|
|---|
MLS Status: Active |
|
|---|
Direction & Address City: Warwick |
|
|---|
Listing Agent Listing ID: 2602582 |
|
|---|
Building Area Building Area: 3925 Square Feet |
|
|---|
Lot Area: 38.7 Acres |
|
|---|
Listing Agreement Type: Exclusive Right To Sell |
|
|---|
BasementMls Number: 2602582 |
Price History for 231 Celery Ave
| Date | Price | Event | Source |
|---|---|---|---|
| 05/09/2026 | $1,950,000 | Listed For Sale | SIBOR #2602582 |
Similar Homes You May Like
10 ACRESListing by: Howard Hanna Rand Realty- 10.56 ACRESListing by: Real Broker NY LLC
- NEW CONSTRUCTION4.19 ACRESListing by: Keller Williams Hudson Valley
- NEW CONSTRUCTION3.52 ACRESListing by: Keller Williams Hudson Valley
- 3.9 ACRESListing by: Keller Williams Realty
- NEW CONSTRUCTION7.4 ACRESListing by: BHHS Hudson Valley Properties
- 4 ACRESListing by: BHG Real Estate Green Team
- 0.69 ACRESListing by: Keller Williams Realty
- 15.5 ACRESListing by: Keller Williams Hudson Valley
- 96 ACRESListing by: RE/MAX Benchmark Realty Group
- 12.3 ACRESListing by: Christie's Int. Real Estate
- 2.4 ACRESListing by: Howard Hanna Rand Realty
- NEW CONSTRUCTION1 ACREListing by: Serhant LLC
- 46.4 ACRESListing by: Howard Hanna Rand Realty
- 66.8 ACRESListing by: Raynor Country
- 5.5 ACRESListing by: Howard Hanna Rand Realty
- 1.9 ACRESListing by: Howard Hanna Rand Realty
- 10 ACRESListing by: Keller Williams Realty
- OPEN SAT, 1:30-3:30PMNEW CONSTRUCTION3.8 ACRESListing by: Keller Williams Realty
- 71 ACRESListing by: WHITETAIL PROPERTIES REAL ESTATE LLC (NY)
- 36.8 ACRESListing by: Keller Williams Hudson Valley
- 88.17 ACRESListing by: P R O Links Realty Inc
- 5 ACRESListing by: Keller Williams Realty
- OPEN SUN, 12-2PM5.9 ACRESListing by: Serhant LLC
- 2.1 ACRESListing by: Howard Hanna Rand Realty
- 3.6 ACRESListing by: Platinum Realty Associates
- 20.5 ACRESListing by: Hudson Valley Home Connection
- 1.3 ACRESListing by: Blue Sky Realty Group LLC
- 0.8 ACRESListing by: Ellis Sotheby's Intl Realty
- 3 ACRESListing by: MS Realty Group USA, Inc
- 189 ACRESListing by: Cronin & Company Real Estate
- 7.6 ACRESListing by: Werner Realty of New York
- 1.9 ACRESListing by: Your Home Sold Guaranteed Rlty
- 3.7 ACRESListing by: Blooming Realty
- NEW - 2 DAYS AGO2.3 ACRESListing by: Blooming Realty
See more homes for sale inWarwick
New Listings near 231 Celery Ave
- 10 ACRESListing by: Howard Hanna Rand Realty
- 3.9 ACRESListing by: Keller Williams Realty
- 10.56 ACRESListing by: Real Broker NY LLC
- NEW CONSTRUCTION7.4 ACRESListing by: BHHS Hudson Valley Properties
- 0.69 ACRESListing by: Keller Williams Realty
- NEW CONSTRUCTION3.52 ACRESListing by: Keller Williams Hudson Valley
- 4 ACRESListing by: BHG Real Estate Green Team
- NEW CONSTRUCTION4.19 ACRESListing by: Keller Williams Hudson Valley
- See more homes for sale inWarwick
Comparable Sales for 231 Celery Ave
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
1.47 | Single-Family Home | $798,000 | 03/26/26 | 3 | 3 | 3,135 | |
2.00 | Single-Family Home | $829,900 | 04/17/26 | 4 | 2.5 | 2,784 | |
2.00 | Single-Family Home | $739,900 | 04/10/26 | 4 | 2.5 | 2,424 | |
1.99 | Single-Family Home | $529,000 | 12/09/25 | 4 | 2.5 | 2,685 | |
1.56 | Single-Family Home | $260,000 | 11/21/25 | 2 | 1.5 | 1,596 | |
1.94 | Single-Family Home | $600,000 | 10/14/25 | 3 | 2.5 | 2,828 | |
2.05 | Single-Family Home | $585,000 | 05/01/26 | 4 | 3.5 | 2,516 | |
1.95 | Single-Family Home | $625,000 | 07/30/25 | 3 | 2.5 | 2,217 | |
2.11 | Single-Family Home | $565,000 | 10/16/25 | 5 | 3.5 | 3,164 | |
1.75 | Single-Family Home | $400,000 | 04/08/26 | 3 | 1.5 | 1,056 |
Assigned Schools
These are the assigned schools for 231 Celery Ave.
- Goshen Central High School
- 9-12
- Public
- 981 Students
7/10GreatSchools RatingParent Rating AverageLet’s delivery people come in the school with out being identified In a classroom full of students to install appliancesOther Review4y ago - Goshen Intermediate School
- 3-5
- Public
- 603 Students
6/10GreatSchools RatingParent Rating AverageThis school district is the best they are very parent focused. They consider a parents option in most decisions.Parent Review1y ago - C J Hooker Middle School
- 6-8
- Public
- 646 Students
6/10GreatSchools RatingParent Rating AverageI think it is pretty good. The kids could be nicer but overall I get a good education.Student Review8y ago - Scotchtown Avenue School
- PK-2
- Public
- 505 Students
NAGreatSchools RatingParent Rating AverageWe have been very pleased with the school. The teachers are fantastic and intuitive. My child has really thrived and went from a shaky reader(in another district) to a confident reader that loves to read. It is a nurturing environment that focuses on the children first. It’s always nerve wracking when you move into a new school district, especially when you can only rely on school reports and second hand reviews(like this) and a few friends with individual experiences as parents in the district. We couldn’t be happier with what we found in this school and town.Parent Review8y ago 
Check out schools near 231 Celery Ave.
What Locals Say about New Hampton
At least 6 Trulia users voted on each feature.
100 % Say yards are well-kept
100 % Say there's wildlife
100 % Say parking is easy
92 % Say car is needed
83 % Say there's holiday spirit
67 % Say kids play outside
65 % Say neighbors are friendly
60 % Say it's dog friendly
55 % Say it's quiet
44 % Say there are community events
44 % Say people would walk alone at night
43 % Say they plan to stay for at least 5 years
18 % Say there are sidewalks
10 % Say streets are well-lit
10 % Say it's walkable to restaurants
Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Lisa Lonuzzi, Compass Greater NY LLC, (516) 331-0070
Certain real estate listing data is provided by Staten Island MLS under its Internet Data Exchange program. This data is provided exclusively for consumers’ personal, non-commercial use and may only be used for identifying prospective properties consumers may be interested in purchasing or renting. Any other use of the data is hereby prohibited. Data deemed reliable but is not guaranteed accurate by Staten Island MLS and should be independently verified. Copyright 2026 Staten Island Multiple Listing Service, Inc. All rights reserved.
231 Celery Ave, Warwick, NY 10990 is a 4 bedroom, 4 bathroom, 3,925 sqft single-family home built in 2009. This property is currently available for sale and was listed by SIBOR on May 9, 2026. The MLS # for this home is MLS# 2602582.