231 Celery Avenue, Warwick, NY 10990

Local realty services provided by:CENTURY 21 Awaye Realty
231 Celery Avenue,Warwick, NY 10990
$1,950,000
  • 4 Beds
  • 4 Baths
  • 3,925 sq. ft.
  • Single family
  • Active
Listed by: lisa lonuzzi
Office: compass greater ny llc.
MLS#:2602582
Source:NY_SIBOR

Price summary

  • Price:$1,950,000
  • Price per sq. ft.:$496.82

About this home

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 and in the wall vacuum on all floors. The property's layout supports both lifestyle and business opportunities, whether you...

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an independent agent affiliated with the CENTURY 21®  brand to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an independent agent affiliated with the CENTURY 21®  brand is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2009
  • Listing ID #:2602582
  • Added:6 day(s) ago
  • Updated:May 16, 2026 at 02:54 PM

Rooms and interior

  • Bedrooms:4
  • Total bathrooms:4
  • Full bathrooms:3
  • Basement Description:Full
  • Living area:3,925 sq. ft.

Heating and cooling

  • Heating:Hot Water, Natural Gas
  • Central air:Yes

Structure and exterior

  • Year built:2009
  • Building area:3,925 sq. ft.
  • Lot area:38.7 Acres
  • Construction Materials:Stone
  • Exterior Features:Balcony

Utilities

  • Sewer:Cesspool

Finances and disclosures

  • Price:$1,950,000
  • Price per sq. ft.:$496.82
  • Tax amount:$18,621

Parking

  • Garage:Yes
  • Garage spaces:2
This information has been obtained from sources believed to be reliable, but no representations or warranties, expressed or implied, as to the accuracy of the information are being made by Ithaca Board of REALTORS® or CENTURY 21 Awaye Realty. Anyone using this information without independently verifying its accuracy bears all risk for any inaccuracies.