Skip main navigation
Off market
  • $1,734,300

    851 Duck Farm Rd, Fairfield, CT 06824

    5beds
    4,366sqft
    SingleFamily
    Built in 1967
    2 Acres Lot
    $1,734,300 Zestimate®
    $397/sqft
    $7,914 Estimated rent

    Home value

    $1,734,300

    $1.58M - $1.93M

    $7,914/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $7,914/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,914/mo

    Rent Zestimate®

    Refinance and save

    $11,592/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $11,592/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Designer Town & Country Home ideally located in sought after lower Greenfield Hill just 5 minutes to town/train and 2 minutes to Greenfield Hill Market. This Spectacular 6 bed, 4.5 bathroom, 3 car garage home with legal In-law apartment, pool, and flat/usable private property will check off all the boxes. Enjoy the beautifully designed chefs kitchen featuring custom cabinetry, Thermadore appliances, 48-inch custom hood, two sinks, 11-ft island (seats up to 6 people) with 2 inch thick quartz counter-top & built-in microwave oven. Enjoy the open floor plan that flows beautifully from kitchen to dining to family room with sliders that leading out onto your sprawling 40 ft deck creating an amazing indoor/outdoor living experience. Hardwood floors, recessed lights, beautiful railings & custom trim work throughout really show the attention to detail taken. Large, bright formal living room w/ fireplace and custom ship lap mantel leads out to a screened porch, perfect for additional outdoor entertaining. The 2nd floor boasts 4 huge bedrooms and a breathtaking master suite featuring a walk-in closet & bathroom with heated floors, double sink vanity, soaking tub & stunning shower. Head downstairs to a beautifully finished lower level w/ expansive mud room, attached 3rd garage and legal in-law apartment with its own kitchen, bathroom & seperate entrance! Also perfect for pool/guest house. This home has so much to offer and is just waiting for you to make it your own!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Range / Oven, Refrigerator, Washer
    • Laundry: Upper Level, Hall Closet
    Features
    • Mud Room
    • Flooring: Hardwood
    • Basement: Unfinished
    • Attic: Finished, Walk-up
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 4,366 sqft
    • Finished area below ground: 943

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage - Attached, Garage - Detached
    Features
    • Patio & porch: Deck, Porch-Screened
    • Exterior features: Wood
    • Pool features: In Ground, Heated
    • Waterfront features: Not Applicable
    Lot
    • Size: 2 Acres
    • Features: Level
    Details
    • Parcel number: FAIRM174B49A
    • Zoning: AAA

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Roof: Asphalt
    Condition
    • New construction: No
    • Year built: 1967

    Utilities & green energy

    • Sewer: Septic Tank
    • Water: Public Water Connected
    Green energy
    • Green verification: ENERGY STAR Certified Homes

    Community & neighborhood

    Community
    • Community features: Fitness Center
    Location
    • Region: Fairfield

    HOA & financial

    Other financial information
    • Total actual rent: 1149000

    Other

    Other facts
    • Sewer: Septic Tank
    • Heating: Forced Air, Natural Gas, Gas on Gas
    • Appliances: Dishwasher, Refrigerator, Dryer, Microwave, Washer, Gas Range, Range Hood
    • FireplaceYN: true
    • Roof: Asphalt
    • Basement: Finished, Full
    • GarageYN: true
    • AttachedGarageYN: true
    • AssociationYN: 0
    • HeatingYN: true
    • PatioAndPorchFeatures: Deck, Porch-Screened
    • CoolingYN: true
    • RoomsTotal: 9
    • FireplacesTotal: 1
    • ConstructionMaterials: Frame, Wood Siding
    • LotFeatures: Level
    • ArchitecturalStyle: Colonial
    • CommunityFeatures: Golf, Fitness Center, Park, Shopping/Mall, Library, Public Rec Facilities
    • GreenBuildingVerificationType: ENERGY STAR Certified Homes
    • PoolFeatures: In Ground, Heated
    • Cooling: Central Air
    • ExteriorFeatures: Garden
    • InteriorFeatures: Mud Room
    • ParkingFeatures: Detached Garage, Attached Garage
    • Attic: Finished, Walk-up
    • LaundryFeatures: Upper Level, Hall Closet
    • BelowGradeFinishedArea: 943
    • YearBuiltSource: Public Records
    • FoundationDetails: Concrete
    • WaterSource: Public Water Connected
    • WaterfrontFeatures: Not Applicable
    • Zoning: AAA
    • TotalActualRent: 1149000.00
    • MlsStatus: Active

    Price history

    DateEventPrice
    12/29/2021Sold$1,265,000+10.1%$290/sqft
    Source: Public Record Report a problem
    2/25/2020Listing removed$1,149,000$263/sqft
    Source: Higgins Group Real Estate #170260409 Report a problem
    11/26/2019Price change$1,149,000-4.3%$263/sqft
    Source: Higgins Group Real Estate #170239422 Report a problem
    9/27/2019Listed for sale$1,200,000+137.6%$275/sqft
    Source: Higgins Group Real Estate #170239422 Report a problem
    2/1/2019Sold$505,000-37.3%$116/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$17,812 +1.8%$627,410
    2024$17,505 +1.4%$627,410
    2023$17,260 +1%$627,410

    Find assessor info on the county website

    Neighborhood: 06824

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Dwight
    • Middle: Roger Ludlowe
    • High: Fairfield Ludlowe

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a free Zillow Showcase℠ listing and you could sell for .
    $1,734,300
    2% more+ $34,686
    With Zillow Showcase(estimated)
    $1,768,986