NOT LISTED FOR SALE

Estimated Value: $2,660,856 - $3,468,000

5 Beds
5.5 Baths
8,662 Sq Ft
$363/Sq Ft Est. Value

Last Sold August 17, 2018

Last sale price $2,150,000 $248 Per Sq Ft

Est. 46% increase in value since last sale

Current estimated payment $20,516/month

108 Days on Market

Highlights

  • Indoor Pool
  • Sauna
  • Colonial Architecture
  • Mckelvie Intermediate School Rated A
  • 5.89 Acre Lot
  • Mountain View

About This Home

As of August 2018

The Castle set high atop a hill overlooking mountain views. The gated entry leads to astounding architectural details which include the front turrets adorned in stone. The open grand Front foyer showcases the curved staircase, custom crafted details of raised panel walls, and is imbued with the warm feel of Brazilian cherry hardwood floors. The chef’s kitchen is equipped with large center island w prep sink, double wall ovens and Encased in stone is the oversized 5 burner cook top w SS hood vent, pot filler, and subzero fridge which is only a fraction of what this kitchen has to offer. Impressive great room is ideal for entertaining with its custom wet bar, coffered ceilings, gas fireplace w continued masonry and hand crafted built-ins. The heart of this home continues into the formal dining room which is highlighted by arched entryways and defined by pillars. Front and back staircases lead you to the upper level which includes 5 spacious bedrooms, 2 featuring ensuite’s. Master bedroom suite features panoramic mountain views, separate lounge area w wet bar, his and her walk-in closets and luxurious master bath with stand-alone Jacuzzi tub, separate shower and double vanities. The RESORT feel of this home continues into the lavish indoor pool surrounded w floor to ceiling windows, heated natural stone flooring, spa w spillover & waterfall feature, state of the art temperature/dehumidification technology and separate heating sys w backup generator. In addition, it has its own kitchen w indoor grill, sliders leading to patio and fire pit. This five star pool room is adjoined to fitness room, with its own private laundry and bath. All in-home systems operated remotely including top of the line Creston home audio system. This home is where luxury meets comfort. Complete list of amenities provided, upon request.

Last Agent to Sell the Property

Molly Miller

Mountain Side Properties, LLC License #070669 Listed on: 05/01/2018

Last Buyer's Agent

Brian Arsenault

Realty 1-Wells Real Estate License #072149

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $35,248

Year Built

  • Built in 2006

Lot Details

  • 5.89 Acre Lot
  • Cul-De-Sac
  • Landscaped
  • Secluded Lot
  • Level Lot
  • Irrigation
  • Wooded Lot
  • Property is zoned RA

Parking

  • 4 Car Direct Access Garage
  • Circular Driveway
  • Off-Street Parking

Property Views

  • Mountain Views
  • Countryside Views

Home Design

  • Colonial Architecture
  • Poured Concrete
  • Wood Frame Construction
  • Architectural Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Wired For Sound
  • Bar
  • Cathedral Ceiling
  • Ceiling Fan
  • Multiple Fireplaces
  • Gas Fireplace
  • ENERGY STAR Qualified Windows
  • Blinds
  • Combination Kitchen and Dining Room
  • Sauna
  • Unfinished Basement
  • Walk-Out Basement
  • Laundry on main level

Kitchen

  • Walk-In Pantry
  • Double Oven
  • Electric Cooktop
  • Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Carpet
  • Radiant Floor
  • Tile
  • Slate Flooring

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Whirlpool Bathtub

Home Security

  • Home Security System
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Indoor Pool
  • Covered Patio or Porch

Schools

  • Peter Woodbury Sch Elementary School
  • Ross A Lurgio Middle School
  • Bedford High School

Utilities

  • Dehumidifier
  • Forced Air Heating System
  • Heating System Uses Gas
  • Heating System Uses Oil
  • Drilled Well
  • Water Heater
  • Septic Tank
  • High Speed Internet

Community Details

  • Association fees include hoa fee
  • Bedford Hills Subdivision

