NOT LISTED FOR SALE

45 Deercliff Rd Avon, CT 06001

Estimated Value: $3,009,000 - $4,169,653

6 Beds
8 Baths
10,212 Sq Ft
$360/Sq Ft Est. Value

Last Sold February 08, 2024

Last sale price $4,000,000 $392 Per Sq Ft

Est. 8% decrease in value since last sale

Current estimated payment $24,438/month

117 Days on Market

Highlights

  • Pool House
  • Sauna
  • 2.6 Acre Lot
  • Thompson Brook School Rated A
  • Sub-Zero Refrigerator
  • Colonial Architecture

About This Home

As of February 2024

Perched atop Talcott Mountain on a 2.6-acre parcel, this exceptional residence offers unobstructed panoramic views of the Farmington Valley, making it a truly unique and captivating property. Built with meticulous care, this one-of-a-kind home showcases an array of state-of-the-art green technology and high-end finishes that sets it apart from the rest. Every element of this residence reflects the artistry and craftsmanship of its builder and homeowner, resulting in a property that exudes elegance and sophistication. The home offers 6 beds, 6 full and 2 half baths in a seamless flow of living spaces providing privacy and ample gathering areas. Among many outstanding features are a gourmet kitchen w/ leathered granite counters and equipped with Wolf appl., a gorgeous FR with 11’ coffered ceilings and a fabulous stone fireplace, another 4 fireplaces, library with American Walnut paneling, elegant Crown molding in every room and perfectly displayed shadow boxes throughout. Three levels of the home are warmed by wide plank American Walnut flooring. The expansive master suite offers a spa-like Carrera marble bathroom w/ an oversized shower outfitted w/ body-spray jets and a rain shower head, 2 spacious walk-in closets and a balcony overlooking the valley. This smart and energy-efficient home features Geothermal radiant heating & cooling with 8 automated zones using a “Control4” Home System. A solar component adds to the efficiency of this green home.

Last Agent to Sell the Property

Sonia Peck

William Pitt Sotheby's Int'l License #RES.0808592 Listed on: 09/15/2023

William Pitt Sotheby's Int'l

Co-Listed By

Brigitte Richter

William Pitt Sotheby's Int'l License #RES.0798198

Last Buyer's Agent

Michael Barbaro

Huntsman,Meade & Partners Comp License #REB.0789149

Huntsman,Meade & Partners Comp

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $56,905

Year Built

  • Built in 2010

Lot Details

  • 2.6 Acre Lot
  • Sprinkler System
  • Garden
  • Property is zoned RU2A

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Stone Frame
  • Frame Construction
  • Slate Roof
  • Vertical Siding
  • Stone Siding
  • Radon Mitigation System
  • Stone

Interior Spaces

  • Central Vacuum
  • Built In Speakers
  • Sound System
  • 5 Fireplaces
  • French Doors
  • Mud Room
  • Entrance Foyer
  • Screened Porch
  • Sauna
  • Home Gym
  • Basement Fills Entire Space Under The House

Kitchen

  • Built-In Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Sub-Zero Refrigerator
  • Ice Maker
  • Dishwasher
  • Wine Cooler
  • Smart Appliances
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms

Laundry

  • Laundry Room
  • Laundry on upper level
  • Electric Dryer
  • Washer

Attic

  • Walkup Attic
  • Finished Attic

Home Security

  • Home Security System
  • Smart Thermostat

Parking

  • 4 Car Garage
  • Automatic Garage Door Opener
  • Circular Driveway
  • Shared Driveway

Accessible Home Design

  • Modified Wall Outlets

Eco-Friendly Details

  • Green Built Homes
  • Energy-Efficient Insulation
  • ENERGY STAR Certified Homes
  • Pre-Wired For Photovoltaic Solar
  • 60 Gallon+ Solar Water Heater

Pool

  • Pool House
  • Heated In Ground Pool
  • Gunite Pool
  • Pool has a Solar Cover

Outdoor Features

  • Balcony
  • Patio
  • Exterior Lighting
  • Outdoor Grill
  • Rain Gutters

Location

  • Property is near shops
  • Property is near a golf course

Schools

  • Avon High School

Utilities

  • Zoned Heating and Cooling
  • Geothermal Heating and Cooling
  • Hydro-Air Heating System
  • Power Generator
  • Private Company Owned Well
  • Cable TV Available

Listing and Financial Details

  • Exclusions: See Inclusion/ Exclusions
  • Assessor Parcel Number 2246876

Home Details

Home Type

Single Family

Est. Annual Taxes

$56,905

Year Built

Built in 2010

Lot Details

0

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 8012
  • Sq Ft Est Heated Below Grade: 2200
  • Total Sq Ft: 10212
  • Year Built: 2010
  • New Construction: No/Resale
  • Nearby Amenities: Basketball Court, Golf Course, Medical Facilities, Private School(s), Shopping/Mall, Tennis Courts
  • Association Amenities: None
  • Remarks Public Addendum: The lower level welcomes you with a beautiful custom bar, a billiards room, a playroom and a movie theater. The outdoor living space is just as magnificent providing a perfect oasis of relaxation and entertaining with a heated inground shotcrete pool, oversized bar with pergola, built-in barbecue, stone patios, pool house with a full bathroom, a screened in porch with fireplace, a half basketball court, a vegetable garden and a flat backyard. Fantastic views of Ely Pond lie east of the property. A meticulous 4 cars garage completes this outstanding property. 45 Deercliff Road is more than just a home; it's a masterpiece of design and craftsmanship, offering a lifestyle of unparalleled luxury. This property represents a rare opportunity to live in the lap of opulence while enjoying the serenity of the Connecticut countryside. Conveniently located on the East Side of town-within a short commute to Farmington, West Hartford Center, UCONN Hospital, shopping & schools.
  • Exclusions: See Inclusion/ Exclusions
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: Yes
  • Radon Mitigation Water Ynu: No
  • Directions: Rt 44 to Deercliff Rd.
  • Financing Used: Cash
  • In Law Apartment: Possible
  • Living Area Sq Ft Per Public Record: 6512
  • Spec Assoc Asses: No
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 15
  • Total Bedrooms: 6
  • Total Bathrooms: 8
  • Full Bathrooms: 6
  • Half Bathrooms: 2
  • Fireplaces: 5
  • Attic Description: Walk-up, Finished, Heated
  • Basement Description: Full
  • Interior Amenities: Audio System, Auto Garage Door Opener, Cable - Available, Central Vacuum, Sauna, Security System
  • Appliances: Gas Cooktop, Wall Oven, Microwave, Range Hood, Subzero, Icemaker, Dishwasher, Disposal, Washer, Electric Dryer, Wine Chiller
  • Additional Rooms: Exercise Room, Foyer, Gym, Laundry Room, Mud Room, Sauna
  • Laundry Room Info: Upper Level
  • Attic: Yes
  • Home Automation: Appliances, Built In Audio, Electric Outlet(s), Security System, Thermostat(s)
  • Street Number Modifier: 45
  • Other SqFt Description: Finished attic space

Exterior Features

  • Exterior Features: Balcony, French Doors, Garden Area, Grill, Gutters, Lighting, Patio, Porch-Screened, Underground Sprinkler
  • Exterior Siding: Vertical Siding, Stone
  • Foundation Type: Concrete
  • Roof Information: Slate
  • Waterfront Description: Pond View
  • Swimming Pool: Yes
  • Pool: Pool House, In Ground Pool, Heated, Gunite, Solar Cover
  • Construction Description: Frame, Stone

Garage/Parking

  • Garages Number: 4
  • Driveway Type: Private, Shared, Circular, Asphalt
  • Garage And Parking: Attached Garage

Utilities

  • Cooling System: Central Air, Zoned
  • Heat Type: Hydro Air
  • Heat Fuel Type: Geothermal
  • Fuel Tank Location: Non Applicable
  • Hot Water Description: 100 Gallon Tank, Solar Assisted
  • Water Source: Private Well
  • Sewer: Septic

Schools

  • Elementary School: Per Board of Ed
  • Middle School: Per Board of Ed
  • High School: Avon
  • Intermediate School: Per Board of Ed

Green Features

  • Energy Features: Energy Star Rated, Built Green Certification, Extra Insulation, Generator, Geothermal Heat

Lot Info

  • Acres: 2.6
  • Lot Description: Secluded Water View Level Lot
  • Flood Zone: No
  • Zoning: RU2A
  • Parcel #: 2246876

Tax Info

  • Tax Year: July 2023-June 2024
  • Property Tax: 56905
  • Total Assessed Value: 1607950
  • Mil Rate Total: 35.39

MLS Schools

  • Elementary School: Per Board of Ed
  • Middle Jr High School: Per Board of Ed
  • High School: Avon

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 15, 2023
Closed on
Feb 5, 2024
Sold by
Gordon David
Bought by
P P J Hld Local Llc
Seller's Agent
Sonia Peck
William Pitt Sotheby's Int'l
Buyer's Agent
Michael Barbaro
Huntsman,Meade & Partners Comp
List Price
$4,000,000
Sold Price
$4,000,000
Views
1598
Current Estimated Value
$3,681,218

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$318,782
Avg. Annual Appreciation
-3.45%

Purchase Details

Closed on
Sep 15, 2023
Sold by
Gordon Connie
Bought by
Gordon David

Purchase Details

Closed on
Jun 3, 2010
Sold by
Gordon David
Bought by
Gordon Connie and Gordon David
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
P P J Hld Local Llc $4,000,000 None Available
P P J Hld Local Llc $4,000,000 None Available
Gordon David -- None Available
Gordon David -- None Available
Gordon Connie -- --
Gordon David S -- --
Gordon David S -- --
Gordon Connie -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open P P J Hld Local Llc $2,860,250
Previous Owner Gordon Connie $417,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/08/2024 02/08/24 Sold $4,000,000 0.0% $392 / Sq Ft
01/10/2024 01/10/24 Pending -- -- --
12/20/2023 12/20/23 For Sale $4,000,000 0.0% $392 / Sq Ft
11/29/2023 11/29/23 Pending -- -- --
09/15/2023 09/15/23 For Sale $4,000,000 -- $392 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $54,427 $1,769,990 $528,650 $1,241,340
2024 $52,498 $1,769,990 $528,650 $1,241,340
2023 $56,905 $1,607,950 $458,650 $1,149,300
2022 $55,651 $1,607,950 $458,650 $1,149,300
2021 $55,008 $1,607,950 $458,650 $1,149,300
2020 $52,902 $1,607,950 $458,650 $1,149,300
2019 $52,902 $1,607,953 $458,650 $1,149,303
2018 $52,389 $1,671,100 $528,650 $1,142,450
2017 $51,119 $1,671,100 $528,650 $1,142,450
2016 $52,090 $1,764,570 $528,650 $1,235,920
2015 $50,820 $1,764,570 $528,650 $1,235,920
2014 $49,973 $1,764,570 $528,650 $1,235,920
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170596310

SmartMLS

APN: AVON-000015-000000-000209-000045