NOT LISTED FOR SALE

Estimated Value: $1,422,000 - $1,626,462

4 Beds
6 Baths
5,127 Sq Ft
$298/Sq Ft Est. Value

Last Sold September 29, 2023

Last sale price $1,400,000 $273 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $10,125/month

1 Day on Market

Highlights

  • Heated In Ground Pool
  • Open Floorplan
  • Attic
  • Gideon Welles School Rated A
  • Colonial Architecture
  • 2 Fireplaces

About This Home

As of September 2023

Experience luxury living at its finest in this highly-appointed Kamis built masterpiece. This meticulously maintained home offers privacy, comfort, and a wealth of high-end features. The in-ground gunite pool and stonework surround is simply stunning and the huge fenced in front yard is a multi-functioning space with its sweeping green lawn and shaded tree areas. Outdoor living has been kicked up a notch or two. Don't miss the opportunity to own this exceptional residence on a private cul-de-sac street of fine homes. This stunning residence offers exquisite features and meticulous attention to detail. The main level impresses with extensive millwork and trimwork, showcasing the craftsmanship that went into creating this masterpiece. Two fireplaces add warmth and ambiance, with a wood-burning fireplace on the first floor and a natural gas fireplace with log insert in the second-floor primary suite. This home’s kitchen and separate Butler's Pantry are a culinary dream. Beautiful white cabinetry, granite counters at every turn, a large island with seating for four and prep sink, a 5 burner Wolf natural gas stove, Electrolux double oven, Sharp Microwave drawer, and a counter depth French door refrigerator/freezer. The exquisite light-filled "breakfast room" features vaulted ceiling with custom millwork and built-in window seats with storage overlooking the pool and back yard. >>>>>CLICK DOWN ARROW FOR FURTHER DETAILS<<< Pro-pics coming Tuesday

Last Agent to Sell the Property

Linda Edelwich

William Raveis Real Estate License #RES.0757389 Listed on: 06/18/2023

William Raveis Real Estate

Last Buyer's Agent

Taylor Mandell-Daly

Berkshire Hathaway NE Prop. License #RES.0795078

Berkshire Hathaway NE Prop.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $20,271

Year Built

  • Built in 2007

Lot Details

  • 1.56 Acre Lot
  • Sprinkler System
  • Property is zoned rr

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Frame Construction
  • Shingle Roof
  • Ridge Vents on the Roof
  • HardiePlank Siding

Interior Spaces

  • Open Floorplan
  • Central Vacuum
  • 2 Fireplaces
  • Thermal Windows
  • Mud Room
  • Entrance Foyer
  • Bonus Room
  • Home Gym
  • Pull Down Stairs to Attic
  • Home Security System

Kitchen

  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Compactor
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry Room
  • Dryer
  • Washer

Partially Finished Basement

  • Basement Fills Entire Space Under The House
  • Garage Access

Parking

  • 3 Car Garage
  • Automatic Garage Door Opener
  • Private Driveway

Pool

  • Heated In Ground Pool
  • Gunite Pool
  • Saltwater Pool
  • Auto Pool Cleaner

Outdoor Features

  • Patio
  • Exterior Lighting
  • Rain Gutters

Schools

  • Hopewell Elementary School
  • Smith Middle School
  • Gideon Welles Middle School
  • Glastonbury High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Hydro-Air Heating System
  • Programmable Thermostat
  • Underground Utilities
  • Power Generator
  • Private Company Owned Well
  • Tankless Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 2518624

Home Details

Home Type

Single Family

Est. Annual Taxes

$20,271

Year Built

Built in 2007

Lot Details