Listing and Financial Details

  • Legal Lot and Block 14 / 37

Home Details

Home Type

Single Family

Est. Annual Taxes

$35,248

Year Built

Built in 2006

Lot Details

0

Parking

4

Listing Details

  • Status Detail: Closed
  • Style: Colonial
  • Development Subdivision: Bedford Hills
  • Directions: Liberty Hill Rd to Olde English Rd to Barrington Drive
  • Assessment Amount: 1864000
  • Construction: Existing
  • Total Stories: 2
  • Price Per Sq Ft: 248.21
  • Property Class: Residential
  • Property Type: Single Family
  • Year Built: 2006
  • List Agent: 23523
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances: Cooktop - Electric, Dishwasher, Range Hood, Microwave, Mini Fridge, Oven - Double, Oven - Wall, Refrigerator
  • Equipment: CO Detector, Dehumidifier, Irrigation System, Security System, Smoke Detector
  • Features Interior: Central Vacuum, Bar, Blinds, Cathedral Ceiling, Ceiling Fan, Dining Area, Fireplace - Gas, Fireplaces - 2, Hearth, Home Theatre Wiring, Kitchen Island, Kitchen/Dining, Primary BR w/ BA, Pool - Indoor, Sauna, Security, Security Door(s), Surround Sound Wiring, Vaulted Ceiling, Walk-in Closet, Walk-in Pantry, Wet Bar, Whirlpool Tub, Laundry - 1st Floor, Laundry - 2nd Floor
  • Total Bedrooms: 5
  • Flooring: Carpet, Hardwood, Slate/Stone, Tile
  • Total Bathrooms: 6
  • Half Bathrooms: 1
  • Full Bathrooms: 5
  • Basement: Yes
  • Basement Access Type: Walkout
  • Basement Description: Unfinished
  • Level 1: Level 1: Bath - Full, Level 1: Bath - 1/2, Level 1: Dining Room, Level 1: Exercise Room, Level 1: Foyer, Level 1: Great Room, Level 1: Kitchen, Level 1: Laundry Room, Level 1: Living Room, Level 1: Office/Study, Level 1: Other
  • Level 2: Level 2: Bedroom, Level 2: Bath - Full, Level 2: Laundry Room, Level 2: Primary Bedroom
  • Room 1: Foyer, 15x16, On Level: 1
  • Room 2: Kitchen, 17x25, On Level: 1
  • Room 3: Dining Room, 14x18 Informal Dining, On Level: 1
  • Room 4: Great Room, 28x20 Grand Living Room, On Level: 1
  • Room 5: 1, 16x21
  • Room 6: Living Room, 17x22, On Level: 1
  • Room 7: Office/Study, 17x15, On Level: 1
  • Room 8: Exercise Room, 18x14, On Level: 1
  • Room 9: Other, 33x64 Pool Room, On Level: 1
  • Room 10: 2, 22x20 & 14x11
  • Room 11: Bedroom, 16x16, On Level: 2
  • Room 12: Bedroom, 13x16, On Level: 2
  • Room 13: Bedroom, 16x12, On Level: 2
  • Room 14: Bedroom, 11x18, On Level: 2
  • Room 15: Laundry Room, 8x8, On Level: 2
  • Room 16: Laundry Room, Second laundry room, On Level: 1
  • Room 17: Bath - 1/2, On Level: 1
  • Room 18: Bath - Full, On Level: 1
  • Room 19: Bath - Full, On Level: 2
  • Room 20: Bath - Full, On Level: 2
  • Room 21: Bath - Full, On Level: 2
  • Room 22: Bath - Full, On Level: 2
  • Sq Ft - Apx Finished AG: 8662
  • Sq Ft - Apx Total: 11666
  • Sq Ft - Apx Total Finished: 8662
  • Sq Ft - Apx Unfinished BG: 3004

