NOT LISTED FOR SALE

550 Essex Dr Warsaw, IN 46582

Estimated Value: $572,000 - $670,721

6 Beds
4.5 Baths
4,982 Sq Ft
$127/Sq Ft Est. Value

Last Sold August 24, 2023

Last sale price $640,000 $128 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $3,825/month

26 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Backs to Open Ground
  • Madison Elementary School Rated A-
  • Vaulted Ceiling
  • Wood Flooring

About This Home

As of August 2023

Welcome home to the highly sought after neighborhood of Barrington Hills! Set on a corner lot this home has inviting curb appeal with an abundance of beautiful living space within. Inside character abounds with gorgeous wood flooring, soaring vaulted ceilings, floor to ceiling windows, and attractive light fixtures. The open concept main floor is a welcoming space for guests and family alike - enjoy time around the fireplace or gather around the impressive island. This kitchen features double ovens, a gas cooktop, an extra large refrigerator, a walk in pantry with plenty of shelving, and attractive countertops and tiled backsplash. Hosting space continues outside on the extensive deck and large yard. Step into your private retreat with the large main level owner’s suite complete with dual vanities, tiled shower, jetted tub, and walk in closet. Work from home in your well lit office with built in window seats. A powder room is readily available as well as an expansive laundry room and drop zone. Upstairs there are four bedrooms and two full bathrooms AND a big bonus room that could be used for a playroom, gaming room, hobby room - you name it! In the basement the space continues with a great family room and kitchen area for mixing up the perfect drink. An exercise or hobby room is available and a sixth bedroom and full bathroom completes the basement. Let's not forget about the 4.5 car garage! The second half has been turned into a heated man cave with stainless steel range/oven, dishwasher, and microwave - bring all your friends! Hook up a TV and enjoy the game as you cheer your team to victory!

Last Agent to Sell the Property

James Bausch

RE/MAX Results- Warsaw Brokerage Phone: 574-742-4531 Listed on: 07/21/2023

RE/MAX Results- Warsaw

Last Buyer's Agent

Julie Hall

Patton Hall Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,386

Year Built

  • Built in 2018

Lot Details

  • 0.56 Acre Lot
  • Lot Dimensions are 150x163
  • Backs to Open Ground
  • Landscaped
  • Corner Lot
  • Sloped Lot

HOA Fees

  • $38 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Heated Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Vaulted Ceiling
  • Ceiling Fan
  • Fireplace With Gas Starter
  • Living Room with Fireplace
  • Video Cameras

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Kitchen Island
  • Stone Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • Double Vanity
  • Whirlpool Bathtub
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry on main level
  • Washer and Gas Dryer Hookup

Finished Basement

  • Basement Fills Entire Space Under The House
  • 1 Bathroom in Basement
  • 1 Bedroom in Basement
  • Natural lighting in basement

Outdoor Features

  • Covered Patio or Porch

Schools

  • Madison Elementary School
  • Edgewood Middle School
  • Warsaw High School

Utilities

  • Multiple cooling system units
  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Private Company Owned Well
  • Well
  • Septic System

Listing and Financial Details

  • Assessor Parcel Number 43-07-28-100-111.000-016

Community Details

Overview

  • Barrington Hills Subdivision

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,386

Year Built

Built in 2018

Lot Details

0

HOA Fees

$38 per month

Parking

