This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
$4,400,000 Coming Soon
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
Full Property Details for MLS# 24209135
General
- Price: $4,400,000
- Taxes: (July 2026-June 2027)
- Status: Coming Soon
- Type: Single Family
- Source: SMARTMLS
- MLS ID: 24209135
- Updated: 10/9/2026
- Added to Site: 5 day(s) ago
- Expected Market Date: 10/13/2026
Interior
- Number of Rooms: 12
- Rooms/Areas: Bonus Room, Exercise Room, Laundry Room, Mud Room, Sitting Room, Wine Cellar
- Interior Features: Audio System, Auto Garage Door Opener, Cable - Available, Central Vacuum, Open Floor Plan, Security System
- Fireplace: Yes
- Number of Fireplaces: 3
- Appliances: Oven/Range, Convection Oven, Microwave, Range Hood, Subzero, Icemaker, Dishwasher, Disposal, Compactor, Washer, Dryer, Wine Chiller
Rooms
Bathrooms
- Total Bathrooms: 8
- Full Bathrooms: 5
- Half Bathrooms: 3
- Primary Bathroom: Primary Bath - Full, 13 x 16, Main
Bedrooms
- Total Bedrooms: 5
- Primary Suite: 9 ft+ Ceilings, Vaulted Ceiling, Fireplace, Sliders, W, 29 x 17, Main
- Bedroom 1: Bedroom - 9 ft+ Ceilings, Bedroom Suite, Full Bath, Walk-In Closet, Hardwood Floor, Tub w/Shower, 15 x 14, Upper
- Bedroom 2: Bedroom - 9 ft+ Ceilings, Jack & Jill Bath, Walk-In Closet, Hardwood Floor, Stall Shower, 15 x 16, Upper
- Bedroom 3: Bedroom - 9 ft+ Ceilings, Jack & Jill Bath, Walk-In Closet, Hardwood Floor, Stall Shower, 16 x 15, Upper
- Bedroom 4: Bedroom - 9 ft+ Ceilings, Vaulted Ceiling, Bedroom Suite, Full Bath, Walk-In Closet, Hardwood Floor, 18 x 17, Upper
Other Rooms
- Family Room: Family Room - 9 ft+ Ceilings, Vaulted Ceiling, Beams, Built-Ins, Fireplace, Hardwood Floor, 25 x 19, Main
- Eat In Kitchen: Eat-In Kitchen - 9 ft+ Ceilings, Granite Counters, Dining Area, Island, Hardwoo, 17 x 19, Main
- Formal Dining Room: Formal Dining Room - 9 ft+ Ceilings, Beams, Combination Liv/Din Rm, Fireplace, French Doors, Hardwood Floor, 31 x 19, Main
- Library: Library - Bay/Bow Window, 9 ft+ Ceilings, Book Shelv, 13 x 15, Main
- Extra Room 1: Primary Bath - Granite Counters, Full Bath, Whirlpool Tub, Marble Floor, 14 x 16, Main
- Game room: Yes
- Game Room: Rec/Play Room - Vaulted Ceiling, Hardwood Floor, On 3rd Floor, 20 x 30, Other
- Rec Room: Vaulted Ceiling, Hardwood Floor, On 3rd Floor, 20 x 30, Other
- Theater/Media: Media Room - Vaulted Ceiling, Built-Ins, Wet Bar, Entertainment Center, Wall/Wall Carpet, 28 x 19, Upper
- Laundry: Main Level, Upper Level
- Other Room 1: Other - 9 ft+ Ceilings, Granite Counters, Pantry, Hardwood Floor, 10 x 8, Main
- Other Room 2: Other - 9 ft+ Ceilings, Built-Ins, Granite Counters, Laundry Hookup, Stone Floor, 12 x 7, Upper
Exterior
- Exterior Features: Gutters, Lighting, Hot Tub, French Doors, Patio, Grill, Underground Utilities, Stone Wall, Underground Sprinkler
- Color: Tan
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 3
- Total Spaces: 20
- Parking: Attached Garage, Paved, Driveway
Location
- County: Hartford
- Driving Directions: Route 4 to Old Mountain Rd to Northeast Road
School Information
- Elementary School: East Farms
- High School: Farmington
Heating & Cooling
- Cooling Type: Central Air, Zoned
- Heating Type: Hydro Air, Zoned, Propane
- Heating Fuel: Propane
- Water Heater: Propane, Upright Tank
Utilities
- Sewer: Septic
- Water: Private Well
Structural Information
- Architectural Style: Colonial
- Construction Status: No/Resale
- Exterior Const.: Shake, Cedar, Stone
- Basement Desc.: Full, Unfinished, Heated, Storage, Garage Access, Interior Access, Concrete Floor
- Roof: Asphalt Shingle, Metal
- Attic: Yes
- Square Feet: 9,268
- Above Ground: 9,268 Sq. Ft.
- Year Built: 2005
Lot Features
- Lot Size (Acres): 5.01
- Driveway/Sidewalk: Private, Paved, Heated
- Zoning: R80
- Lot Description: City Views, Lightly Wooded, Treed, Borders Open Space, Dry, Professionally Landscaped
Green Features
- Energy Features: Generator, Ridge Vents, Thermopane Windows
Financial Considerations
- Assessment Amount: $1,604,050
- Tax Year: July 2026-June 2027
Disclosures and Reports
- Property ID: 23684490
Listed by Silver and Oak Realty, Sandra Manafort
Schools serving MLS# 24209135
| Name | Grades | Distance |
|---|---|---|
East Farms School 25 Wolf Pit Road, Farmington, CT 06032 | K-4 | 2.2 mi |
Irving A. Robbins Middle School 20 Wolf Pit Road, Farmington, CT 06032 | 7-8 | 2.1 mi |
Farmington High School 10 Monteith Drive, Farmington, CT 06032 | 9-12 | 3.6 mi |
Price & Sales History for MLS# 24209135
Estimate the Cost for MLS# 24209135
MLS# 24209135, Farmington, CT 06032 (MLS# 24209135) is a Single Family property with 5 bedrooms, 5 full bathrooms and 3 partial bathrooms. MLS# 24209135 is currently listed for $4,400,000 and was received on October 07, 2026. Want to learn more about MLS# 24209135? Do you have questions about finding other Single Family real estate for sale in Farmington? You can browse all Farmington real estate or contact a Coldwell Banker agent to request more information.