Exterior Features

  • Construction: Wood Frame
  • Driveway: Circular, Paved
  • Exterior: Vinyl Siding
  • Foundation: Poured Concrete
  • Road Frontage: TBD
  • Roads: Association, Cul-de-Sac, Paved, Public
  • Roof: Shingle - Architectural
  • Features Exterior: Patio, Porch - Covered, Windows - Energy Star

Garage/Parking

  • Garage Capacity: 4
  • Parking: Garage, Off Street, Parking Spaces 11 - 20, Paved
  • Garage Type: Attached
  • Garage: Yes
  • Garage Description: Direct Entry

Utilities

  • Electric: Circuit Breaker(s)
  • Fuel Company: Irving Oil/Energy North
  • Sewer: Septic
  • Water: Drilled Well
  • Water Heater: Tank
  • Heating Fuel: Gas - LP/Bottle, Oil
  • Heating: Forced Air, Radiant Floor
  • Cooling: Central AC
  • Electric Company: Eversource
  • Utilities: Internet - Cable

Condo/Co-op/Association

  • Fee Includes: HOA Fee
  • Association Amenities: Landscaping

Schools

  • Elementary School: Peter Woodbury Sch
  • High School: Bedford High School

Lot Info

  • Map: 27
  • Lot: 14
  • Lot Sq Ft: 256568
  • Lot Acres: 5.89
  • Lot Description: Country Setting, Level, Mountain View, Secluded, Sidewalks, Subdivision, View, Wooded
  • Surveyed: Unknown
  • Zoning: RA
  • Deed Book: 8979
  • Deed Page: 1253-1255
  • Deed Recorded Type: Warranty

Tax Info

  • Tax Gross Amount: 35248
  • Tax Year: 2017

MLS Schools

  • School Middle Jr: Ross A Lurgio Middle School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 1, 2018
Closed on
Aug 17, 2018
Sold by
Todd A Berkowitz Ret
Bought by
Langlois John
Seller's Agent
Molly Miller
Mountain Side Properties, LLC
Buyer's Agent
Brian Arsenault
Realty 1-Wells Real Estate
List Price
$2,499,000
Sold Price
$2,150,000
Premium/Discount to List
-$349,000
-13.97%
Current Estimated Value
$3,145,619

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$995,619
Avg. Annual Appreciation
5.37%

Purchase Details

Closed on
Jun 21, 2017
Sold by
Berkowitz Todd A
Bought by
Todd A Berkowitz Ret

Purchase Details

Closed on
Mar 14, 2005
Sold by
Donner Ray D and Donner Marie T
Bought by
Berkowitz Todd A and Berkowitz Maureen L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$188,000
Interest Rate
5.64%
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
Langlois John $2,150,000 --
Todd A Berkowitz Ret -- --
Berkowitz Todd A $235,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Berkowitz Todd A $750,000
Previous Owner Berkowitz Todd A $188,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/17/2018 08/17/18 Sold $2,150,000 -6.5% $248 / Sq Ft
05/29/2018 05/29/18 Price Changed $2,299,000 -8.0% $265 / Sq Ft
05/01/2018 05/01/18 For Sale $2,499,000 -- $289 / Sq Ft
Source: PrimeMLS

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
2024 $47,435 $3,000,300 $400,900 $2,599,400
2023 $44,404 $3,000,300 $400,900 $2,599,400
2022 $40,123 $2,279,700 $297,100 $1,982,600
2021 $39,074 $2,279,700 $297,100 $1,982,600
2020 $40,060 $2,001,000 $237,100 $1,763,900
2019 $37,919 $2,001,000 $237,100 $1,763,900
2018 $38,026 $1,864,000 $237,100 $1,626,900
2017 $35,248 $1,864,000 $237,100 $1,626,900
2016 $34,295 $1,533,100 $189,500 $1,343,600
2015 $34,893 $1,533,100 $189,500 $1,343,600
2014 $34,495 $1,533,100 $189,500 $1,343,600
2013 $33,989 $1,533,100 $189,500 $1,343,600
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: PrimeMLS

MLS Number: 4689398

PrimeMLS

APN: BEDD-000027-000037-000014