4

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2018
  • Age: 5
  • Style: Two Story
  • Total Number of Rooms: 11
  • Total Number of Rooms Below Grade: 3
  • Bedrooms: 6
  • Number Above Grade Bedrooms: 5
  • Total Bathrooms: 5
  • Total Full Bathrooms: 4
  • Total Number of Half Bathrooms: 1
  • Legal Description: 29-109-127 LOTS 113 BARRINGTON HILLS SEC 2
  • Parcel Number ID: 43-07-28-100-111.000-016
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Breakfast Bar, Ceiling-9+, Ceiling Fan(s), Ceilings-Vaulted, Closet(s) Walk-in, Countertops-Stone, Deck Open, Disposal, Dryer Hook Up Gas/Elec, Jet Tub, Kitchen Island, Landscaped, Open Floor Plan, Pantry-Walk In, Porch Covered, Twin Sink Vanity, Alarm System-Sec. Cameras, Tub and Separate Shower, Tub/Shower Combination, Main Level Bedroom Suite, Garage-Heated, Main Floor Laundry, Washer Hook-Up, Jack & Jill Bath
  • Cross Street: Barrington Pl
  • Grid: 10 - Central Kosc.
  • Improvmnts In Last5 Yrs: Yes
  • Number Below Grade Bedrooms: 1
  • Sp Lp Percent: 98.46
  • Year Taxes Payable: 2023
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 5270
  • Total Finished Sq Ft: 4982
  • Above Grade Finished Sq Ft: 3282
  • Below Grade Finished Sq Ft: 1700
  • Below Grade Sq Ft: 288
  • Price Per Sq Ft: 195
  • Basement: Yes
  • Basement Foundation: Daylight, Finished, Full Basement
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Gas Starter
  • Fireplace: Yes
  • Flooring: Carpet, Ceramic Tile, Hardwood Floors
  • Living Great Room: Dimensions: 20x17, On Level: Main
  • Kitchen: Dimensions: 19x11, On Level: Main
  • Dining Room: Dimensions: 19x11, On Level: Main
  • Family Room: Dimensions: 19x17, On Level: Lower
  • Den: Dimensions: 20x13, On Level: Lower
  • Extra Room: Bedroom 6, Dimensions: 19x11, On Level: Lower
  • Bedroom 1: Dimensions: 20x14, On Level: Main
  • Bedroom 2: Dimensions: 12x11, On Level: Upper
  • Bedroom 3: Dimensions: 13x12, On Level: Upper
  • Bedroom 4: Dimensions: 14x10, On Level: Upper
  • Bedroom 5: Dimensions: 13x11, On Level: Upper
  • Other Room1: Office, Dimensions: 14x12, On Level: Main
  • Other Room 2: Bonus Room, Dimensions: 13x27, On Level: Upper
  • Other Room 3: Lower Kitchen, Dimensions: 18x21, On Level: Lower
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 1
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 1988

Exterior Features

  • Exterior: Brick, Vinyl
  • Roof Material: Asphalt
  • Outbuilding1: None

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 4
  • Garage Size: Dimensions: 22x30
  • Garage Sq Ft: 660
  • Garage: Yes
  • Off Street Parking: Yes

Utilities

  • Cooling: Central Air, Multiple Cooling Units
  • Heating Fuel: Gas, Forced Air
  • Sewer: Septic
  • Water Utilities: Well
  • Electric Company: REMC
  • Gas Company: NIPSCO
  • Laundry: Dimensions: Mainx7, On Level: 14
  • Well Type: Private

Condo/Co-op/Association

  • Association Restrictions: Yes
  • Association Fees: 450
  • Association Fees Frequency: Annually
  • Common Amenities: Sidewalks, Swimming Pool

Schools

  • School District: Warsaw Community
  • Elementary School: Madison
  • Middle School: Edgewood
  • High School: Warsaw
  • Elementary School: Madison

Lot Info

  • Lot Description: Corner, Slope, 0-2.9999
  • Lot Dimensions: 150X163
  • Estimated Lot Sq Ft: 24394
  • Estimated Lot Size Acres: 0.56

Tax Info

  • Annual Taxes: 3385.86
  • Exemptions: Homestead

MLS Schools

  • High School: Warsaw
  • Middle School: Edgewood
  • School District: Warsaw Community

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 21, 2023
Closed on
Sep 5, 2023
Sold by
Seale Ryan and Seale Shannon
Bought by
Seale Ryan and Seale Shannon
Seller's Agent
James Bausch
RE/MAX Results- Warsaw
Buyer's Agent
Julie Hall
Patton Hall Real Estate
List Price
$650,000
Sold Price
$640,000
Premium/Discount to List
-$10,000
-1.54%
Views
16
Current Estimated Value
$633,930

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$6,070
Avg. Annual Appreciation
-0.52%
Original Mortgage
$512,000
Outstanding Balance
$501,624
Interest Rate
6.96%
Mortgage Type
New Conventional
Estimated Equity
$131,713

Purchase Details

