Our mobile site is optimized for smaller screens.


MLS Quicksearch

Custom Search

794 Warrenville RoadMansfield, CT 06250MLS Number G10235356

  • Price: $775,000The price has recently decreased
  • Est. Mortgage of $/month
PrintSave Favorite
Price Down Payment Interest Rate Years

Est. Mortgage: $/month

Federal 30-year interest rate: 4.57% last updated on 2018-06-21

This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

  • 4Bedrooms
  • 5Bathroom
  • 4,700Square Feet
  • 12.07Acreage

Award Winning Custom Built Yankee Barn Post & Beam “Green” Home, Set on 12 Sprawling Acres of land, bordering Mt. Hope! The Breathtaking Grounds include 3 Ponds, a River, a Tree Farm and a 2 Story Barn, complete with Running Water & Electricity! This Award Winning Home Boasts an Open Floor Plan Throughout! The Gorgeous Stone Fire and Propane Gas Log Fireplace welcomes all into the Great Room with Cathedral Ceilings and 150 year old Douglas Fir Exposed Beams and Antique Oak Flooring! The Gourmet Kitchen Boasts Granite Counters, Double Oven & Jenn Air Cooktop, Handsome Custom Cabinetry, oversized 3 Compartment sink and more! The 1st Floor Master Suite is Extraordinary with a Cedar Sauna, Master Bath with Soaking Tub, Built In Cabinets, a Solarium, and a 20x20 Walk In Closet! Upstairs, Find 2 Large, Private Bedrooms, Plus an additional Room, and a Jack and Jill Bathroom with Separate Vanities! Additional Features Include: 2 Gas Furnaces for heat and Central A/C with 4 Zones, Solar Electricity system with battery backup, 100 year metal roof, 3 Car Garage, Central Security System, Touch Plate Light Switches Throughout, Underground Utilities, 1,000 Gallon underground propane tank for heat, fireplace and gas grill, and so, so much more!

Listed by Deb Chabot of RE/MAX Destination

Driving Directions

Storrs Office

Your Local Office

Storrs Office
1734 Storrs Road
Storrs CT, 06268

Office: 860-429-9351

Ask A Question

Call: Storrs Office 860-429-9351 Willimantic Office 860-456-1554 or send a message:

Do not fill in this field:

More Info

Basic Information

  • MLS NumberG10235356
  • StatusACT
  • List Price$775,000
  • Square Feet4,700
  • Virtual TourClick Here
  • Property TypeSingle Family For Sale
  • HoaNo
  • Lease purchaseNo
  • Property InfoHorse Property


  • Rooms10
  • Rooms additionalGreenhouse
  • Interior featuresCable - Available, Auto Garage Door Opener, Open Floor Plan, Sauna
  • Room count9
  • Radon mitigation airUnknown
  • Radon mitigation waterUnknown


  • Waters ourcePrivate Well
  • Cooling SystemCentral Air
  • Hot water descriptionPropane
  • Heating FuelNatural Gas, Propane, Solar
  • Fuel tank locationNon Applicable
  • Heat SystemHot Air, Solar
  • Septic approvalNo
  • Septic plan availableNo
  • Sewage systemSeptic

Tax Information

  • Assessed value$480,300
  • Milrate total29.87
  • Taxes$14,347
  • Tax YearJuly 2016-June 2017


  • StateCT
  • Zip06250
  • CountyTolland
  • Short SaleNo


  • Acreage12.07
  • Lot DescriptionFarm Land, Lightly Wooded, Open Lot, Rolling, Water View
  • Driveway TypeCircular, Crushed Stone
  • Garages3
  • Parking spaces per 1000sqft
  • Parking spaces uncovered
  • Parking Spaces
  • Parking spaces covered
  • FloodzoneNo
  • SwimmingpoolNo

Water Body

  • Waterfront DescriptionPond, Direct Waterfront


  • Appliances Included
    • Compactor
    • Cook Top
    • Dishwasher
    • Dryer
    • Microwave
    • Refrigerator
    • Wall Oven
    • Washer
  • Fha approvedNo
  • SubletableNo
  • Space is leasedNo
  • View Count85

School Information

  • Elementary SchoolPBOE
  • High SchoolPBOE


  • Laundry room locationFirst Floor


  • Full Bath3
  • Half Bath2
  • BasementFull, Unfinished
  • Attic descriptionCrawl Space
  • AtticYes
  • Bedrooms4
  • Bathroom5
  • Year Built2001
  • Property StyleContemporary, Ranch
  • Energy FeaturesBuilt Green Certification
  • Fireplaces1
  • Garage Parking InfoAttached Garage
  • Inlaw apartmentyNo


  • Exterior featuresBarn, Deck, Gutters, Lighting, Storage Building
  • Exterior sidingCedar


Room LevelRoom TypeRoom WidthRoom LengthRoom Features
MainDining Room1412Hardwood Floor,Vaulted Ceiling
MainKitchen1412Cathedral Ceiling,Country,Eating Space,Hardwood Floor,Island
MainLiving Room1615Beams,Cathedral Ceiling,Fireplace,Great Room,Hardwood Floor
MainMaster Bedroom2020Bedroom Suite,Full Bath,Hardwood Floor,Hot Tub,Steam/Sauna,Vaulted Ceiling,Walk-In Closet,Whirlpool Tub
UpperBedroom119Bedroom Suite,Full Bath
UpperBedroom1411Bedroom Suite,Full Bath,Upper Level
UpperBedroom1412Bedroom Suite,Full Bath,Upper Level
UpperFamily Room2014Cathedral Ceiling,Upper Level

Information contained in this Smart MLS listing has been compiled from various sources, all of which may not be completely accurate. Smart MLS makes no warranty or representation as to the accuracy of listing information. All information that influences a decision to purchase a listed property should be independently verified by the purchaser. Copyright 2017 Smart MLS, Inc. All rights reserved.

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:


Do not fill in this field: