NOT LISTED FOR SALE

1828 Flintstone Rd Windsor, MA 01270

Estimated Value: $768,000 - $1,197,000

4 Beds
4 Baths
3,230 Sq Ft
$322/Sq Ft Est. Value

Last Sold April 02, 2018

Last sale price $575,000 $178 Per Sq Ft

Est. 81% increase in value since last sale

Current estimated payment $6,077/month

86 Days on Market

About This Home

As of April 2018

Breathtaking Panoramic Berkshire Views!!! Exclusively private custom built authentic "Timber Frame" with handmade mortise & tenon red oak retreat sits atop 9.45 acres of pure serenity. Property is surrounded by the Chalet Wildlife management area on 3 sides & consists of 6437 acres. This is the perfect private or vacation home to get out of the city & decompress. Hiking, biking & snowmobiling trails start right at your door step. Close to Notchview cross country ski area which offers free skiing to Windsor residents. Store all your toys in the over sized heated red barn which features 4 bays, fully insulated, propane heated, has a 3/4 bath with full storage above it & a commercial ice maker. Entertain your guest this summer around your heated in ground pool which features fiber optic lights, auto cleaning system & auto chlorine generating system. Come out at night and enjoy a BBQ with friends around the fire pit and dimly lit skyline. Motion activated lights line up the long driveway

Last Agent to Sell the Property

Kolleen Schmitt

Real Broker MA, LLC Listed on: 08/03/2017

Last Buyer's Agent

Non Member

Non Member Office

Home Details

Home Type

  • Single Family

Year Built

  • 1995

Lot Details

  • 9.45

Utilities

  • Private Sewer

Home Details

Home Type

Single Family

Year Built

1995

Lot Details

0

Listing Details

  • Lot Description: Wooded, Paved Drive, City View(s), Cleared, Level, Sloping, Scenic View(s)
  • Property Type: Single Family
  • Single Family Type: Detached
  • Style: Contemporary, Multi-Level
  • Other Agent: 2.00
  • Year Built Description: Actual
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1995

Interior Features

  • Has Basement: Yes
  • Fireplaces: 1
  • Primary Bathroom: Yes
  • Number of Rooms: 10
  • Amenities: Shopping, Swimming Pool, Park, Walk/Jog Trails, Golf Course, Medical Facility, Conservation Area, Highway Access, House of Worship, Public School
  • Electric: Circuit Breakers, 200 Amps
  • Energy: Insulated Windows, Prog. Thermostat, Backup Generator
  • Flooring: Tile, Hardwood
  • Insulation: Fiberglass - Rigid
  • Interior Amenities: Central Vacuum, Security System, Wetbar, French Doors
  • Basement: Full, Partially Finished, Interior Access, Garage Access, Concrete Floor
  • Bedroom 2: Second Floor
  • Bedroom 3: Second Floor
  • Bedroom 4: First Floor
  • Bathroom #1: Second Floor
  • Bathroom #2: Fourth Floor
  • Bathroom #3: Second Floor
  • Kitchen: First Floor
  • Laundry Room: First Floor
  • Living Room: Third Floor
  • Master Bedroom: Fourth Floor
  • Master Bedroom Description: Bathroom - Full, Bathroom - Double Vanity/Sink, Skylight, Ceiling - Cathedral, Ceiling Fan(s), Ceiling - Beamed, Closet - Walk-in, Flooring - Hardwood
  • Dining Room: Third Floor
  • No Bedrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Oth1 Room Name: Mud Room
  • Oth1 Dscrp: Closet, Flooring - Stone/Ceramic Tile, Exterior Access
  • Oth2 Room Name: Exercise Room
  • Oth2 Dscrp: Skylight, Flooring - Wall to Wall Carpet
  • Oth3 Room Name: Game Room
  • Oth3 Dscrp: Flooring - Hardwood, Flooring - Stone/Ceramic Tile, Main Level, Wet bar, Recessed Lighting
  • Oth4 Room Name: Bathroom
  • Oth4 Dscrp: Bathroom - Half
  • Main Lo: M95273
  • Main So: H11111
  • Estimated Sq Ft: 3230.00

Exterior Features

  • Construction: Timber Frame, Other (See Remarks)
  • Exterior: Wood
  • Exterior Features: Porch, Patio, Pool - Inground Heated, Cabana, Storage Shed, Barn/Stable, Professional Landscaping, Decorative Lighting, Fruit Trees, Stone Wall
  • Foundation: Poured Concrete

Garage/Parking

  • Garage Parking: Attached, Garage Door Opener, Heated, Storage, Work Area, Side Entry, Insulated, Barn, Oversized Parking
  • Garage Spaces: 6
  • Parking: Off-Street, Paved Driveway
  • Parking Spaces: 12

Utilities

  • Hot Water: Propane Gas
  • Utility Connections: for Gas Range, for Gas Dryer
  • Sewer: Private Sewerage
  • Water: Private Water

Lot Info

  • Assessor Parcel Number: M:009.0 B:0000 L:0071.0
  • Zoning: Res
  • Acre: 9.45
  • Lot Size: 411642.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 3, 2017
Closed on
Apr 2, 2018
Sold by
Burke John J and Freitag-Burke Susan D
Bought by
Kintner Michael R and Kintner Alecia T
Seller's Agent
Kolleen Schmitt
Real Broker MA, LLC
Buyer's Agent
Non Member
Non Member Office
List Price
$749,000
Sold Price
$575,000
Premium/Discount to List
-$174,000
-23.23%
Current Estimated Value
$1,041,579

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$466,579
Avg. Annual Appreciation
7.93%
Original Mortgage
$345,000
Outstanding Balance
$296,280
Interest Rate
4.38%
Mortgage Type
New Conventional
Estimated Equity
$745,300
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Kintner Michael R $575,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Kintner Michael R $345,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/02/2018 04/02/18 Sold $575,000 -23.2% $178 / Sq Ft
10/28/2017 10/28/17 Pending -- -- --
08/03/2017 08/03/17 For Sale $749,000 -- $232 / Sq Ft
Source: MLS Property Information Network (MLS PIN)

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 $8,208 $723,800 $37,100 $686,700
2024 $7,980 $691,500 $43,700 $647,800
2023 $7,685 $586,200 $42,600 $543,600
2022 $7,698 $585,400 $41,800 $543,600
2021 $8,173 $626,300 $41,700 $584,600
2020 $8,007 $568,700 $41,700 $527,000
2019 $8,329 $625,800 $41,700 $584,100
2018 $8,098 $601,600 $40,800 $560,800
2017 $7,360 $542,000 $43,400 $498,600
2016 $7,587 $566,600 $48,600 $518,000
2015 $7,392 $555,400 $56,400 $499,000
2014 $7,351 $558,600 $59,600 $499,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 72208313

MLS Property Information Network (MLS PIN)

APN: WIND-000090-000000-000071