Listed on
Jul 21, 2023
Closed on
Aug 24, 2023
Sold by
Haynes Nicholas and Haynes Jessica
Bought by
Seale Ryan and Seale Shannon
Seller's Agent
James Bausch
RE/MAX Results- Warsaw
Buyer's Agent
Julie Hall
Patton Hall Real Estate
List Price
$650,000
Sold Price
$640,000
Premium/Discount to List
-$10,000
-1.54%
Views
16

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$512,000
Outstanding Balance
$501,624
Interest Rate
6.96%
Mortgage Type
New Conventional
Estimated Equity
$131,713

Purchase Details

Listed on
Jan 14, 2022
Closed on
Feb 25, 2022
Sold by
Miller Heidi C
Bought by
Haynes Jessica and Haynes Nicholas
Seller's Agent
Brian Peterson
Brian Peterson Real Estate
Buyer's Agent
James Bausch
RE/MAX Results- Warsaw
List Price
$599,900
Sold Price
$592,000
Premium/Discount to List
-$7,900
-1.32%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.37%
Original Mortgage
$562,400
Interest Rate
3.55%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jan 14, 2022
Closed on
Feb 11, 2022
Sold by
Miller Heidi C
Bought by
Miller Heidi C and Miller Matthew J
Seller's Agent
Brian Peterson
Brian Peterson Real Estate
Buyer's Agent
James Bausch
RE/MAX Results- Warsaw
List Price
$599,900
Sold Price
$592,000
Premium/Discount to List
-$7,900
-1.32%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$562,400
Interest Rate
3.55%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jan 14, 2022
Closed on
Feb 9, 2022
Sold by
Miller Matthew J and Miller Heidi C
Bought by
Miller Matthew J and Miller Heidi C
Seller's Agent
Brian Peterson
Brian Peterson Real Estate
Buyer's Agent
James Bausch
RE/MAX Results- Warsaw
List Price
$599,900
Sold Price
$592,000
Premium/Discount to List
-$7,900
-1.32%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$562,400
Interest Rate
3.55%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 15, 2020
Sold by
Miller Matt
Bought by
Miller Matthew J and Miller Heidi C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$340,000
Interest Rate
3.2%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 4, 2018
Sold by
K-Development Inc
Bought by
Miller Matt

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$344,000
Interest Rate
4.22%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 5, 2012
Sold by
Hamilton Zhen Llp
Bought by
First Federal Savings Bank
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
Seale Ryan -- None Listed On Document
Seale Ryan $640,000 None Listed On Document
Haynes Jessica $592,000 None Listed On Document
Miller Heidi C -- None Listed On Document
Miller Matthew J $592,000 Hardig Edward W
Miller Matthew J -- None Available
Miller Matthew J -- None Available
Miller Matt $53,000 --
First Federal Savings Bank $1,200,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Seale Ryan $512,000
Previous Owner Haynes Jessica $562,400
Previous Owner Miller Matthew J $406,000
Previous Owner Miller Matthew J $340,000
Previous Owner Miller Matthew J $344,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/24/2023 08/24/23 Sold $640,000 -1.5% $128 / Sq Ft
08/16/2023 08/16/23 Pending -- -- --
07/21/2023 07/21/23 For Sale $650,000 +9.8% $130 / Sq Ft
02/25/2022 02/25/22 Sold $592,000 -1.3% $119 / Sq Ft
02/17/2022 02/17/22 Pending -- -- --
01/14/2022 01/14/22 For Sale $599,900 -- $120 / Sq Ft
Source: Indiana Regional MLS

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 $3,994 $594,900 $47,000 $547,900
2023 $3,749 $575,300 $47,000 $528,300
2022 $3,386 $484,800 $65,800 $419,000
2021 $3,008 $429,000 $65,800 $363,200
2020 $3,091 $431,100 $63,200 $367,900
2019 $2,992 $431,100 $63,200 $367,900
2018 $55 $18,000 $18,000 $0
2017 $200 $18,000 $18,000 $0
2016 $218 $18,000 $18,000 $0
2014 $9 $800 $800 $0
2013 $9 $800 $800 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Indiana Regional MLS

MLS Number: 202325699

Indiana Regional MLS

APN: 43-07-28-100-111.000-016