Custom built expansive Ranch style home. Large living area with floor to ceiling stone fireplace, stones where taken right from property to build this fireplace (3) flues. Cathedral ceilings, wood flooring with inlay. Formal dining room with crown molding. Large kitchen features a bow window for seating area, maple cabinetry, island with cooktop and breakfast bar, double oven, wine cooler, granite countertops and large pantry. First floor laundry and half bath. Primary bedroom with full walk in closet, huge full bath with jetted tub, double sinks and oversized shower. Heated 3 car heated garage with finished bonus room above that has been plumbed for an additional bath. Huge basement that has 9ft ceiling and metal beams should you want to finish at some point, also plumbed for bath. 2 - 330 oil tanks, 5 zone heating, 80 gallon heat water heater, 3 central air units. Lots of natural light throughout with large windows and fantastic attention to detail. Beautifully landscaped yard with open wrapped front porch, stone walls, covered back porch with large patio. Located on country road, convenient to route 2 and route 9, lots of walking trails in the area.
Sold
$620,000
242 Waterhole Rd, Colchester, CT 06415
3beds
3,317sqft
Single Family Residence
Built in 2004
1.39 Acres lot
$717,600 Zestimate®
$187/sqft
$-- HOA
What's special
Zillow last checked: 7 hours ago
Listing updated: March 31, 2023 at 01:00pm
Listed by:
Dana L. Flanagan,
William Pitt Sotheby's Int'l
Bought with:
Erik Sousa, REB.0790391
William Raveis Real Estate
Source: Smart MLS,MLS#: 170545405

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Features: High Ceilings, Cathedral Ceiling(s), Full Bath, Hardwood Floor, Stall Shower, Whirlpool Tub
- Level: Main
Bedroom
- Features: High Ceilings, Hardwood Floor
- Level: Main
Bedroom
- Features: High Ceilings, Hardwood Floor
- Level: Main
Dining room
- Features: High Ceilings, Hardwood Floor
- Level: Main
Family room
- Features: Hardwood Floor
- Level: Upper
Kitchen
- Features: Bay/Bow Window, Hardwood Floor, Kitchen Island
- Level: Main
Living room
- Features: 2 Story Window(s), High Ceilings, Cathedral Ceiling(s), Ceiling Fan(s), Fireplace, Hardwood Floor
- Level: Main
Heating
- Forced Air, Oil
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Cooktop, Oven, Refrigerator, Dishwasher, Washer, Wine Cooler, Water Heater
- Laundry: Main Level
Features
- Central Vacuum, Open Floorplan
- Windows: Thermopane Windows
- Basement: Full,Unfinished
- Attic: None
- Number of fireplaces: 1
Interior area
- Total structure area: 3,317
- Total interior livable area: 3,317 sqft
- Finished area above ground: 3,317
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage Door Opener, Shared Driveway, Gravel
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Patio & porch: Patio, Porch
- Exterior features: Stone Wall
Lot
- Size: 1.39 Acres
- Features: Level, Few Trees
Details
- Parcel number: 2468894
- Zoning: r2
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Underground Utilities, Cable Available
Green energy
- Energy efficient items: Windows
Community & neighborhood
Security
- Security features: Security System
Location
- Region: Colchester
Services availability

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.