NOT LISTED FOR SALE

Estimated Value: $1,133,000 - $1,480,534

4 Beds
6 Baths
5,680 Sq Ft
$234/Sq Ft Est. Value

Last Sold October 27, 2023

Last sale price $1,296,800 $228 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $9,054/month

62 Days on Market

Highlights

  • Wine Cellar
  • 2.26 Acre Lot
  • Colonial Architecture
  • Gideon Welles School Rated A
  • Open Floorplan
  • Deck

About This Home

As of October 2023

Welcome to 83 Quail Run, located in the seldom available, prestigious Balmoral Estates. Whether entertaining on the expansive rear deck or relaxing on your fieldstone patio with fireplace, the panoramic westerly views of the Hartford skyline and the unforgettable sunsets are sure to stun and delight! Attention to every detail and use of the highest quality materials were paramount when this exquisite 4,600 square foot, Colonial style home was built. This well maintained estate is sure to impress the discerning buyer, looking for luxury living and unparalleled beauty. Features include 4 bedrooms, 4 full and 2 half baths, 3 car heated garage, all privately set on 2.26 acres on a cul-de-sac road. As you enter the grand foyer, you'll immediately notice the soaring ceilings and the stunning two-story marble tiled foyer with open staircase. The expansive formal living room is perfect for both relaxing or entertaining guests, and includes a gas insert fireplace with marble surround, built in bookcases, and incredible westerly views. The formal dining room includes a butler's pantry with French doors and transom. South of the living room is a reading room with deck access and fabulous views. Cooking will be a delight in the gourmet kitchen, featuring stainless steel appliances, granite countertops, a large island and breakfast bar, and deck access to enjoy alfresco dining. Enjoy your morning coffee in the breakfast nook, while taking in the breathtaking views.

Last Agent to Sell the Property

Erik Sousa

William Raveis Real Estate License #REB.0790391 Listed on: 06/02/2023

William Raveis Real Estate

Last Buyer's Agent

Lisa Hutt

Berkshire Hathaway NE Prop. License #RES.0777637

Berkshire Hathaway NE Prop.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $19,248

Year Built

  • Built in 1999

Lot Details

  • 2.26 Acre Lot
  • Stone Wall
  • Sprinkler System
  • Property is zoned RR

HOA Fees

  • $31 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Clap Board Siding

Interior Spaces

  • Open Floorplan
  • Central Vacuum
  • 3 Fireplaces
  • Thermal Windows
  • Entrance Foyer
  • Wine Cellar
  • Workshop
  • Pull Down Stairs to Attic
  • Home Security System

Kitchen

  • Built-In Oven
  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

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

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Garage Access

Parking

  • 3 Car Garage
  • Parking Deck
  • Automatic Garage Door Opener
  • Shared Driveway

Outdoor Features

  • Deck
  • Patio
  • Terrace
  • Shed
  • Rain Gutters

Location

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

Schools

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

Utilities

  • Central Air
  • Heating System Uses Oil
  • Hydro-Air Heating System
  • Programmable Thermostat
  • Underground Utilities
  • Power Generator
  • Private Company Owned Well
  • Oil Water Heater
  • Fuel Tank Located in Basement
  • Cable TV Available

Community Details

  • Balmoral Subdivision

Listing and Financial Details

  • Assessor Parcel Number 574792

Home Details

Home Type

Single Family

Est. Annual Taxes

$19,248

Year Built

Built in 1999

Lot Details

0

HOA Fees

$31 per month

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 4580
  • Sq Ft Est Heated Below Grade: 1100
  • Total Sq Ft: 5680
  • Year Built: 1999
  • New Construction: No/Resale
  • Nearby Amenities: Golf Course, Health Club, Medical Facilities, Park, Private Rec Facilities, Private School(s), Shopping/Mall, Tennis Courts
  • In Law Access: Lower Level
  • Association Amenities: None
  • Remarks Public Addendum: Main level is completed by a stately office with upholstered walls, french doors, built-in book shelves, and gas insert fireplace. Upstairs, you'll enjoy a luxurious master suite complete with a sitting area, tray ceiling, large dual walk-in closets, and a spa-like en-suite bathroom retreat. Enjoy relaxation to the fullest in the jetted tub or steam shower stall. Dual sinks with marble top, and make-up room complete the primary bath. Three additional spacious bedrooms, one with en-suite bathroom and walk-in closets, offer plenty of room for family or guests. A convenient laundry room and entertainment room complete the second level. In the lower level, the walk-out finished 1,100 square foot family room features a full bathroom, wood burning fireplace with blue-stone hearth, and provides additional space suitable for in-law, home gym, game room, or fifth bedroom. Lower level also includes a small wine room, wood shop with garage access and plenty of additional storage. Additional features include newer roof, fresh exterior paint, hydro-air HVAC, oak hardwood floors with mahogany in-lays, front and rear staircases, superb millwork throughout, stone walls, lawn irrigation, invisible pet fence, and a 12x24 shed with electricity. Just a short drive to the center of Glastonbury for fine dining and shopping, 30 mins to Downtown Hartford, and centrally located between Boston and New York.
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Public Record Gross Sq Ft: 8162
  • Directions: Diamond Lake Rd to Quail Run
  • Financing Used: Cash
  • In Law Apartment: Possible
  • Living Area Sq Ft Per Public Record: 4580
  • Spec Assoc Asses: No
  • Street Type: Run
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 15
  • Total Bedrooms: 4
  • Total Bathrooms: 6
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Fireplaces: 3
  • Attic Description: Pull-Down Stairs
  • Basement Description: Fully Finished, Heated, Cooled, Garage Access, Walk-out, Liveable Space
  • Interior Amenities: Auto Garage Door Opener, Cable - Pre-wired, Central Vacuum, Open Floor Plan, Security System
  • Appliances: Gas Range, Wall Oven, Microwave, Refrigerator, Dishwasher, Washer, Dryer
  • Additional Rooms: Foyer, Laundry Room, Wine Cellar, Workshop
  • Laundry Room Location: Laundry room on second level.
  • Laundry Room Info: Upper Level
  • Attic: Yes
  • Street Number Modifier: 83