0

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 4777
  • Sq Ft Est Heated Below Grade: 350
  • Total Sq Ft: 5127
  • Year Built: 2007
  • New Construction: No/Resale
  • Remarks Public Addendum: Additional conveniences include a warming drawer, trash compactor, wine refrigerator & additional dishwasher in the Butler's Pantry. This home offers practical amenities as well, including an upstairs laundry room, bedroom closet systems, & plenty of extra storage space. The home's entrance is welcoming & impressive. Beautiful foyer is flanked by a living room and a huge dining room. Natural light pours into each space. The home’s color palette is soft and neutral. Living room leads to hallway & access to the home’s private 1st floor office with custom built in desk and walk in closet with cabinetry storage. The foyer and living room also flow into the large great room with fireplace, built-ins and adjacent kitchen. A walk in food pantry, the butler's pantry and huge mudroom area with built in bench storage seating allows access to the back staircase to the second floor. The mill-working in this home is truly extensive and gives way to the overall impression of extreme attention to detail and high level quality craftsmanship. The primary suite is a true lux retreat while remaining completely casual. Large and spacious with fireplace and 2 separate walk-in closets with built-ins. Spa-like bathroom with whirlpool tub, tiled surround shower and double sinks, and stunning marble countertops. With 3 additional generous bedrooms, each boasting walk-in closets and en-suite full baths, this home provides the utmost comfort and privacy. Back hallway w/custom built in cabinetry, shelving, & extra deep reading nook window seats is reminiscent of a small library, and the large bonus room with extra office space is perfect for a movie room or family game room. The "secret" storage room can double as a kids' hideout. Stay active in the heated finished gym w/rubber flooring located in the basement. Direct access from the basement into the 3-car oversized garage with a Gladiator Garage Storage System providing ample space for vehicles and storage needs. Enjoy outdoor living in style with the bluestone and stone patio and pool deck, featuring a professionally landscaped yard and landscape lighting. In-ground salt-water gunite pool w/ PebbleTec surface offers relaxation & recreation, complemented by a hot tub spa with spillover waterfalls for added luxury. Pool area is equipped w/ Jandy Variable Speed Pump & an iAquaLink system for monitoring & control via a phone app.
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Public Record Gross Sq Ft: 10394
  • Directions: Niepsic to Crosby- home is on the right
  • Financing Used: Other
  • Living Area Sq Ft Per Public Record: 4777
  • Spec Assoc Asses: No
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 12
  • Total Bedrooms: 4
  • Total Bathrooms: 6
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Fireplaces: 2
  • Attic Description: Pull-Down Stairs
  • Basement Description: Full, Partially Finished, Garage Access
  • Interior Amenities: Auto Garage Door Opener, Cable - Available, Central Vacuum, Open Floor Plan, Security System
  • Appliances: Gas Cooktop, Microwave, Refrigerator, Dishwasher, Disposal, Compactor, Washer, Dryer
  • Additional Rooms: Bonus Room, Exercise Room, Foyer, Laundry Room, Mud Room
  • Attic: Yes
  • Street Number Modifier: 49

Exterior Features

  • Exterior Features: Gutters, Lighting, Patio, Underground Sprinkler, Underground Utilities
  • Exterior Siding: Hardie Board
  • Foundation Type: Concrete
  • Roof Information: Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: Yes
  • Pool: In Ground Pool, Heated, Salt Water, Auto Cleaner, Gunite
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 3
  • Driveway Type: Private, Paved
  • Garage And Parking: Attached Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hydro Air
  • Heat Fuel Type: Natural Gas
  • Fuel Tank Location: Non Applicable
  • Hot Water Description: Tankless Hotwater
  • Water Source: Private Well
  • Sewer: Septic

Schools

  • Elementary School: Hopewell
  • Middle School: Smith
  • High School: Glastonbury
  • Intermediate School: Gideon Welles

Green Features

  • Energy Features: Generator, Programmable Thermostat, Ridge Vents, Thermopane Windows

Lot Info

  • Acres: 1.56
  • Lot Description: On Cul-De-Sac Open Lot In Subdivision Cleared Fence - Full Professionally Landscaped
  • Zoning: rr
  • Parcel #: 2518624

Tax Info

  • Tax Year: July 2023-June 2024
  • Property Tax: 20271
  • Total Assessed Value: 653700
  • Mil Rate Total: 31.01

MLS Schools

  • Elementary School: Hopewell
  • Middle Jr High School: Smith
  • High School: Glastonbury

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 18, 2023
Closed on
Sep 19, 2023
Sold by
Schwartz Robert A and Schwartz Erika M
Bought by
Douglas Katie and Douglas John
Seller's Agent
Linda Edelwich
William Raveis Real Estate
Buyer's Agent
Taylor Mandell-Daly
Berkshire Hathaway NE Prop.
List Price
$1,299,000
Sold Price
$1,400,000
Premium/Discount to List
$101,000
7.78%
Views
125
Current Estimated Value
$1,530,154

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$130,154
Avg. Annual Appreciation
3.32%

Purchase Details

Closed on
Oct 2, 2007
Sold by
Crosby Homestead Llc
Bought by
Schwartz Robert A and Schwartz Erika M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$800,000
Interest Rate
6.65%
Mortgage Type
Purchase Money Mortgage
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
Douglas Katie $1,400,000 None Available
Schwartz Robert A $265,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Schwartz Robert A $495,000
Previous Owner Schwartz Robert A $590,000
Previous Owner Schwartz Robert A $150,000
Previous Owner Schwartz Robert A $800,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/29/2023 09/29/23 Sold $1,400,000 +7.8% $273 / Sq Ft
06/26/2023 06/26/23 Pending -- -- --
06/24/2023 06/24/23 For Sale $1,299,000 -- $253 / 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 $23,667 $720,900 $167,300 $553,600
2024 $23,018 $720,900 $167,300 $553,600
2023 $20,271 $653,700 $167,300 $486,400
2022 $18,154 $486,700 $124,900 $361,800
2021 $18,164 $486,700 $124,900 $361,800
2020 $17,959 $486,700 $124,900 $361,800
2019 $17,696 $486,700 $124,900 $361,800
2018 $17,521 $486,700 $124,900 $361,800
2017 $19,141 $511,100 $131,700 $379,400
2016 $18,604 $511,100 $131,700 $379,400
2015 $18,451 $511,100 $131,700 $379,400
2014 $17,415 $488,500 $131,700 $356,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170577135

SmartMLS

APN: GLAS-000008I-001590-W000002