HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

Layout spacer

    Layout spacer

      About Us

      • Who We are
      • Meet the Team

      Resources

      • Latest Blogs
      • Free Vendor List
      • Need Funding?
      • Property Inspector
      • Down Payment Eligibility

      Communities

      • Otsego County
      • Schoharie County
      • Chenango County
      • Delaware County
      • Greene County
      • Broome County
      • Oneida County
      • Montgomery County
      • Ulster County

      Disclosures

      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution

      © 2026 Homes, Farms & Land. All rights reserved.

      Property at 123 Warwick Road, Ellicott, NY 14701
      IN ESCROW
      $29,500
      $419,500

      123 Warwick RoadEllicott, NY, 14701

      3 Beds2 Baths1,635 SqFt0.2597 Acres
      Experience modern luxury in this newly built comfortable single story, barrier free home. Entering through a large foyer, you can enjoy the open floorplan concept in a spacious vaulted room with contemporary timber beams and ample natural light. A hookup for a freestanding gas fireplace is provided. The kitchen is a chef's dream with a generous island, all new appliances and a walk-in pantry. The spacious primary suite boasts a walk-in closet and a bathroom with a luxurious shower, while two additional bedrooms on the other side of the house share their own well-appointed bath. This house offers a convenient laundry room with ample storage. The heated 584 sq ft fully finished 2-car garage and storage room offer practicality with hookups for EV cars, hot & cold water, a floor drain and hookup for a generator. To maximize comfort, this home is equipped with state-of-the-art hydronic floor heat in all rooms including the garage, coupled with high velocity air conditioning, 30% more efficient than traditional AC, and an on-demand hot water system. Step outside under custom timber frame roofs and a backyard patio for your outdoor enjoyment. In addition a Ring door bell system. Enjoy the advantage of lower electric costs within the renowned Southwestern school district. This prime location offers convenience with nearby shops and schools, ensuring a well-connected and vibrant lifestyle. Seize the opportunity to create your own heaven in this thriving community. See attachment for additional amenities and options. PLEASE REMOVE SHOES UPON ENTERING. Some photos have been Virtually Staged.
      1 / 19

      Est. Monthly

      $1,988/mo

      $419,500
      $29,500

      123 Warwick Road, Ellicott, NY

      3 Beds2 Baths1,635 SqFt0.2597 Acres

      Experience modern luxury in this newly built comfortable single story, barrier free home. Entering through a large foyer, you can enjoy the open floorplan concept in a spacious vaulted room with contemporary timber beams and ample natural light. A hookup for a freestanding gas fireplace is provided. The kitchen is a chef's dream with a generous island, all new appliances and a walk-in pantry. The spacious primary suite boasts a walk-in closet and a bathroom with a luxurious shower, while two additional bedrooms on the other side of the house share their own well-appointed bath. This house offers a convenient laundry room with ample storage. The heated 584 sq ft fully finished 2-car garage and storage room offer practicality with hookups for EV cars, hot & cold water, a floor drain and hookup for a generator. To maximize comfort, this home is equipped with state-of-the-art hydronic floor heat in all rooms including the garage, coupled with high velocity air conditioning, 30% more efficient than traditional AC, and an on-demand hot water system. Step outside under custom timber frame roofs and a backyard patio for your outdoor enjoyment. In addition a Ring door bell system. Enjoy the advantage of lower electric costs within the renowned Southwestern school district. This prime location offers convenience with nearby shops and schools, ensuring a well-connected and vibrant lifestyle. Seize the opportunity to create your own heaven in this thriving community. See attachment for additional amenities and options. PLEASE REMOVE SHOES UPON ENTERING. Some photos have been Virtually Staged.

      StatusIn Escrow
      Property TypeResidential
      Property SubtypeSingle Family Residence
      Year Built2024
      Total Rooms6 rooms
      Days on Market504 days

      Est. Monthly Payment

      $1,988.42

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      123 Warwick Road

      Ellicott, NY 14701 • Chautauqua
      3
      Beds
      2
      Baths
      1,635
      SqFt
      0.2597
      Acres
      Status
      In Escrow
      Property Type
      Residential
      Property Subtype
      Single Family Residence
      Year Built
      20242 years ago
      Total Rooms
      6 rooms
      Days on Market
      504 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $8,237
      Property History
      • Price reduced
        Feb 19, 2026 • NYSAMLS • R1581976
        $449,000 → $419,500
      • Listed for sale
        Dec 20, 2024 • NYSAMLS • R1581976
        $535,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $1,988.42
      Down Payment
      Interest Rate
      Loan Term
      %
      %
      yearsyrs.
      Affordability Checkoptional
      $

      Enter your annual income to see if this home fits your budget

      Private Mortgage Insurance

      Not required — down payment above 20%
      MLS Information
      • Source
        NYSAMLS
      • MLS#
        R1581976
      • Listing Office
        Real Estate Advantage
      • Last Updated
        23 days ago

      Appliances

      • Appliances
        • Dryer
        • Dishwasher
        • Exhaust Fan
        • Gas Cooktop
        • Gas Water Heater
        • Refrigerator
        • Range Hood
        • Washer

      Climate & Systems

      • Heating
        • Gas
        • Radiant Floor
        • Radiant

      Interior Features

      • Flooring
        • Ceramic Tile
        • Laminate
        • Varies
      • Basement
        None
      • Interior Features
        • Breakfast Bar
        • Granite Counters
        • Kitchen Island
        • Kitchen Family Room Combo
        • Pantry
        • Storage
        • Main Level Primary
        • Primary Suite
        • Programmable Thermostat

      Parking

      • Parking Features
        • Electric Vehicle Charging Stations
        • Garage
        • Heated Garage
        • Storage
      • Garage Spaces
        2

      Lot & Grounds

      • Lot Size
        0.2597 acres
      • Lot Features
        • Rectangular
        • Rectangular Lot
        • Residential Lot
      • Exterior Features
        Blacktop Driveway

      Type

      • Property Type
        Residential
      • Property Subtype
        Single Family Residence
      • Architectural Style
        • Patio Home
        • Ranch

      Structure

      • Construction
        • Stone
        • Vinyl Siding
        • Pex Plumbing
      • Roof
        Asphalt
      • Foundation
        Poured

      Condition

      • Year Built
        2024
      • Condition
        Resale
      • Days on Market
        504 days
      • Water
        Connected
      • Sewer
        Connected
      • Electric
        Circuit Breakers
      • Utilities
        • High Speed Internet Available
        • Sewer Connected
        • Water Connected

      607-282-6242, (607) 282-6242, or +1 607 282 6242

      Kevin Lucero

      Kevin Lucero

      Lic. Real Estate Salesperson

      CallEmail
      Picked for you

      Similar Properties

      Handpicked listings that match what you're looking at

      View all →
      • 0 Hill Run Unit #14, Concord, NY 14141ACTIVE$377,918

        0 Hill Run Unit #14, Concord, NY 14141

        2 Beds2 Baths1,250 SqFt

        LISTING BY KELLER WILLIAMS REALTY LANCASTER

      • 0 Hill Run Unit #13, Concord, NY 14141ACTIVE$377,918

        0 Hill Run Unit #13, Concord, NY 14141

        2 Beds2 Baths1,250 SqFt

        LISTING BY KELLER WILLIAMS REALTY LANCASTER

      • 6447 Glass Factory Road, Marcy, NY 13403ACTIVE$378,500

        6447 Glass Factory Road, Marcy, NY 13403

        4 Beds2.5 Baths2,048 SqFt2.97 Acres

        LISTING BY COLDWELL BANKER PRIME PROPERTIES

      • 1038 Brierwood Boulevard, Schenectady, NY 12308ACTIVE$378,900OPEN 5/9

        1038 Brierwood Boulevard, Schenectady, NY 12308

        4 Beds2.5 Baths2,804 SqFt0.21 Acres

        LISTING BY KW PLATFORM

      • 346 Moyer Road, Richfield, NY 13439ACTIVE$379,000

        346 Moyer Road, Richfield, NY 13439

        2 Beds1 Bath1,592 SqFt5.18 Acres

        LISTING BY COLDWELL BANKER PRIME PROPERTIES

      • 3340 Galway  Road, Ballston Spa, NY 12020ACTIVE$379,000OPEN 5/10

        3340 Galway Road, Ballston Spa, NY 12020

        2 Beds1 Bath1,100 SqFt3.6 Acres

        LISTING BY CAPITAL REGION HOMES

      • 10329 State Route 22, Granville, NY 12832ACTIVE$379,000

        10329 State Route 22, Granville, NY 12832

        4 Beds3 Baths2,496 SqFt0.77 Acres

        LISTING BY COLDWELL BANKER PRIME PROPERTIES

      • 19 Park Avenue, Fort Edward, NY 12828ACTIVE$379,000

        19 Park Avenue, Fort Edward, NY 12828

        3 Beds2 Baths1,805 SqFt1.36 Acres

        LISTING BY HOME HAVEN REAL ESTATE GROUP LLC

      • 640 Church Road, Minerva, NY 12857ACTIVE$379,000

        640 Church Road, Minerva, NY 12857

        3 Beds2 Baths1,701 SqFt0.69 Acres

        LISTING BY JULIE & CO REALTY LLC

      • 2256 Townline Road, Phelps, NY 14456ACTIVE$379,000

        2256 Townline Road, Phelps, NY 14456

        5 Beds1.5 Baths2,426 SqFt10.1 Acres

        LISTING BY FOUR SEASONS SOTHEBY'S INT'L