Exterior Features

  • Exterior Features: Deck, Gutters, Patio, Shed, Sidewalk, Stone Wall, Terrace, Underground Sprinkler, Underground Utilities
  • Exterior Siding: Clapboard
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

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

Utilities

  • Cooling System: Central Air
  • Heat Type: Hydro Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: 50 Gallon Tank, Oil
  • Water Source: Private Well
  • Sewer: Septic

Condo/Co-op/Association

  • HOA Fees: 375
  • HOA Fee Frequency: Annually
  • Property Management Type: Unit Owners Association
  • Property Manager Email: Balmoralarb1@gmail.com

Schools

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

Green Features

  • Energy Features: Generator, Programmable Thermostat, Thermopane Windows

Lot Info

  • Acres: 2.26
  • Lot Description: On Cul-De-Sac In Subdivision City Views Professionally Landscaped
  • Zoning: RR
  • Parcel #: 574792

Tax Info

  • Tax Year: July 2023-June 2024
  • Property Tax: 19248
  • Total Assessed Value: 620700
  • 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 2, 2023
Closed on
Oct 25, 2023
Sold by
Castanza Gregory M
Bought by
Chen Canling and Chen Guoxing
Seller's Agent
Erik Sousa
William Raveis Real Estate
Buyer's Agent
Lisa Hutt
Berkshire Hathaway NE Prop.
List Price
$1,476,000
Sold Price
$1,296,800
Premium/Discount to List
-$179,200
-12.14%
Views
397
Current Estimated Value
$1,327,511

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$30,711
Avg. Annual Appreciation
1.21%

Purchase Details

Closed on
Jan 27, 2022
Sold by
Castanza Melinda L
Bought by
Castanza Gregory M

Purchase Details

Closed on
Sep 6, 2000
Sold by
Chojnicki Bldrs Inc
Bought by
Castanza Melinda D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$630,000
Interest Rate
7.63%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 28, 1995
Sold by
Zieky Stephenie
Bought by
Chojnicki Bldrs Inc
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
Chen Canling $1,296,800 None Available
Castanza Gregory M -- None Available
Castanza Melinda D $647,000 --
Chojnicki Bldrs Inc $100,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Chojnicki Bldrs Inc $350,000
Previous Owner Chojnicki Bldrs Inc $200,000
Previous Owner Chojnicki Bldrs Inc $630,000
Previous Owner Chojnicki Bldrs Inc $200,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/27/2023 10/27/23 Sold $1,296,800 -2.6% $228 / Sq Ft
08/18/2023 08/18/23 Pending -- -- --
07/24/2023 07/24/23 Price Changed $1,332,000 -9.8% $235 / Sq Ft
06/16/2023 06/16/23 For Sale $1,476,000 -- $260 / 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,812 $725,300 $190,600 $534,700
2024 $23,159 $725,300 $190,600 $534,700
2023 $19,248 $620,700 $190,600 $430,100
2022 $19,064 $511,100 $158,300 $352,800
2021 $19,074 $511,100 $158,300 $352,800
2020 $18,860 $511,100 $158,300 $352,800
2019 $18,584 $511,100 $158,300 $352,800
2018 $18,400 $511,100 $158,300 $352,800
2017 $19,706 $526,200 $170,900 $355,300
2016 $19,154 $526,200 $170,900 $355,300
2015 $18,996 $526,200 $170,900 $355,300
2014 $18,759 $526,200 $170,900 $355,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170570810

SmartMLS

APN: GLAS-000007N-005710-W000003